Ankita Sharma
Oracle Data Base Administrator (DBA)
Ghaziabad,Uttar Pradesh
Summary
Experienced IT professional with over 12 years in database management, specializing in Oracle 19c/18c/12c/11g/10g/9i and platforms like PostgreSQL and Snowflake. Expert in performance tuning, RMAN, RAC, ASM, Golden Gate, and Oracle Cloud. Adept at data migration, replication, and backups, with a strong track record in system optimization and automation using OEM and SQL Developer.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
5
5
Certifications
Work History
DBA Consultant
Infosys
11.2021 - Current
- Enhanced system stability and operational efficiency by managing Production, Standby, Development, QA, and RAC databases in Oracle 10g/11g and 12c, ensuring robust performance and uptime.
- Drove seamless operations through expert installation, configuration, upgrade, and troubleshooting of Oracle databases and Golden Gate, significantly reducing downtime.
- Improved service delivery and team coordination by leveraging the ServiceNow ticketing tool for managing Incidents, Problems, and Change Requests, and streamlining processes through effective handling of RITMs.
- Strengthened system security and efficiency by executing critical tasks including user management, password rotation, and automation via the NIA Tool, while resolving issues in Snowflake and PostgreSQL environments.
- Facilitated decision-making and data management by handling reporting responsibilities and utilizing Expdp/Impdp for efficient data pump tasks.
Senior Analyst
Accenture
03.2013 - 11.2021
- Supported major projects including KOHL's, DEXMEDIA, and NEW LOOK by managing Production, Standby, and Development databases in Oracle 10g/11g and 12c, ensuring high availability and performance.
- Enhanced database efficiency through reorganization, cloning, and server migrations, while ensuring secure access by managing user roles and system space.
- Facilitated development and testing by creating dedicated databases, and maintained system currency through regular upgrades and CPU patches.
- Optimized performance by gathering statistics, rebuilding indexes, monitoring databases, and verifying data integrity through user and role management, cloning, and backup validation.
- Improved system understanding and client relations by documenting key processes and reports, executing successful database migrations from AIX to Linux, managing ASM instances, and configuring monitoring tools like OEM, SQL Developer, and Toad.
Data Base Adminitrator
Wipro Aviva Life Insurance
05.2011 - 03.2013
- Streamlined database operations by installing Oracle databases, creating users, and managing necessary grants to ensure efficient access control.
- Maintained system health by conducting daily check-ups and monitoring over 500 servers across production and non-production environments.
- Managed data replication and ensured data safety using Golden Gate for replication and various backup utilities, including data pump and Flex One.
- Facilitated data availability and system stability through cloning with NetApp FlexClone and vigilant monitoring of alert and archive logs.
- Optimized performance by creating and managing tablespaces, and enhancing system understanding with AWR, ADDM, and Statspack reports, along with generating explain plans for queries.
Education
Bachelor's of Technology - Information Technology
MAHARSHI DAYANAND UNIVERSITY
Haryana, India 11.2006 - 12.2010
Skills
Oracle 10g/11g/12c/18c/19c
Data Base Migration
OEM
Encryption
User Management
Oracle Streams
Golden Gate
Data Pump (Expdp/Impdp)
RMAN
SQL Tuning & Query Optimization
Automatic Database Diagnostic Monitor
Automatic Workload Repository
Data Guard
RAC
ASM
Oracle 10g/11g/12c/18c/19c
Certification
ITIL
Timeline
DBA Consultant
Infosys
11.2021 - Current
Senior Analyst
Accenture
03.2013 - 11.2021
Data Base Adminitrator
Wipro Aviva Life Insurance
05.2011 - 03.2013
Bachelor's of Technology - Information Technology
MAHARSHI DAYANAND UNIVERSITY
11.2006 - 12.2010