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.
