SUMMARY:

• I have about 10 years of experience as an Oracle Database Administrator, working with prestigious organizations and having hands on experience in production database administration, support, installation, configuration, upgrades, patching, performance tuning, backup and recovery, cloning, migration, space management and database security & auditing.
• Expertise in Oracle 9i/10g/11g/12c, 10g and 11g RAC/ASM installation, administration, configuration, production support, upgrades, patching, space management, database security, performance tuning, troubleshooting, database design, UNIX shell scripting, Oracle Enterprise Manager (OEM) and documentation.
• Installed oracle database server on Solaris 8/9/10, HP - UX, IBM AIX 5.1/5.2/5.3/6.1/7.1 SP03, RHEL and Windows environment and migration of oracle server from 10g to 11g and 11g to 12c and applied oracle patches.
• Thorough knowledge in high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.
• Proficient in Database System Architecture, Oracle Streams, Logical/Physical database design (Data Guard implementation for Disaster Recovery).
• Proficient in Physical & Logical Standby Database creation and maintenance, Data Guard, DG broker and Patching of Oracle Databases
• Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring and troubleshooting.
• Implemented Oracle RAC with ASM and standalone with ASM in different environments such as development, testing, production and standby databases.
• Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Proficient in Hot/Cold Backup, Recovery and Cloning of databases using RMAN and shell scripts with VERITAS Net Backup, Export and Import database schema.
• Expertise knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$, DBA views and Data modeling, Logical and Physical databases design.
• Monitored database servers using various tools such as Oracle Enterprise Manager (OEM), Oracle Grid Control and TOAD.
• Actively involved in troubleshooting various database performance issues and used dynamic V$ views to identify the root cause.
• Expertise in performance tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, and ADDM to collect and maintain performance statistics and improves the database performance.
• Expertise in planning, implementation and documentation of installation, migration, patching, backup retention policy, recovery, security, auditing, capacity planning, space management and storage allocation (SAN/NAS).
• Expert in export/import and data pump import to load data in to tables.
• 24/7 Production Database support and maintenance, and worked in a rotating on-call schedule. SR/TAR tracking, Espresso and Service Now support.
• 3 years of Experience in Mongo DB setup and administration.
• Extensively worked on setups, upgrades, complex migrations, cloning, security, and administration under stringent deadlines.
• Worked extensively on MySQL setup and administration.
• Expertise in configuring standby to Active Data guard, snapshot standby mode, Switchover, Failover and FSFO operations.
• Experience in setup and maintaining Database Security - SOX, auditing, TDE and SSL.
• Extensive Experience with DD-BOOST, Cold Backup, Hot Backups, Logical Backups and RMAN Backups (Incremental Backups)
• Performance Management, Partitioning of large table for better performance.
• Experience in OLTP database systems, managing Critical Oracle Databases.
• UNIX shell scripting, CRON jobs.
• Attended various workshops on Oracle-10g Grid Control Workshop, Oracle 10g Data Guard and 11g ASM and RAC Workshops.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment

TECHNICAL SKILLS:

Operating Systems: AIX 7.1,6.1,5.1, 5.2, 5.3, MAC OS X, Sun Solaris 8, 9, 10, RHEL 6.x, 4.x, 5.x, HP-UX 10.x, 11.x, and Windows 2008/95/98/ME/NT/2000/XP.

RDBMS: Oracle 12c, 11g RAC, 10g RAC/9i, Mongodb and MySQL

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

Tools: /Utilities: RMAN, ASM, Grid Control, Golden Gate, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD, Espresso, Service Now, Radar,Putty

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

Other: SAN, TSM, EMC, NetApp, VERITAS NetBackup

WORK EXPERIENCE:

Confidential, Pleasanton, CA

Senior Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 12c and 11g databases.
• Install and configure Oracle Golden Gate 11, 12.2 on AIX and Linux platforms for bidirectional replication.
• Upgrade Oracle Golden Gate from 11.1 to 12.2 for unidirectional replication on heterogeneous platforms.
• Apply bug fix patch, performance tuning and setup of Oracle GoldenGate on regular basis.
• Add/remove new schema, tables in Oracle Golden Gate replication on regular basis.
• Co-ordinate and participate in new application release compatibilty and performance testing for Golden Gate.
• Migrate database using Oracle Golden Gate replication.
• Setup of Oracle Goldengate on HACMP cluster for Oracle database.
• Maintenance and administration of Oracle database on Exadata servers.
• Compression of tables used in Oracle Golden Gate replication.
• Setup/administartion of TDE on 12c databases and backup of wallet.
• Implemented Oracle 11g RAC and Standby Databases including Active Data Guard for High Availability and Disaster Recovery.
• Installation configuration and administration of Mongo DB database.
• Installed Mongo DB and created setup replica sets and clusters. Installed MMS and setup monitoring agents. Configured alerts for relevant mongo metrics.
• Optimizing, monitoring, and understanding of Mongo DB in system setting areas as well as by modeling data as required for application.
• Written shell scripts for backup automation and monitoring tasks
• Hybrid Columnar Compression (HCC) for tables less frequently used.
• Creating table spaces, tables, and users for custom applications.
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
• Capacity planning and benchmarking.
• Rebuilding of Indexes, Partitioning of large table for better performance and management.
• Installation, configuration and administration of Golden Gate.
• Replication using Golden Gate, streams, Data guard and DG broker.
• Managing OLTP/Data Warehousing Databases.
• Implemented Databases with FSFO.
• Implemented SOX, auditing, TDE, and SSL setup.
• Developed PL/SQL Functions, Procedures Packages and Triggers.
• Importing data from flat files into database using SQL loader and External Tables.

Environment: Exadata, Oracle 11g RAC, AIX, Red Hat Linux, OEM(Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM,TKPROF, STATSPACK AWR, ADDM, SQL* Loader.

Confidential, Sunnyvale, CA

Senior Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 12c, 11g and 10g databases.
• Implemented Oracle 11g RAC, 10g RAC and Standby Databases including Active Data Guard for High Availability and Disaster Recovery.
• Trained a team for 24x7 support for Confidential Care Production Databases and Applications With High Criticatility.
• Performed daily health check and generated reports for all Critial Databases and based on it performed Risk mitigation Plan.
• Installation configuration and administration of Mongo DB database.
• Installed Mongo DB and created setup replica sets and clusters. Installed MMS and setup monitoring agents. Configured alerts for relevant mongo metrics.
• Optimizing, monitoring, and understanding of Mongo DB in system setting areas as well as by modeling data as required for application.
• Proactively analyzed performance of critical metrics graphed in MMS, and uncovered potential issues for existing mission critical production databases.
• Point in time Backup and recovery in Mongo DB using onsite MMS.
• Installation configuration and administration of MySQL Database.
• Performed database Cloning to setup test and development database.
• Database Upgrades and Migration of Databases from 9i to 10g and 10g to 11g, applying patches whenever required
• Applied CPU patches
• Developed physical and logical models of the databases
• Written shell scripts for backup automation and monitoring tasks
• Migrated databases from Linux, Sun Solaris to AIX.
• Creating table spaces, tables, and users for custom applications.
• Extensive knowledge on OEM.
• Involved in design and layout for the database structures and implementation.
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
• Cold Backup, Hot Backups, Logical Backups and RMAN Backups (Incremental Backups).
• Design and implementation of backup and recovery procedures.
• Implemented Oracle Streams for the replication of data.
• Capacity planning and benchmarking.
• Rebuilding of Indexes, Partitioning of large table for better performance and management.
• Installation, configuration and administration of Golden Gate.
• Replication using Golden Gate, streams, Data guard and DG broker.
• Managing OLTP/Data Warehousing Databases.
• Implemented Databases with FSFO.
• Implemented SOX, auditing, TDE, and SSL setup.
• Developed PL/SQL Functions, Procedures Packages and Triggers.
• Importing data from flat files into database using SQL loader and External Tables.

Environment: Oracle 11g RAC/10g RAC/9i, Sun Solaris, Red Hat Linux, HP-UX, Windows, OEM(Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM,TKPROF, STATSPACK AWR, ADDM, SQL* Loader.

Confidential

Oracle Database Administrator

Responsibilities:

• 24x7 support for Production databases and applications
• Installation, configuration, upgrade, migration and administration of Oracle 10g/11g databases.
• Implemented Oracle 11g RAC and Standby Databases for High Availability and Disaster Recovery.
• Upgraded databases from 10g to 11g.
• Applied CPU patches as necessary.
• Involved extensively in installation and configuration of Oracle 10.2 Grid control and configured above 20 DBs under Grid monitoring.
• Created Materialized Views & Logs utilizing, Query Rewrite.
• Tuning the performance of the databases with respect to memory, I/O, and contention.
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
• SQL, PL/SQL Programming. Developed PL/SQL functions, procedures, packages and triggers.
• Written shell scripts for the automation of backups and routine tasks.
• Design and implementation of backup and recovery procedures.
• Managing OLTP/Data Warehousing Databases.
• Worked on conceptual model, logical and physical database design.
• Installation of Oracle databases and evaluation of the hardware for the Database Servers.
• Created partition of tables
• Storage management using ASM.
• Perform full or partial refresh of non- production schema/database.
• Evaluating and preparing System documentation and Audit report
• Impact analysis and High level and low level design documentation.
• Identify the problems/issues in production and resolve within Application Service Level Agreement (ASLA).
• Root cause analysis and providing stability to the Database.
• Knowledge repository maintenance of tickets and issues for achieving productivity gains and to reduce person dependencies

Environment: Oracle 11g/10g RAC/Dataguard, IBM AIX, Sun Solaris, Red Hat Linux, HP-UX, Windows, OEM (Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM, TKPROF, STATSPACK AWR, ADDM, SQL* Loader.

Confidential

Oracle Database Administrator

Responsibilities:

• 24x7 support for Production and non prod Oracle databases.
• Installation, configuration and administration of Oracle 11g/10g/9i databases.
• Applied patches on Oracle databases.
• Upgraded databases from 9i to 10g, 10g to 11g, and 9i to 11g.
• Performing upgrades for the databases and software installations for new releases.
• Monitoring growth of the database objects for space management.
• Regular Monitoring Alert Files on daily basis.
• Migrating schemas from development to test and test to production databases.
• Managed System Users, security and system monitoring for development / production environment.
• Backup of the databases using RMAN and Conventional Hot backups.
• Created index or rebuild index in order to improve query performance in Oracle.
• Performed installation, configuration, deployment, migration and up gradation of oracle database servers
• Implemented materialized views.
• PL/SQL Programming.
• Extensive UNIX Shell scripting in csh, ksh.
• Assisting customer setup, tune and maintain Oracle database.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Cloning of databases from production to development and test.
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
• SQL, PL/SQL Programming. Developed PL/SQL functions, procedures, packages and triggers.
• Performed Database security and Auditing.
• Cloning databases using scripts as well as RMAN.
• Synchronize Databases with production for data and testing purpose.
• Having Strong Oracle PL/SQL Programming Skills.
• Help Development team for technical issues related to database issues.
• Involved in running the Access Profile batch jobs.
• Creating the database schema, converting VIEWS specific to database.
• Development of backup and recovery procedures and Import and Export of Data (Logical Backup) and RMAN.
• Creation of the Test database, Table spaces, Tables and Indexes, Index rebuilding.
• Data migration, loading with SQL Loader.

Environment: Oracle 10g RAC/9i/8i,Citrix Xenapp4.5, Oracle Application server, Oracle web logic, Red Hat Linux, HP-UX, OEM (Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM, TKPROF, STATSPACK, AWR, ADDM, SQL* Loader.

Confidential

Database Administrator

Responsibilities:

• Create new database structures, install and implement the fixes.
• Oracle 24* 7 customer support services.
• Creation and sizing of tablespaces and setting tablespace attributes.
• Troubleshooting Oracle issues with Application Stored Procedures, Connectivity problems, Space issues, access issues.
• Installation, configuration and administration of Oracle 10g/9i databases.
• Provide support to maintain databases for application development groups.
• Installation of Oracle Database and Oracle products.
• Writing scripts for backup and recovery.
• Upgraded databases from 9i to 10g.
• Performance monitoring and tuning using Explain Plan, SQL TRACE, TKPROF, AWR, ADDM
• Creating users and granting privileges.
• Applied patches to Oracle databases
• Writing UNIX shell scripts for backup and recovery.
• Writing SQL scripts to monitor database performance.
• Problem troubleshooting and resolution.
• Database tuning, backup and recovery and general day to day database administration tasks.
• Conducted training for TCS internal.
• Sending monthly oracle updates mailer to clients.
• Environment: Oracle 10g/9i/8i, Sun Solaris, Red Hat Linux, Windows 2003, OEM (Grid Control), SQL, PL/SQL, TOAD, RMAN, OEM, ASM, TKPROF, STATSPACK and SQL* Loader.

Confidential

Database Administrator

Responsibilities:

• On call customer support services.
• Installation, configuration and administration of Oracle 10g/9i databases.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Writing scripts for backup and recovery.
• Upgraded databases from 9i to 10g.
• Performance monitoring and tuning using Explain Plan, SQL TRACE, TKPROF, AWR, ADDM
• Creating users and granting privileges.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Designing and enforcing standards and naming conventions.
• Writing UNIX shell scripts for backup and recovery.
• Writing SQL scripts to monitor database performance.
• Problem trouble shooting and resolution.
• Database tuning, backup and recovery and general day to day database administration tasks.
• Imparting training to TCS associates.
• Sending monthly oracle updates mailer to clients.

Environment: Oracle 10g/9i, Sun Solaris, Red Hat Linux, Windows 2003, OEM (Grid Control), SQL, PL/SQL, TOAD, RMAN, OEM, STATSPACK, AWR and ADDM.