IBM India Pvt Ltd Sep’2014 – Oct’2018

Role: Oracle SME

Project: ABN AMRO Netherlands
Description:

·      24×7 Oracle Production Database Administration including Oracle 10g/11g RAC.

·     Installed, configured and maintained Oracle Databases.

·     Managing, troubleshooting and resolving oracle database, RAC and applications issues.

·     Involved in Upgrade/Migration of the oracle databases.

·     OEM Gridcontrol to monitor all databases.

·     Implementation of High Availability solutions with Oracle 10g RAC, Physical  Standby.

·     Developed scripts and reports using shell scripts and automated the jobs

·     Working alongside programmers and contributing to the development process; Enabling and analyzing trace files

·     Performing monitoring and performance tuning.

·     Defining and Setting backup and recovery procedures.

·     Oracle query tuning

·     Writing Shell Scripts for managing day-to-day activities and automation of backup.

·     Installation of Oracle RDBMS server software and version upgrades.

·     Verify the backup of Databases

·     Installation and configuration of Oracle Client software and Tools.

·     Performed point in time recovery on request of client.

Environment: Oracle 10g/11g/12c ,RAC, Exadata X4 , Redhat & AIX

Bureau Veritas India (ISM-GSSC)

Oracle DBA

May 2014 – September 2014

Bureau Veritas is an international certification agency.

Description:

ü  Deploying RDBMS update packages on existing servers

ü  Access management through database account create/drop operations on RDBMS

ü  Execute DDL/DML instructions against an existing hosted database to extract or update
       data

ü  Execute DDL/DML instructions against an existing hosted database as part of application
       deliveries

ü  Refresh schema contents with data from another schema

ü  Control and verify automated backup maintenance tasks execution

 IBM India Pvt Ltd( Payroll Artech Infosystem)

Oracle DBA

February 2012 – May 2014

Project: ABN Amro Bank Netherlands

Environment: Oracle 10g/11g/12c, RAC, Exadata X4-2 , Redhat & AIX

Description:

o    Creation of new database & Database cloning.

o    Applying quarterly security patches.

o    Liaison with other technical areas such as Unix System Administrator, Backup teams and so on.

o    Performing database refresh through RMAN on user request.

o    Managing backup of database.

o    Managing & working on DB alerts through 10g grid / APEX.

o    Creation and management of clones of live database for testing purposes.

o    Creation and Managing Physical objects, Logical objects like Users, Tablespaces, Databases Tables, Views, Indexes other Database Objects.

o    Hands on Experience in 10g/11g Database/Agent installation, configuration & Administration.

o    Supporting RAC databases running on Linux.

o    Refresh schema contents with data from another database or schema

o    Control and verify the RDBMS instance health in real time

o    Increase database space (tablespaces, datafiles, etc.) and server partitions storage preventively.

o    Deploying RDBMS security patch update packages on existing servers

Nokia Siemens Networks (P) Ltd

Oracle DBA

November 2010 – January 2012

Project: Zain Telecom Saudi Arabia

ü  Daily activities include monitoring the database which includes, checking the size of tablespace, datafile, processes, free space in the data drives.

ü  User accounts management.

ü  Creating base product Tablespaces, Datafiles, tables.

ü  User accounts management.

ü  Logical backup of database

ü  Interaction and Co-ordination with clients.

ü  Monitoring space utilization for the datafile and archive log files.

ü  Written shell scripts for filesystem usage, memory, tablespace usage etc. look for the SQL performance issue.

Certification:

Oracle Database 12c Administrator Certified Professional
Oracle Database 9i Administrator Certified Professional
Oracle Database 9i Administrator Certified Associate
Education :

Uttar Pradesh Rajarshi Tandon Open University

Master of Computer Application

Lucknow, Uttar Pradesh

Completed: January 2010

Integral University Lucknow

Bachelor in Computer Application

Lucknow, Uttar Pradesh

Completed: January 2008

Department of Electronics and Accreditation of Computer Classes(DOEACC)

Diploma, A Level

New Delhi, Delhi

Completed: January 200

TECHNICAL SKILLS:

Operating Systems: Red Hat Enterprise Linux RHEL 5.x,6.x,7.x Sun Solaris ,IBM AIX

DB Management:  OEM 10G/11g/12c/12c

RDBMS : Oracle 11g, 10g, 9i,PostgreSQL

NoSQL DB: Mongodb

Tuning/Monitoring: TKPROF, EXPLAIN PLAN, AWR

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, Export/Import, Data pump

Programming Others: SQL, PL/SQL, UNIX Shell Scripting, Python (Basics)

Other: TSM

Professional experience:

Gemini Solutions Pvt Ltd Oct 2018 – Present

Role: IT Tech Lead-Oracle

Project: PIMCO (U.S. based income investment firm)
Description:

·         Full time DBA to provide support for 24×7

·         Responsible for continuous database monitoring and reorganization for ensuring performance.

·         SQL queries optimization by adding hints.

·         Monitor and troubleshoot Golden Gate related issue.

·         Manage databases running on Exadata.

Environment: Oracle 11g/12cR1/12cR2, RAC, Exadata X4, Redha