SUMMARY

• 8+ years of solid hands on experience in Oracle database administration. As database administrator, I supported, administered large and diverse range of mission - critical database applications (OLTP and DWH) on production, development and test environments of leading Banking, Mortgage, Financial and Pharmaceutical industries.
• Installed, configured and supported Oracle database software (8i, 9i, 10g, 11gR1/11gR2, 12c), including Oracle Clusterware, standalone, Restart on traditional file system and also on ASM (Automatic Storage Management), ACFS on Unix and Linux platforms.
• Solid hands on experience in applying cpu, psu and one-off and bundled patches on oracle databases on both standalone and RAC environments using opatch, oakcli.
• Extensive hands on experience in upgrading oracle databases to current 12c.
• Good implementation skills, knowledge and understanding of new oracle database technologies like SCAN, TAF, Pluggable databases(12C) and In-Memory.
• Involved in designing and implementing capacity planning for enterprise databases across all regions for forecasting.
• Hands on experience in Installing, configuring and supporting/upgrading OEM and Enterprise Manager Agent (10g, 11g, 12c).
• Expert in designing and handling backup and recovery strategies (standalone and RAC) using RMAN (Incremental and Cumulative), Flashback technology, cold backup, import and export, impdp and expdp technologies as part of disaster recovery and recoverability for mission critical databases making sure that they meet RTO and RPO guidelines.
• Helped applications teams with database refresh and cloning requests from higher environments to lower environments as part of application testing, business requests and for Sox compliance using RMAN and data pump utility.
• Implemented both physical and logical database backups to disk and tape (TSM, Net Backup, Legato Networker) by automating the jobs using shell script (via cron Job) and OEM.
• Participated in corporate level disaster recovery exercise using Oracle Data Guard technologies including Fail-over and Switch-over operations.
• For High availability and Failover strategy, installed, configured Oracle RAC (Real Application Cluster) and Oracle Flex cluster databases.
• Solid understanding and managing experience in supporting RAC databases on 3 and 4 nodes cluster.
• Solid knowledge and experience in supporting ASM by creating disk(s), disk group(s) using ASMCMD.
• Handled security requests for databases by creating users, roles and granting the required privileges as per the client’s security standards.
• Involved column level masking and encrypting the database tables.
• Proactive monitoring of databases by setting up server monitoring and alerting using OEM (Oracle Enterprise Manager) Grid Control 12c, Database Control, or shell scripts.
• Managed and supported tablespaces and database files of standalone and RAC databases by adding, altering and reclaiming space.
• Good hands on experience in troubleshooting server level performance issues using vmstat, iostat, top, prtinfo, prtconf, prstat on linux and solaris servers and network level issues for TNS and listener.
• Investigated database performance related issues, using a range of tools including Stats pack, AWR (Automatic Workload Repository), adrcli, OEM, ASH (Active Session History), extended tracing & TKPROF, ADDM (Automatic Database Diagnostic Monitor), SRVCTL, CRSCTL, ORATOP and SAR.
• Mentored junior DBA’s and application users by providing industry best practices to application teams and helped troubleshooting database issues like index defragmentation and updating statistics and fixing.
• Supported 24×7 mission-critical production systems including trading applications as a member of the on-call rotation team.
• Good knowledge and hands on exposure supporting Oracle database in EXADATA.
• Good knowledge and hands on exposure supporting oracle databases in GoldenGate environment.
• Database maintenance and Shell Scripting - creating tables, views, stored procedures, triggers, updating databases through programs
• Good communicational, verbal, analytical and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 12c R1, R2 RAC, 11g/10g RAC, Oracle 9i, Oracle 8i, SQL Server, MySQL

DBA tools: SQL Navigator, SQL*Loader, SQL *Plus, OEM 10/11/12c, RMAN, DBCA, DBUA, Data Pump, Oracle Streams, Toad, Data Guard, EXPDP/IMPDP, Export / Import, TKPROF, STATSPACK, EXPLAIN PLAN, AWR, ADDM, ASH.

Operating System: Red Hat Linux 4.x, 5.x,6.x,7x, AIX 5.1, 5.2, 5.3,6.1, Sun Solaris 8,9,10 HP-UX10x,11.x, Oracle Enterprise Linux 6.x,7.x, SESU Linux 11/12, Windows NT/2000/XP/Vista

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Oracle DBA

Responsibilities:

• Responsible for supporting and maintaining Production/UAT/TEST/Development databases in 24 x 7 environment on day-to-day basis.
• Held responsible for assisting application users on database requests like providing them with database health reports, tablespace usage reports, ASM reports and maintenance jobs (index rebuilds, table fragmentations, stale stats reports) on day-to-day and weekly basis.
• Proactive monitoring of Schema Management, Security management(users/roles), Tablespace usage, alert log, trace files, disk usage, Table/index analyze jobs, database backup logs etc and sending status reports to higher management for review.
• Worked/implemented RAT POC and used RAT (Real Application Testing) for application testing for database upgrade and database parameter changes.
• Upgraded Databases from 11.2.0.3 to 11.2.0.4 and11.2.0.4 to 12c.
• Upgraded 11g R2 RAC to 12c RAC.
• Applied Quarterly released PSU’s for 10g, 11g (RAC), 12c (RAC) Oracle databases.
• Created and administered pluggable database in both standalone and RAC (12c).
• Installed & configured Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
• Migrated Non-ASM Single Instance to ASM RAC 4 node Instance.
• Migrated 3+ TB databases across the platform (from Solaris to Linux)
• Involved in storage migration from vmax to emc storage.
• Worked with different stake holders of different projects by gathering information and understanding them and providing them with inputs from the database technology perspective.
• Supported application teams with Schema/Database Refresh Requests using Data Pump (expdp/impdp). Used Network Link feature of Data Pump to import data directly to target database.
• Worked on AWS (Amazon Web Services) POC to move databases from local to AWS cloud.
• Investigated database performance related issues using a range of tools including AWR, ASH, extended tracing & TKPROF, ADDM (Automatic Database Diagnostic Monitor) and SQL tuning advisor and OEM (Oracle Enterprise Manager) 12c.
• Enabled flashback database as a point in time recovery for application releases and performance testing’s as backout plan for PROD change requests.
• Manage RAC environment for Day to Day Database administrator, Performance Tuning.
• Expertise in Oracle Enterprise Manager (OEM) 12c, TOAD.
• Hands on experience in supporting clustered databases using Veritas Cluster (VCS) on SUSE 10/11.
• Supported application team by coordinating with developers with new releases by gathering new application release by reviewing, managing by following change management across several instances by tracking and reconciling database modifications with change control tickets.
• Worked with development teams to test newly deployed code and monitored unit/performance tests using OEM 12c. Generated/gathered AWR reports, sql’s execution plans and identifying bad sql’s and suggesting developers with enhancements to the queries/stored procedure based on results.
• Enabled audit triggers, Database triggers, product profile for Database security and profile setup for managing system resources.
• Developed/tested shell scripts for monitoring and automating database activities by implementing across all environments.
• Installed and configured Oracle Golden Gate of version 11.1 and 11.2 for schema and table level replication for reporting teams.
• Proactive monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redologs, Archived Redologs by creating alerts.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT).
• Database design Data modeling, Schema design using ER Studio, Schema design and scripting, dynamic schema generation.
• Worked on physical modelling to create scripts for application releases.

Environment: Oracle 12c RAC,11g RAC, 10g HP-UX, Sun Solaris, IBM AIX, SUSE 10/11, Oracle Enterprise Linux, RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader, TOAD, Data Pump, Oracle Golden Gate, OEM12c, ER Studio.

Confidential, Tempe, AZ

Sr. Oracle DBA

Responsibilities:

• Responsible for 24 X 7 Production, other lower environment database administration, support and monitoring.
• Installed and configured ODA’s (Oracle Data Appliances) onsite and remotely with Oracle 11.2.0.3 with 2 node RAC and worked with development team with testing new hardware as part of pre migration.
• Migrated all existing Non-ASM single instance database to ODA’s with 2 node RAC
• Upgrade databases from 11.2.0.3 to 11.2.0.4 on 2 node RAC
• Upgraded Oracle Enterprise Manager (OEM) 11g to 12c and as part of centralized monitoring setup installed OEM agents on SQL Server and Middleware servers and configured monitoring alerts for DB Threshold, policy violations, RMAN backups, database maintenance.
• Upgraded Oracle Enterprise Manager 12c R1 to 12c R2
• Created standby databases for all production databases and enabled active data guard for application team reporting jobs purpose to off load user traffic on primary database
• Applied psu’s and one-off and bundled patches (for ODA’s) on oracle databases on both standalone and RAC environments using opatch, oakcli
• Worked with middleware/Unix/network teams on performance issues to mitigate and resolve issue in timely manner.
• Worked on performance tuning of SQL and Procedures and packages.
• Cloned databases per application requirements using RMAN and refreshed schemas using datapump utility (expdp/impdp) from higher to lower environment databases.
• Enabled flashback database for application team testing’s and resorted back to point in time after the testing.
• Using Oracle gateway migrated data from SQL Server database to Oracle and setup daily refresh shell script job to refresh target Oracle database as per business requirement.
• Worked in parallel with development team on database/schema design by gathering new requirements. After deploying the new changes to database, worked with development team to monitor unit/performance testing and suggested sql changes from AWR, sql plan results
• Used Compress for OLTP 11gR2 option for Table/Partitioned Tables to save space and improve I/O performance. Enabled Secure File LOBS to take advantage of data compression.
• Performance planning and solution implementation to handle high-speed and high volume data.
• Migrated Database related Cron jobs from server to OEM 12c
• Administrated existing MySQL databases. Created/removed users as needed
• Administrated SQL Server databases. Deployed application releases when needed.
• Using Idera SQL admin tool monitored, administrated SQL server databases and configured backups.
• Applied new release changes and data modification changes when needed on SQL Server DB’s
• Did setup SQL Server database alerts to page on call dba if we have any issues

Environment: Oracle 11g RAC, ODA’s, HP-UX, Sun Solaris, RedHat Linux, Oracle Enterprise Linux, Windows, MySQL, SQL Server, Idera, RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader, TOAD, Data Pump, OEM GRID Control 12c.

Confidential, Newark, DE

Sr. Oracle DBA

Responsibilities:

• Provided support for both the Production and Development databases on 24*7 basis with on-call pager.
• Installed, configured and administrated mulit node RAC databases on windows and Unix
• Upgraded databases from 10g to 11g include RAC
• Applied cpu and one-off patch using optach utility
• Configured bi-directional replication for critical application databases using Oracle Streams
• Using RMAN refreshed databases from higher to lower environments and cloned databases for application testing
• Setup stand by database (Data guard) for high availability/disaster recovery purpose.
• Daily Health check of database using STATSPACK, AWR, ADDM.
• Developing Disaster Recovery plan.
• Monitoring and Troubleshooting issues.
• Recovery of database from Media failure and Block corruption.
• Management of schemas, objects partitioning the tables & indexes.
• Scheduling of jobs database maintenance, reporting and backup jobs.
• Responsible for optimizing the queries and application tuning.
• Monitoring and tuning system resources related to database performance issues
• Setup Automatic Storage Management.
• SQL scripts to monitor tablespaces and extent growth.
• Creating and maintaining Big File Table Spaces.
• Experience in maintaining database security using security compliance auditing.
• Setting up and Managing Flash Recovery Area.

Environment: Oracle 11g RAC, 10g Sun Solaris, IBM AIX, RedHat Linux, Windows, RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader, TOAD, Data Pump, OEM GRID Control.

Confidential, Sacramento, CA

Oracle DBA

Responsibilities:

• Part of 4-member DBA team for 24x7 supports of 9i production, development databases.
• Installed, administrated Oracle 9i, 10g RAC and applied cpu, one-off patched as recommended by Oracle.
• Performed backup and recovery using RMAN.
• Monitoring performance and tuning the database.
• Maintaining database security by creating roles, privileges, quotas and passwords.
• Creation of database objects.
• Involved in Database Capacity Planning and Security Management.
• Documenting all Oracle database operations and training of backup personnel.
• Transfer of data from one database to another using export/import (exp/imp).
• Monitoring the performance of database and viewing alert log.
• Creating hot and cold backup scripts to automate backup procedures.
• Providing support to end users and developers.

Environment: Oracle 10g RAC, 9i Sun Solaris, Red Hat Linux, Windows, RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader, TOAD, Data Pump, OEM GRID Control

Confidential

Junior Oracle DBA

Responsibilities:

• Maintaining Oracle databases
• Provided 24x7 supports when required.
• Involved in the installation of Oracle 8i,9i,10g
• Monitoring the growth of the database.
• Involved in creating the backup and recovery procedures.
• Diagnose and Troubleshoot Database Problems and failures.
• Involved in tuning the database to increase the response times.
• Created materialized views, Database links, tables, synonyms, for replication.
• Created database objects, imported database objects which have been either truncated or dropped by accident.
• Management of table space growth, monitoring data file additions.
• SQL, PL/SQL Programming. Written PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 10g, 9i, 8i, Sun Solaris, Red Hat Linux, Windows, RMAN, PL/SQL, SQL*Loader, TOAD, Data Pump