Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Rahul Jain

Rahul Jain

Denver,CO

Summary

Accomplished and results-driven professional with over 14 years of extensive experience leading various databases and application administration. Well-exposed to database practices and procedures, including building near real-time replication, performance tuning, designing, administration, configurations & monitoring, high-availability solutions, disaster recovery, and more. Has handled multiple database technologies both on-premises and in the cloud, such as Oracle, PostgreSQL, MySQL & RDS. Additionally, experienced in automations and building Tableau/PowerBI dashboards for data visualization.


Actively contributes to the end-to-end planning, design, architecture, and implementation phases of various database solutions. Possesses strong analytical skills and excellent problem-solving abilities and equally confident working independently or collaboratively as needed.

Overview

15
15
years of professional experience
8
8
Certification

Work History

Lead/Sr. Database Engineer

Cognizant Technologies Solutions
06.2014 - Current
  • Spearheaded installation, configuration, upgrade & administration of various Oracle & PostgreSQL databases
  • Managing and responsible for backup, recovery, performance, standby of Oracle & PostgreSQL databases
  • Managing 180TB+ warehouse databases on oracle platform for enterprise critical pharmacy application
  • Expertise in handling various production and non-production databases ensuring SOX controls are followed
  • Designed & Implemented RAC one-node solutions for pharmacy production databases
  • Implemented Transparent Data Encryption(TDE) & Oracle Key Vault(OKV) for immutable backup solutions.
  • Managing complex GoldenGate replication and handling replication for 400+ pharmacy stores
  • Experience in migration of on-prem oracle databases to Amazon RDS and EC2 instances
  • Expertise in various on-prem to cloud migration includes Oracle to PostgreSQl, postgreSQL to RDS & Aurora.
  • Own all aspects of database including design, architecture, code reviews, performance and high-availability
  • Developed and automate install of 19c database, migrations on multiple servers using Ansible
  • SQL tuning for large database using AWR, ADDM, Snapper tool
  • Expertise in handling various MySQL databases community and enterprise edition
  • Setup Master-Slave replication for MySQL database
  • Monitoring, performance tuning, upgrade & maintain MySQL databases
  • Performed various load testing using HammerDB
  • Collaborated with cross-departmental team and vendor to develop robust warehouse system for downstream customers and analytic solutions
  • Monitor key performance metrics, measuring the utilization, capacity and overall health of the databases
  • Implement resource manager for optimizing database resources
  • Led analysis on capacity planning for futuristic growth analysis of the IT systems using data visualization tool
  • Involved in root cause analysis for multiple applications and resolved various performance issues
  • Tuned SQL queries for optimal performance to meet SLAs by understanding complete business logic
  • Mentoring and training new hires by knowledge transfer of internal process, and database technologies
  • Conducted regular audits to identify areas of improvement in databases, leading to increased efficiency.
  • Improved database performance by optimizing queries and implementing efficient indexing strategies.
  • Optimized storage utilization by implementing advanced compression techniques without compromising data accessibility or performance.

Sr. Database Engineer

KPIT Cummins Inc.
09.2009 - 05.2014
  • Working as a senior application DBA/Specialist Architect straddle the fence between the RDBMS/NoSQL DB applications, and responsible for maintaining critical databases
  • Handled backup & recovery, security, monitoring, performance tuning and administering Oracle and PostgreSQL databases
  • Designed & implemented high-availability solutions using Oracle RAC
  • Configure physical standby databases for disaster recovery
  • Worked in multiple system study, analysis, design and maintenance of database
  • Design and configure various database backup policies
  • Performing backup recovery and database cloning using RMAN, data-pump export/import
  • Familiarity with Shell Scripting and PL/SQL
  • Working with/as offshore support DBA for Cummins in 24x7 environment coordinating with customer’s problems round the clock
  • Implemented automation tools to streamline routine maintenance tasks, enhancing productivity levels.
  • Designed robust disaster recovery plans that ensured minimal impact on business operations during unforeseen events affecting the company's data infrastructure.
  • Established clear documentation of all databases, facilitating knowledge transfer among team members and across departments.
  • Responsible 24x7 production operations (incident breakfix, change, service requests) and on-call rotation

Education

Bachelor of Science - Computer Science

Nagpur University
Nagpur, Maharashtra, India
06.2008

Skills

  • Oracle 10g ~ 19c
  • PostgreSQL 92 ~ 16
  • MySQL 57 ~ 8
  • Oracle OEM, Toad, SQL Developer
  • Pgadmin, Pganalyze
  • AWS (EC2, RDS, S3, EBS, CloudWatch)
  • Grafana monitoring
  • Tableau & PowerBI
  • Linux, AIX
  • RedHat Ansible Tower
  • Excellent Communication
  • Teamwork and Collaboration

Certification

  • Oracle Certified GoldenGate Expert
  • PostgreSQL - trained from EDB
  • DataStax Certified Cassandra Administrator
  • AWS Certified Solution Architect - Associate
  • Oracle Cloud Infrastructure Architect - Associate
  • ITIL V3 Certified

Timeline

Lead/Sr. Database Engineer

Cognizant Technologies Solutions
06.2014 - Current

Sr. Database Engineer

KPIT Cummins Inc.
09.2009 - 05.2014

Bachelor of Science - Computer Science

Nagpur University

Similar Profiles

CREATE PROFILE
Rahul Jain