PROFESSIONAL SUMMARY:

• Over 12 years of experience with Oracle Database Administration such as Database Installation, Upgrade, Maintenance and support of Oracle Database Server (9i/10g/11g) on a variety of UNIX flavors (Linux, Solaris, AIX).
• Over 1 years of experience in Installing and maintaining Oracle GoldenGate (11gR2) Replication processes.
• Experience in supporting MySQL and SQL Server database.
• Experience in installing Oracle 11g Grid Infrastructure with ASM disk as part of Oracle RAC 11gR2 installation.
• Installed Oracle 11gR2 RAC database with ASM disk both with bare - metal server and on Virtual Machine (using Vmware).
• Extensive experience in creating ASM diskgroups from SAN disks, adding new ASM disks to existing ASM diskgroup, Adding disk space to the existing ASM disk.
• RAC experience includes working experience in - planning, designing, developing, deploying, maintenance and supporting RAC on Linux, CentOS, IBM AIX & Windows XP/NT servers for high availability (HA).
• Configured the Load Balancing on RAC database through service names using SRVCTL utility and using SCAN - Single Client Access Name (in 11g).
• Scheduled shell scripts to monitor each of the RAC nodes and to detect any RAC hang check.
• Involved in capacity planning: developed strategies and maintenance plans and implemented the same for monitoring, security, disaster recovery & load balancing.
• Experience in changing the public, private, virtual and SCAN IP for 11g RAC database.
• Experience with database backup, restore, and disaster recovery procedures such as creating catalog database, Virtual Private Catalog, Hot Backup, RMAN (9i/10g, 11g) full & incremental backup, 10g Data pump (expdp, impdp).
• Experience in recovering corrupted data files using “recover corruption list” command.
• Experience in cloning 11g RAC database from RMAN backups.
• Experience in Oracle Data Guard (Both Physical & Logical) for setup, maintenance and gap resolution.
• Installed GoldenGate 11gR2 software in Test and production environment.
• Prepare GoldenGate parameter files for Extraction and Replication to implement data filter and column mapping.
• Implemented High availability using GoldenGate Replication from Oracle-to-Oracle and Oracle-to-SQL Server environment.
• Implanted Bi-directional replication using GoldenGate.
• Handled Conflict resolution using CDR (Conflict Detection and Resolution) Feature.
• Implemented GoldenGate setup to achieve Uni-directional replication both for DDL and DML operation.
• Improved performance of GoldenGate replication process by implementing parallel Extract & Replicat processes.
• Experience in using GoldenGate Veridata for detecting data discrepancies.
• Investigated Replication failures using LogDump utility
• Performed initial Data Load option of GoldenGate during environment build.
• Developed Shell Scripts to monitor different GoldenGate processes.
• Successfully implemented Oracle wallet on RAC database for encrypting both normal and BLOB columns.
• Experience on managing Oracle Grid Control servers & Database Control to monitor performances and schedule alerts for all the db servers.
• Experience in external monitoring tools such as Nagios, Cacti, Zenoss and Tape backup tools such as Amanda, HP Data Protector, TSM (Tivoli).
• Good experience in implementing different performance strategies including generating explain plan, creating normal & reverse-key indices, gathering stats, modifying db parameters etc.
• Extensive experience working as Team Lead by leading a technical team upto 5 in offshore-onshore model projects.
• Actively involved in preparing Logical and Physical data modeling from the business requirement using different modeling tools such as Erwin, Power Designer (From DataStage).
• Extensive experience in using SQL loader utility, External Tables for loading data from Flat files to Oracle database.
• Experience in using export/import and expdp/impdp utility to make copy of databases or to backup databases for testing purposes.
• Strong experience in working with all advanced SQL functions including, Analytical function, REGEXP, DBMS LOB package, DECODE, NVL,DBMS CRYPTO package (for encrypting strings) etc.
• Strong experience in Oracle Procedures, packages and triggers.
• Strong experience in all database object operation, including creating & Altering Tables/ Constraints/ Index/ Synonyms/ Sequence/ View/ Table Partitions.
• Always worked with the business analyst (Line-of-business), testing team and the front-end developers to provide the necessary support from the database side.
• Extensive hands-on experience working in Unix (Linux, CentOS) environment and with UNIX Shell Scripting.
• Using the Crontab in UNIX and Scheduler for Automatic Tasks.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.
• Extensive experience on working with onsite-offshore model which involves co-ordinating with offshore or onshore team.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i/7.X, Sql server 2000 & 2005, MySQL, MS Access

Database Tools: ERWIN, Designer, SQL Navigator, Designer 2000, SqlPlus, SQL*Plus, SQL*Loader, expdp/impdp, RMAN, Toad, SQL* Navigator, SQLDeveloper, Oracle Grid Agent, Oracle GoldenGate

CASE Tools: VMWare, Designer 9i, ERWIN, ER/Studio, Sybase Power Designer

Operating System: UNIX, Linux, HP-UX, AIX, Windows NT, Windows 2000, Windows XP.

Hardware: Sun Sparc E5000, HP9000, RS6000, Compaq, EMC

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

PROFESSIONAL EXPERIENCE:

Confidential, ATLANTA, GA

Sr. Oracle DBA

Responsibilities:

• Install, configure and support of Oracle RAC Database 10g & 11g on Linux environment.
• Extensively used srvctl & crsctl commands to perform RAC database related activities.
• Monitored the database performances using OEM Grid Control utility.
• Implemented Oracle 11g RAC load balancing using SCAN (Single Client Access Name) feature.
• Installed GoldenGate 11gR2 software in Test and production environment.
• Prepare GoldenGate parameter files for Extraction and Replication to implement data filter and column mapping.
• Implemented High availability using GoldenGate Replication from Oracle-to-Oracle and Oracle-to-SQL Server environment.
• Implanted Bi-directional replication using GoldenGate.
• Handled Conflict resolution using CDR (Conflict Detection and Resolution) Feature.
• Implemented GoldenGate setup to achieve Uni-directional replication both for DDL and DML operation in Oracle RAC database.
• Improved performance of GoldenGate replication process by implementing parallel Extract & Replicat processes.
• Experience in using GoldenGate Veridata for detecting data descrepancies.
• Investigated Replication failures using LogDump utility
• Performed initial Data Load option of GoldenGate during environment build.
• Developed Shell Scripts to monitor different GoldenGate processes.
• Created RMAN scripts for DB duplicate (to a different host) and DB Restore from existing backups.
• Extensively worked on the TSM (Tivoli) tape backup configuration for RMAN DB backups.
• Created physical Data Guard (Stand-By DB) for 11g RAC Production database.
• Experience in oracle Data Guard maintenance such as fixing log gap, transitioning from recovery mode to read-only mode.
• Writing Unix Shell script to track and monitor database alerts and scheduled the scripts through crontab.
• Executing Database script for scheduled releases on all the database environments (non-Prod & Prod).
• Extensively Used Explain Plan, SQL Trace, AWR, ADDM reports to Monitor Performance Tuning.
• Implemented object auditing to track tables DMLs & DDLs for production database.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Worked on user & role management such as user/ role creation, maintenance, audit.
• Executed the backup/recovery drill by recovering a copy of the database from the RMAN incremental backup and documenting the steps.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Worked on optimizing various SQL queries by creating index, reverse-key index, gathering table stats in fixed intervals, archiving old/unused data from larger tables and using hint, changing DB parameters.

Environment: Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp, Oracle GoldenGate 11gR2

Confidential

Sr. Oracle DBA

Responsibilities:

• Install, configure and support of Oracle RAC Database 11g on Linux environment.
• Installed Oracle Grid Infrastructure 11g as part of the RAC installation in staging and Production environment.
• Used oracleasm utility to create ASM disks from SAN disks, add new ASM disks to existing diskgroup and add disk space to the existing disk.
• Monitoring all the databases for tablespaces and OS disk space usage and add space as necessary.
• Monitored the database performances using Database Control utility.
• Installed Oracle Wallet for standalone & RAC databases to encrypt the biometric information (Both for normal & BLOB columns)
• Extensively used srvctl & crsctl commands to perform RAC database related activities.
• Implemented Oracle 11g RAC load balancing using SCAN (Single Client Access Name) feature.
• Performed Database maintenance to change the public, Private & SCAN IP of the existing RAC installation.
• Executing Database script for scheduled releases on all the database environments.
• Identifying the long running queries from Database control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint or any other query changes to make the query faster.
• Writing Unix Shell script to track and monitor database alerts and scheduled the scripts through crontab.
• Extensively Used Explain Plan, SQL Trace, AWR, ADDM reports to Monitor Performance Tuning.
• Implemented object auditing to track tables DMLs & DDLs for production database.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Created catalog database to implement RMAN incremental backup strategy in all the production databases.
• Created automated scripts to make hot RMAN backup (both Full & Incremental) for the Oracle databases.
• Executed the backup/recovery drill by recovering a copy of the database from the RMAN incremental backup and documenting the steps.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Worked on optimizing various SQL queries by creating index, reverse-key index, gathering table stats in fixed intervals, archiving old/unused data from larger tables and using hint, changing DB parameters.
• Worked as a Team Lead for one junior DBA and one technical support team member on their everyday activities.
• Installed GoldenGate 11gR2 software in Test and production environment.
• Prepare GoldenGate parameter files for Extraction and Replication to implement data filter and column mapping.
• Implemented GoldenGate setup to achieve Uni-directional replication.
• Performed initial Data Load option of GoldenGate during environment build.
• Installed and managed Mysql server 5.5 to be used for reporting.

Environment: Erwin 7.1,Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp

Confidential, Los Angeles, CA

Sr. Oracle DBA

Responsibilities:

• Install, configure and support Oracle Database (Release 10g & 11g) for Dev, QA, Staging, UAT and Production environments.
• Monitoring all the databases for tablespaces and OS disk space usage and add space as necessary.
• Installed the Grid Control agents on all the DB servers to better monitor the performance and gather a lot other metrics for the target databases.
• Executing Database script for scheduled releases on all the database environments.
• Refresh the data from Prod to UAT/Staging/QA databases on need basis using expdp/impdp utility.
• Identifying the long running queries from Grid control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint or any other query changes to make the query faster.
• Writing Unix Shell script to track and monitor database alerts and scheduled the scripts through grid control servers using UDM.
• Configured, implemented, 10g RAC with ASM disk on Linux servers.
• Performed extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Capacity Planning for all the Stage Servers (Performance Analysis, Storage Growth and Grid Controlling and monitoring user access to the database.
• Extensively Used Explain Plan, SQL Trace, AWR, ADDM and ASH reports to Monitor Performance Tuning.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Scheduled scripts to monitor each of the RAC nodes and to detect any RAC hang check.
• Gathered OS statistics using Oracle OS Watcher tool.
• Used export and import commands for database back-up and refresh activities.
• Created automated scripts to make hot snapshot backup and RMAN backup (both Full & Incremental) for the Oracle database.
• Created physical Data Guard for Production database (11g RAC)
• Executed the backup/recovery drill by recovering a copy of the database from the hot backup and documenting the steps.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through either cron job or Grid control UDM.
• Writing Technical Specification Document (TSD) and oracle stored procedure for new client’s Migration project.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Extensively worked on Oracle SQL, PL/SQL stored procedure, function, package, trigger and other oracle objects for Canvas projects (such as, new client migration and data archival job).
• Developed scripts to create table with storage clause, view, materialized views, external table, index, sequence, synonyms, grant privileges.
• Extensively worked on many database development tools such as TOAD, SQL Navigator, and PL/SQL developer.
• Worked on optimizing new and existing SQL queries by creating index and Materialized views.

Environment: Erwin 7.1,Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp

Confidential, Cincinnati, OH

Oracle DBA

Responsibilities:

• Install, configure and support Oracle Database (Release 10g) on all the environments.
• Installed Oracle Clusterware CRS, Clustered Install of Oracle 10g, applying patch in clustered environments, created database / instances using DBCA on a four node cluster, troubleshooted RAC at OS / OCR / CRS / DB Level.
• Install the Grid Control agents on all the DB servers to better monitor the performance and a lot other metrics for the target database.
• Executing Database script for scheduled releases on all the database environments.
• Refresh the data from Prod to UAT/Staging/QA databases on need basis using expdp/impdp utility.
• Identifying the long running queries from Grid control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint, indexes, materialized views to make the query faster.
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.
• Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Writing Unix Shell script to track and monitor database alerts and scheduling the scripts through grid control servers.
• Used export and import commands for database back-up and refresh activities.
• Created hot snapshot backup and RMAN backup (both Full & Incremental) for the Oracle database.
• Added new instances to the cluster DB and removed instance from the cluster.
• Experience in working with CRS related commands.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through cron job or Grid control UDM.
• Writing Technical Specification Document (TSD) and oracle stored procedure for new client’s Migration project.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Extensively worked on Oracle stored procedure, function, package, trigger and other oracle objects for Canvas projects (such as, new client migration and data archival job).
• Developed scripts to create table, view, materialized views, external table, index, sequence, synonyms, grant privilege, DBMS jobs including the storage clause, wherever required.
• Used advance Oracle features such as MERGE, Analytical function and dynamic SQL for the migration scripts.
• Worked on tuning new and existing SQL queries by creating index and Materialized views.

Environment: Erwin 7.1, Oracle 10g, Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader

Confidential

Oracle DBA

Responsibilities:

• Install, configure and support Oracle Database (Release 10g) on all the environments.
• Install the Grid Control agents on all the DB servers to better monitor the performance and a lot other metrics for the target database.
• Executing Database script for scheduled releases on all the database environments.
• Refresh the data from Prod to UAT/Staging/QA databases on need basis using expdp/impdp utility.
• Identifying the long running queries from Grid control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint, indexes, materialized views to make the query faster.
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.
• Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Writing Unix Shell script to track and monitor database alerts and scheduling the scripts through grid control servers.
• Used export and import commands for database back-up and refresh activities.
• Created hot snapshot backup and RMAN backup (both Full & Incremental) for the Oracle database.
• Added new instances to the cluster DB and removed instance from the cluster.
• Experience in working with CRS related commands.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through cron job or Grid control UDM.
• Writing Technical Specification Document (TSD) and oracle stored procedure for new client’s Migration project.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Extensively worked on Oracle stored procedure, function, package, trigger and other oracle objects for Canvas projects (such as, new client migration and data archival job).
• Developed scripts to create table, view, materialized views, external table, index, sequence, synonyms, grant privilege, DBMS jobs including the storage clause, wherever required.
• Used advance Oracle features such as MERGE, Analytical function and dynamic SQL for the migration scripts.
• Worked on tuning new and existing SQL queries by creating index and Materialized views.

Environment: Erwin 7.1, Power Designer 5, Linux (RHEL), TOAD 8.5, Oracle 10g/9i,8i, MS SQL Server, Windows 2000,Windows XP.

Confidential, Charlotte, NC

Jr. Oracle DBA

Responsibilities:

• Executing Database script for scheduled releases on all the database environments.
• Refreshed the data from Prod to testing environment on need basis using export/import dump.
• Writing Unix Shell script to track and monitor database alerts and scheduling the scripts through grid control servers.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through cron job or Grid control UDM.
• Created and maintained read-only users for Dev team to access non-dev databases.
• Designed logical and physical data model from the Business Requirement document using ERWIN and Power Designer (Sybase).
• Developed scripts to create table, view, materialized views, external table, index, sequence, synonyms, grant privilege, DBMS jobs including the storage clause, wherever required.
• Extensively worked on many database development tools such as TOAD, SQL Navigator, and PL/SQL developer.
• Worked on optimizing new and existing SQL queries by creating index and SQL hints.
• Writing the design document for the database changes.
• Created the normalized physical Data model using Power Designer.
• Experience in developing ETL process using SQL*Loader to load the data from flat files to a temporary staging area, cleanse the data and then load it to the main database.

Environment: Erwin 7.1, Power Designer 5, Linux (RHEL), TOAD 8.5, Oracle 10g/9i,8i, MS SQL Server, Windows 2000,Windows XP.

Confidential

Oracle Developer/DBA

Responsibilities:

• Responsible for coding, testing, review and documentation.
• Writing PL/SQL packages to achieve numerous tasks and writing shell scripts for batch processing.
• Writing DDL scripts to create tables, indexes, sequences and calculating the storage parameters both in development and production databases.
• Documenting the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Created copies of schema using export/import method.
• Tracked DB errors from alert log file and scheduled DB monitoring scripts.
• Executed DB scripts on non-prod environments for new releases.
• Developing PL/SQL procedures, customizing existing programs according to the needs of the client testing.
• Designed program specs.
• Customized existing programs in Pro*C, and converted some to PL/SQL.

Environment: Oracle (8.0.x/9i), Windows NT, HP-UX 11.0, Sun Solaris, UNIX Shell Scripting, SQL Scripting, Pro*C