We provide IT Staff Augmentation Services!

Oracle Dba Resume

SUMMARY:

  • A vast amount of experience as a Data professional working for government agencies (US, State, and local), banks, fortune 50 companies, health care, Telecom, and small start - ups
  • A professional who demonstrates a commitment to ensuring client success and satisfaction
  • Clear concise planning and excellent analytical abilities
  • Managed Dev, test, & Production VLDB, OLTP, & Real Time databases
  • Installed, and managed Oracle high availability Data Guard (10G & 11G)
  • Proactive Oracle infrastructure and capacity planning
  • Performed upgrades & patching, SQL and index tuning
  • Data modeler modeling and designing VLDB, OLTP, & Real Time databases

TECHNICAL SKILLS:

Methodologies: SCRUM, AGILE, Water Fall, IDEF, Martin Crows foot

Oracle Tools: RMAN, Data Guard, Golden gate, Partitioned tables, Materialized views, Data Pump

Applications: Toad for DBA's, TOAD Data Modeler, Erwin, Database Examiner, Visio, Unica, File Maker

Languages: SQL, PL/SQL, Linux Shell, Windows batch file scripting

Databases: Oracle versions 5.2, 7, 8i, 9i, 10G, 11G, 12C & SQL Server 2008, virtual Oracle databases

Operating Systems: LINUX (Red Hat, Oracle linux, Centos), SOLARIS, Windows, Virtual servers, VmWare

Capabilities: Database Administration (Dev, Test, Production), physical database design, Database Quality Assurance, best practices, Health checks, PCI and PII database security.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential

Technical Environment: Oracle 11G, RMAN, PL/SQL, Windows batch file scripting

Responsibilities:

  • Audited production and test databases for backup/recovery and database performance on Microsoft Windows Server 2008 R2. Performed database RMAN and Data Pump backups and resolved production issues. Wrote and tuned PL/SQL procedures. Wrote batch files to monitor database availability, perform RMAN and Data Pump backups, Version and delete Database backup files.
  • Performed database quality evaluations for:
  • Adherence to Data Quality standards
  • Identification of data relationships and potential data integrity issues
  • Interface with other enterprise databases
  • Conform to Corporate Data retention polices Legal, Business, and Analytics

Database Quality Metric measurement - Washington Health Plan Finder

Confidential

Technical Environment: Oracle 11G & 12C, Erwin, SQL Optimizer, Database Examiner, PL/SQL, Toad, Power Point, Ms Excel .

Responsibilities:

  • Work with management to identify business needs and IT staff to solve problems and support their needs.
  • Worked with IT staff and management to improve their SDLC Technology - Architecture.
  • Identified measurable Database Quality metrics.
  • Created a project plan that included scope and deliverables.
  • Presented findings and recommendations to senior management.
  • Worked with team members to document lineage from database tables through SQL, to java application front end.
  • Tuned problematic SQL.
  • Provided Data migration and archiving strategy recommendations.
  • Recommended database design changes with a focus Database Design Quality (DDQ) metrics affecting:

Marketing Data Modeler

Confidential

Technical Environment: Oracle 11G&s12G, Toad Modeler, Visio professional .

Responsibilities:

  • Logical and Physical Data modeler and database designer of the Marketing Operational data Store (MODS) database. Created logical ERD s, record layout proof of concepts, and MODS data dictionary including Source to Target mapping. Worked with stake holders to define the way Confidential uses marketing terms across marketing teams and Marketing channels.
  • Unica and File Maker analyst. Developed File maker programs and databases. Developed strategic plan for marketing Customer Life Cycle and touch point management. Created Unica flow charts for email trigger campaigns.
  • Used CASE tool Toad Modeler and Database Examiner for reverse engineering, comparing database physical models against the actual database design, and for reviewing application and database functionality with end users.
  • Data Steward & Data Quality Assurance. Performed Data Governance work (Data Quality, Data Retention, and Data definition & value Governance). Responsible for data retention (legal, analytical, operational life cycle management). Documented and organized data quality assurance (best practices, Health checks, Data Quality rules) for business, analytical, legal.

Production DBA\Data Governance\Database Design

Confidential

Technical Environment: Oracle 11G&s12G, Data Guard, RMAN, PL/SQL, Solaris & Windows .

Responsibilities:

  • Logical and Physical Data modeler and database designer. Reverse engineered several Databases using Toed Modeler. Worked with stake holders and development staff to create a data dictionary and ERD of several databases to assist with modifying existing application functionality.
  • Production/Development DBA. Managed high availability Data Guard databases, Wrote PL/SQL and used Oracle Wallet to maintain security over PCI data, created views to satisfy reporting requirements, Managed RMAN and Data Pump backup, built new databases and recovered crashed databases, used GRID, Spotlight, TOAD, PL/SQL, SQL Work Bench, and SQL Plus for every day monitoring, issue resolution, and maintenance.
  • Data Governance/Database design. Identified data lineage from application front end code via middle tier pl/sql code to database back end schemas and objects. Reverse engineered databases and created ERD s that identify relationships, and subject areas each table/column affects. Created a data dictionary organized by subject area domains with lineage and physical design characteristics.

Production DBA

Confidential

Technical Environment: Oracle 11G, RMAN, PL/SQL, Windows batch file scripting .

Responsibilities:

  • Audited production and test databases for backup/recovery and database performance on Microsoft Windows Server 2008 R2.
  • Performed database RMAN and Data Pump backups and resolved production issues.
  • Wrote and tuned PL/SQL procedures.
  • Wrote batch files to monitor database availability, perform RMAN and Data Pump backups, Version and delete Database backup files.

Production DBA

Confidential

Technical Environment: Oracle 10G/11G, Data Guard, TAF & FSF, Toad for DBA's, Linux Shell scripting .

Responsibilities:

  • Installed, configured, patched, and upgraded database versions 10.2 and 11.2. on 10 databases.
  • Installed Data Guard and TAF (Transparent Application Fail over) and FSF (Fast Start Fail over) on two databases.
  • Performed RMAN backups, recoveries, and cloning on five database, upgraded the database time zone version on 10 databases.

Database Developer

Confidential

Technical Environment: PL/SQL, Oracle 11G, Toad for DBA's, SQL Developer, Linux Shell scripting .

Responsibilities:

  • Supported Confidential 's largest customer Confidential & Confidential with PL/SQL development.

Production DBA

Confidential

Technical Environment: MS Office Suite, Oracle v.11.2, PL/SQL, Unix shell scripts, CASE tool Toad ModelerOracle 11G, Oracle RAC & Golden Gate, Toad for DBA's on LINUX and HPUX .

Responsibilities:

  • We moved 42 databases from all over the United States to three service centers in Seattle, Phoenix, and St. Louis in RAC/Linux and Service Guard/HPUX environments.
  • Worked with Golden Gate and Data Guard to build mission critical 24/7 databases and dramatically reduce down time while maintaining current data replication from the legacy database to the new target database.
  • Authored a Migration Factory Staffing Plan for the project MGR.
  • Project saved Boeing 4 $million during the first 9 months with less than 150 databases moved.

Database Designer/Administrator

Confidential

Technical Environment: Oracle 11G, PL/SQL, shell scripts, Toad Modeler, Database Examiner, Toad for DBA's

Responsibilities:

  • Lead Oracle Development DBA and database designer of the first application of its kind to allow Toyota and Lexus automobiles to communicate with the WWW via a smart phone. Entune is a Real Time processing application that enables occupants of the car to do things like make restaurant reservation, reserve parking spots Confidential a garage before arrival. Get real time stock quotes etc.
  • Data Governance/Database design.
  • Designed four databases to support Real Time interaction between the Car, historic tracking of user activity, applications content management, and an analytical database for providing Business Intelligence.
  • Used CASE tool Toad Modeler and Database Examiner for reverse engineering, comparing database physical models against the actual database design, and for reviewing application and database functionality with end users.
  • Worked with end users and corporate executives to identify business processes and application requirements that could be part of a logical ERD and physical ERD.
  • Production/Development DBA.
  • Wrote Shell scripts and SQL scripts for building the entire database including table spaces, schemas, tables, grants etc.
  • Wrote Unix shell scripts for proactive DB Health monitoring, import/export (Data pump).
  • Authored/co - authored Production and Development standard operational procedures to ensure the confidentiality, integrity, and availability of the corporate data asset.
  • Conducted database DDL and DCL code reviews. Assisted management with development of SDLC procedures and entrance and exit criteria.

Data Steward & Data Quality Assurance

Confidential

Technical Environment: SQL server, Oracle, Teradata, PL/SQL, Ab-Initio, Linux, MS Excel, Visio .

Responsibilities:

  • Performed Data Governance work (Data Quality, Data Retention, and Data definition & value Governance).
  • Worked with production DBA's to establish data quality assurance processes and data quality dash boards related to ETL between production database and analytical databases.
  • Performed Source - to-Target data mapping from production ->legacy analytical->additional analytical->data marts/reporting.
  • Responsible for data retention (legal, analytical, operational life cycle management).
  • Obtained, organized, and defined subject area Meta Data in applicable repositories (Ab-Initio, SQL Server, and Oracle).
  • Documented and organized data quality assurance (best practices, Health checks, Data Quality rules) for business, analytical, legal.
  • Performed JAD session information identification & subject area segmentation to obtain high quality data for financial analytics, SOX, PII governance, and production/operations forecasting and management.

Hire Now