Sr. Oracle Dba Resume
Newark, DE
SUMMARY:
Dynamic and results - driven professional, with over 20 years of IT experience. Extensive project leading skills and technical experience building and operating various ecosystems running multi-terabyte databases. Led, managed and supported various projects such as designing, implementing, tuning, migrating and upgrading database environments including Oracle, Teradata and delivering solutions in the most effective way.
TECHNICAL SKILLS:
SOFTWARE: ORACLE RDBMS, Oracle ZDLRA, EM Cloud Control, GoldenGate, RAC, Active Data Guard, Partitioning, NetBackup, Informatica, AbInitio, Teradata, Vormetric Encryption, Bitbucket, JIRA, Sharepoint,Quest TOAD, VMware ESXi, EMC SRDF, Linux (RedHat, Oracle), UNIX (Solaris, AIX)
EXPERIENCE:
Confidential, Newark, DE
Sr. Oracle DBA
Responsibilities:
- Implemented best practices for the physical database design, integrity, operations, performance and security management by working directly with application developers, vendors, system administrators and auditors.
- Reviewed project requests describing database user needs to estimate time required to accomplish projects. Worked closely with Project Managers to coordinate database development and determine projects’ scope, resources, timing, limitations and the level of DBAs participation.
- Provided expertise and guidance in building data management systems including patching, data compression, partitioning, performance tuning, backup and recovery practices.
- Troubleshot various Oracle database related issues.
- Supported scheduled and emergency database maintenance events, participated in other infrastructure upgrades.
- Performed Oracle upgrades and installed latest available Oracle BP, PSU and one-off patches to improve stability and performance.
- Performed database rehost migrations from AIX to RHEL on VMware ESXi to Oracle 12.1.0.2.
- Configured Oracle Active Data Guard and/or Oracle GoldenGate to increase application's disaster tolerance and to facilitate reporting and offload processing from primary Oracle databases.
- Created and maintained comprehensive Logical/Physical Account Drop process for Info Security including support for multitenant Oracle architecture.
- Installed and support Oracle Application Express (APEX) for Recovery Analytical Reporting System.
Confidential, Wilmington, DE
Sr. DBA
Responsibilities:
- Managed all aspects of 24/7/365 database operations covering high volume OLTP and multi-terabyte financial, analytical, data warehouse and reporting databases running on physical and virtual servers.
- Tuned multiple SQL statements and business reports to meet customer’s performance SLA.
- Designed and implemented database failover strategies using Oracle Active Data Guard or EMC SRDF.
- Migrated 70tb Oracle database to Teradata. Provided full Teradata application design and support, monitored Teradata stability and performance, interacted with business/application teams and Teradata Support for all Teradata related issues.
- Re-engineered database security and established audit procedures, successfully completed number of projects that enabled company to pass Sarbanes-Oxley requirements and company-wide audit processes.
- Configured databases for encryption in-transit and data-at-rest using Oracle configuration and Vormetric.
Confidential, Wilmington, DE
DBA, Datawarehouse Database Administration
Responsibilities:
- Identified performance bottlenecks (OS, network, and databases). Tuned SQL statements, PL/SQL procedures, packages, batch processes supporting data warehouse applications.
- Recognized and identified potential areas where existing policies and procedures required changes or where new policies and procedures needed to be developed for Payment Card Industry (PCI) compliance.
- Rolled out new stand-alone and Oracle RAC servers running Oracle 11g databases for new datacenters.
- Participated in storage migration from EMC Clarion to EMC VMAX for all servers running Oracle. Utilized EMC Storages and Oracle ASM for all Oracle databases.
- Upgraded all Oracle databases from Oracle 9i, 10g to Oracle 11gR1 and Oracle 11gR2 (11.2.0.4).
- Performed regular administration tasks such as database backup and restore using RMAN, space and performance monitoring.
Confidential, Wilmington, DE
Sr. Application Support Analyst
Responsibilities:
- Provided 24x7 application support for Confidential Data Warehouse applications using Ab Initio, Unix shell scripting and Tivoli scheduling.
- Worked directly with Oracle Support consultants to achieve Datawarehouse stability and best performance.
- Developed functional and tech specs, flow charts, implementation plans and runbooks following Confidential software development lifecycle methodology.
- Participated in design, development and implementation of multiple internal projects.
- Worked with data warehouse Development team to redesign data flow to improve processing performance.
Confidential, Blue Bell, PA
Senior Database/ETL Consultant
Responsibilities:
- Participated in the design, development and support of FUSA Rehost to Confidential STARBASE system utilizing Ab Initio, Oracle SQL, Unix Shell scripting and Autosys. The STARBASE system provides a common Consumer Finance Suite and online user experience for all of Confidential customers.
- Provided daily support for Confidential STARBASE special requests files using Ab Initio, Unix shell scripting and Tivoli scheduling.
- Created ad hoc reports for STARBASE utilizing Oracle SQL and Ab Initio.
- Performed quality data analysis for DN2 Privacy system utilizing Ab Initio, PL/SQL and Unix Shell scripting.
- Participated in design and development of Customer Information Interchange system (CII) utilizing Ab Initio, Oracle SQL, Unix Shell scripting and Tivoli.
Confidential, Horsham, PA
Senior Consultant
Responsibilities:
- Provided 24x7 support for Advantage Point (ADVP) database which provides data for the Net Economic Value (NEV) and other essential Confidential systems utilizing Unix Shell Scripting and PL/SQL procedures.
- Created extracts of data from ADVP using Unix Shell Scripting, PL/SQL procedures and FTP.
- Participated in migration NEV Oracle database from NT platform to Unix.
- Maintained NEV Oracle8i database structure across development, model and production environment.
- Designed and implemented Product Hierarchy using PL/SQL procedures.
- Modified existing PL/SQL procedures to improve performance and reliability.
Confidential, Blue Bell, PA
Consultant
Responsibilities:
- Developed and supported data transformation processes using Informatica and PL/SQL procedures.
- Designed and maintained Oracle8i database structure utilizing Designer 2000.
- Created Account Information Business Objects universe based on data from Siebel Sales Enterprise. This universe allowed creating different business reports, which are not provided by Siebel.
- Analyzed fifteen different software applications that included different brokerage and financial applications.
- Each application had to be evaluated based on the following criteria: criticality, ease of maintenance, work effort, capability Maturity Model (CMM) and level of risk.
- After evaluating each application, developed questions based on the findings from the evaluations in order to better assess each application. To answer the questions, met with application managers for each application.
- After the interview, all assessment documents were completed and delivered to another Confidential team who developed the final application outsourcing proposal.
- Participated in migration Oracle database from v.6.1 to v.7.3
- Created new and enhanced an existing Cardiology System forms and reports using Oracle Developer 2000.
- Created indexes and tuned the SQL statements for optimum performance
- Provided full development and 24x7 support of a data collection process for the Arthur Allocation System.
- Extracted data from mainframe DB2 tables using Platinum Utilities.
- Transferred data from MVS to UNIX utilizing FTP and MQ-Series.
- Developed PL/SQL packages and Shell scripts to reformat the mainframe data and populate Oracle8 database using SQL*Loader.