Note: The job is a remote job and is open to candidates in USA. Ardent Eagle Solutions is a company focused on providing IT application and website development support. They are seeking a Senior SQL Server Database Administrator to administer and maintain SQL Server databases, ensuring high availability, security, and performance for mission-critical applications.
Responsibilities
- Administer, maintain, and support Microsoft SQL Server databases across development, test, and production environments in both on-premises and Microsoft Azure cloud infrastructures
- Ensure high availability, security, performance, and recoverability of SQL Server databases supporting mission-critical federal applications
- Perform daily database monitoring, health checks, performance analysis, and proactive issue resolution across SQL Server environments
- Execute database installation, configuration, upgrades, patching, and security updates to maintain supported and secure SQL Server platforms
- Manage database backup and recovery operations, including full, differential, and transaction log backups, and support disaster recovery procedures
- Perform database performance tuning, query optimization, indexing strategies, and troubleshooting of complex database performance issues
- Maintain and manage database security, including user accounts, roles, permissions, authentication, and access controls in compliance with federal security requirements
- Support production release activities, including database deployments, schema changes, data refreshes, and environment synchronization between development, test, and production
- Develop, maintain, and optimize SQL Server stored procedures, T-SQL scripts, functions, triggers, and database objects to support application and reporting needs
- Support integration between SQL Server databases and external systems, including Oracle, COTS applications, and federal enterprise data platforms
- Design and maintain database views and data structures to support reporting and business intelligence tools such as Power BI and Qlik Sense
- Support data mart operations by adding and modifying tables, fields, and structures to meet evolving reporting and application requirements
- Develop and maintain SQL Server Reporting Services (SSRS) or equivalent reporting environments, ensuring reliable and timely access to data for end users
- Monitor and troubleshoot data integration processes and scheduled data loads to ensure accuracy, completeness, and data integrity
- Support database connectivity and interoperability across heterogeneous environments, including Oracle, MySQL, and enterprise data warehouses
- Provide technical support for database-related issues, including data recovery, troubleshooting, and resolution of production incidents
- Evaluate and implement new SQL Server database technologies and enhancements based on business and technical requirements
- Develop and maintain Standard Operating Procedures (SOPs) for database administration, including installation, configuration, patching, backup/recovery, and troubleshooting processes
- Retrieve and analyze data from enterprise systems to support reporting, analytics, and operational decision-making
- Collaborate with application developers, system administrators, and infrastructure teams to ensure optimal database performance and system reliability
- Ensure compliance with federal security standards, including data protection, encryption, and vulnerability remediation requirements
Skills
- Clearance: Public Trust
- More than 5 years of experience in conducting SQL Server database administration
- Extensive experience in administering SQL Server database in standalone and clustered architecture on Windows on premises and in cloud environments
- Extensive experience in SQL Server backup/recovery, configure failover cluster, setup jobs and monitoring
- Strong T SQL, performance tuning, and troubleshooting skills
- Experience with SQL Server reporting services, integration services, and analysis services
- Requires BS/BA degree in related field (or equivalent)
- Experiences with SQL Server 2016/2019/2022, SQL Server on Windows, and MySQL on Ubuntu
Benefits
- Medical/Dental/Vision Coverage
- Matching 401(k) Plan
- Continuing Education Assistance
- Paid Time Off
- Free parking is available for the night shift Operations Watch Officers
Company Overview