SUMMARY:

• Nine plus years of experience as Sr. Oracle Database Administrator providing 24x7production support as well as for Development databases (Oracle Exadata, 12c/11g/10g/9i) primarily worked on UNIX/LINUX (Sun Solaris, HP - UX,AIX, RedHat)/Windows/zLinux environments.
• Oracle Database 10g Administrator Certified Associate with experience in Oracle Database Administration activities such as Database Design, Database creation, Oracle Server Installations/Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, Multi-Node RAC, Goldengate, Apex (module) capacity planning, shell scripting, and documentation.
• Extensive experience on database administration for Oracle 12c, 11gRAC, 10gRAC, 9i within very large scale database environment and mission critical OLTP and OLAP systems.
• Installed and configured of Real Application Clusters (Oracle 11g RAC, 10g RAC), Standby Databases (DataGuard) for High Availability and Disaster Recovery.
• Ugraded databases from Oracle 9i to 10g R2, 9i to 11gR2, 10R2 to 11gR2, 11gR2 to 12c.
• Skilled in setting up/Installation and configuration of release 12c/11g/10g with ASM. Experienced in configuring & Managing the ASM.
• Experienced with GoldenGate 12c/11g replication for Oracle databases.
• Planned Goldengate setup to achieve unidirectional heterogeneous replication from SQL Server 2012R2 to Oracle 11.2.0.4 and also exposure to ELK stack
• Configured GoldenGate 12c RAC for Active-Active Replication between the Datacenter for High Availability
• Hands on experience on Oracle 12c/11g Active DataGuard/10g DataGuard with swithover, failover and Dataguard Broker
• Experience in using Export, Import, DataPump, OEM Grid Control, SharePlex, Golden gate.
• Skilled in Cross platform migrations from Windows to zLinux, Solaris to Linux, Linux to AIX
• Analyzing, Coding and Implementation of Oracle based applications.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Installed and configured Oracle Database Software 10g/11g on Zlinux, AIX in development, integration, Production Environment.
• Monitoring and management of various database components (logical & physical) like tablespaces.
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ADDM, ASH, AWR, ORADEBUG, 13c/12c/11g/10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL*LOADER and External Table.
• Skilled in MySQL, SQL Server Database Administration 2012/2008
• Good experience in managing Very Large OLTP and Datawarehousing databases.
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Experience on Backup Methodologies (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Scheduling jobs through Oracle Job Scheduler, cronjobs (Unix) and Schedule Tasks (Windows).
• Experience on Recovering Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Awareness on Oracle Support processes for technical requests through Metalink
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS:

Operating Systems:: Sun Solaris, Linux, zLinux, HP-UX, IBM AIX, WIN 2000

Languages:: C, C++, SQL, PL/SQL, UNIX Shell Scripting, PERL scripting.

Database/Applications/Tools:: Oracle Exadata, ORACLE 9i/ 10g RAC/11g RAC,12c, SQL server 2005/2008, MySQL, Recovery Manager (RMAN), TSM, TDP, Exp/Imp, Data Pump, Data Guard, Oracle Data Integrator, STATSPACK, AWR,ADDM,ASM, SQL TRACE, EXPLAIN PLAN, TKPROF, AWS, SQL Developer, TOAD, DB Artisan, SQL*Loader, TOAD, OEM/GridControl, Erwin, Remedy, Maximo, Golden Gate.

Business Intelligence Tools:: Informatica, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Oracle Database Administrator III

Responsibilities:

• 24x7 Support to production databases and critical projects including participating in a weekly on call rotation.
• Prerequisites, installation, configuration, migrations, upgrades, patches and administration of Oracle database 12c/11g on Linux VM machines and physical servers.
• Installation, configuration, database creation and supporting of Oracle 12c /11g databases.
• Installed CPU and one-off standalone patches & patch set update (PSU).
• Involved in the implementation of High availability with Real Applications Clusters(RAC), Disaster Recovery solutions with Physical/Logical Standby Databases (DataGuard).
• Working experience on upgrading and migration project, Upgraded databases from 11g to 12c.
• Configured Dataguard using physical standby and active dataguard for high availability and reporting purpose and setup DG Broker configuration.
• Supported annual DiRT (disaster recovery) exercise on multiple databases with a data center outage. And also supported database failover and switchover situations
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis. Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Working experience on upgrading and migration project, Upgraded databases from 11g to 12c (11.2.0.4 to 12cR1/R2) on RHEL.
• Setup and documented Oracle GoldenGate replication on 12c/11g for support team.
• Planned Goldengate setup to achieve unidirectional heterogeneous replication from SQL Server 2012R2 to Oracle 11.2.0.4 and also exposure to ELK stack.
• Configured GoldenGate 12c RAC for Active-Active Replication between the Datacenter for High Availability.
• Resolved replication & lag issues in GoldenGate
• Troubleshoot Repcat, Extract, Abend scenarios, data issues with developers and application teams.
• Installed SQL Server 2012/2016 and created new database, setup backup and created mirror databases. Supported database switchover from principal to mirror database.
• Worked extensively with data pump for expdp/impdp and RMAN duplication process for refreshes and creating standby databases.
• Created new schemas, constraints, indexes, synonyms, and tablespaces. Created DB links, roles and users, assigning grants/roles, index rebuilding, recompiling invalid objects, helping the users with SQL queries, truncating partitions.
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance(Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Resolving Oracle listener and TNS names problems
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries using RMAN.
• Re-organizing, Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Developed PL/SQL functions, procedures, packages and triggers.
• The daily work involves maintenance and administration of Oracle Databases, Backups, Lower environment refreshes (expdp/impdp & RMAN Duplicate), Space management, Stand-by lag monitoring, Performance Tuning, Dev/QA/Prod changes, other housekeeping tasks

Environment: Exadata, Oracle 12c,11g RAC,10g RAC,9i, SQL Server, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, OEM/Grid Control, DataPump, RMAN, ASM, TOAD, SQL, PL/SQL, ERWIN, Oracle GoldenGate 12c/11g

Confidential, Bloomington, MN

IT - Oracle DBA (Senior)

Responsibilities:

• 24x7 Support to production databases and critical projects including participating in a weekly on call rotation.
• Prerequisites, Installation, configuration, migrations, upgrades, patches and administration of Oracle database and GoldenGate 10gRAC/11gRAC/12c on AIX, Unix, Sun Solaris servers.
• Installation, configuration, database creation and supporting of Oracle 10gRAC /11gRAC, 12c databases.
• Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC/10g RAC), Disaster Recovery solutions with Physical/Logical Standby Databases (DataGuard).
• Installed CPU and One-off standalone patches & patch set Upgrade (PSU).
• Involved in setting up replication solution with GoldenGate in Dev, Test and Production environments and configured GoldenGate Processes on Source, Target and Middleware environments.
• Configured and build Golden Gate Extracts/replicats for multiple databases following best practices.
• Installed and configured Oracle Database Software 10g/11g on Zlinux, AIX in development, integration, Production Environment.
• Migrated databases from Oracle 10.2.0.2 on window 2008 to Oracle 10g on ZLinux development, integration, production environment using Import/Export.
• Perform POC for testing DDL and DML replication across Databases using Goldengate 11g/12c.
• Troubleshoot Repcat, Extract, Abend scenarios, data issues with developers and application teams.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Experience in Ugrading and migrating Oracle databases from 10g to 11g, 11g to 12c.
• Supported MySql databases, created backup and supported database recovery. Locking/unlocking tables and dropping triggers for migration, supported migration and improved the performance of the oracle databases after migration.
• Involved in discussions with different application teams during the deployments and enhancing the performance. Finding long running transactions and recycling the processes causing the issue.
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries using RMAN.
• Set up database security, auditing, creating users, roles, TDE, Database Vault, ASO, granting quotas, re-organize databases.
• Re-organizing, Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented data replication through materialized views, GoldenGate.
• Capacity planning and bench marking
• Created new schemas, constraints, indexes, synonyms, and tablespaces. Created DB links, roles and users, assigning grants/roles, index rebuilding, recompiling invalid objects, helping the users with SQL queries, truncating partitions.
• Used puppet paltform to automate some of the DBA tasks like schema refreshes, switchovers/failovers, creating restore points, database start/stop, creating awr reports, user account unlock.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 12c,11g RAC,10g RAC,9i, MySql, RedHat Linux, IBM zLinux, Sun Solaris, HP-UX, IBM Aix, OEM/Grid Control, DataPump, RMAN, ASM, TOAD, DB Artisan, SQL, PL/SQL, ERWIN, Golden Gate

Confidential, Eagan,MN

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Installed, configured and maintained Oracle 9i/10gRAC/11gRAC databases.
• Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying oracle database patches
• Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).
• Standby Database (Data Guard) setup and configuration.
• Installed, configured and administered Oracle Clusterware, Automatic Storage Management (ASM) and created ASM Disk Groups and created Oracle 10g RAC/11g RAC DB’s
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Created 10g databases using DBCA on HP-UNIX, ZLinux platform.
• Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on ZLinux development, integration, production environment using Import/Export.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis.
• Worked extensively on RMAN, Used RMAN for Point in Time Recovery and for Full DB refreshes and schema level refreshes.
• Worked extensively with DATA PUMP for expdp/impdp.
• Supported the development team at offshore in issue fixing, code migrations & other support activities.
• Installed and configured SQL server 2008 and SQL server 2012 on WINDOWS 2008 systems.
• Migrated and upgraded SQL Server 2000 to SQL Server 2005
• Provided DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012 environments.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Resolving Oracle listener and TNS names problems
• Installed, configured, upgraded Oracle GoldenGate, troubleshooting GG issues.
• Implemented data replication through materialized views, GoldenGate.
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries.
• Re-organizing, Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Responsible for setting and managing user accounts, granting required privileges to users
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Loading data from flat files into Oracle Database using SQL*Loader, External Tables and automated the process by using UNIX Shell scripting.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 11g RAC,10g RAC,9i, SQL Server 2000/05/08/12, RedHat Linux, IBM zLinux, Sun Solaris, HP-UX, IBM Aix, Grid Control, DataPump, RMAN, ASM, TOAD, SQL, PL/SQL, SQL*Loader, ERWIN, Golden Gate