OBJECTIVES

• To obtain challenging and rewarding full time position in an organization with growth and learning opportunities in supportive, challenging work environment that would take advantage of my job experience.

SUMMARY

• 12+ years of IT experience as a Production Support Executive and Oracle DBA, responsible for managing and supporting Database Servers.
• Hands on experience in Data Migrations and modeling
• Creating Oracle, RAC and Single instance database.
• Monitoring database for daily health checkup.
• Performance tuning (Giving suggestion for query tuning from application side and parameter setting from database end).
• Hands on experience on upgrading RAC database from 11.2.0.3 to 11.2.0.4, from 11.2.0.4 to 12R1 and from 12.1 to 19C
• Patching for RAC Oracle database as per Oracle recommendations while debugging the environment.
• Applying PSU and CPU on RAC database as per the Oracle updates and recommendation.
• Hand - on experience to support Oracle database hosted on Exadata X7 machine for production, pre production databases.
• Export and import of database for taking the backup as per customer policy and making UAT database in-sync with Production database.
• Rman back up and restoration for replicating database performance for successful testing of new module in the pre-production environment.
• Managing Datagaurd environment in Active mode, making DC-DR synchronized.
• Shell scripting for automation of daily backups (Rman and Export) jobs and index rebuild.
• Stats gathering for the production schemas.
• Hands of experience in data conversion and migration.
• Hands on experience with Databases migration from other databases to Oracle Databases.
• Supporting AWS RDS databases for on-prem to cloud application and database migration
• Configuring services such as cloud watch for Database health on the EC2 instances for DBA managed servers.
• Allocating space to AWS managed Databases using S3 bucket, Elastic storage etc.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Senior Lead Administrator DBA

Responsibilities:

• The project involves complete Production and DR site end to end database management services, which includes the database implementation, tuning, backup configuring, migration and tuning activity
• Supporting Exadata machines X7 and X9.
• The environment consists of more than 700+ Oracle databases present in organizations Production and DR sites.
• The scope of work is to upgrade database from 12C to 19C with minimum downtime to the application.
• To support operation services for the databases support including end to end installation, configuration and support of Oracle, maintaining normal operation of standalone, clustered database across various OS platform.
• Some of the transactional database is having business requirement to have replication objects to another database with Oracle GoldenGate 12c software via table level replication.
• Supporting AWS RDS standalone databases on Oracle 19C version for Development and performance testing for on-prem to cloud migration.

Environment: OS-Oracle Linux, SunOS, HP Linux, Application Server- SAP Basis, Database Server-Oracle12c (12.2.0.1) and Oracle 19c (19.10.0.0) two and three node RAC DB

Confidential

Lead Oracle Database Administrator

Responsibilities:

• The project involves complete end to end database management services, which includes the database implementation, tuning, backup configuring, migration and tuning activity.
• The environment consists of more than 2500+ Oracle databases present in organizations London and Cambridge datacenters.
• The scope of work is to manage and operational support of the databases across globe for all the BU sites, database support including end to end installation, configuration and support of Oracle, maintaining normal operation of standalone, clustered database across various OS platform.
• Some of the transactional database is having business requirement to have replication objects to another database with Oracle Golden Gate software via table level replication.
• I have travelled to London (U.K) for project and knowledge transition perspective to gain the hands-on experience about the working on different project and successfully transferred the gained knowledge to the team based in Indore (India).

Environment: OS-Oracle Linux, AIX, Application Server- Jboss and Weblogic, Database Server-Oracle 11g (11.2.0.4), Oracle12c (12.1.0.1) three node RAC databases and Oracle Golden Gate 12c (implementation phase).

Confidential

Assistant Manager

Responsibilities:

• The project involves complete end to end database management services, which includes the database implementation, tuning, backup configuring, migration and tuning activity
• The environment consists of more than 1500+ Oracle databases present in Organizations Wolfsburg datacenter
• The scope of work is to manage and operational support of the databases across globe for all the BU sites, database support including end to end installation, configuration and support of Oracle, maintaining normal operation of standalone, clustered database across various OS platform.
• To complete the knowledge transition process travelled -Wolfsburg Germany.

Environment: OS- AIX 7.1, HPUX, Oracle Linux, Application Server- Websphere application server (WAS), Jboss, etc., Database Server- Oracle 11g (11.2.0.4) two and three node RAC databases.

Confidential

System Engineer

Responsibilities:

• The project is governed by Confidential bank and Confidential where Confidential is responsible for all the transaction taking place in remote areas, via Point of Sale (POS) device.
• The transaction hits the application server which connects to the database server for carrying the relevant transaction.
• The database needs to connect with other Confidential bank databases via Database links for validating the customer authentications and account details for completion of transaction.
• My scope of work in this project was to check the database is up and running, while performing housekeeping jobs, creating automation scripts for Rman and Export backups for keeping database up to date for any critical situation.
• Index rebuilding and stats gathering scripts were also implemented during project go live state.

Environment: OS - AIX 7.1, Sun OS, Application Server - Jboss 4.0, Database - Oracle 11g (11.2.0.3) Single instance.

Confidential

Application and Database Implementation

Responsibilities:

• From the work I did in my previous project my organization awarded me with new Database Implementation project for launching new product in the banking domain.
• The project entailed enabling the people living in small towns to perform transaction using biometric devices called kiosk devices.
• My tasks involved Installation of Oracle database from scratch, including gathering information regarding the product and the hardware requirement for the proper functioning of new product launched.
• We also created automated shell scripts for Rman, export, index rebuild and stats gathering tasks.

Environment: OS- Confidential 7.1, Application Server- Jboss 4.0, Database server-Oracle 11g (11.2.0.3) Single instance.

Confidential

Database Implementation and performance tuning expert

Responsibilities:

• The project was undertaken by Confidential, where all the interbank transaction comes to Confidential EPH database.
• The primary role was to implement the Oracle Database in rac environment, where the scope of work involved coordinating with Confidential bank infrastructure team, providing requirement for creating RAC database physical servers, for installation of the Oracle Clusterware and database software.
• After implementation of the Oracle RAC database server, performance tuning of the application from the server side was performed before going live.
• Implemented Datagaurd for the production database, which was sighted in different locations.
• I was also responsible for keeping Production database in sync with DR site database.
• Implemented shell scripts on both the sites (DC and DR) for Rman, export, sats gathering and index rebuilding
• As a performance tuning job I was responsible for managing and rectifying queries based on the duration of execution.

Environment: OS- Confidential 7.1, Application Server- Websphere application server (WAS), Database server- Oracle 11g (11.2.0.3) two node RAC database.

Confidential

Database Administrator and performance tuning

Responsibilities:

• The project involves complete end to end infrastructure management including servers, Databases, Storage and Networks.
• The environment consists of more than 2500+ Oracle databases around the globe supporting various applications for the client.
• The scope of work is to manage and operational support of the databases across globe for all the BU sites, database support including end to end installation, configuration and support of Oracle, maintaining normal operation of standalone, clustered database across various OS platform.

Environment: OS- Confidential 7.1, Windows Server 2008, RHEL 4, 5., Application Server- Websphere application server (WAS), Jboss, etc., Database - Oracle 11g (11.2.0.4) two node RAC databases.