SUMMARY

• An Oracle all - round Developer, DBA, Analyst, Capacity Planner, Application Architect and Data Modeler having over 16 years of 24x7 production experience working for key vital industries such as Financial & Banking, Manufacturing, Oil & Energy, Healthcare and Airlines. Thorough into all core DBA competencies such as RAC, Data Guard, ASM, Backup & Recovery and end-to-end Performance Tuning using OEM.
• Expert in performing SQL Tuning and Plan Stability tasks using SQL Plan Baselines and embedding SQL HINTS. A champion of Automation and have architect and wrote many applications using Oracle Forms, Reports and Oracle Apex 3.0 and PL/SQL. Ardently experienced in architecting vendor-based as well as customized Oracle-based applications.
• Have administrated Oracle databases on all flavors of Unix and Linux such as REDHAT, AIX, HP-UX, Solaris, Oracle Linux, VmWare and Windows Servers. Experienced in architecting, building and maintaining large mammoth Data Warehouse and Data Marts for a global Financial institution.
• Very shrewd in exploiting Oracle Partitioning and related maintenance to gain application efficiency and performance. Played key roles of Infrastructure DBA, Production DBA, Development DBA, Oracle Developer and Reporting Specialist.
• As a financial reporting expert satisfy management WHAT-IF queries by pulling the data from SQL*Server, Oracle Applications, and ACCESS. Savvy cross-platform, zero-down-time Database migration and upgradation specialist; an experienced Technical Writer. Sizable Oracle 12c experience and currently working on OCP upgrade to 12c.
• Well versed in architecting Database and Application Security from ground-up. Tuning skills and related knowledge extends to Oracle Exadata. Rigorous Systems Analysis, Business Analysis, and Shell Scripting skills. Accomplished and Savvy technical writer.

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

Oracle DBA/Developer

Responsibilities:

• Working on a short-term assignment in end-to-end performance tuning of one of FIA’s key Oracle System.

Confidential, Herndon, VA

Oracle Developer/ DBA

Responsibilities:

• Served external clients such as SHELL, Houston Methodist as 10 pearls consultant (tasks accomplished at those companies are given below)
• As Confidential in-house Oracle Senior Oracle Developer and DBA, supported a team of offshore developers on a remote basis.
• Taking production calls on rotation for clients inshore and offshore mostly related to performance.
• When tuning, provide developer team multiple options to choose from many solutions offered to solve problems .
• Mostly the tuning is happening on Oracle 12c.
• Advised on PL/SQL coding strategies and troubleshooting to less experienced Oracle Developers

Environment: 12c R1, 11g, Linux, SQL Developer, PL/SQL, Shell Scripting

Confidential, Houston, TX

Oracle DBA Consultant/ Performance expert DBA

Responsibilities:

• Played a lead role in migrating PeopleSoft ERP system from version 9.1 to 9.2; database from 11gR2 to 12c.
• Worked with developers in migration issues related to performance and plan stability.
• Research, identified and corrected the configuration issues that comes with vanilla 12c database install.
• Recognized objects storage organization that can benefit from Oracle Partitioning and performed the storage conversion to get speedy performance that exceeded the SLA.
• Ironed out query performance issues using SQL Profiles, SQL Plan Baselines and Hints.
• Upgrade PROD and UAT databases from 11gR3 to 12c with multi-tenancy features
• Analyzed existing Oracle databases and consolidated to 12c to improve cost and efficiency.
• Wrote technical reports on findings and also written turn-key-operate manuals on Production systems.

Environment: 12c, Oracle Linux, Toad, Shell Scripting, DBUA

Confidential, Houston, TX

Oracle DBA Consultant

Responsibilities:

• Let the performance tuning and enhancement efforts for OpenLink ENDUR Energy Trading and Risk Management Application, ensuring user meet the SLA round-the-clock for large Oil and Gas client.
• Performed root cause analysis for slow performance on clients and servers and suggested measures to stabilize the Oracle infrastructure.
• Conducted stress performance testing for customized application modules, suggested, and implemented measures.

Environment: 11g R2, Toad, Red Hat Linux, Shell Scripting, PL/SQL

Confidential, Houston, TX

Senior Oracle DBA/e-2-e Performance Expert

Responsibilities:

• As L3 SME Level-3 Subject Matter Expert provided 24x7 production, infrastructure and operational DBA support to Bank’s Credit Risk Division.
• Installed and configured/build multi-nodes Oracle 10g/11g R2 RAC using with Data Guard
• Utilized OEM to monitored 1000+ Prod Servers each with RAC and Data Guard and fixed the issues in addition to perform RCA Root Cause Analysis
• In support of Bank’s BI and DW initiative wrote 5 to 6 executive queries dashboards applications using Oracle Apex to quickly identify the performance and health of the framework.
• Completed rigorous performance tuning of 100+ TB mammoth Data Warehouse; implemented SQL Profiles, SPM (Baselines) and SQL HINTS to stabilize the execution plans where and when as needed.
• Perform database migrations and refreshed between development, QA and PROD environments.
• Designated Performance lead on Tuning, management and support
• Coordinated system build, install and support tasks with off-shore DBAs that were running follow-the-sun model in JP’s IT hubs in London, Glasgow, Singapore and Bangalore.
• Wrote many departmental application using Oracle Apex (3.0) and wrote documentations on the Apps.

Environment: 11g R2, 11g R1, 10g, 9i, Linux, Solaris, TOAD, PL/SQL, Shell Scripting, Toad, SQL Developer, Oracle Apex.

Continental, Houston, TX

Senior DBA

Responsibilities:

• Provided production Oracle DBA services to the companies such as Emphasized on end-to-end performance tuning including SQL Tuning and plan stability
• Developed Shell scripts to support manageability of databases. This includes RMAN backups, tasks automation, standardization and database infrastructure support.
• Assisted in large databases refreshes using EMC’s Time-Finder snap mirror technology.
• Carried out Oracle partitioning tasks converting mammoth non-partitioned tables to partitioned tables ensuring performance improvements.
• Installed, configured and administered a SQL 2005 database on a 2-node MS Windows Cluster (MSCS) providing high availability solution.
• Successfully led data conversion & migration effort of a production geographically dispersed multi-site Oracle-based financial application.

Environment: Oracle 10g, 9i, HP-UX, Enterprise Manager, SQL Server 2005

Confidential, Monterey Park, CA

Senior DBA

Responsibilities:

• Reporting to Manager Database Operations, worked as an anchor Team Lead Oracle data warehouse Analyst/DBA covering business as well as technical side for Japanese Bank in the West Coast.
• Managed Oracle databases on multiple flavors UNIX and windows.
• Designated Technical Lead on installing major upgrades ad patching on database supporting 10,000+ users on HR Benefits application.
• Provided DBA support on Bank’s ICRS (Integrated Credit Risk-Monitoring System) Data Mart
• Performed day-to-day DBA activities, performance tuning, database security and backups on ODS, data mart and EDW (Enterprise Data Warehouse) databases. UsedErwinto forward/reverse engineer data models.

Environment: Oracle 9i, Solaris, AIX, Linux, Erwin

Confidential, Richmond, VA

Lead Oracle Consultant, Database Administration

Responsibilities:

• Led a mid-size team of Unix Administrators, DBAs and Jr. DBA in the implementation groundwork for Systems Excellence’s Pro-IBM POS (Point-of-sale) Pharmacy Benefits Claim Adjudication System. This was a third party vendor product solution.
• Played a lead role in architecting customized Oracle-based application in HealthCare industry.
• Performed project deliverables such as build, tuned and backup and recovery tasks.
• Mentored and trained mid-level and Jr. DBAs on critical database administration items.
• Installed, configured and maintained highly available Oracle Parallel Fail Safe Environment on 2-node MS Cluster running a shop-floor application. Was Responsible for backup and recovery, security, performance and day-to-day operations and maintenance.
• Tech-lead on data conversion, migration, transfer and integration of HR/Payroll/Employee Benefits modules of couple of Company’s ERP systems.
• Wrote an add-on Oracle-based App a claim processing module for Land America Financial Group. Utilized Oracle Forms, Oracle Reports and backend PL/SQL code.

Environment: Oracle 8i, 9i, AIX, Oracle Fail Safe, UNIX, Windows, PL/SQL, Oracle Forms, Oracle Reports.