SUMMARY

• 16+ years of IT experience as a Database administrator Specialized in more of Oracle and Cassandra databases and have exposure to Mongo, Postgres, MySQL and MSQL Server databases.
• Senior Database administrator with GoldenGate Specialist having more than 16 years of IT experience in administration of Oracle, Cassandra, PostgreSQL, MS SQL, MySQL, AWS RDS/Aurora, NoSQL, GoldenGate, RAC, OEM, GRID, ASM, Data guard, Hot Standby, TDE, RMAN, ETL, APEX & Exadata.
• Expert in installation, configuration, administration & troubleshooting of Oracle 19c/12c/11g/10g Grid (RAC, CRS, ASM, Database) and Configuration of High Availability, Load Balancing, scalability and Better Performance with latest Cluster Technology.
• More than 5 years of experience in installation, configuration, administration & troubleshooting of PostgreSQL databases to ensure accurate, appropriate & effective use of data. Proactive management of standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Expert in Architecting, Design & Documentation of Database Systems to provide database support for systems/projects, replication, patching, upgrade, migrations and conversions.
• Proficient in migration of databases from on - prem to cloud (OCI/AWS)with zero downtime using AWS DMS/SCT services & Oracle Goldengate.
• More than 6 years of solid hands-on experience in installation, configuration, administration & troubleshooting of Oracle homogeneous and Heterogeneous (MySQL/MSSQL/PostgreSQL) GoldenGate Classic & Microservices Architecture 19c/12c/11g using the latest features to optimize performance.
• Firsthand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in AWS EC2, AWS RDS & RAC high available environment.
• Deep understanding Oracle GoldenGate internal mechanism, DML/DDL Replication, OGG new features such as Integrated capture/apply, coordinate apply mode, multi-threaded replicat. Developed home-cooked OGG lag & alert monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager).
• Installation, configuration, administration, troubleshooting and Maintenance of SQL Server 2016/2014/2012/2008 in all Environments (Which include both VMWare and Physical). Experience with T- SQL, SSAS, SSIS and SSRS.
• Expert-level knowledge of Amazon IAM, VPC, EC2, RDS, EBS, S3, Route53, ELB, Amazon SQS, Cloud Formation and other services of the AWS family.
• Experience in maintenance, configuration and administration of user accounts for non-prod and Prod servers and created roles for EC2, RDS, S3, Cloud Watch, EBS resources to communicate with each other using IAM.
• Proficient in High-Availability, Fault Tolerance, Scalability, Database Concepts, System & Software Architecture, Security, IT Infrastructure, Virtualization, and Internet Technologies.
• Expertise on Managing Oracle 19c/12c/11g/10g, RAC, non-CDB, GoldenGate environments 24*7 on call production DBA Support on Linux, Solaris, HP-UX, AIX and Windows Environments including full project life cycle experience skills.
• Expertise on Oracle Datacenter/storage Migrations, Upgrade/Migrations of Databases for different Oracle Versions and platforms. Patching, upgrade and Cloning of Oracle Instances.
• Performance tuning of Queries, Database Performance improvements on Critical production Environment. Performance tuning of SQL, PL/SQL Queries, tuning using ASH, AWR & ADDM Reports. Analysis of Wait events and analysis of trace files using debug commands.
• Helped different Customers/clients to upgrade their databases of different sizes (database sizes from 50GB to 60 Terabyte support) on different OS Environment.
• Have worked on and implemented process as per the ITIL Framework Environment and adheres to operational/business SLA required for the organization.
• Handled large data warehouse DB size in production ranging from 50GB to 60 TB.
• Creating and Modifying of various shell Scripts for Services management, clearing logs, alert log monitoring, setting environmental variables etc.
• Worked on Oracle & PostgreSQL features (Partition, Parallelism, Compression), SQL*PLUS, IMP/EXP, IMPDP/EXPDP, PG DUMP, PG RESTORE, RMAN, ASMCA, DBCA, SQL*Loader.
• Experience in supporting database design, development, document and Administration for enterprise Oracle applications, Tomcat, Apache, .net, Java (J2EE), WebLogic, WebMethods ESB and IBM MDM & WebSphere. End to end DBA support for applications and Operating systems upgrade/maintenance.
• Experience in supporting Oracle Hyperion products like Oracle Essbase, Planning, HFM and DRM
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills.
• Strong Logical & Analytical Reasoning Skills, Management skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.

PROFESSIONAL EXPERIENCE

Confidential

Database engineer

Responsibilities:

• Extensively worked on upgrading and migrating databases from 11g/12c to 19c using Oracle Goldengate replication with Zero down migration method to support Ticketmaster Ecommerce Platform with CDR feature on a Net Scalar environment with VIP concept.
• Extensive experience working on Goldengate Veridata for data mismatch issues.
• Mentored and Guided Junior DBA’s
• Extensive experience in setting up Oracle data guard with FSFO solution.
• Extensively worked on implementing bi-directional golden gate replication between Oracle and MySQL.
• Installed, configured, Administered, Monitored, Upgraded, and Tuned Oracle databases on 19c.
• Performed Migration of databases from Onprem to AWS cloud.
• Installed and configured OEM 13c.
• Extensively worked on application fine-tuning and database fine-tuning using Explain Plan and analysis tools, monitor performance and identify bottlenecks and System Tuning and Monitoring indexes and analyzing their status for performance tuning and query optimization.
• Proficient in AWS Cloud platform and its features which includes EC2, VPC, EBS, AMI, SNS, RDS, EBS, CloudWatch, Cloud Trail, CloudFormation AWS Config, CloudFront, IAM, S3, and R53
• Extensively worked on Backup and Restore solutions using RMAN method.
• Supported Postgres/mySQL/Oracle/Cassandra/SQL Server databases in ONCALL rotation.
• Written Python code to automate repetitive DBA tasks.
• Handled Two Cassandra clusters with 60 nodes spread across Multi datacenters with 11k+ writes/sec and 5k+ reads /sec per Datacenter to store user’s trip Data storing 50+TB of Data.
• Involved in Cloud infrastructure planning, designing, High Availability and Scalability for multi-region and multi data- center DSE Cassandra cluster in AWS.
• Upgraded cluster from DSE 5.1.1 to 5.1.9.
• Architected and Built Apache Cassandra cluster with 3.11 and monitoring using Prometheus and Grafana.
• Developed Backup & Recovery solution for Open Source Apache Cassandra to do incremental and Full backups using Shell scripting.
• Helping Developers in designing Cassandra Tables with appropriate partition and clustering keys as needed, use of User Defined datatypes.
• Automated node build, add & replace pipelines using Jenkins, Ansible & AWS stack creation.
• Scheduled repair and cleanup process in production environment.
• Performed Stress and Performance testing, benchmark for the cluster.

Confidential, Irving TX

Senior Database Administrator

Responsibilities:

• Extensively worked on upgrading and migrating databases from 11g to 19c using Oracle Goldengate replication with Zero down migration method
• Migrated databases from OnPrem to AWS Cloud.
• Extensively worked on application fine-tuning and database fine-tuning using Explain Plan and analysis tools, monitor performance and identify bottlenecks and System Tuning and Monitoring indexes and analyzing their status for performance tuning and query optimization.
• Supported Migration of Databases from Oracle to MySQL using Golden Gate
• Installed and configured Oracle WebLogic Servers.
• Lead, Mentored and Guided Junior DBA’s
• Installed and configured Oracle Hyperion suite of Products (Essbase, Planning, DRM).
• Installed, configured, Administered, Monitored, Upgraded, and Tuned Oracle databases on 19c.
• Worked on writing scripts using PL/SQL
• Extensively Worked on Data Security Confidential Rest and In Transit.
• Designed and Implemented Active DataGaurd for High availability purpose.
• Designed and Implemented Oracle Golden Gate for Replication purpose.
• Designed and Implemented 4 Node Oracle RAC on 12c.
• Extensively worked on Tuning Oracle Databases for better performance.
• Supported Oracle/Cassandra/Mongo databases in On Call rotation.
• Installed and Configured Cassandra Clusters on Linux Machines.
• Designed and Deployed On-Premise database over AWS Cloud.
• Installed and configured Solr and Spark for Cassandra clusters.
• Performed node repair, adding/removing nodes from Cassandra clusters.
• Worked on Performance Tuning of Cassandra.
• Worked on Backup & recovery setup’s Cassandra DB environments

Confidential

Senior Database Administrator

Responsibilities:

• Defining Architectural vision and analyzing gaps between base architecture and target architecture.
• Participated in Design & Road Map for Cloud Strategy for Oracle Databases & Oracle Suite of Products.
• Working experience moving on premise databases over to AWS Cloud.
• Worked on building Private, Public cloud for Oracle Databases and Oracle Suite of Hyperion Products.
• Installed, Configured and provided support for WebLogic server.
• Involved in Upgrade/Migration of the oracle databases from Oracle 11g to Oracle 12c. Worked on Automating repetitive tasks using Python scripting.
• Extensively worked on application fine-tuning and database fine-tuning using Explain Plan and analysis tools, monitor performance and identify bottlenecks and System Tuning and Monitoring indexes and analyzing their status for performance tuning and query optimization.
• Extensively Worked on Data Security Confidential Rest and In Transit.
• Designed and Implemented Active Data Gaurd for High availability purpose.
• Designed and Implemented Oracle Golden Gate for Replication purpose.
• Designed and Implemented 4 Node Oracle RAC on 12c.
• Extensively worked on Tuning Oracle Databases for better performance.
• Supported Postgres/mySQL/Oracle/Cassandra/MS SQL Server databases on Rotational OnCall support.