Description

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

1. Database Administration and Maintenance

• 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.

2. Azure Cloud Database Management

• 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.

3. Application and Database Deployment Support

• 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.

4. Reporting and Analytics Collaboration

• 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.

5. Security and Administrative Responsibilities

• 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.

Required Qualifications and Skills:

• 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.

Other Skills:

• 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.

Position Demands:

This position requires sitting, bending, and stooping for up to 8 hours per day in an office setting. Ability to lift and move objects weighing up to 10 lbs. Ability to learn technical material. The person in this position occasionally needs to move about inside the office to access filing cabinets, office machinery, etc. Must be able to operate a computer and other office productivity machinery such as a calculator, copy machine, printer, etc. The person in this position frequently communicates with guests, team members, and vendors and must be able to exchange accurate information.

Equal Employment Opportunity:

The Company is a veteran-owned Company and provides Equal Employment Opportunities (EEO) to all Team Members and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender (including gender identity), pregnancy, childbirth, or a medical condition related to pregnancy or childbirth, national origin, age, disability, genetic information, status as a covered veteran in accordance with applicable federal, state, and local laws, or any other characteristic or class protected by law and is committed to providing equal employment opportunities. The Company complies with applicable state and local laws governing non-discrimination in employment. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, promotion, discharge, pay, fringe benefits, membership, job training, classification, and other aspects of employment.  Team Members who believe they are the victims of discrimination should immediately report the concern to their Supervisor and the Human Resources Department. Discrimination and harassment will not be tolerated.

We are committed to creating an inclusive environment for all Team Members and applicants. We value the unique skills and experiences that veterans bring to our team and encourage veterans to apply.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of our personnel. All team members may be required to perform duties outside of their normal responsibilities from time to time, as needed.