Ankit Jain Phone: 919-***-****

Oracle Database Administrator ac0ozi@r.postjobfree.com

Relevant Experience:

Seasoned IT Professional with 8 years 4 months of Experience Database Infrastructure Management projects

Proficient in Oracle 12c/11g/10gR2 Database Design/Architecture, Disaster recovery, Data Guard, Oracle 12c/11g/10gR2 RAC and in backup and flashback recovery techniques, tuning and troubleshooting

Good in SQL & Application Tuning. Expertise in DBA Scripts for Ad-hoc backup & recovery and Database tuning

Setup and Implementation of Oracle Enterprise Manager 12c.

Performing SQL server database restore (point in time recovery).

Experience in installation of Oracle Apex application

Experience in setting up Disaster Recovery using Physical standby with Oracle Data Guard using Data Guard broker.

Enterprise Management and Administration: Estimated technology requirements based on need. Recommended and implemented Oracle Enterprise products (GRID, OEM, RAC, Data Guard and Active Data Guard) required by the client. Architecture designed at Server, SSA (Shared Storage), and Physical and Logical database levels.

Designed and implemented database backup & recovery solutions using shell scripting, Recovery Manager (RMAN), SMO technology

Good experience with Oracle 10& 11G performance tuning management for (Server, Application)

First line of response in 24x7 operations with on-call rotation

Experience in Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches.

Expert in methodology development, process improvement, enterprise technology strategy development and implementation

Experienced in database capacity planning, sizing objects, space management, and monitoring DB growth

Documentation experience includes writing procedures and recording configuration for major tasks completed, such as migration, installation, upgrades and configuration changes

Extensive Knowledge of Data Guard, Flashback technologies, Oracle Data Pump.

Monitoring and optimizing the Database Performances through Database Tuning, System Tuning and Application Tuning using AWR, ADDM, SQL ADVISOR, DBMS_STATS etc.,

Oracle Support Services are utilized for troubleshooting and database issues by creating Service Requests.

Hands on Experience in setup and maintenance with MongoDB and Elastic Search Database system as well.

Mongo DB – Backup and Restore, Upgrade and installation ops-Manager Maintenance

Technical Skills:

Databases Oracle12c, 11g, 10g, SQL Server 2012/2008/2005, MongoDB, Elastic Search

Development Tools TOAD, SQL Developer, SQL Loader, SQL*Plus, PL/SQL, DB2 Tuna

Diagnostic Tools OEM Grid Control, ADDM, AWR, Explain Plan, SRVCTL, SQL Performance Analyzer, CHM, RAC Check, YaST, TOAD, Ops-Manager for MongoDB, Sheild & Marvel Console for Elastic Search

Backup & Recovery RMAN,Data-Guard,EXP/IMP,DataPump, Flashback, Netapp SMO (Snapmanager for Oracle)

Operating Systems Solaris 8, Red Hat Linux 4.5, Windows Servers 2000/2003/2005/2008

Tools/Utilities Oracle Enterprise Manager 12c, DBTuna, BMC Remedy, HP PPM, Bugzilla, CA-Unicenter, Ops Manager for MongoDb, Service Now

Advanced Technology: Real Application Cluster, ASM, GoldenGate

Education:

Bachelors in Electrical & Electronics Engineering 2004-08, IES IPS ACADEMY Indore, India.

OCA 11g, OCP11g

Six Sigma Green Belt Certified

Employment Experience:

Database Administrator (Insurance Client), TCS (USA) March 2013 – Till Date

Responsibilities:

Responsible for setting up Dev to Prod environments (POC to production).Responsibilities included installation, configuration and production support of different versions of Oracle, MS SQL Server, MongoDB, ElasticSearch databases on various platforms.

Implemented physical Data Guard for high availability and disaster recovery in Oracle 12c/11g/10g.

Project Planning and management.

POC and Implementation of Oracle Apex Application/12c DB

Single handed setup of OEM12c from scratch to production.

Implementation on RAC Check, CHM and YaST for Oracle 11g RAC system.

Oracle database migration and upgrade from Oracle 8i/9/10g to Oracle 11g R2 and now moving them to 12c.

Performing Cumulative, Differential and Incremental backups using RMAN.

Setting up SMO and Administering the backup policy and restore.

Performed TSPITR, duplicating database using RMAN. Involved in Disaster Recovery Planning (DRP).

Data transferring and backup using exports/imports, Data pump and RMAN

Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches

Performance Tuning oracle databases and tuning applications, with Tuning Tools like OEM GC, Cost optimizer, SQL analyzer, Performance Manager, Statspack, AWR, ADDM, ASH,RDA,SQLT.

Partitioning tables by determining the suitable methodology to improve performance and manageability

Efficient use of Flashback technology to meet the requirements

Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access.

Oracle Support Services are utilized for troubleshooting and database issues by creating Service Requests.

Preparing documentation for ongoing maintenance and support

Interacting with Onsite & Offshore team for design and development.

Interacting with clients and all stakeholders.

Tracking and Mitigating the Risks.

Providing strategic and tactical direction to the setup of new applications.

Establishing & monitoring the processes for Issue Management, Change Management and Quality Management.

Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs.

Actively involved in design, implementation, and Testing of Disaster Recovery systems.

Actively working on reviewing and assessing the Security tools for the Database to monitor and Audit Database level of activity.

Performing SQL server database restore (point in time recovery).

Migration of SQL server database.

Creating a replication setup for databases.

Monitoring of the entire SQL Server mirrored database. There is one server which has mirrored database setup.

SQL Server database alert monitoring

MongoDB setup on Unix environment and maintaining the DB.

Setting up the Cluster,Standby and Backup & Restore policies for Mongodb.

Setup of Ops-ops manager for mongo to administer database using GUI.

ElasticSearch DB maintenance and Support using tools like Marvel, Sheild and Kibana

Environment: Oracle 12c/11g/10G, SUN SOLARIS 9/10, Linux 9, Oracle 12c/11g Grid Control, Oracle RAC 10g,11g, & 12c Data Guard, Import/Export, Data pump, SQL Loader, OEM, ADDM, AWR, DBMS_STATS, RMAN, EXPLAIN PLAN, Shell Scripts, SQL Server 2008/2012, MongoDB, Elastic Search

Oracle DBA, TCS (India) March 2010 to Feb 2013

Responsibilities:

Analyzing the project performance data and presenting the data as dashboard for project.

Interacting with Offshore team for design and development and with clients and all stakeholders for their requirements.

Responsible for Project management, Tracking and Mitigation of the Risks.

Work on sizing of database and tables, re-organizing of tables, tablespaces and users. Involved with monitoring the databases

Worked on user requests like export/import operations

Establishing & monitoring the processes for Issue Management, Change Management and Quality Management

Managing the Genworth Financial database

Reverse Engineering on database.

BO Report Query tuning

Data Warehouse Design and Size Estimation

Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs.

Creation script of database objects.

Developing migration strategies.

Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX

Environment: Oracle 11g/10G, Linux 9, Oracle 11g/10g Grid Control, Oracle RAC 10g & 11g, Data Guard, Import/Export, Data pump, SQL Loader, OEM, ADDM, AWR, DBMS_STATS, RMAN, EXPLAIN PLAN, Shell Scripts, SQL Server 2008.

Developer,TCS Dec 2008 to Feb 2010

Responsibities:

Setting up the whole new IVR System from scratch.

Collecting Data in the flat file system and modulating the data as per the application requirement.

Developed the database with the voice modulation software for the application to read the data.

Shell Scripting to combine the data in to the readable format for the application.

Trained for the Oracle Database.

Initial learning Program, by TCS for grooming up for the projects as Fresher.

Environment: Unix,C and C++, Sphinx(IVR software),Oracle SQL,PL-SQL.

Contact this candidate