Database Administrator Sql Server

David J. Cooper

314-***-**** Land O’Lakes, FL ***************@*****.***

Seeking SQL Server Database Administrator Role - Available Immediately for either employment (desired) or a Consulting role, on premise, hybrid, or remote

Current Skills and Experience:

Cigna / Evernorth, Senior SQL Database Administrator, 03/2010 – 03/2024

More than 20+ years Senior SQL Server Database Administrator experience

30+ years Database experience in SQL, Oracle, Vax RDB, S1032, Access

Expert in SQL Server Database Optimization and Query Tuning for problematic Database applications

Extensive Healthcare applications experience at Cigna, Blue Cross of CA, Baxter Caremark, Wellpoint, and others, mostly in the Medical Claims Cost Containment area.

Both in-house and 3rd party applications were installed, maintained, and extended.

Data Architect role in many of the projects, usage of SSIS for ETL, and SSRS for reporting

Specialist in efficient Key and Join design, Query Plan analysis and Table design.

Extensive experience with Solarwinds Database Performance Analyzer (DPA)

Database Security Issues addressed at all levels, Auditing safeguards were developed, row and column security were implemented on sensitive data.

Database Compression and Transparent Data Encryption (TDE) was introduced to several organizations as well as SQL Backup and Restore, Replication Strategies, and Disaster Recovery

Training of other users, analysts, and programmers on Database script and programming techniques was performed.

Worked closely with the Analytics and Reporting teams to construct correct and efficient queries.

Created Application Pools along with Resource Governor to control and Optimize DB throughout.

Most recently have handled specialized SQL Databases for software robotics applications including Blue Prism, Pega, Automation Anywhere and UiPath on the cloud.

Accomplishments:

Installed, configured, and optimized Software Robotics database products Blue Prism and Automation Anywhere, costing many millions of dollars, to bring the Cigna organization into the Robotics applications sphere successfully.

Managed a large database project with a team of 3 DBAs in the Medical Cost Containment area to achieve a $40 million cost savings in complex medical claims over a two- year period

Successful ETL project to bring in data from external sources and EDI transfers to make data available for the Medical Claims Engines saved over $7 million in internal costs

Education: Stevens Institute of Technology, Castle Point Station, Hoboken, NJ – Bachelor of Science in Engineering, Certification in Project Management, MS Project Manager

Contact this candidate