We provide IT Staff Augmentation Services!

Senior Database Administrator/developer/edi Specialist Resume

Phoenix, AZ

AREAS OF EXPERTISE:

  • Performance Tuning
  • Disaster Recovery
  • Solution Planning

TECHNICAL SKILLS:

  • SQL Server Development
  • SQL Server Database Administration
  • Server Administration
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • PHP

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

  • Worked as a tutor during the gap created by the reorganization at Confidential
  • Instructed one student in the basics of working with Microsoft SQL Server

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

  • Created SSIS packages to bring in claims data from clients
  • Did quality - assurance testing for the data imported from client files
  • Wrote SSRS reports to present data to clients
  • Worked on performance tuning to speed up several slow-moving reports

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

Hire Now