SUMMARY:

• An experienced Sr. Oracle DBA professional with deep expertise in Oracle DBA version: 10g, 11g, 12c, RAC, OEM12c, Dataguard, Transparent Data Encryption (TDE), GoldenGate, Exadata, WebLogic application server, Microsoft SQL Server and Performance tuning.

• Oracle Certified Professional over 9 Years of experience in Oracle DBA with proficiency in, GoldenGate, Non - RAC, RAC, RMAN, Data guard and 12C
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g and 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems and ERP Systems.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transitive and Very large databases (VLDB).
• Experience installation of 10g, 11g database including RAC servers.
• Experience installing 12C database including plug and unplug PDB’s, how to plug a non CDB to CDB.
• Experienced in Installation of high availability RAC environment (2, 3, and 4 node clusters) and upgraded standalone databases to 11gr2 RAC and 12c RAC environment.
• Installed and Configured the unidirectional and bidirectional Golden Gate replication and troubleshooting replication issues using log dump.
• Work experience with GoldenGate replication process which involves Capturing, Route, Transform, and Deliver
• Technical expertise in Oracle DB implementations, maintenance, trouble shooting and administration.
• Experience upgrading Oracle databases from 9iR2 to 10gR2, 9iR2 to 11gR2 and 10gR2 to 11gR2, 12cR2.
• Experience in RMAN backup, restorations, recoveries and cloning of databases using RMAN duplicate and 12c DBA RMAN New features
• Migrating large databases (10TB, AIX to Linux) with almost Zero down time using Goldentate replication.
• Migrating large databases (10TB, AIX to Linux) with minimal down time using “RMAN Incremental X transportable tablespace method”.
• Implementation and Administration of Oracle Dataguard including Broker and FSFO.
• Have experience in installing and configuring Oracle Fail Safe.
• Have experience with Exadata.
• Monitoring of Exadata server using Exachk tool/utility for Health of Exadata System.
• Working knowledge in 12c Oracle GRID control (Oracle Enterprise Manager).
• Experience in applying Oracle PS, CPU Patching on 9i, 10G, 11G and 12C including RAC
• Fixing performance issues using AWR, ADDM, Profiles and Base lines.
• Exposure of working on OEM and Strong in Database Backups using RMAN, Export/Import, and Data pump, SQL Loader, etc.
• Backup, Recovery and Cloning of databases using RMAN, also profound in using the new oracle11g and 12C features in these utilities.
• Good working Knowledge of SQL and PL/SQL
• Experience installing SQL SERVER 2016 RTM and administering the SQL SERVER databases.
• Basic Knowledge of NoSQL databases.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude.
• A very good team player, self-motivated, dedicated in highly regulated work environment.
• ITIL Foundation level, SCRUM trained.

TECHNICAL SKILLS:

Operating Systems: RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10, HP-UX Itanium, IBM AIX, Windows XP,SQL SERVER 2012 & 2016.

RDBMS: Oracle 12C/11g/10g/9i, Oracle 10g Real Application Cluster (RAC), ASM, Microsoft SQL Server 2005, 2008, Postgres, DB2.

Oracle Products: OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, Import and Export (EXPdp/ IMPdp), ASM, TKPROF, SRVCTL,DBCA,DBUA

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

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

Other Tools: Autosys, TOAD, Putty, SQL Developer, Blade logic BMC Database automation tool, management system, GRD Ticketing System, Nexus ticketing System, ServiceNow and Remedy.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

Sr. Oracle - Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 11 g R2, 12C and RAC databases on Linux.
• Upgrading Oracle Database from 11.2.0.3.0 to 11.2.0.4.0 and to 12.1.0.2(12c) including RAC servers.
• Applying PSU patches quarterly on standalone and RAC databases
• Configured Oracle Data guard replication including Data guard broker and Fast start failover.
• Performing Failover operations/Disaster Recovery in Data Guard Environment.
• Installed and Configured the Golden Gate software and created manager, extract, replicate trail files and tested the data is flowing from source to target database. Monitoring GoldenGate process and working on issues.
• Resolving GoldenGate abend issues using log dump.
• Worked on encryption using Transparent Data Encryption (TDE) and SQLNET encryption for PCI compliance.
• Worked on Data center migration for one of the client of Confidential .
• Migrated database (5 TB) from AIX(64 bit) to Linux with almost Zero down time using Goldentate replication.
• Migrated large databases (9 TB, AIX-64 bit to Linux) with minimal down time using “RMAN Incremental X transportable tablespace method”.
• On-call Production database support(Business and Developers), attend problems on a daily basis, resolve various database related performance issues and customer requests.
• Analysing AWR, ADDM and ASH reports and fixing performance issues.
• Resolved SQL performance issues by applying SQL profiles using SQL-T, and fixing plans using SQL baselines.
• Worked on Morning checks to ensure all production databases and applications are in good health. And analysis of data tablespace, TEMP, UNDO tablespace growth.
• Scheduling RMAN Database backups using crontab, Autosys and OEM12C
• Had played the supervisory role to the offshore team for a brief period of time.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with failure notification.
• Upgraded OEM server from 12c to 13c for production databases and corresponding application servers and applied patches.
• Have worked on Exadata environment and patched Exadata stack.
• Wrote shell scripts for weekly/daily backup, to stdby and to snapshot.
• Ensuring SLA timings by taking and restoring backups from PROD to TEST.
• Provided assistance to Junior DBA’s.
• Installed MS SQL SERVER 2016 RTM Installation and add features to an existing SQL SERVER 2016 Installation.
• Have experience in creating sample databases and creating instance level and database level principals and granting permissions to SQL SERVER databases.
• Have worked on Login Auditing and Built-in Reports in SSMS.
• And apply Service Packs(SP3) to SQL SERVER 2012 RTM version.
• Have implemented and administered SQL Server replication.
• Have setup SQL Server database backup to URL (Windows AZURE).
• Upgraded databases from SQL SERVER 2012 SP3 to SQL SERVER 2016 RTM.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Installed OAS 10.1.2, 10.1.3 and configured and deployed the applications.
• Experience installing, configuring, deploying applications and troubleshooting WebLogic application servers version 12.1.3.

Environment: Oracle 10g/11g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, HEAT-LITE tool, OEM, SQL SERVER 2012, 2016.

Confidential, IL

Oracle - Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Have experience in installing and configuring Oracle Fail Safe. And maintaining the high availability clusters.
• Installed, Configure and maintained 2 Node 11g RAC/Non-RAC with ASM development databases.
• Upgrading Oracle Database from 11.2.0.2.0 to 11.2.0.3.0 .
• Ensuring SLA timings by taking and restoring backups from PROD to TEST.
• Partitioning of large tables for fine performance tuning.
• Implemented Data Guard on oracle 11g R2 on Linux.
• Scheduling RMAN Database backups on Linux Server.
• Upgraded development databases from 10.2.0.5 to 11.2.0.3.
• Scheduling RMAN backup jobs from Oracle Enterprise Manager.
• Had played the supervisory role to the offshore team for a brief period of time.
• Configured and maintained replication using Oracle Golden Gate.
• Monitoring GoldenGate process and working on issues.
• Performing Failover operations/Disaster Recovery in Data Guard Environment.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with failure notification.
• Wrote shell scripts for purging trace files, alert log and network log files in Sun Solaris boxes which is used as standard script across all the databases.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.

Environment: Oracle 9i, 10g/11g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Fog light tool, OEM.

Confidential, TX.

Oracle DBA/Data Analyst

Responsibilities:

• Providing Oracle database administrative support for Production, Development and Staging databases of HMS applications.
• Providing Level 3 Production Support. Responsible for processing all the E-mails and monitoring all the alerts.
• Installed, Configure and maintained 2 Node 10g RAC/Non-RAC with ASM development databases
• Installed, Upgraded Oracle software (10.2.0.4 to 11.2.0.3) on both single instance and RAC environments and applied various patches on RAC environments which include quarterly PSU patches and other minor patches for bug fixes on both ASM and DB instances.
• Configured and constructed development databases on RAC environment.
• Managing Daily Backups of Production database.
• Configured Standby database/ Dataguard for RAC databases
• Supporting monthly Change Activities related to Production database and generating AWR and ADDM reports after every Change Activity and perform tuning on SQL’s identified in the reports.
• Implemented database refresh using RMAN and full Exports/Imports.
• Scheduled full database backup jobs and archive jobs through OEM.
• Creating and Managing Table spaces and Data files as needed and implemented database level security using Roles and privileges.
• Performed database refreshes using RMAN.
• Monitoring alert logs, trace files to check Database health and corruption.
• Providing 24*7 on call production support.
• Upgraded Oracle RAC Database s to 11.2.0.3 from 10g.
• Resolved gaps in Dataguard using RMAN.
• Migration of database storage location from Filesystem to ASM.
• Implemented RMAN backups from Physical Standby.

Environment: Oracle 10g, 11g, RAC, RMAN, ASM, GRID Control, RHEL, HP-UX, Sun OS, Oracle Enterprise Linux.

Confidential, WI

Oracle - Database Administrator

Responsibilities:

• Daily maintenance of the 200 production and 400 development and staging databases and pro-active monitoring of the performance.
• Installation, Maintenance & Configuration of databases.
• Monitor and report status of databases (capacity, size/limit, performance, etc.). Increasing the size and managing the TEMP,UNDO and tablespaces.
• Carry out with Database refresh (Using Hot & Cold backups, RMAN), schema refreshes, table refreshes.
• Creation of table spaces, user account maintenance, database security imposition by creation and granting of roles and privileges.
• Distribution of Table spaces among different Disks and creation of Database objects and monitoring the tablespaces.
• Executed the scripts as on when asked by the developers and provided them the log files of the executed scripts.
• Worked on Oracle Enterprise Manager (OEM) used to schedule the database backups and handle the failed backups through OEM, used to extract the AWR and ADDM reports and extract the structure of tablespaces and tables through OEM.
• Production Support for Oracle 9i/10g/11g Databases.
• Installed, configured and performed the maintenance of SQL Server.
• Expertise in Microsoft SQL Server 2005 Database Administration including planning, implementing, backup, and recovery strategies.
• Optimized data loading using SQL*Loader to load different types of data from flatfiles to the Oracle server.
• Performed Refresh Activity for Databases from Production to Development, Testing Environment.
• Troubleshooting performance issues reported by the Application Team.
• Worked with application development team to resolve app related issues.
• Monitoring the Tablespace and thus help Predict Trends and take Appropriate Steps like adding and resizing the datafiles.
• Upgrading of Oracle RAC Database s to 11.2.0.3
• Performing Databases Refreshes using Rman Duplication and Active Duplication.
• Applied Patches on Database home, Grid home and experience with deployment of Oracle database and application patches.
• Performed switchover and failover in a data guard environment.
• Creation of Physical Standby databases to Production Databases to ensure Maximum Availability through RMAN

Environment: Oracle 9i,10g, 11g, RAC, RMAN, ASM, GRID Control, Microsoft SQL Server 2005,SQL* Loader, RHEL, HP-UX, Sun OS, Oracle Enterprise Linux.

Confidential

Oracle DBA

Responsibilities:

• Configured and constructed Development database.
• Designing and Creating database to support system needs.
• Creation of tablespace, adding datafiles, periodical backups and database recovery as needed.
• Monitoring the Mount points(Disk) for space issues and removing the Old files, dumps as per the retention period.
• Distribution of Table spaces among different Disks and creation of Database objects and monitoring the tablespaces. If the tablespaces reach the threshold value either resize or add the datafile as per the requirement.
• Worked on Oracle Enterprise Manager (OEM) used to schedule the database backups and handle the failed backups through OEM, used to extract the AWR and ADDM reports and extract the structure of tablespaces and tables through OEM.
• Creation of Users and granting required privileges and roles as required.
• Monitoring alert logs, trace files to check Database health and corruption.

Environment: Oracle 9i,10g, RMAN, OEM,TOAD, Sun OS