Senior SQL Database Administrator

Job: Senior SQL Database Administrator Location (if onsite/hybrid): Remote, must work in EST Expected duration: 12/31/2025, long-term contract

Required skills, experience, etc.: 6+ years of MS SQL DBA experience, experience in healthcare claims environment; Microsoft certifications: MTA, MCSA, MCSE, ITIL or equivalent
Interview process: 2 rounds after screening, 1 CAI side, and 1 client side

Job Description
We are looking for a Senior SQL Database Administrator to join our team. This position will be a full-time contract and remote.

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