Summary
Overview
Work History
Education
Skills
Personal Information
Certification
Overview
Timeline
Generic
Anmol Mittal

Anmol Mittal

Database Administrator in Oracle, Mysql, Postgres and Amazon RDS
Dehradun

Summary

With 13+ years of experience as an Oracle and Cloud DBA, Possess a strong proficiency in all aspects of database management, including installation, administration, configuration, upgrades, patching, backup and recovery, performance monitoring, tuning, cloning, space management, security, and production support. Primary focus is ensuring the seamless operation and security of critical databases while optimizing performance and providing reliable production support. I specialize in maintaining and enhancing database functionality to meet organizational needs. Currently, I lead a highly motivated team of 9 experienced DBAs and manage over 350 AWS EC2 and RDS instances for Oracle, PostgreSQL, and MySQL databases.

Overview

1824
1824
years of professional experience
4
4
years of post-secondary education
4
4
Certifications

Work History

Associate Technical Manager

Clovertex Inc
Hyderabad
02.202 - Current
  • Worked on multiple databases like AWS RDS such as Aurora, Oracle, MySQL, and PostgreSQL
  • Assisted with budget management for specific areas of business and costs related to onboarding and training of new personnel.
  • Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
  • Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
  • Extensive knowledge and experience on Amazon Web Services(AWS) Technologies like: EC2, RDS, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), IAM, VPC, Subnets.
  • Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production db and application.
  • Experience in Cloning the databases and Restorations from production to Test using Hot, Cold and RMAN Backups. Cloning (Hot/Cold/RMAN) an oracle database for Testing.
  • Applying PSU Patches and Bug Patches to fix the Bugs using Opatch Utility and Opatch Auto.
  • Hands on experience in implementing and installation of DataGuard Broker for EC2 instances and supported High Availability.

Oracle DBA III

Rackspace India
05.2012 - 01.2022
  • Managing 5k+ databases of 60+ US clients
  • Database Administration for Oracle (10g, 11g, 12c,18c,19c) responsibilities include daily maintenance review, Database Health checkup
  • Monitoring ample of alerts from ample of DBs using OEM and provide solutions of database errors immediately within SLA as per criticality of issue
  • Re-org database objects Tables & indexes to minimize fragmentation in the database
  • Performing Database Patching activity
  • Generate AWR, ASH and ADDM reports
  • EXPDP & IMPDP and RMAN Backup
  • Database object space monitoring and resolution
  • Standby database maintenance
  • Database upgrade using DBUA
  • Hands on experience on Database security tools like TDE, Database vault
  • Tracing and follow up issues through ticketing system Service Now , Jira and Client Standard SOPs
  • 13c OEM installation and managing Rule set and Metrics
  • OEM monitoring, agent Installations and configuration of host monitoring
  • ASM and RAC database maintenance and administration
  • Troubleshooting and Root Cause Analysis of production support related issues
  • 24 X 7 support
  • Complete Work from home option available for weekends & off-hours
  • Pluggable database maintenance

Sr. Support Executive

Path infotech Ltd.
02.2010 - 04.2012
  • Team is responsible for 24X7 supports for working on alerts and issues
  • Managing Backups using RMAN, Export/Import, Hot backup
  • Refreshed database from production to testing environment
  • Performance tuning for optimized results using tools like Explain Plan, SQL
  • Trace and TKPROF, Stats pack
  • Setup of Standby database for faster disaster recovery
  • Experience in database recovery (Control file, Data file, Init file)
  • Creation and maintenance of table spaces
  • Monthly Health Checkup of ATS clients and Preparation of Health checkup reports
  • Installation of different version of databases on different OS
  • Backup verification & monitoring

Education

Bachelor of Science - Information Technology

Galgotia University
Greater Noida, India
08.2005 - 07.2009

Skills

Patching

Personal Information

Date of Birth: 02/04/87

Certification

Oracle Cloud Infrastructure 2019 Certified Architect Professional

Overview

Proficient in database administration for Oracle and
PostgreSQL, including management of RMAN, RAC,
Data Guard, Data Pump, HA, upgradation, migration,
patching, Security,ASM, performance tuning, and
installation.

Timeline

Oracle DBA III

Rackspace India
05.2012 - 01.2022

Sr. Support Executive

Path infotech Ltd.
02.2010 - 04.2012

Bachelor of Science - Information Technology

Galgotia University
08.2005 - 07.2009

Associate Technical Manager

Clovertex Inc
02.202 - Current

Similar Profiles

CREATE PROFILE
Anmol MittalDatabase Administrator in Oracle, Mysql, Postgres and Amazon RDS