SUMMARY

• Highly accomplished database administrator with a successful 5+ year track record of success in Database Designing, Installation, Configuration, Patches and Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring, and Tuning, RAC, Data Guard, Grid and cloud Control, Oracle Goldengate, and support of RDBMS such as Oracle, SQL Server, PostgreSQL databases and also experience in Migrating databases to Oracle Exadata Database Machine and Amazon web service(AWS) Cloud.
• Proficient in Oracle , Monitoring, and Tuning, RAC, Data Guard, Grid and cloud Control, Oracle Goldengate.
• Good understanding of Exadata Architecture and Exadata Storage Administration.
• Experience with data related cloud technologies such as AWS (EC2, VPCs. S3, RDS, Route53)
• Knowledge in Golden Gate installation & Configuration setups in a Linux environment .
• Good Knowledge of RMAN backups.
• Extensive experience with Unix shell scripting Development
• Have Provided System support for both development and 24/7 production environment
• Strong technical background covering SQL - PL/SQL-TSQ -Python programing
• Expertise in PostgreSQL on Linux environment.
• Experience with data modeling, ETL and database design.
• Efficient in using Data guard Broker for all Data Guard tasks.
• AWS Networking concepts such as DNS and Load Balancing.
• Experience with Informatica System Administration.
• Installed and Configured SQL Server Reporting Services (SSRS).
• Experience in ETL using SQL Loader, oracle supplied Utility DBMS packages.

TECHNICAL SKILLS

Tools: and Technology: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, TOAD, Oracle SQL Developer, MKT, SCT, DMS, PG Admin, Remedy, SSIS, SSAS, SSRS, Putty, WinSCP, SQL Loader, Erwin Data Modeler, ETL, ER STUDIO, ANSIBLE, TKPROF, EXPLAIN, AWR, ADDM.

RDBMS: Oracle, MS SQL Server, PostgreSQL

Cloud Computing: AWS Cloud.

Languages: Python, SQL, PL/SQL, T-SQL, shell scripting.

Operating Systems: UNIX, Linux, Sun Solaris, Windows.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Oracle Database Administrator

Responsibilities:

• Responsible for Integration of Exadata monitoring into our existing IT monitoring framework.
• Supporting multiple databases from production, development, test and staging purposes on Linux and Windows environments.
• Maintaining Oracle Data Guard and ensuring that the physical standby is always in sync with primary database.
• Implemented Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Configured Golden Gate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Experience in configuration and administration of Data Guard.
• Deployed Oracle standard build changes using shell scripts.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Responsible for monitoring Informatica environments.
• Perform Regular Backup & Recovery using RMAN ,
• Oracle 11g &12c RAC Database administration and maintenance .
• Involved in the construction of DR sites for all the Production and Test environments.
• Installation, Configuration and Troubleshooting Golden Gate 12c software
• Tested Switchover and failover between data centers before migration of production databases using Data guard Broker.
• Exadata bundle patching includes Storage cell, DB server.
• Cloned databases using Export Import, Data Pump and RMAN Duplicated Databases.
• Installed and configured Golden Gate Agent to work with OEM Golden Gate.
• Performed Database Refresh from Production to Test, UAT, and Development databases and Maintaining Database Security using TDE.
• Implemented Business rules using the PL/SQL libraries, Stored Procedures, Functions and Triggers.
• Responsible for Planning the Backup/Restoration Strategy , Planning, and scheduling Backups , taking Logical Backups (with Export and Data pump utilities ).
• Goldengate Monitoring through OEM.
• ASR implementation and configuration Administration
• SQL Tuning, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN , AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH .
• Migrated on-premise oracle databases to AWS Cloud using DMS and SCT.
• Applied upgrade patch, maintenance and interim (OPatch) patches on all databases
• Monitoring of cell disk, grid disk, cell flash cache, flash disks, OS administration, InfiniBand.
• Goldengate installation, configuration and troubleshooting GG extract and REPLICAT issues.

Confidential, Rochester, NY

Database System Engineer

Responsibilities:

• SQL Server 30%, Oracle 40%, PostgreSQL 30% production support.
• Responsible for the data architecture, data modeling, data mapping for ETL, schema design, table design, and database design that provides the most optimal data flow interfacing with the applications while ensuring data integrity, accuracy, protection.
• Programming with SQL, Oracle PL/SQL or other database procedural languages using a major relational RDBMS. Including Linux/Unix shell scripts.
• Configured and Maintained Fail-Over Clustering using SQL Server2012.
• Installed and Configured SQL Server Reporting Services (SSRS).
• Responsible for Performing basic level performance tuning using extended events and SQL Profiler.
• Migrate databases across platforms using Oracle Golden Gate.
• Responsible for the Operations and Maintenance on the OLAP and OLTP databases.
• Designed backup and restore strategies for new servers.
• Worked on High Availability Solutions - Data guard, DG Broker, Physical/Logical Standby.
• Implementing Oracle 11g & 12c RAC for mission critical Application & Databases. performance tuning using Explain Plan, TKPROF, AWR, ADDM.ASH Performance Tuning of the database.
• Install and configure a new PostgreSQL cluster as and when required.
• Updated Oracle Application Express (APEX) to the newest version.
• Test and eventually deploy the code in production database servers.
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting.
• Migrate business reports to the Enterprise Data Warehouse
• Setup Crontab jobs to automate the routine tasks.
• Ensure the Migration of the oracle database to the PostgreSQL database using MKT.
• Installation, Upgradation, Configuration and Troubleshooting GOLDENGATE 12c software
• Database monitoring/maintenance, replication process, and performance tuning are done using OEM (Oracle Enterprise Manager).
• Addressing RMAN backup jobs failures.
• Ensure the smooth Conversion of CRM apps Forms to APEX.
• Monitoring and Troubleshooting RAC database issues.
• Administrating oracle 11gR2 GOLDENGATE Replication.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table, and column levels.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Responsible for Patching, Upgrade, and keep the PostgreSQL DBs current.
• Refreshed/cloned databases using RMAN utility.
• Administered (12c RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Involved in the installation, configuration, and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on the Linux platform.