Azure SQL Database Administrator

AVER is seeking an Azure SQL Database Administrator to design, implement, and maintain enterprise-scale SQL database environments across on-premises and cloud platforms, including SQL Server, Azure SQL Managed Instance, and Azure SQL Hyperscale. The role involves collaborating with teams, producing technical documentation, ensuring data accuracy and security, and supporting SQL Server migrations to Azure. The ideal candidate will have 10+ years of experience in SQL Database Administration, expert-level T-SQL proficiency, and extensive experience with high availability and disaster recovery solutions.

Must Have

• Design, implement, and maintain enterprise-scale SQL database environments (SQL Server, Azure SQL Managed Instance, Azure SQL Hyperscale).
• Expert-level proficiency in T-SQL, including complex joins, stored procedures, functions, and indexing strategies.
• Extensive experience with high availability and disaster recovery solutions (clustering, replication, availability groups).
• Proven ability to troubleshoot and resolve complex performance, deadlocks, replication, data integrity, and connectivity issues.
• Hands-on experience with Azure Portal, administering Azure SQL Database, Azure SQL Managed Instance, and cloud-based SQL services.
• Experience planning and executing SQL Server and SQL cloud migrations.
• Ability to obtain and maintain a government clearance (Public Trust) and U.S. citizenship.

Description

AVER is a fast-growing SDVOSB that has achieved significant revenue growth over the past 5 plus years with much of our work focused on Data Analytics, Mission Support, IT Modernization and Biometrics. AVER is seeking an Azure SQL Database Administrator, who is a technical expert to support activities related to administration of computerized databases at an enterprise level spanning application development, SharePoint, and data services. Join a collaborative team who values AVER’s mission, focus, and culture of delivering exceptional client service with great people and transformative technology solutions that ensure Government mission success.

Responsibilities Include:

• Design, implement, and maintain enterprise-scale SQL database environments across on-premises and cloud platforms, including SQL Server, Azure SQL Managed Instance, and Azure SQL Hyperscale
• Collaborate with management, technical teams, and end users to gather requirements and define database solutions prior to automation or implementation
• Produce detailed technical documentation and reports covering system requirements, concurrency, storage capacity, performance metrics, and data processing procedures for relational database systems
• Forecast long-term database administration and architecture needs in coordination with information systems leadership
• Perform quality assurance, auditing, and governance of enterprise databases to ensure data accuracy, integrity, and appropriate usage
• Manage user access and security across multiple enterprise database environments
• Install, configure, patch, and upgrade SQL Server RDBMS from both hardware and software perspectives
• Partner with development teams to design and optimize queries, perform performance tuning, and implement schema-level changes
• Ensure database availability, backup, restoration, and disaster recovery for mission-critical systems
• Support SQL Server migrations to Azure, including cloud architecture alignment and risk mitigation

Education Requirements:

• Bachelor’s degree in Computer Science, Information Systems, or an equivalent/related field

Experience Requirements:

• 10+ years of experience as a SQL Database Administrator supporting mission-critical enterprise environments
• Expert-level proficiency in T-SQL, including writing and optimizing complex joins, stored procedures, functions, and indexing strategies
• Extensive experience with high availability and disaster recovery solutions, including clustering, replication, and availability groups
• Proven ability to troubleshoot and resolve complex issues related to performance, deadlocks, replication, data integrity, connectivity, TempDB, backups, and configuration
• Strong experience analyzing execution plans, identifying bottlenecks, and resolving large-scale performance issues
• Demonstrated ability to administer multiple production databases while ensuring high availability and continuous performance monitoring
• Hands-on experience with Azure Portal, administering Azure SQL Database, Azure SQL Managed Instance, and cloud-based SQL services
• Experience planning and executing SQL Server and SQL cloud migrations
• Advanced SQL scripting expertise for index creation, optimization, and removal, and development of ad-hoc and scheduled SQL Agent jobs
• Experience with custom logging, monitoring, and alerting to proactively identify performance, availability, and security issues
• Experience applying patches and upgrades in production (PROD) environments
• Experience with resolving database and application-level security and permission issues
• Ability to create and maintain backup and recovery documentation across all environments (development, test, and production)

Location:

• HYBRID (2 days a week on site in Washington, DC)

Security Requirement:

• Ability to obtain and maintain a government clearance (Public Trust)
• This role supports a government agency that requires U.S. citizenship

About Us:

AVER, LLC is a Data & Digital Transformation company committed to delivering exceptional client service through the use of transformative technology solutions and a team of highly skilled professionals. Our focus is on enabling Government mission success in the domains of Homeland Security, Biometrics, Law Enforcement, and Healthcare. As a verified Service-Disabled Veteran-Owned Small Business (SDVOSB), we prioritize building trusted partnerships with our clients and people, providing a customer-centric experience.

AVER is an Equal Opportunity Employer/Veterans/Disabled