Database Administrator, Senior (IT) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Jobs via Dice ยท 1 day ago

Database Administrator, Senior (IT)

DSS, Inc. is a leading health information software development and systems integration company, offering services utilized by thousands of clinicians and administrative staff. They are seeking an experienced Senior Database Administrator (DBA) with extensive SQL Server expertise to ensure the performance, availability, and security of critical databases.

Computer Software
badNo H1Bnote

Responsibilities

Administer and maintain multiple SQL Server instances across development, testing, and production environments
Install, configure, and upgrade SQL Server databases and related components
Monitor database performance, availability, and capacity planning
Manage database backups and recoveries
Manage database security, including user access, roles, and permissions
Perform regular maintenance tasks including index optimization, statistics updates, and space management
Conduct advanced performance tuning of databases, queries, and server configurations
Analyze and resolve complex database performance issues and bottlenecks
Design and implement indexing strategies for optimal query performance
Monitor and optimize resource utilization (CPU, memory, I/O, storage)
Establish performance baselines and proactive monitoring alerts
Assist with developing partitioning and archiving strategies
Implement and manage high availability solutions (Always On Availability Groups, Failover Clustering)
Develop and maintain comprehensive disaster recovery plans and procedures
Conduct regular DR testing and documentation updates
Manage database replication and synchronization processes
Ensure RTO and RPO requirements are met for critical systems
Implement and maintain database security best practices and policies
Conduct security audits and vulnerability assessments
Ensure compliance with regulatory requirements (HIPAA, SOC 2, etc.)
Manage encryption strategies for data at rest and in transit
Coordinate with security teams on database-related security initiatives
Collaborate with development teams on database design and optimization
Work with infrastructure teams on server and storage planning
Participate in on-call rotation and provide escalation support
Conduct knowledge transfer sessions and create technical documentation
Maintain and monitor database monitoring and alerting systems
Recommend and document changes to operating procedures
Evaluate and implement new database technologies and tools
Drive continuous improvement initiatives for database operations
Knowledge of storage systems and storage optimization
Experience with monitoring tools (Extended Events, RedGate, DataDog, etc.)
Understanding of networking concepts related to database connectivity

Qualification

SQL ServerT-SQL programmingPerformance tuningBackupRecoveryAlways On Availability GroupsFailover ClusteringSQL Server Management StudioDatabase migrationAWS technologiesSQL Server Integration ServicesSQL Server Reporting ServicesDevOps practicesData warehousingContainerizationRegulated industries experience

Required

5+ years of experience as a SQL Server Database Administrator
Expert-level knowledge of Microsoft SQL Server (2016, 2017, 2019, 2022)
Advanced proficiency in T-SQL programming and query optimization
Extensive experience with SQL Server Management Studio (SSMS)
Deep understanding of Always On Availability Groups and Failover Cluster Instances
Strong experience with backup and recovery strategies (full, differential, log backups)
Expertise in performance monitoring and tuning tools and techniques
Knowledge of SQL Server security implementation and best practices
Ability to work in the US for a Government Contractor

Preferred

Experience with AWS technologies
Knowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Experience with database migration projects and upgrade planning
Familiarity with DevOps practices and CI/CD pipelines for database deployments
Knowledge of other database platforms (Oracle, PostgreSQL, MySQL)
Experience with data warehousing and business intelligence environments
Understanding of containerization for database deployments
Experience in regulated industries (healthcare, finance, government)

Company

Jobs via Dice

twitter
company-logo
Welcome to Jobs via Dice, the go-to destination for discovering the tech jobs you want.

Funding

Current Stage
Early Stage
Company data provided by crunchbase