SUMMARY

• 8+ years of experienced in Oracle Database Administration in production, test and development environments in diversified domains on various versions of UNIX/LINUX and windows operating systems.
• Oracle DBA proficiency in installation, upgrading, patching, administration of multiple Oracle Enterprise Edition 9i, 10g, 11g databases on RHEL, Sun Solaris, HP - UX, IBM-AIX and Windows.
• Good experience in installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Migrated databases using Golden Gate, Transportable tablespace and Datapump from 9i, 10g to 11g
• Exceptional Knowledge of various states of Software Development Life Cycle (SDLC) me.e. System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 8i,9i, 10g, 11g in Production, Staging, and Development environments and responsible for deployments.
• Developed backup and recovery policy and used new features/technologies to optimize system maintenance and extensive noledge on table Partitioning and Oracle Streams for replication.
• Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (me.e. table spaces, rollback segments) and auditing of users.
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader.
• Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using automatic work reports, stats pack, Grid control Monitoring or Oracle Enterprise Manager (OEM).
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, STATS PACK, SQL TRACE, TOAD and Diagnostic monitor.
• Expert in Optimization of SQL queries, providing SQL execution plan, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and storage technologies Storage Area Network, Network Area Storage.
• Ability to restore and recover databases from file system backup like tape drives VERITAS netback up in order to bring to the original state as per the business and user requirement.
• Expertise in maintenance, Database upgrades from Oracle 10g to 11g and 11.2.0.1 to 11.2.0.4, Database administration, backup and recovery of Oracle Exadata systems.
• Installing and monitoring database security tools like TIVOLI, BMC PATROL. Escalating the issues as per the severity of database and resolving it immediately without any delay.
• Applying latest versions or releases like quarterly and one half database patches to minimize the bug issues and to maintain all databases in same version as per business requirement using Opatch utility.
• Working on PL/SQL programing using stored procedures, functions, triggers, packages, exception handling for various me/O errors using Toad and Oracle SQL Developer tools.

TECHNICAL SKILLS

Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan 4.0.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatica 5.1, Data pump, Share Plex.

Data Modeling: Erwin, DB Artisan, Rational Rose, SOX

Other: EMC, Net App, VERITAS, Golden Gate, Oracle Wallet Manager.

PROFESSIONAL EXPERIENCE

Confidential, Issaquah, WA

Oracle DBA

Responsibilities:

• 24x7 on-call production database support. Primarily responsible for supporting mission critical databases to resolve the database issues on the time and make sure database up and running
• Configured OEM 12c monitoring tool for more TEMPthan 500 databases. For proactively monitoring the issues on the databases issues like performance of databases, tablespaces, database growth etc.
• Applying the latest patches like quarterly and one half patches for Oracle Database to fix bugs which occurred in previous version and applying it using Opatch utility.
• Configuring 11gR2 RAC databases on EXADATA. Cell administration on EXADATA.
• Migrating databases to EXADATA Database Machine.
• Working on Smart Scan and query processing that can be offloaded to EXADATA storage server.
• Using the EXADATA monitoring tools like EXACHK, DIAGTOOLS, ADRCI, IMAGEINFO, and OSWATCHER. EXADATA database patches, cell patch
• Configuring 12c and 11gR2 RAC databases on EXADATA. Cell administration on EXADATA.
• Working on EXADATA Full Rack (8 node RAC) applying quarterly patches in rolling patches
• Mapping EXADATA physical disks, Luns and Cell Disks on the Storage Servers using CellCLI.
• Configuring RMAN backup’s for humungous databases to ZBA controllers on EXADATA machine.
• Validating, verifying, diagnosing InfiniBand Network Topology and find out the root cause of issue.
• Manual cluster upgrade from Grid infrastructure 11.2.0.3 version to 11.2.0.4 version.
• Working on huge SAP (CRM, BW, and Payroll) database refreshes from Production to all other lower regions using RMAN, Common vault backup recovery tools.
• Working on data storage management, network cost estimation, user roles and privileges, user space management, memory usage estimation for the existing and future expansion requirements.
• Creating Cronjobs and Autosys jobs for RMAN and EXPORT/IMPORT backups.
• Building RAC databases on Linux/IBM AIX/Sun Solaris with 4 to 6 node on 10g/11gR1/11gR2.
• Troubleshooting RAC issues like node eviction, network issues and addition of nodes dynamically.
• Responsible for Oracle 9i/10g/11g logical and physical standby database design, implementation and maintenance for production as well as testing databases for Disaster Recovery and switch over.
• Golden Gate Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
• Good working noledge on Oracle Streams to capture source message, move to stage, propagate, consume, detect and resolve conflicts during the transmission to reach the destination.
• Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance. Developed strategies for optimal backup and restores procedures.
• Database refreshes using database links from Production to QA, testing and development.
• Involved in Database Performance tuning and analyzing Stats pack/AWR reports on regular basis to resolve CPU utilization and Disk me/O Read and Writes to increase database performance.
• Partitioned large tables, created global portioned indexes for manageability and performance improvement. Managed and resolved design issues. Dropping and rebuilding indexes.
• Created primary database storage structures (tablespaces), users, roles, altering, and modifying the database structure according to the business requirement as necessary.
• Worked on databases consolidation into a single database in Exadata.
• Responsible for automation of startup, shutdown of database without the involvement of DBA to start the database manually. Effective noledge of working with System Administrator’s
• Developing SQL, PL/SQL stored procedures, packages, functions, triggers and views.
• Created and managed users, profiles, implementing security, granting roles and privileges etc.
• Upgraded production databases from 10g to 11g without downtime using Golden Gate replication.
• Planning and implementing Backup and Recovery procedures (Conventional Cold & Hot Backups, and RMAN Backups), scheduling daily backups and performed periodic recovery tests.
• Developed Unix Shell scripts to automate database cloning, backups and database monitoring.
• Working noledge on HPQC to create the SQL performance related queries to developers and ability to deploy the defected SQL on database by issuing appropriate severity tickets.
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Environment: Oracle 10g R2/11gR1/11gR2 RAC on Sun Solaris/ AIX and EXADATA, Golden Gate, Oracle Streams, Data Guard, EXADATA, Import Export utilities, PL/SQL, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.

Confidential

Oracle DBA

Responsibilities:

• Database Administration support (24x7) for large mission critical production databases
• Database Security Management involving managing Users, Roles and Privileges Expert in troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Performed Data guard switch over to check the standby database is in SYNC with production as per the business requirement and also operated standby database using Data Guard broker.
• Configured Oracle wallet manager on windows file management system or in the user profile area of the Microsoft Windows system registry storing for better access control and easier management.
• Support multiple front end application such as .Net, Java, SAP troubleshooting issues as per the requirement. Good understanding of environment as per the developers.
• Ability to resolve .Net application users to communicate with Oracle Database Server.
• Participated in doing schema refresh like taking export of one schema and importing it into another schema using different ways of utility tools like REMAP SCHEMA, REMAP TABLESPACE.
• Space management of logical structures (me.e. table spaces, rollback segments) and auditing of users
• Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.
• Good noledge on troubleshooting Golden Gate whenever Extract or Replicate process gets stop.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Upgraded production databases from 10g to 11g without downtime using Golden Gate replication.
• Working with High transaction databases (OLAP) using Golden Gate to replicate the data to source.
• Installing and configuration of Golden Gate Veridata on production, development and testing.
• Analyzing SOX application for validating business inventory for critical ones and risk assessment.
• Responsible for automation of startup, shutdown of database without the involvement of DBA to start the database manually. Effective noledge of working with System Administrator’s.
• Administration, Optimization, Monitoring, Tuning of Oracle Databases.
• Knowledge of storage technologies like SAN, NAS whenever we has a disk outage or mount point issues due to database growth. Raising a request to SAN or NAS to request for additional storage.
• Table Space management, Database Refreshes, and User Administration. Adding additional data file to table space whenever there is required and also involved in shrinking of table space size.
• Involved in scheduling file system backup using Net backup or FDR/Upstream.
• Proficient in using Oracle utilities me.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Used Data Modeling tools for data message in order to show the output results in different formats using Erwin, Informatica and some other ETL tools Informatica, Cognos and Crystal Reports
• Running PostgreSQL using stored procedures in more TEMPthan several languages, including Java, C/C++.
• Worked on setting up Data Guard on RAC in Oracle 11g & Exadata.
• Managed patching and upgrade of Exadata Storage Server’s.
• Ability to restore and recover databases from file system backup in order to bring it to the original state as per the business or user requirement. me has done Point in time Recovery using RMAN.
• Installing and monitoring database using security tools like TIVOLI, BMC PATROL. Escalating the issues as per the severity of database and resolving it immediately without any delay.

Environment: s: Oracle 11g RAC, 10g RAC/9i, IBM AIX, HP-UX, Red Hat Linux, Sun Solaris, Windows XP, SQL*Plus, SQL*Loader, SQL Developer, Import/Export, .Net, Java, Data Pump, TOAD, Oracle Data Guard.

Confidential, Dallas Fort worth

Oracle DBA

Responsibilities:

• Database Administration support (24x7) for large mission critical production databases
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Responsible for Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• Oracle 10g & 11g Databases maintenance and troubleshooting.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update (CPU) for latest versions. Good experience in managing Very Large OLTP and Data ware housing databases.
• Hands on experience on working with Shareplex tool for replicating table level and schema level.
• Troubleshooting shareplex issues with Quest customer services, replicating tables using where clause.
• Good noledge on replication tools like Golden Gate to extract and replicate Databases.
• Installing Golden Gate from scratch as per the business requirement to replicate large and mission critical tables for the production/testing/development environments.
• Migrated applications to the HDS (Hosted Database Services) environment using Golden Gate 10.4.0
• Involved in setting up, maintenance of Standby Database with Data Guard for Disaster recovery.
• Working noledge on NETAPP storage from disk to tape to copy the RMAN Backup Data and mirroring of databases (BCV Split backup) from one database to another using NETAPP utility.
• Proficient in using Oracle utilities me.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN. Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database. Implemented strong backup and recovery strategies and monitored backups.
• SOX verification of spreadsheet formulas and macros to identify mechanical and logic errors.
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Working with SAN people for additional storage on disk/mount point if having any space issue.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users.
• For security administration used oracle Wallet Manager to manage public key security credentials on Oracle clients and servers
• DB2supports both SQL. DB2 TEMPhas native implementation of XML data storage, where XML data is stored as XML (not as relational data or CLOB data) for faster access using XQuery.
• A capacity planning tool outlines how a future application will function and determines whether or not a company will has to upgrade its CPU or add disk storage to keep users happy.
• PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting.

Environment: s: Oracle 9i, 10g RAC& 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHEL, Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i & 10gRAC database and Performed DBA tasks
• Supporting large mission critical databases in a 24x7 environment.
• Migration of database from Oracle 9i to Oracle 10g.
• Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN. Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database. Implemented strong backup and recovery strategies and monitored backups.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and korn shells, Unix shell Scripting.
• Cloning of databases from production to development and test databases
• Used RMAN for Backup & Recovery.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Reviewing performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as SQLTRACE, TKPROOF, STATSPACK, Explain Plan, AWR and ADDM.
• Automatic Health Monitoring, security, SQL Performance Analyzer.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link.
• Working and good experience in diamond relational tables of SQL server 2005 management studio.
• Participating in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Submitting Tickets using remedy communicating with other groups like UNIX, Configuration Team.
• Oracle utilities me.e. export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.

Environment: Oracle 10g RAC/9i, Sun Solaris, AIX, PL/SQL, .Net, Java, Stored Procedures, Oracle Streams, DATAGUARD,Import Export, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.

Confidential, DALLAS, TX

Oracle DBA

Responsibilities:

• Part of INM DBA Support team for the Production/UAT databases pertaining to various entities of the HSBC Group. Involved in designing and creating the Oracle 9i database.
• 24x7 support for Critical Applications on Global Banking and Check Transaction System.
• Installed and Configured Oracle 9i/10g on different operating systems.
• Worked as Production Support for Oracle based systems and UNIX based Server environments.
• Managed Users access control and security by creating appropriate roles and profiles.
• Enforced security by creating roles, giving grants on the tables, stored procedures, and other database objects depending on role.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Used SQL*Loader to load data from flat files to Oracle database.
• Created database links for data transfer to support distributed transactions.
• A batch performance monitor collects application performance data, collates it and produces reports that illustrate application efficiency
• Extensive Conceptual noledge on designing Data Modeling like Data Models, Conceptual, Logical, Physical Schemes, Data Modeling Process, Modeling Methodologies, Entity Relationship Diagrams, Generic Data modeling, Semantic Data modeling.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Migration of database from Oracle 9i to 10g. Performed Backup and Recovery using RMAN.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, tablespace, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.

Environment: s: Oracle 9i, 10g, HP-UX, Red Hat Linux, RMAN, TOAD, Data Pump, EXPLAIN PLAN, STATSPACK, TKPROF.

Confidential

Oracle DBA

Responsibilities:

• Responsible for installation, Maintenance, Backup, Recovery of Oracle 9i database on Sun Solaris and setting up and maintaining user accounts and profiles
• Ensured proper online and off line Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking privileges when required.
• Involved in Database logical Designing (Table spaces and Rollback Segments).
• Monitoring of database objects like rollback segments, temp segments and table spaces.
• Performed Backup and Recovery using RMAN.
• Storage and space management including table space growth, monitoring data files and extent growth
• Constantly monitor the performance of the Databases by viewing Alert log files & Trace files.
• Monitoring of database for growth, data fragmentation and correcting them for better performance
• Partitioned large tables to increase the performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the better performance tuning.
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance. Developed PL/SQL Functions, Procedures, Packages and Triggers.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups. Data Pump Utilities to move the data between different databases and for backups
• Instance cloning done to create test and training environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Environment: Oracle 9i, SQL, PL/SQL, Sun Solaris, TKPROF, EXPLAIN PLAN, STATSPACK, SQL*Loader, SQL*Plus, Shell Scripting, Windows-NT, HP-UX, Oracle 9i/8i. E