PROFILE:

A self - starter, result-oriented, well-experienced & certified hands-on Oracle Developer, DBA & and Performance guru having double Masters in Computer Science & related Database Technologies. Over 20 years of designing, administrating and streamlining databases in Financial & Banking, Manufacturing, Oil & Gas, Energy, Healthcare and Airlines industries; Administered and performance-tuned databases on virtually all flavors of Unix and Linux (REDHAT, AIX, HP-UX, Solaris, Oracle Linux) and Windows Servers. Savvy in crafting high performance contingency solution using latest Oracle technologies.

WORK EXPERIENCE:

Confidential, Herndon, VA

Oracle Project Manager/Technical Lead Developer, DBA

Responsibilities:

• 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.
• For research purpose, transferred critical data from PROD databases using Data
• Advised on PL/SQL coding strategies and troubleshooting to less experienced Oracle Developers

Environment: 12c R1, 11g, Linux, SQL Developer, PL/SQL, Unix Scripting, Data Pump

Confidential, Herndon, VA

Oracle Developer/DBA /Performance Expert

Responsibilities:

• Administered and honed Production database with applying latest in Performance Tuning and Oracle best practices.
• Automate Backup procedures to be done by non - Oracle-DBA staff.

Confidential, Washington, DC

Oracle Developer/DBA

Responsibilities:

• Worked on a short - term assignment in end-to-end performance tuning of one of Confidential s key Oracle System.
• Played a lead role in out-of-place migration of PeopleSoft ERP system to version 9.2; and database from 11gR2 to 12c. oracle 12c was installed as multi-tenancy option.
• Worked with System Administrators, ERP Module Managers and Developers in post-migration issues related to Finance and Payroll modules.
• Used Segment Advisor and recognized objects storage format that can benefit from Oracle Partitioning and performed the storage conversion to get speedy performance that well-exceeded the SLA.
• Wrote technical reports on findings and also written turn-key-operate manuals on Production systems related to 12c.

Environment: 12c, Oracle Linux, Toad, Unix Scripting

Confidential, Houston, TX

Oracle DBA & Developer Consultant

Responsibilities:

• Completed 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, Unix Scripting, PL/SQL, Data Pump Export and Import.

Confidential, Houston, TX

Oracle RAC DBA

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
• 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.
• Setup contingency planning using Physical Standby Database and maintained the Data Guard configuration using DG Broker. Failed-over as well as switched-over configuration as needed.
• Perform database migrations and refreshed between development, QA and PROD environments. Designated Performance lead on Tuning, management and support
• Performed Data Pump Export and Import, hence successfully duplicated databases, Tables and Partitions across QA, UAT and PROD environments.
• Assisted development teams in setting up Logical and Physical Data models for multiple applications.
• 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.
• Extensively supported Informatica ETL functions for a mission-critical Data Warehouse. Capable of carving out and driving ETL strategy using the induction of Golden Gate

Environment: 11g R2, 11g R1, 10g, 9i, Linux, Solaris, TOAD, PL/SQL, Unix Scripting, Toad, SQL Developer, Data Pump Export and Import.

Continental, Houston, TX

SQL Server DBA

Responsibilities:

• Installed, configured and managed 2 - node SQL Server cluster for Superior Energy Services PRODUCTION environment.
• Provided DBA services to the enterprise such as backup and recovery, ad hoc reporting using T-SQL and end-to-end performance tuning.
• Performed Backups and Restores and Database Refreshes

Confidential, Monterey Park, CA

Senior Oracle DBA/Developer/Performance Expert

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 & backups on ODS, data mart & EDW (Enterprise Data Warehouse) databases. Used Erwin to forward/reverse engineer data models.

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

Confidential, Richmond/Gordonsville, VA

Lead Oracle Consultant, Database Administration and Development

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; includes Ross, SAP etc.
• Wrote PL/SQL programs to perform ETL i.e. extract data from various other sources to SAP.
• 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.