Senior SQL Database Administrator

Location: North Carolina (Eastern Time)
Position Type: Remote
Contract Length: 6 months + likely extensions

Job Description

This role is for a Senior SQL Database Administrator responsible for designing, developing, and maintaining complex Microsoft SQL databases and data warehouses, while supporting performance, troubleshooting, and large-scale system upgrades. The position requires expertise in SQL, ETL processes, SDLC/ALM practices, and Agile methodologies, with strong collaboration skills to work across business and technical teams in a remote, full-time contract capacity.

What You’ll Do

• Maintain, improve, and create new complex Microsoft SQL database objects including but not limited to stored procedures and functions

• Troubleshoot and resolve database performance issues

• Design, document, create, unit and system test, deploy, and maintain databases including data warehouses

• Collaborate with the business and other teams to develop and implement business rules for the data warehouse

• Support the development team with database-related issues

• Develop reference and workflow documents for documentation purposes

• Identify and evaluate industry trends in database systems to advise the Data Manager, Director of Business Systems, and/or Chief Information Officer

• Review project requests describing database user needs to estimate time and cost required to accomplish tasks

• Discover and contribute to the development, implementation, and maintenance of Informatics functional architecture and systems design to deliver IT outcomes

• Other duties as assigned

What You'll Need

Required:

• Minimum 6 years of experience or equivalent higher education. Preferred experience in healthcare claims environment and reporting development, n-tier development and support, and Microsoft SQL database development including relational and star schema data warehouses

• Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, or equivalent

• 2-year degree required. Applicable certifications may substitute equivalent degree requirements

• Advanced knowledge of SQL and MS SQL Server operating systems

• Experience with Visual Studio for database projects (currently on 2019 Pro or Enterprise)

• Expertise in database development, maintenance, and execution of mission-critical large-scale system upgrades

• Advanced knowledge in ETL (Extract, Transform, Load) processes and data warehousing

• Understanding of Application Lifecycle Management (ALM) and Software Development Life Cycle (SDLC) principles

• Familiarity with Azure Dev Ops as a platform for demand repository, workflow management, and source control/code promotion

• Proficiency in Agile methodologies, including User Stories, Continuous Integration, Continuous Delivery, Continuous Deployment, and Automated testing

• Strong problem-solving skills

• Effective communication skills for interaction with various stakeholders

• Ability to work independently and unsupervised, setting and adjusting priorities as needed

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with ADA and other federal, state, and local standards

• Sedentary work involving sitting or remaining stationary most of the time with occasional movement around the office.

• Ability to conduct repetitive tasks on a computer using a mouse, keyboard, and monitor