AVER, LLC · 3 weeks ago
Azure SQL Database Administrator
AVER, LLC is a fast-growing SDVOSB focused on Data Analytics, Mission Support, IT Modernization, and Biometrics. They are seeking an Azure SQL Database Administrator who will be responsible for the administration of computerized databases at an enterprise level, including design, implementation, and maintenance of SQL database environments.
AnalyticsConsultingHealth CareInformation TechnologyTelehealth
Responsibilities
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
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or an equivalent/related field
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)
Ability to obtain and maintain a government clearance (Public Trust)
This role supports a government agency that requires U.S. citizenship
Company
AVER, LLC
AVER, LLC – Data and Modernization Experts, delivers exceptional client service with great people and transformative technology solutions to enable Government mission success.