SUMMARY

• 15 years of experience as a Sr.Oracle DBA providing Database and Infrastructure support to various clients in USA for mission critical production environments related to Banking, SFRAC, Exadata, RAC, E - Commerce, B2C, B2B, Telecom, Energy, Oracle ERP systems, Data Warehousing, Media Entertainment and Television Networks, Data conversion for Telecom Billing systems and remote DBA support. Worked on very large Databases (1 TB to 7 TB) providing infrastructure and maintenance support. Saved 1 million US$ for a client(Data Center change) and 100,000 Euros per Annum by migrating and upgrading 4 production databases from Germany to USA on high speed datalinks (Infrastructure support).
• Currently working as an Oracle DBA at Confidential Bank at Wilmington, Delaware.
• Performed Oracle (9i & 10g) and DB migrations to VLDB’s, setting up monitoring tools, Application upgrades, Performance Tuning.
• Installed Oracle Enterprise Manager 11g.
• Upgraded databases and Binaries, applied CPU patches to databases in Prod/Dev/Test and UAT environment.
• Prepared DBA work plans, Documented Client site’s “Site specific work procedures”, Change Management and control, Best Practices and did Capacity planning for clients.
• Conducted workshops on “How to provide better DBA support” for DBA teams to increase their productivity in a shift.
• Implemented Oracle Goldengate. Configured RAC databases and Data Guard.
• Mentored team members, trained and guided them in establishing procedures and processes for Oracle core and APPS production env, Backup and DR plans.
• Relocated & migrated Oracle Databases from Germany to USA saving the client 100,000 Euros per annum.
• Saved the client 1 million US $ performing proactive DB administration.
• Worked as a data migration DBA consolidating customers from multiple billing systems to single billing system in Telecom sector.
• Worked as a Development DBA on RAC and Non-RAC Databases, Data Guard and DR plans on all UNIX platforms.
• Performed Server consolidations for optimization of resources.

TECHNICAL SKILLS

Operating Systems: Linux AS3/4/5/6 Solaris 9 and 10, AIX 4.x and AIX 5L(HACMP and Non-HACMP), HP Unix 10.x & 11, SCO Open server, Windows 2000/NT/XP, ACOS-6 on NEC S-1000.

Languages: SQL, PL/SQL, Shell Programming, CBL74, Programming in FoxBASE.

RDBMS: Oracle 11gR2, Oracle 10G RAC on Linux, AIX 5.x and Non- RAC on Solaris 10, on AIX 5.x with HACMP& non HACMP Oracle 9i Rel.2 in AIX/ Solaris/ Windows Env. Oracle 8i / 8.x / 7.x/ 6, MSSQL Server 7 DTS (Data Transformation Services), Net8, SQL*NET V1/V2, SQL Report Writer 1.1.

Web servers & GUI: Weblogic, Websphere, Oracle 9IAS, Apache 1.3.x, and IHSServers, Windows XP/NT/2000/2008, Exceed 7.0.

Tools: EMGRID 11gR2, expdp, impdp, AWR, ASH, ADDM STATSPACK, Golden Gate ESP (Job schedulers), Foglight, Spotlight, Toad, SQLNavigator, RMAN, OMWB, Rational Rose, DBA Artisan, ERWIN, BMC Patrol for DB Monitoring. OAS, OEM, Net8. ODBC drivers, Oracle EBU 2.x, RMAN for backups, Omniback 3.0, SQL Forms 3.0, SQLReport Writer 1.1, Forms 4.5, Reports 2.5.

Hardware: Exadata Servers V2 (Quarter / Half/ Full RACKS), Sun Fire Enterprise Servers 25K & 15K, IBM server P-Series 690, 670, 660 Regatta Servers, EMC Disk Arrays and LPARS (Logical Partitioning Servers), SUN SPARC Servers Sunfire E6800, E5500, E4500, E3500, E3000, Pentium/Pentium Pro Servers, PC AT 486/386, NEC S-1000/20

E-Commerce Suites: Intershop Enfinity 2.xTelecom Software’s SB - Service Broker, SI Service Integrator, SC Service Controller, CM - Content Manager for Telecom Applications

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Oracle DBA

Responsibilities:

• Monitor ticket queues (HP service Manager) for Oracle Provisioning (11g and 12c access control) to various Agile teams in various environments.
• Data and schema refreshes from Production to QA, DEV environments of the Datawarehouse.
• Installation of Oracle 12.x binaries in different database environments. DEV/QA/Pre-Prod..
• Upgrade databases from Oracle 12c release 12.1.x to Oracle 12.2.x and migrate databases from 11.2.x to 12.x.
• Apply PSU patches to databases.
• Prepared production ready scripts and test those scripts in DEV and QA environment for normal and emergency change requests of Production.
• Provided DB support for access provisioning and troubleshooting of connectivity issues of all the Agile teams for databases existing in 11.2.0.4 and Oracle 12.2.x.
• Prepared and tested all partition maintenance scripts in Pre-Prod environments - for all Change Orders in Production.
• Provided database support for off-shore teams of Confidential .
• Generated Nezumi reports for data security and fixed violations as per the recommendations of enterprise standards.
• Worked with development teams to review code performance and make recommendations before the code is moved to QA for various application migrations from 11.2.x to 12.x
• Space management in the data warehouse. (Compress data and drop partitions) and overall maintenance of the databases of Confidential .
• Participated in Daily conference calls for support and for PCAB calls (Production Change Advisory calls).

Confidential, Carmel, IN

Oracle DBA

Responsibilities:

• Provided production support for day to day operations using HP Service Now ticketing system and clarity.
• Provided DBA support for deployments of Application releases (Minor, Major, Version release Builds) related to Dev/ Test / UAT and Production environments in Auto Finance, Business Intelligence, E-Business and portal databases of Confidential Auction Services.
• Migrated databases from One Unix Frame on to new Unix frames. (AIX LPARS).
• Upgraded databases from 11.2.0.x to 11.2.0.4.
• Identified and tuned badly performing SQL queries in BI.
• Provided database support for overall maintenance.

Confidential, NY

Oracle DBA

Responsibilities:

• Coordinated with offshore support team of Datavail for day to day tickets in “Service now” at enterprise level.
• Upgraded databases from 11.2.0.x to 11.2.0.4 and 11.x to 12.x. (Short Term Migration project).
• Assisted other groups providing database support for data center migrations. (Short Term Migration Project).
• Installed and configured OEM 12c Agents on servers for monitoring on AIX.
• Installed oracle 12c.(12.1.0.1) and 11.2.0.4, applied CPU patches and created databases.
• Provisioning of DEV/TEST/UAT and Production environments for various internal groups of Guardian and build all the environments as per the SLA’s for different projects.
• Implemented MBS (Minimum baseline security) while provisioning users in all environments. (Likely to move to tripwire).
• Configured RMAN backups for DEV/TST/UAT and Production databases. (TDP /TSM - Tivoli)
• Worked closely with developers for logical and physical design of databases.
• Tuned SQL code of developers for better response time by identifying the SQL's with unstable plans.
• Tested SQL baselines in Dev and test environments.
• Provided database support for change control. (Application code pushes for minor and major releases.)

Confidential, Brooklyn, NY

Sr.Oracle DBA

Responsibilities:

• Maintained existing 6 node SFRAC 11gR2 environment on Solaris with VCS (Veritas) cluster.
• Tuned RAC cluster private interconnect and network settings and protocol issues.(Jumbo Frames). Made recommendations for improvements, tested and implemented changes in production. Data archiving for very large tables.
• Identified and tuned Top 10 SQL’s.(EMGRID, SQL performance Analyzer and Custom scripts). Compared execution plans of queries and recommended changes for faster response times.
• Identified SQL’s which do not have plan stability and tune them.
• Identified and resolved Top 5 wait events of AWR, ADDM (Top Activity) reports and comparison of these reports for performance and troubleshooting of database issues.
• Provided database support for instance bounces. (DB parameter changes, Application code pushes for minor and major releases.)
• Upgraded databases from 10.2.x to 11gR2 for non RAC environments.
• Table partitioning and maintenance. (Conversion from Global indexes to local indexes, rebuild indexes for DML intensive objects.
• Maintained Dataguard setup in 11gR2 for POS (Paperless office System) application.
• Migration of databases from Solaris to AIX.(Non - RAC) for resource optimization.
• Recovery of databases in standalone environments (10.2.0.3)
• Worked closely with developers and setup reporting database for query offloading.
• Coordinated with Oracle support for Service requests.
• Analyzed and applied Oracle database patches 11gR2 and one off patches.
• RMAN backups and archivelog maintenance.

Confidential

Sr.Oracle DBA

Responsibilities:

• Configured Enterprise Manager for Database monitoring.
• Configured ASM DISK groups for databases and rebalancing operations.
• Installed Oracle binaries for Grid Home 11gR2.
• Performed Database migrations from 11gR1 to 11gR2 and from 10.x to 11gR2.
• Configured SCAN listeners.
• Configured backups and testing of restoration using RMAN.