Database Developer / Database Architect / Dba Resume
4.00/5 (Submit Your Rating)
Plano, TexaS
SUMMARY:
Technically skilled professional with exceptional talent in the areas of design and development on database projects.
AREAS OF EXPERTISE:
- Broad knowledge of installing, configuring and administering multiple versions of SQL Server.
- Expertise in designing and implementing a range of databases.
- Experienced team leader with success in overseeing database projects to ensure optimal outcomes for clients.
- Skilled developer that works to ensure code efficiency and enhance performance.
TECHNICAL PROFICIENCIES:
Platforms: Microsoft Windows, IBM AS/400, UNIX, Linux
Tools: Microsoft SQL Server 6.5/7/2000/2005/2008/20012 , Microsoft Visual Studio 2012 & 2012, Team Foundation Server, IBM DB2, Oracle
Hardware: Windows Server
PROFESSIONAL EXPERIENCE:
Confidential, Plano, Texas
Database Developer / Database Architect / DBA
Responsibilities:
- Lead architect on IEX 6.0 project to upgrade back - end database from SQL Server 2005 to 2012. Project involved redesigning several hundred database objects and the development of 50+ SSIS packages.
- Team lead and developer on multiple SSIS ETL processes.
- Supervised the migration of all SQL Server databases from Legacy Countrywide Servers to Confidential Servers.
- Assisted developers with the coding and testing of complex queries.
- Data architect for new databases including the JobMonitoring, Audit Review and Mergers and Acquistions databases.
Confidential, Irving, Texas
Consultant
Responsibilities:
- Tested multiple DTS packages for the population of the data warehouse in new application tables.
- Created stored procedures to generate emails and to export letter files.
- Developed and tested multiple ad-hoc query statements for verification of database population with history data.
- Designed, coded and tested various XML scripts to import and export data from external vendors.
Confidential, Irving, Texas
Managing Consultant
Responsibilities:
- Provided extensive troubleshooting of hard drive and tape drive issues during OEM development, integration, manufacturing, and repair depot.
- Conducted performance tuning on multiple stored procedures resulting from timeout and deadlock issues within the server. Redesigned stored procedures and multiple tables to be more efficient.
- Provided recommendations for implementing new security processes.
- Served as DBA Developer for the Store Profile and Reporting Tool Application ( Confidential ) used by 7-Eleven stores.
- Created an application to manage conference facilities at Confidential
- Redesigned and modified COBOL II inventory reports as part of Zales’ acquisition of People’s Jewelers in Canada.