SUMMARY:

• 9 years of experience as an Oracle Database administrator, having extensive experience in administration, installation, configuration and upgrades with Oracle database Software 12c/11g/10g on Sun Solaris, Red Hat Linux, Oracle Linux, AIX, and Windows Platform.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD 12.1
• Experience in configuring GoldenGate Replication
• Hands on experience on RAC databases and RAC Services administration.
• Experience in designing, implementing and supporting highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
• Experience on Oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment.
• Converted PHYSCIAL STANDBY to SNAPSHOT STANDBY and to ACTIVE DATA GUARD.
• Configuration and Management of Data Guard on RHEL and OEL.
• Experience in administrating and migrating databases on Exadata platform.
• Working experience with Oracle Exadata X2 - 2, X4-2 and X5-2 Servers nodes ranging from 2 to 8.
• Hand on experience on Exadata smart scan and Hybrid columnar compressions.
• Setup and installed Oracle 12c with multitenant and 11gR2 RAC software with ASM.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g and 10g in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN backup.
• Experience in active duplication of databases using RMAN cloning or duplicate.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc.
• Working knowledge on 13C OEM (Oracle Enterprise Manager).
• Performed Migration and Upgrade of databases to 12c and 11gR2.
• Upgradation of databases applying patches, patch sets and critical patch updates.
• Configuration of Automatic Storage Management (ASM).
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Implementation of Flashback Technology to restore lost data.
• Working experience in creating materialized views.
• Performance tuning of the database using 11g new features - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM, SPA and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Excellent track record of co-ordination and communication with system administrators, business data analysts and development teams.
• 24*7 on-call production database support and maintenance including remote database support.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 11g R2, 10g RAC, 11g R2 RAC, 12c RAC, 12c Multitenant

Operating Systems: Redhat Linux AS 3-6 Oracle Linux 5-6, Solaris 2.8-10, Windows, AIX

Oracle HA and RAC Tools: Crsctl, Srvctl, Ocrconfig, Oifcfg, Ocrdump, Ocrcheck, Olsnodes, Cluvfy, Vipca

Performance Tuning: AWR, SQL Level AWR, SQL Monitoring, ASH, Tkprof, Explain Plan, Auto trace, Optimizer Hints, DBMS Stats, Parallelism, Partitioning, oradebug

Oracle Technologies: ASM, Enterprise Manager Grid Control and Cloud Control, Exadata X2-X5, sqlplus, emctl, asmca, dbca, netca, lsnrctl, rman, Data Pump expdp & impdp, sqlldr, External Tables, adrci, Logminer, dgmgrl, Flashback Query, Flashback DB, Restore Point

Replication and DR: Data Guard, Physical Standby, Snapshot Standby, Golden Gate

Softwares: MS Office Suite, Acrobat, MS Visio, Share Point, HTML, Putty, Toad, Patrol, Oracle SQL Developer, MobaXterm, Jira, Open Office, ITSM

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle Database Administrator

Environment: Oracle 10g, 11g, 12c, Linux 4/5, OEM12c, OEM10g, RMAN, Exadata, Grid, RAC, ASM, Dataguard, Dbsmart, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports

Responsibilities:

• Working on 12c multi-tenancy on Exadata platform.
• Worked on databases ranging from 500GB to 45TB.
• Supporting 45 Terabyte Oracle Data Warehouse (Oracle 12c).
• Upgrading RAC databases from 10.2.0.5 to 11.2.0.2 and 11.2.0.4 to 12c.
• Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and single instance databases.
• Performed 12c Upgrade of RAC Grid Infrastructure from 11g.
• Experience in database administration of Oracledatabases used for critical applicationson Exadata platforms.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Performed Physical standby database rebuild using SRDF technology when gap is unrecoverable.
• Performed switch-over and switch-back from primary to its corresponding standby databases during maintenance window and when required.
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Working knowledge on Oracle streams and Performed complete rebuild of oracle streams.
• Responsible in leading the project and writing shell scripts to automate the process ofupgrading Enterprise level Golden Gate software from 11.1.1.1.1 to 11.2.1.0.14
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Addition of ASM disks to a database disk group.
• Implemented EMC Data Domain Boost on servers for quicker backups and recovery.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Applying Patch Set Updates (PSUs) every quarter in rolling mode with no downtime.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Established performance tuning best practices used by the DBA and Development teams.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Capacity Planning and requesting the storage required by analyzing the database growth.
• Provided a positive impression of support centre by documenting, tracking, and following-up on all solutions making sure end-user problems were resolved to their satisfaction
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Also, configured database cloning using RMAN.
• Provided appropriate security for users of databases, applications, servers, and systems, by setting and managing accounts, keeping sensitive data secure.
• Worked in shifts and on call support for one weekend every month.

Confidential, Dallas, TX

Sr.Oracle Database Administrator

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN,ADEPT

Responsibilities:

• Buidling databases both standalone and clustered databases (RAC), manually and using ATT tool ADEPT .
• Installed and Configured Oracle 10gdatabases on Linux and also Upgraded Oracle databases from 10g to 11g
• Maintenance of around 20 databases combined on all the production, development and testing environments.
• Install and configured Oracle databases on windows server 2003 and 2008 platform.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data Pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Experienced in performing Point in time recovery using RMAN.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor and SGA Trace.
• Created indexes to facilitate easy user interface implementation and tuning.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Confidential, Collierville, TN

Sr. Oracle Database Administrator

Environment: Oracle 10g/11g, RAC, SQL Loader, Sun Solaris 10, OEM, Red Hat Linux, TOAD, PL/SQL, DB Artisan.

Responsibilities:

• End-to-End implementation of High Availability solutions Oracle 11gR2 RAC with ASM.
• Good experience in using 11g RAC utilities such as srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities.
• Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.
• Experience in application support in partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, Application audit logs, Oracle RAC, Scheduling, etc
• Experience in Data guard (DR) Switchover and failover of RAC and Non RAC databases.
• Installed and configured Golden Gate for replication.
• Setup parameter files for extract and replicat processes in golden gate.
• Create golden gate user with necessary privileges and investigate replication failures using log dump utility.
• Supported critical golden gate system and tested for impact of multiple extract and replicat processes.
• Rehosting and refreshing of schemas from one host to another by using expdp and impdp utilities.
• Creating Physical design models and estimation of size of data using power designer.
• Experience with RMAN backup and recovery setup.
• Performed SQL query tuning and optimization.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache
• Database Cloning and standby database creation using RMAN and manual method from Production to Test and Development environments.
• Maintaining disks for ASM storage inside the disk group and adding using ASMCA for increasing storage as required.
• Installed Oracle text and created context indexes for accented character search.
• Planned and upgraded DB including patch updates (CPU/PSU/one-off).
• Creating incidents, alerts, blackouts, thresholds using OEM 12c.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, Cumulative and differential Incremental Backups.
• Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
• Monitored performance of queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor.
• Maintained and setup streams for schema level propagation and SQL apply.
• SQL, PL/SQL Programming, Shell Scripting, Partitioning, Logical and Physical Database Design.
• Responsible for optimizing data access and performance by tuning indexes.
• Hands on experience in writing UNIX Shell Scripts for automating various database activities.

Confidential, MD

Sr. Oracle Database Administrator

Environment: Oracle 9i, 10g, RAC, Sun Solaris, Toad, HP-UX, ASM,GRID, AWR, OEM, Data guard, RMAN, Shell Scripting.

Responsibilities:

• 24 X 7 Production database support with on call pager
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installation and Maintenance of Oracle 9i, 10g, 11g on IBM-AIX, Red Hat LINUX.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment.
• Minimized downtime during disaster recovery and data corruption using Data guard.
• Management of table space growth, monitoring data files additions, extent growth.
• Worked on several shell scripts to maintain the database activities & implemented automated backup strategy using the UNIX shell script.
• Experience in migrating database from NON-ASM to ASM.
• Creation of cluster indexes, bit-map indexes and creation of index organized tables to enhance performance.
• Use of Data gaurd broker command line utility DGMGRL for setting up configurations,starting and stopping Redo transport services and Log apply services & performing switch overs.
• Performing Database Administration activities like space management, user and roles administration, schema management.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Good experience in golden gate for cross platform migrations.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Confidential, Danville, PA

Sr. Oracle Database Administrator

Environment: Oracle 9i/10g/11g, Linux, Solaris, PLSQL, Shell Scripting, RMAN, Grid control, Data guard, EXP, IMP, Data Pump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Responsibilities:

• Provide 24x7 production database support
• Support round the clock deployments
• Install the 11gR2 databases for test, development, production-like, production and standby databases
• Migrate database from Solaris to Linux
• Upgrade Oracle Database from 10g to 11gR2
• Clone 10g and 11g oracle homes for setting up standby databases and recovery purposes.
• Install grid agents and setup the databases per standards for monitoring and scheduling jobs.
• Use traditional export-import and Data Pump for refreshing schemas, tables and different objects
• Use Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Apply security related CPU and One-off patches using Opatch utility, Apply RDBMS Patch set Utility (PSU).
• Maintained oracle databases on both windows( NT/2003/2008).
• Recovery of Database (recovering from Media Failure, recovering tables dropped accidentally,recovering data files, recovering from Block Corruption)
• Generate performance reports and Daily health checkup of the database using utilities like AWR,
• Statspack and ADDM to gather performance statistics
• Work closely with the project teams to deploy their changes in the database and servers

Confidential, Menomonee Falls, WI

Sr. Oracle Database Administrator

Environment: Oracle 9i/10gRAC, RHEL, Sun Solaris, SQL, PLSQL, UNIX Shell Scripting, RMAN, Oracle 10g Grid control, Data guard, SQL*Loader, EXP, IMP, TOAD, Data pump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Responsibilities:

• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Designing, documenting and deploying through the various development and production environments.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of Oracle 10gRAC and Standby Databases for high availability and disaster recovery.
• Automation of deployment/migration from existing systems (Oracle), monitoring and reporting.
• Database Migration
• Applied CPU, One-off patches using Opatch utility, RDBMS patch set Upgrade (PSU).
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Used Oracle 10g grid control utility.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using SR, SAR, IOSTAT and RDA.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Confidential

Oracle Database Administrator

Environment: Oracle 10g and 9i, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, STATSPACK

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Review of Database logical and Physical design
• Creating and managing users, roles, privileges, profiles, schemas
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• Oracle Security Patches Installation on Oracle 10g R2.
• Write and modify UNIX shell scripts to manage Oracle environment
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly

Confidential

Oracle Database Administrator

Environment: Oracle 8i/9i, SQL, PL/SQL, RHEL, Sun Solaris 2.5, 2.6, Shell scripting, Tkprof, Explain plan.

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Installation of Oracle 8i/9i on Solaris platform.
• Experience in working with cold and hot backups and recoveries.
• Installation and creation of databases & worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Customized database backups for Disaster Planning and implementation.
• Creating profiles and assigning to users.
• Performed database tuning for daily loads and slow response issues by refining queries.
• Monitoring Database for fragmentation and correcting them.
• Creating and implementing backup and recovery strategies.