Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

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

undefined

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

Similar Profiles

CREATE PROFILE
Ankita SharmaOracle Data Base Administrator (DBA)