LingaTech

Senior SQL Database Administrator

LingaTech

full-time

Posted on:

Origin:  • 🇺🇸 United States • North Carolina

Visit company website
✨ AI Apply
Manual Apply

Job Level

Senior

Tech Stack

AzureETLMS SQL ServerSDLCSQL

About the role

  • 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
  • Support performance, troubleshooting, and large-scale system upgrades
  • Other duties as assigned

Requirements

  • Minimum 6 years of experience or equivalent higher education
  • 2-year degree required (Applicable certifications may substitute equivalent degree requirements)
  • Preferred experience in healthcare claims environment and reporting development
  • Preferred experience in n-tier development and support
  • Microsoft SQL database development including relational and star schema data warehouses
  • Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, or equivalent
  • 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