Database Administrator (Remote or On-site)

Management Resources Group LLC (MRG)•Schertz, TX

10h•Hybrid

About The Position

The Database Administrator (DBA) will serve as the primary database administrator responsible for managing, securing, optimizing, and maintaining the organization’s SQL Server database systems across Azure cloud environments. This role manages a hybrid infrastructure that includes SQL Server on Azure Virtual Machines (IaaS) and Azure SQL Database (PaaS). The DBA will collaborate closely with the data analyst team to support reporting and analytics initiatives and will coordinate with development teams to deploy database changes and application updates into production environments. The ideal candidate is a detail-oriented, mid-level DBA with strong fundamentals in SQL Server administration, a working knowledge of Azure cloud services, and the ability to execute reliably in a production environment.

Requirements

Minimum of 4 years of hands-on experience administering Microsoft SQL Server databases in production environments.
Demonstrated experience managing SQL Server in Azure cloud environments, including both SQL Server on Azure VMs and Azure SQL Database.
Proficiency in SQL Server database administration fundamentals: backup and recovery, performance tuning, query optimization, indexing strategies, and security management.
Advanced SQL scripting skills, including stored procedure development, query optimization, and troubleshooting execution plans.
Experience with database deployment processes, including executing migration scripts and coordinating releases with development teams.
Working knowledge of IIS web server administration, including deploying application files and basic configuration.
Familiarity with Azure cloud services relevant to database administration, including Azure Monitor, Azure Backup, and Azure networking fundamentals.

Nice To Haves

Microsoft Certified: Azure Database Administrator Associate (DP-300) or equivalent certification.
Experience with Always On Availability Groups and Azure SQL failover groups.
Familiarity with PowerShell and Azure CLI for database automation and administrative scripting.
Experience with data governance practices and enterprise database architecture principles.
Exposure to CI/CD concepts and working alongside development teams using Azure DevOps or similar platforms.

Responsibilities

Configure, manage, optimize, and secure Microsoft SQL Server environments running on both Azure Virtual Machines and Azure SQL Database.
Perform routine database maintenance including backups, integrity checks (DBCC), index maintenance and rebuild strategies, statistics updates, and proactive performance monitoring.
Develop and maintain disaster recovery plans, including backup/restore procedures, geo-replication configurations, and failover testing for both IaaS and PaaS database instances.
Monitor database health and performance using Azure Monitor, SQL Insights, Dynamic Management Views (DMVs), and related tooling; investigate and resolve performance issues.
Maintain database integrity and stability across all environments, ensuring high availability and minimal unplanned downtime.
Manage and administer SQL Server instances on Azure VMs, including OS-level patching coordination, storage configuration, and availability group management.
Manage Azure SQL Database instances
Implement and maintain cloud-based data solutions, including database migrations, storage optimization, and environment provisioning.
Leverage Azure resources and services to enhance database scalability, reliability, and cost efficiency.
Participate in capacity planning and make recommendations for infrastructure scaling based on workload trends and growth projections.
Execute database deployment scripts (dbdeploy) prepared by the development team as part of coordinated application releases.
Deploy application updates to IIS servers by copying published build artifacts to the appropriate target servers following established procedures.
Validate deployments post-release by confirming database schema changes, application functionality, and system stability.
Maintain deployment documentation, checklists, and runbooks to ensure repeatable, error-free releases.
Partner with the data analyst team to support reporting and analytics initiatives, including providing optimized data access, views, and stored procedures for report consumption.
Assist in translating business requirements into efficient SQL queries and data pipelines that feed reporting tools.
Support stakeholders and data analysts by troubleshooting data quality issues, optimizing report query performance, and ensuring data accuracy.
Enforce security standards and best practices across all database environments, including encryption, auditing, and access controls.
Manage database user permissions, roles, and service accounts; conduct regular access reviews and audits.
Identify and remediate security vulnerabilities proactively across database and related application infrastructure.
Maintain and improve database policies, procedures, and operational documentation.
Continuously evaluate current systems and processes, recommending improvements to enhance reliability, performance, and security posture.