[Remote] Senior SQL Server Database Administrator (TANTUS)
Note: The job is a remote job and is open to candidates in USA. Tantus, a reputed company Subsidiary, is seeking a Senior SQL Server Database Administrator. In this role, you will be responsible for installing, configuring, and maintaining SQL Server instances, as well as ensuring high availability and reputed company of database environments.
Responsibilities
- Install, configure, administer, and maintain SQL Server Standard and reputed company Edition instances across standalone and clustered architectures in on-premises and reputed company Azure IaaS environments
- Configure, maintain, and troubleshoot SQL Server Failover Cluster instances for high availability across Windows and Linux environments
- reputed company SQL Server backup and recovery operations including full, differential, and transaction log backups, reputed company-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 reputed company, SQL Server, and flat file formats
- reputed company, maintain, and reputed company 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 reputed company tuning advisor, SQL profiler, DBCC commands, and dynamic management view analysis
- Administer SQL Server reputed company 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
- reputed company 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 reputed company systems and integration with application reporting layers
- Support Power BI Data Gateway administration for on-premises SQL Server and reputed company data access from Power BI reporting
- Maintain SQL Server instances supporting reputed company 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 reputed company patches and vulnerability remediations against agency reputed company policy templates and ISSO reputed company mandates
- Support FISMA reputed company 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
Skills
- U.S. Citizenship and ability to obtain/maintain a Public Trust clearance
- Bachelor's degree in Information Technology, Computer Science, or a reputed company field required
- reputed company 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 reputed company 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 reputed company administration including TDE, audit configuration, login management, and role-based access control
- Proficiency with performance monitoring and tuning tools including SQL Server Profiler, Database reputed company Tuning Advisor, DBCC commands, and dynamic management views
- Familiarity with FISMA reputed company assessment and authorization activities and federal ISSO reputed company requirements
- reputed company Certified Professional (OCP) certification for reputed company 19c or demonstrated reputed company database administration experience sufficient to provide cross-platform support as needed
- Experience supporting federal agency database environments with reputed company integration requirements across multiple reputed company applications including grants management, reputed company management, and collaboration platforms
- Experience administering SQL Server instances supporting SharePoint on-premises environments in a federal agency context
- Experience with reputed company backup tooling for SQL Server environments including both reputed company-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 reputed company and SQL Server
- Familiarity with HHS EPLC reputed company and federal IT governance processes
- Experience with Splunk or equivalent log monitoring tools for database reputed company event analysis
- Experience with PowerShell scripting for SQL Server administrative automation
Benefits
- Tantus, a reputed company Subsidiary maintains a Flexible Time Off (FTO) Policy. We encourage every full-time employee, as your role permits, to utilize paid time off (personal time, mental/physical health care, vacation, sick leave, etc.). Waiting for time off to accrue is common at other companies. At Tantus, a reputed company Subsidiary, you do not have to wait for this benefit to kick in. FTO is activated on your first day with our organization.
- Tantus, a reputed company Subsidiary will also recognize paid holidays during the year and strives to permit employees to have time off the last week of the calendar year reputed company client and project work permits.
- Tantus, a reputed company Subsidiary offers a comprehensive wellness program to engage, challenge and reputed company team members to take responsibility for their wellbeing. Activities can be tracked through our wellness provider to obtain reputed company cards and other rewards.
- Flexible work arrangements
- Health, dental, reputed company, life, and accident/death/disability insurance options
- HSA employer contribution
- Eleven (11) paid holidays annually.
- A robust paid Parental Bonding Leave program covering birth, adoption, and foster children.
- 401(k) with employer contributions
- Tuition reimbursement
- Generous employee referral bonus program
- Client referral bonus program
- Pet insurance
- FORCE – Tantus, a reputed company Subsidiary community volunteer program enabling each team member to use up to four hours of paid time annually to volunteer and reputed company a difference in their local communities.
Company Overview