SUMMARY:

• Provided 24x7 support for mission critical projects as a production support DBA and specialist role of database administrator.
• Expertise in installation, configuration, upgrades, patches, cloning, backup & recovery of Oracle 9i, Oracle 10G, Oracle 11G and Oracle 12C on various platforms like IBM - AIX, Sun-Solaris, HP-UX, RHEL and Windows.
• Experience in installing and managing Cloudera Hadoop clusters and Hadoop file system (HDFS), using Cloudera Manager.
• Strong experience in supporting production, development, unit test, system test, Integration test, certification test databases under UNIX/LINUX.
• Strong Experience monitoring and identifying issues in database and its services using OEM Grid-Control/Cloud-Control (10G, 11G, 12C).
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and ODI have used data migration ETL tools.
• Extensively worked as Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.
• Around 3 years of experience working with Oracle Goldengate with complete end-to-end support for Goldengate - Configure, Setup, Install, & Support.
• Over 5 years of experience working with Oracle Data Guard - Implementation & support.
• Experience in planning and implementing high availability solutions using Oracle RAC - Install & configure.
• Experience on Oracle Exadata Database Machine - Implementation and Maintenance.
• Working experience of setup, configuration and implementation of Cloud-Control/Grid-Control/Automation.
• Extensive knowledge of Automatic Workload Repository (AWR), Oracle Datapump, Flashback, RMAN.
• Skilled in dealing with ASM environment such as Installation, configuration. Administered Oracle ASM disk groups (mirroring, compatibility) and migrated database from NON-ASM to ASM environment.
• Experience in upgrading CRS, ASM & Database and also applying oracle patches for CRS & RDBMS homes.
• Experience in database performance and tuning techniques using SQL Trace, TKPROF, Explain Plan and generating statistics of database using ADDM and tuning the database accordingly.
• Hands on experience in using dbms packages like DBMS JOB, DBMS SCHEDULER, DBMS SQL and gathering of cost-based optimizer (CBO) statistics for tables with stale statistics using DBMS STATS.
• Expert experience in Hot and Cold Backup of databases. Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN and VERITAS Netback up.
• Experienced with RMAN & Oracle database Clustering.
• Extensively used Oracle Datapump (EXPDP & IMPDP) to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Hands-on experience with Oracle database security administration, configuration and Implementation of Vormetric encryption, Oracle Transparent Data Encryption (TDE), Oracle Wallet Management, and experience on Oracle Data Masking and Oracle key vault, audit vault and database vault.
• Implemented Oracle Security / Oracle database Auditing, FGA, FGAC/VPD, for SOX compliance. Created roles, profiles and privileges and assigned roles to users.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL Loader utility.
• Performed complete multi-master replication with updateable materialized views.
• Strong knowledge in SQL, PL/SQL and also strong knowledge of creating Public/Private Synonyms, DB Links, Ref Cursors, Raise Application Error, Parameterized Cursors.
• Experience in monitoring database growth including File system, tablespaces and tables. Performed Tablespace management both local and dictionary. Managed Undo Segments in order to avoid "Snapshot too old".
• Experience with continuous development and deployment to Amazon Web Services (AWS).
• Automated many common tasks with Scripts by scheduling jobs (crontab) including: Backups, exports and imports, archiving old records and verification of such processes.

TECHNICAL SKILLS:

Operating Systems: HP-UX., Sun Solaris, IBM-AIX, RHEL and Windows.

Languages: SQL, PL/SQL, PERL Scripting, UNIX Shell Scripting.

DB Utilities/Applications/Tuning Tools: RMAN, ASM, SQL *Loader, Oracle Exadata, Data Guard, No SQL, Expdp/Impdp, Opatch, Golden Gate, ASM, OEM 11g/12c, Putty, TOAD, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM . RDBMS Oracle.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle DBA & Exadata DBA

Environment: Oracle 12c/11g, SQL, PL/SQL, Exadata, RMAN, Oracle Goldengate, ASM, Solaris, RHEL, Data Guard, Oracle Enterprise Manager 11g/12c, Tuning of SQL queries.

Responsibilities:

• Overall planning, installation & support of oracle 11G and 12C databases in production, development and test environments depending on project requirements.
• Monitoring and administration of databases through OEM 12c Cloud control.
• Installed, configured, and managed Oracle database 12C on Exadata (X6 2) box.
• Migrated 12C Oracle databases from Exadata X4 to X6 using both physical and logical methods.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery clone purposes.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application
• Generated Exacheck and Sundiag reports and worked with oracle on issues.
• Worked on Disaster Recovery by converting Physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Move pluggable databases between container databases and created pluggable database from seed database.
• Cloned pluggable database in existing container database. Hands on experience in cloning the non-multitenant container database (Non-CDB’s) to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Cloning UAT RAC databases using RMAN active duplication method and Refreshing development/test database from production using Export/Import Datapump & RMAN backups.
• Making structural changes to the databases, sizing database objects for effective space management and optimal performance.
• Managing database security, Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Monitoring and troubleshooting the gaps between source and target databases configured with Goldengate.
• Successfully upgraded the databases from 11g to Non-CDB 12c. And then successfully migrated those12c Non-CDB databases to Pluggable databases.
• Installed Goldengate version 12 with latest patches applied on DBFS filesystem and ACFS filesystem.
• Implemented Goldengate integrated replicat and coordinated replicat (available from OGG 12c) to improve the performance of data replication to targets.
• Responsible for managing the Golden gate sync process and configuring new data replication methodologies and modifying the existing replication as per the project requirements.
• Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Performed other DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving and provided production support for the deployed project till it is stabilized.
• Designed Logical and physical database for business transaction functionality.
• Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Environment:: Oracle 12c/11g/, SQL, PL/SQL, NoSQL, ASM, RMAN, Golden gate, RHEL, Oracle Enterprise Manager (OEM), Hadoop.

Responsibilities:

• Installed, configured, managed & supported store databases on Oracle 12C (NON-CDB) and 11G on RHEL and Windows platform.
• Worked on different technologies like Oracle RAC, Physical standby, Golden Gate, Oracle Streams, Mongo DB 3.0 and Bigdata hadoop Administration.
• Installed Central office Databases on Oracle 11GR2 RAC Environment.
• Monitoring and administration of databases through OEM 11g/12C Cloud Control.
• Discover, Promote and add target hosts and databases in Oracle Enterprise manager (OEM) 11G/12C.
• Implemented quarterly patch cycles for databases systems in 12C and 11G.
• Administered and managed databases for Oracle Retail Point of Service (ORPOS 13.1).
• Cloning/Data Refresh from Production to Test and Development environments using Backup-duplication method, Active duplication and Export/Import datapump.
• Converted a single instance database to Oracle RAC. Node addition and deletion to serve business needs.
• Worked and implemented Database Wallet for Oracle 11g (also called as keystone from 12c) and TDE (Transparent Data Encryption) for encrypting the Sensitive data using column encryption and tablespace encryption.
• Installed & configured Active Dataguard using physical standby for high availability and reporting purpose.
• Implemented Oracle 11g Goldengate for replication project.
• Ensure database logs are turned on, logging appropriate information, protected from unauthorized disclosure or modification, and retained for the time period specified.
• Defined and implemented the backup and recovery strategies using Recovery Manager (RMAN) for all the Store databases and Central office database.
• Configure database backups using RMAN, EXP/IMP before upgrades for recovery purposes.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.
• Created DB Link between two databases to access the table data from one local database to remote database using distributed database feature.
• Performed Data loading from flat files and external files activities through SQL loader and External tables.
• Managing different versions of Production, QA and Dev databases.

Confidential, Charlotte, NC

Oracle DBA

Environment:: Oracle 11g/10g, SQL, PL/SQL, RMAN, Exadata, OEM, Windows, Oracle Linux, Solaris, RMAN, ASM, UNIX Shell Scripting.

Responsibilities:

• Configured, Setup and maintained Oracle11G RAC two-node environment on ASM on EXADATA (X3 - Half rack) machine.
• Monitored Oracle Exadata database servers and storage servers including Cell Server Administration.
• Monitored and configured, Oracle 10G and 11G databases using OEM 11G
• Responsible for Patching/Firmware Upgrade /Re-image of Oracle Exadata Systems (X3 - Half Rack).
• Installed and Configured Oracle Dataguard for Oracle 11G & 10G for the maintenance of Standby database.
• Responsible for managing complex Standby databases and Data Guard for disaster recovery.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application
• Involved in installing, configuring, upgrading, replication monitoring, capacity planning and tuning Oracle Golden Gate.
• Troubleshot various Goldengate replications and Performance issues on Exadata environment.
• Responsible for managing the Golden gate sync process and configuring new data replication methodologies and modifying the existing replication as per the project requirements.
• REFRESH/CLONE Database using RMAN Duplicate for development, testing. .
• Applied PSU patches and other security patches on Oracle 11G RAC and Standalone Databases.
• Converted large Non-Partitioned tables to Partitioned tables following Range partitioning method, to improve the performance.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Optimized and tuned SQL queries using SQL* TRACE, EXPLAIN PLAN and by monitoring STATS PACK report generated from snapshots taken at the peak business hours.
• Worked on database security with audit vault and database vault including installation, configuration monitoring and troubleshooting.
• Defined and Implemented backup and recovery strategies. Tested many backup and crash recovery scenarios on test environment (10g, 11g), using RMAN tool.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Management of schemas, objects partitioning the tables & indexes. Defragmentation of tables and indexes for improved performance and effective space management.
• Detected locks and resolving in-doubt transactions manually.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Responsible for preventing residual data from exposure to unauthorized users as information resources are released or reallocated.
• Developed, communicated and implemented Disaster Recovery plan for DR exercise.

Confidential

Jr. Oracle DBA

Environment:: Oracle 11g/10g/9i, Goldengate, Data Guard, Cold/hot backups, Crontab, SQL, PL/SQL, RAC, RMAN, Windows, Oracle Linux, Solaris, RHEL.

Responsibilities:

• Installed and configured Oracle database Setup on brand new machines including Oracle software installation, Oracle database creation, and backup setup on multi-node RAC environment.
• Created and maintained Oracle11g database on RAC four-node environment on ASM.
• Upgraded Oracle database from 10.2.0.5 to 11.2.0.3 and applied oracle patches to rdbms homes from 11.2.0.3.0 to 11.2.0.3.6 .
• Configured and built heartbeat monitoring in Goldengate.
• Configured error handling for restart, logging, production support and status reporting in Goldengate.
• Implemented necessary monitoring scripts for Goldengate in unix/perl scripting.
• Wrote shell scripts for various database activities like space cleanup, datapump refresh, and RMAN refresh.
• Migrated data using import/export, oracle datapump, transport tablespaces and standby databases.
• Converted single instance to three-node Real Application Cluster (RAC) database instances.
• Reorganized existing database to standardize the placement of various databases related files.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection.
• Converted/altered existing manual Partitioned tables for large customer related data in to Interval-Partitioned tables.
• Involved in developing a Disaster Recovery (DR) plan & implemented a DR exercise.
• Monitored and configured, oracle 9i, 10G and 11G databases using OEM 11G.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Implementing user level security, object level security, data encryption, data masking, and Fine Grained-auditing using DBMS FGA package.
• Migrated oracle databases from oracle 10.2.0.4 to 11.1.0.7 on AIX to RHEL.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database objects by fixing row chaining, I/O and CPU bottlenecks.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, and Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.

Confidential

Jr. Oracle Database Administrator

Environment:: Oracle 11g/10g/9i/8i, RMAN, SQL, UNIX shell scripting, AIX, Sun Solaris,

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager.
• Supported both production and development activities.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Installation of Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• Supported Production Database Oracle 10G RAC 4 Node with High Level Evaluation, performance tuning, instance recovery, load balance.
• Upgraded of Database from 9.2.0.6 and to 10.2.0.2 and applied patches whenever required.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Configuration and Maintenance of RAC, Standby database.
• Extensive use of Oracle Dataguard for protection of critical production data & provide disaster recovery support.
• Rebuilt Indexes for better performance, maintenance of Oracle Database.
• Created and Managed Tablespaces with different block-sizes to prevent row chaining.
• Configured Oracle Data Guard on Oracle 11G and 10G databases for Disaster Recovery.
• Supported custom application development team including database objects deployment, migration and troubleshooting.
• Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
• Installed and configured Oracle Enterprise Manager (OEM) 10G & 11G and Enterprise Backup Utility to monitor databases and its services.
• Established a DB Link between two Oracle Servers.
• Used SQL*Loader and External tables to load data from flat files.