Job Description

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

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

Job Tags

Similar Jobs