Senior Database Administrator/Developer/EDI Specialist Resume Phoenix, AZ - Hire IT People

AREAS OF EXPERTISE:

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Senior Database Administrator/Developer/EDI Specialist

Confidential, Phoenix, AZ

Used SSIS to move data between environments and to process incoming healthcare claims
Wrote reports in SSRS to present data to executives and clients
Created a disaster recovery plan for the business with a warm standby for quick failovers
Learned how to work with EDI healthcare data to bring in data from new clients and improve existing ones

Tutor

Confidential, Scottsdale, AZ

Database Administrator

Confidential, Scottsdale, AZ

Worked as part of a team of three in database administration for the enterprise
Managed over 200 instances with 10TB of databases
Helped to iron out performance issues in a variety of applications
Instructed colleagues on how to correct issues with application code
Deployed scripts as part of the continuing expansion of the enterprise’s software
Migrated several systems from SQL Server 2008/2008 R2 to SQL Server 2014
Created a process to identify and list undocumented SQL Server installations
Maintained and expanded our disaster recovery system
Built the first AlwaysOn Availability Group setup for the enterprise

Database Developer

Confidential, Scottsdale, AZ

Database Administrator/Developer

Confidential, Scottsdale, AZ

Created and managed several ETL processes via SSIS to aggregate data from several different servers and database systems, including MySQL and Oracle, to our central SQL Server instance
Wrote reports in SSRS, and adjusted existing reports in Crystal Reports, for internal analysis and client billing
Wrote PowerShell scripts to send data to client FTP sites
Oversaw the upgrade of our server hardware, improving system resilience and increasing read/write speed by 50%
Created and managed the disaster recovery plan for the business

Data Architect

Confidential

Created and updated many stored procedures for use with the enterprise’s front-end software
Designed new databases and added new tables to accommodate data storage requests from the enterprise
Worked on performance tuning by adding indexes and rewriting existing stored procedures to improve execution speed
Identified issues with existing ETL systems, and worked with the managers of those systems to correct issues facing our third-party applications that worked with the output of the ETL

Database Administrator/Database Programmer

Confidential, Chattanooga, TN

Optimized existing third-party vendor code
Created and manged the disaster recovery plan for the business
Wrote reports in SSRS for internal analysis, including time clock monitoring and profitability of current clients
Wrote several web pages in PHP for internal use, including a site for the transcription department to mass-input respondent verbal surveys as opposed to doing them one by one

Database Administrator/IT Lead

Confidential, Cleveland, TN

Assisted with the migration of the enterprise’s core system from Microsoft Access to Microsoft SQL Server
Implemented stored procedures to manage the presentation of data and internal operations
Created and managed the disaster recovery plan for the business
Created several workflows to make internal operations more efficient by tying together scattered pieces of operational data