Senior SQL Server Database Administrator (TANTUS)Sikich LLP • Bethesda, Maryland, United States
Senior SQL Server Database Administrator (TANTUS)
Sikich LLP
- Bethesda, Maryland, United States
- Bethesda, Maryland, United States
Über
In anticipation of a recompete contract award, Tantus, a Sikich Subsidiary, is looking for a Senior SQL Server Database Administrator.
Responsibilities
Install, configure, administer, and maintain SQL Server Standard and Enterprise Edition instances across standalone and clustered architectures in on-premises and Microsoft Azure IaaS environments
Configure, maintain, and troubleshoot SQL Server Failover Cluster instances for high availability across Windows and Linux environments
Perform SQL Server backup and recovery operations including full, differential, and transaction log backups, point-in-time recovery, and automated backup policy management using SQL Server Native Backup with Azure Blob Storage
Administer and maintain SQL Server Reporting Services (SSRS) including report development, deployment to report server, and maintenance of reports from multiple data sources including Oracle, SQL Server, and flat file formats
Develop, maintain, and deploy SQL Server Integration Services (SSIS) packages for ETL and data integration operations
Administer and maintain MySQL 8.x instances on Ubuntu Linux including replication, encryption, backup, and semi-synchronous replication configuration
Monitor and tune database performance including index defragmentation, query optimization, database engine tuning advisor, SQL profiler, DBCC commands, and dynamic management view analysis
Administer SQL Server security including login creation, role assignment, user account management, group management, privilege grants, and audit configuration
Implement and maintain Transparent Data Encryption (TDE) for SQL Server and MySQL tablespace encryption for data at rest protection
Configure and maintain SQL Server Always On availability groups, database mirroring, log shipping, and replication for business continuity
Develop and maintain automated job scheduling, alerts, and notifications for system errors, resource constraints, database health events, and task assignment tracking
Migrate and configure SQL Server databases and instances from on-premises infrastructure to Azure IaaS platform
Support agency data mart operations including nightly data pulls from enterprise systems and integration with application reporting layers
Support Power BI Data Gateway administration for on‑premises SQL Server and Oracle data access from Power BI reporting
Maintain SQL Server instances supporting enterprise applications across a large federal agency application portfolio
Author and maintain SQL Server and MySQL SOPs covering installation, configuration, backup and recovery, replication, patching, failover clustering, encryption, and monitoring
Apply security patches and vulnerability remediations against agency scan policy templates and ISSO security mandates
Support FISMA security assessment and authorization activities as they relate to SQL Server and MySQL database environments
Support application developers and subject matter experts in database optimization, schema design, stored procedure development, and integrated systems performance
Qualifications
U.S. Citizenship and ability to obtain/maintain a Public Trust clearance
Bachelor's degree in Information Technology, Computer Science, or a related field required
Microsoft Certified Technology Specialist (MCTS) or equivalent SQL Server certification required
Minimum 5 years of SQL Server database administration experience; 12-plus years preferred
Demonstrated experience administering SQL Server 2016, 2019, and 2022 in both standalone and clustered configurations on Windows on‑premises and in Microsoft Azure
Proficiency in T‑SQL including stored procedures, functions, views, triggers, constraints, indexes, joins, unions, and dynamic management views
Hands‑on experience with SQL Server Failover Clustering, Always On availability groups, database mirroring, log shipping, and replication
Experience with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS)
Experience administering MySQL 5.7 and 8.x on Ubuntu Linux including master‑slave replication, GTID replication, encrypted backups, and MySQLPump
Experience with SQL Server backup and recovery tools including SQL Server Native Backup and Azure Blob Storage integration
Experience migrating SQL Server databases from on‑premises environments to Azure IaaS
Experience with SQL Server security administration including TDE, audit configuration, login management, and role‑based access control
Proficiency with performance monitoring and tuning tools including SQL Server Profiler, Database Engine Tuning Advisor, DBCC commands, and dynamic management views
Familiarity with FISMA security assessment and authorization activities and federal ISSO security requirements
Preferred Certifications & Qualifications
Oracle Certified Professional (OCP) certification for Oracle 19c or demonstrated Oracle database administration experience sufficient to provide cross‑platform support as needed
Experience supporting federal agency database environments with complex integration requirements across multiple enterprise applications including grants management, contracts management, and collaboration platforms
Experience administering SQL Server instances supporting SharePoint on‑premises environments in a federal agency context
Experience with enterprise backup tooling for SQL Server environments including both third‑party solutions and SQL Server Native Backup to Azure Blob Storage
Experience with Power BI Data Gateway configuration and administration
Experience with SSRS report development across multiple heterogeneous data sources including Oracle and SQL Server
Familiarity with HHS EPLC framework and federal IT governance processes
Experience with Splunk or equivalent log monitoring tools for database security event analysis
Experience with PowerShell scripting for SQL Server administrative automation
Salary In compliance with this state’s pay transparency laws, the salary range for this role is $160,000 - $180,000.
Values
Values driven – you embody and model absolute integrity and servant leadership and you have a bias for action and continuous innovation
Uncompromising problem solver – you see opportunities in every business challenge and can develop, articulate and implement solutions
Collaboration – you are a relationship builder across all levels of the organization and across all business units
Instills trust – you do what you say, without ego, and you follow through on commitments consistently and credibly
Impact & influence – you are relentlessly focused on making a difference and can gain support for ideas, proposals and solutions. You get others to act, with or without formal authority, to advance initiatives and objectives
Benefits
Flexible Time Off (FTO) Policy – full‑time employees may utilize paid time off (personal time, mental/physical health care, vacation, sick leave, etc.) from the first day of employment
Paid holidays throughout the year, with an additional week of time off in the last week of the calendar year when client and project work permits
Comprehensive wellness program with activities tracked through a wellness provider to obtain rewards
Health, dental, vision, life, and accident/death/disability insurance options
HSA employer contribution
Eleven paid holidays annually
Robust paid Parental Bonding Leave program covering birth, adoption, and foster children
401(k) with employer contributions
Force – community volunteer program enabling up to four hours of paid time annually to volunteer and make a difference in local communities
Equal Opportunity Employer Tantus, a Sikich Subsidiary is an Equal Opportunity Employer M/F/D/V.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.