SQL DBA

Adaptive Solutions Group; Saint Charles (MO); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

401k plan

Paid vacation and holidays

Job summary

Adaptive Solutions Group is seeking a Database Administrator to join our team, handling SQL Server across on-premises and Azure environments in the St. Louis and Kansas City area.

You will ensure database availability, performance, security, and data integrity for mission-critical systems, develop ETL pipelines, and support Power BI datasets while collaborating with analytics and data governance teams to enable enterprise reporting and BI initiatives.

Qualifications

• Bachelor's degree or equivalent combination of education, training, and relevant experience.
• 3-5 years of experience administering relational database systems in a production environment.
• Experience with Microsoft SQL Server in both on-premises and Azure environments.
• Experience with Azure SQL Database and/or Azure SQL Managed Instance, including configuration, administration, and performance tuning.
• Experience with Microsoft Azure data services such as Microsoft Fabric, Azure Synapse Analytics, Azure Data Lake Storage, or Azure Data Factory.
• Experience integrating and administering data across enterprise applications and third-party or cloud-hosted platforms.
• Strong knowledge of relational database design, normalization, indexing, and query optimization.
• Proficiency with T-SQL.
• Knowledge of database security, access controls, encryption, and auditing.
• Strong troubleshooting, analytical, and problem-solving skills.
• Ability to manage multiple priorities and projects while communicating effectively with technical and non-technical stakeholders.

Responsibilities

• Administer, configure, and maintain Microsoft SQL Server databases across on-premises and Azure cloud environments.
• Ensure database availability, performance, security, and data integrity for mission-critical enterprise systems.
• Support backup, recovery, high-availability, and disaster recovery strategies.
• Monitor and troubleshoot database and data management issues across applications.
• Manage data integration across Microsoft technologies and third-party platforms.
• Develop and maintain reports, stored procedures, views, and other database objects.
• Collaborate with reporting, analytics, and data governance teams to support BI initiatives.
• Support Power BI datasets, data models, and semantic layers.
• Coordinate database patches, upgrades, and maintenance with minimal disruption.
• Develop and maintain documentation for database architecture and procedures.

Skills

Troubleshooting

Analytical thinking

Project management

Stakeholder communication

Education

Bachelor's degree

Tools

PowerShell

Power BI

Job description

Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the St. Louis and Kansas City areas. Database Administrator to join our team.

Responsibilities

Administer, configure, and maintain Microsoft SQL Server databases across on-premises and Azure cloud environments, including Azure SQL Database and Azure SQL Managed Instance. Ensure database availability, performance, security, and data integrity for mission-critical enterprise systems. Support backup, recovery, high-availability, and disaster recovery strategies to protect organizational data and minimize system downtime. Monitor and troubleshoot database and data management issues across internally managed and vendor-hosted applications. Manage data integration across Microsoft technologies, including Microsoft Fabric, Azure Synapse Analytics, Azure Data Lake Storage, and Azure Data Factory, as well as third-party platforms. Develop and maintain reports, stored procedures, views, and other database objects supporting business operations and system integrations. Partner with reporting, analytics, and data governance teams to support enterprise reporting and business intelligence initiatives. Support Power BI datasets, data models, and semantic layers. Implement and maintain database security controls, including role-based access, encryption, and auditing. Coordinate database patches, upgrades, and maintenance activities while minimizing disruption to business operations. Develop and maintain documentation related to database architecture, standards, naming conventions, and operational procedures. Collaborate with application owners, developers, infrastructure teams, and vendors on database design, system implementations, integrations, and upgrades. Design and maintain ETL/ELT processes and data pipelines. Troubleshoot and resolve database performance, availability, and integration issues. Participate in an on-call rotation and provide occasional after-hours support for maintenance or production incidents. Perform other related duties as assigned.

Required Qualifications

Bachelor's degree or equivalent combination of education, training, and relevant experience.

3-5 years of experience administering relational database systems in a production environment.

Experience with Microsoft SQL Server in both on-premises and Azure environments.

Experience with Azure SQL Database and/or Azure SQL Managed Instance, including configuration, administration, and performance tuning.

Experience with Microsoft Azure data services such as Microsoft Fabric, Azure Synapse Analytics, Azure Data Lake Storage, or Azure Data Factory.

Experience integrating and administering data across enterprise applications and third-party or cloud-hosted platforms.

Strong knowledge of relational database design, normalization, indexing, and query optimization.

Proficiency with T-SQL.

Knowledge of database security, access controls, encryption, and auditing.

Strong troubleshooting, analytical, and problem-solving skills.

Ability to manage multiple priorities and projects while communicating effectively with technical and non-technical stakeholders.

Preferred Qualifications

Experience with PowerShell scripting and database administration automation.

Experience designing and maintaining ETL/ELT pipelines.

Experience supporting enterprise reporting and analytics environments, including Power BI.

Experience working with Microsoft Fabric, Azure Synapse Analytics, Azure Data Lake Storage, and Azure Data Factory.

Experience supporting databases and integrations across ERP, CRM, or other enterprise business applications.

Experience developing database architecture, standards, and operational documentation.

Experience working with application development, infrastructure, information security, and data governance teams.

Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.