We provide IT Staff Augmentation Services!

Database Administration Resume Profile

2.00/5 (Submit Your Rating)

NY

SUMMARY

  • Enthusiastic and highly driven Professional Data Engineer with an excellent reputation for getting data to the business users who need it. I have a well-rounded understanding of data engineering roles, such as Data Architecture, Data Modeling and Database Administration. I am adept at learning and applying new skills and technologies.
  • I am a team player who is attentive to detail, and able to work in a fast paced environment. My Masters in Business Administration allows me to better understand the business side of IT.

Data Modeling 3NF, Dimensional

Data Development

Data Security Management

Meta-data Management

Data analytics

Team Leader

Database Administration

Data Governance

Data Operations Management

Reference and Master Data Management

Agile and Waterfall Methodology

.

Technical Skills

  • Database Oracle 8/8i/9i/10g/11g/12c, HP Vertica, DB2/OS390/IMS , PL/SQL,
  • ETL DataStage, Talend , Dashboard Tibco Spotfire, Tableau , CA-Erwin 9.5, SOA,
  • Tibco BE, WSDL, SoupUI, UNIX Scripting, XML, Quest Shareplex, Toad, Liquibase

PROFESSIONAL EXPERIENCE

Confidential

Support for HP customers included: Shell, AGCO, AT T, Continental Airlines, General Motors, DOD Navy/Marine, United Water, Delphi Automotive in various data roles.

Data Architecture

  • Was an integral part of the creation of an application data strategy including: Governance, Development, Operations, Security, Meta-Data and MDM/Reference.
  • Standards creation included: data naming, metadata, data backup and interface control.
  • Developed data mapping of interface files to current database data models.
  • Created stored procedures for extraction and loading into reference database.
  • Managed development environment for database change migration through the SDLC.
  • Evaluated and recommended database architecture software: replication and change management..
  • In a SOA environment, created/updated data service metadata for input into Tibco Business Events WSDL creation and tested using SoupUI software.
  • Recommended and tracked database work for onshore/offshore Data Engineers.
  • Self-trained in HP Vertica, Tableau, Tibco Spotfire and Tableau to meet the needs of a Sales pursuit demonstrating the use of these products.

Data Modeling

  • Logical and Physical Data Modeling for Oracle and Vertica databases based on User requirements, wire frames, reports
  • Supported sales pursuit as a Lead Data Modeler.
  • Lead and mentored less experienced off shore modelers on use of Erwin and current processes, this resulted in a saving of revenue for customer.
  • Reversed engineered of databases into Erwin, to declare specific versions of the application. This provided the historical data for the application.
  • Created process to streamline the creation of data models using Erwin bulk editor and the requirement documentation spreadsheets . This allowed the customer to not require additional data modelers on the project.

Database Administration

  • Planned and migrated an Oracle11g RAC infrastructure to another site, resulting in HP not incurring a financial penalty for missed deadline.
  • Built and supported Oracle and HP Vertica databases structures. This included loading of data, performance structures, data backups, and security.
  • Created install documentation and software used to automatically install Oracle software/patches, database structures and other software packages.
  • Subject matter expert for Quest Shareplex data replication product.
  • Project Leader and Work Load Coordinator for a team of nine DBAs.
  • DBA supporting DB2 and IMS applications on the mainframe.
  • Based on requirements, I would develop database Oracle, HP Vertica structures tables, indexes, triggers, stored procedures and user access rights. These structures were then deployed into system following the SDLC.
  • I was responsible for production support and correcting performance issues.
  • Experienced with RMAN, replication, RAC, Data Guard, Goldengate and Oracle12c.

Confidential

DB2 Database Administrator/Senior Programmer/Analyst

  • Database support for mission critical DB2 databases on MVS based mainframes in high transaction volume banking applications.
  • Developed logical and physical data models using Bachman software.
  • Developed data access routines to access DB2.
  • Lead an application development team in regards to task assignment, program specification, code walkthrus, and assisted in validation of programs runs.

We'd love your feedback!