We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Atlanta, GA

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

Hire Now