SUMMARY:

• Seasoned IT Professional with 9 years 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 Oracle 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.
• Mongo DB - Backup (Mongo dump, Full back up using Ops-manager) and Restore,
• Mongo DB Upgrade from 3.2 to 3.4.
• Ops-Manager Installation, Upgrade and Maintenance.
• Hands on Experience in setup and maintenance with MongoDB and Elastic Search Database system as well on RHEL.

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, Robo mongo, Robo3T

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

Backup & Recovery: RMAN, Data-Guard, EXP/IMP, Data Pump, Flashback, NetApp SMO (Snap manager for Oracle), Ops Manager4 for Mongo Backups and Restore

Operating Systems: Solaris 8, Red Hat Linux 7.3, Windows Servers 2000/2003/2005/2008/2012

Tools: /Utilities Oracle Enterprise Manager 12c, DB Tuna, BMC Remedy, HP PPM, Bugzilla, CA-Unicenter, Ops Manager for Mongo DB, Service Now, DB Maestro

Advanced Technology: Real Application Cluster, ASM, Golden Gate

PROFESSIONAL EXPERIENCE:

Database Administrator/Architect

Confidential

Responsibilities:

• Working as Senior Database Administrator, Architecting new databases for the cloud applications.
• Setting up new 12c Databases on Cloud (AWS and OPC)
• Working on Migrating databases from On-Prem to Cloud.
• Automating the server setup and Database creation as per the company standard.
• Setting up the Database security features for Oracle databases.
• Migration of Databases from oracle 10g/11g to 12c On-prem and cloud environment.
• Working on-need basis for the performance issues. L3 Support.

Database Administrator

Confidential

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 and MongoDB and Elastic-Search 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, Stats pack, 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 Mongo DB.
• Setup of Ops-ops manager for mongo to administer database using GUI.
• Ops Manager Upgrade from 2.0.6 to 3.4.4
• Mongo DB migration and Upgrade from 3.2 to 3.4
• Elastic-Search DB maintenance and Support using tools like Marvel, Shield 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

Confidential

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

Confidential

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 Confidential for grooming up for the projects as Fresher.

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