SUMMARY:

• Over 8 years of experience as Database Administrator in multiple Database technologies Oracle, and IBM DB2.
• DBA experience in fortune 16 company handling different database technologies for customer facing mission critical, and business critical applications.
• Hands - on experience in administration of Oracle Database on Linux, Windows environments.
• Exposure of business Intelligence tools Qlikview, SAP Lumira and Network security tools.
• Experience in installation and setup of MongoDB, NOSQL databases.
• Strong understanding and development experience of all stages System Development Life Cycle (SDLC).
• Very strong in Creation, Installation, setup, Administration, Maintenance, Backup restore, and recovery of Oracle database Server in Single Instance & RAC for 11g and 12c.
• Strong experience in database design, develop, database creation, administration and maintenance.
• Strong command Oracle 12c architecture, installation, and Administration.
• Experience in creating Container Database (CDB) and Pluggable Database databases (PDB).
• Sound Knowledge of internal architecture of UNIX operating system.
• Experience in Golden gate implementation, monitoring of GG process, GG cleanup scripts.
• Experience in Real Application Cluster, Oracle Enterprise Manager, Patching, and Up gradation of database.
• Experience in Verifying Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH) reports, checking the statistics, and troubleshooting for good performance of the database.
• Experience in administration of Import/Export, DataPump Expdp, and Impdp
• Performed Data guard switchover /failover as per the requirements.
• Experience in Automatic Storage Management, Adding disk groups, dropping disk groups.
• Experience in RMAN backup and complete knowledge all recoveries.
• Experience in database performance tuning by gathering statics using TKPROF, STATSPACK, AWR, as on when required. Improve the performance of databases.
• Experience in building Data Warehouses/Data Marts using ETL tools.
• Experience with Informatica (ETL Tool) for Data Extraction, Transformation and Loading.
• Experience in supporting production release on business requirements monthly, quarterly, yearly.
• Skilled in writing Perl and shell scripting.
• Experience in handling and resolving critical Sev1, Sev2 issues.
• Experience as IBM DB2 DBA (UDB) 9.7.
• Strong Knowledge on Devops methodology, Citrix Xenserver Cloud Infrastructure, Chef, Jenkins, Dockers.
• Experience in Database creation for Dev, test, Prod environments and handling DB request from developers and testers.
• Experience in handling Business critical and system critical database system.
• Monitoring the db2diaglog for alerts and Daily backup for Databases.

TECHNICAL SKILLS:

Platforms: Linux, Sun Solaris, Windows

Languages: Shell Scripting

RDBMS: Oracle 10g, 11g, 12c, IBM DB2 9.7, Sql Server 2008 R2

NoSQL: MongoDB

Tools: RMAN, Data pump, OEM Grid, Golden Gate

Business Intelligence: Qlikview, SAP Lumira BI

Network Security: Splunk, Wireshark

Middleware: Oracle Access Manager

Methodology: Devops

Virtualization Technologies: XenServer, AWS

CI Tools: Knowledge on Jenkins

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Oracle DBA

Responsibilities:

• Worked as an Oracle 9i/10g/11g/12c DBA with Single node RAC databases running on Sun Solaris Sparc machines, Supporting more than 150 Instances of Oracle Databases (9i/10g and 11g) sized 500 GB up to 10 TB with more than 1200 concurrent users.
• Worked in a 24/7 Environment supporting Oncall rotation and resolving Alerts/job failures and Production issues.
• Worked closely with the System Admins as well as WebApp Admins to maintain 99% availability.
• Perform pro-active and reactive performance analysis, monitoring, troubleshooting, and resolution of issues in accordance with client SLAs using Cron jobs, Grid Control, Toad and Ignite.
• Perform regular database capacity planning taking into account database growth, system utilization, trend analysis, and predicting future database resource requirements.
• Performed regular Oracle Database PSU patching including the latest 11.2.0.3.12 JVM Combo patch using OPatch on entire Non-Prod and Prod systems to stay up to date.
• Performed user maintenance and assisted in Auditing efforts to remain SOX compliant.
• Work closely with Web and Application support teams to perform database migrations and ATG BCC database refreshes.
• Worked closely with development team and implemented Interval partitioning in entire Non-Prod and Prod systems for some of the reporting tables thereby saving storage and improved performance for the critical databases.
• Worked Closely with ORACLE SOA Developers and WebAdmins and implemented the SOA Purge mechanism on the SOAINFRA schemas thereby reducing overhead on the storage and checked the massive growth of those tables. Wrote a detailed implementation document outlining the functioning and steps to be followed on the SOA Purge process.
• Worked with multiple teams throughout the development process up till Production deployment of new projects on a regular basis.
• Worked on a regular basis with ORACLE Support to solve pending Production, Implementation issues identifying and logging bugs.
• Developed, tested and successfully Implemented disabling SSLv3 and enabling TLSv1 Only secure authentication protocol in entire internal systems including OMS servers and more than 300+ Agents including WebServer Agents. Authored a comprehensive document outlining steps to be followed by the System DBA's and WebAdmins.
• Worked on clearing Tickets in the DBA support queue which includes Business Users, Developers, QA analysts and Infrastructure requests.
• Worked as Primary focal contact for Non-Prod and Prod code releases, successfully releasing Prod code during monthly Production code release windows working from 11 PM to 10 AM.
• Performing performance tuning of slow running SQL queries using tkprof, explain plan and AWR/ADDM reports.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Performed Infrastructure Changes on Production databases during Monthly Global Maintenance Windows.
• Experience on Data Replication using Snapshot, Materialized views, import/export, Data Pump.
• Expertise in maintaining Database Security using security compliance auditing, expertise in Loading data from flat files using external tables, SQL*LOADER.

Environment: Oracle 9i/10g/11g/12c Single Node RAC & 11g Data guard, Ignite Confio 8, Grid Control OEM 11g, Solarwinds, Hobbit, RMAN, Toad, SunOS 5.10 x64, Service Now ticketing tool, HP Project and Portfolio Management(Pulse), Oracle SOA.ATG.

Confidential, Pleasanton, CA

Oracle DBA

Responsibilities:

• Migrated databases on standalone server to 2 node RAC cluster.
• Migrated databases from Windows to Linux using RMAN Duplicate and Data Pump.
• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 2 Node RAC on EXADATA X2-2 Quarter Rack and Eighth Rack.
• Implemented and Installed Level 1 OEM Cloud Control 12c on Linux machine.
• Installed WebLogic server 10.3 during the Installation of Cloud Control 12C
• OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12c.
• Converted single Instance Databases to RAC databases using Manual method.
• Setup physical standby's (DATAGUARD) for several Databases
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using data pump.

Environment: Migrations Oracle on windows to Exadata, Oracle EXADATA Quarter and Eighth RACK X2-2, Oracle 11gr2, OEL 5.8, OEM 12c, RAC, Data guard including DGMGRL, RMAN, Performance tuning, Oracle Patch Auto, TOAD for oracle 11

Confidential, Edison, NJ

Oracle DBA

Responsibilities:

• Configuring and Administration of Oracle RAC infrastructure
• Created, configured, and administrated Oracle 12c Container Database (CDB), Pluggable Database databases (PDB).
• Experience on ASM, Data Guard with switch over and fail over Experience in troubleshooting the performance related issues with AWR, ADDM reports.
• Monitor and administration of databases with Oracle Enterprise Manager
• Database creation, Administration, Monitoring, Maintenance activities are handled for VRD (Verizon Rapid Delivery) environments.
• Experience in applying Patch Set Update (PSU) and Critical Patch Update CPU patches
• Handling DR-drill test quarterly as part of ensuring the system availability
• Monitoring of alert log file, and regular database health checkup
• Experience in handling production releases, Major and Minor releases, Maintenance activities
• Tuning oracle databases and tuning applications, with Tuning Tools like OEM, SQL analyzer, Statspack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE
• Checking and verifying for the corrupt blocks and recovering them
• Responsible in handling very large database environments (VLDB)
• Configuration of Test, UAT, Dev database environments depend on the project requirements
• Handling the issues, developing fast forward recovery mechanism in resolving issues
• Documenting the issues for improvement of process in solving the database issues
• Pro-active monitoring the databases for performance, and availability
• Performance tuning for optimized results using AWR, ADDM statistics.
• 24/7 support for production databases.
• Production support DBA, managed Oracle 10g, 11g, 12c databases.
• Experience in handling Crisis Bridge, incident handling, DBA support group in handling incidents/crisis issues.
• Experience in handling on-call support and working with external business customers.

Environment: Oracle 9i/10g/11g, Linux, AIX, HP-UX, Solaris, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, Oracle Replication, SQL*Plus, PL/SQL, SQL*Loader.

Confidential, Dublin, CA

Oracle DBA

Responsibilities:

• Creation of databases of Dev, Test, Migration of environments upon the request.
• Closely working with developers on deploying stored procedures
• Running rebinds on the tables, handling performance issues when slowness is reported
• Handling DBA request tickets
• Production support for the DB2 System for the enter support group
• On-call duties for handling emergency issues
• Experience in working in war room kind of setup during stress test or shake out of the application to monitor the performance and problems.
• Experience in developing disaster recovery planning documentation, business continuity planning documentation for the database systems
• Experience is developing change plan, Major release and minor release for every application
• Experience in production support of the IBM DB2 system parallel with Oracle systems.
• Tuning parameters, buffer pools, indexes to improve the performance.
• Binding the Sql statements and run them as a package.
• Working on implementing multiple HADR standby servers.
• Handling Crisis Bridge of all the application in support, Running all the basic health checks of the databases respective to the application and confirming on the Crisis Bridge.
• Handling Change Activity bridges for planning of any Production changes/ Releases /Maintenance activities.
• Verifying all the database health checks before the business hours are started
• Opening SR case - with Oracle for unresolved issues and driving the task for the problems resolution.
• Keeping a track of fast forward recovery for the problems occurred and impacted production systems.
• Handling on-call duties for week-ends
• Identifying the slow running queries, high IO usage, high CPU usage, long running queries are optimizing the queries.
• Monitoring the databases on OEM system to drill down the servers with high CPU usage.
• Contacting all the teams respective to the application and brought up a plan for migration of the application to new hardware.
• Closely working with Application Manager for the approval of new hardware and necessary installation of latest version of Operating system.
• Installation of Oracle 11g and creation of databases with same kind of setup which is available on old hardware.
• Taking database export dump using Data Pump utility and copying on the new server, and importing the data on the new databases created.

Confidential

L1 - Database Administrator

Responsibilities:

• Completed my academic Project CHRIS (Complete Human Resource Information system) at this organization.
• From Aug-2009, Part of production support team, Monitoring on Production Database and escalating to lead to fix the issue.
• Database Installation, DB Creation, monitoring databases, maintenance, export, Import, adding space, checking database health before business day starts
• Monitoring backup of databases.
• Developing the Dev & Test Database, supporting production databases
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Expert with OEM Event and Job Managers, Change Manager, Diagnostics & uning Packs.

Environment: Oracle 10g, Export, Import, RMAN backup, Space Management, User Management, Networking, Installation, DB creation, Monitoring, 24/7, Maintenance.