Oct 1
Unspecified
Mid Level Career (5+ yrs experience)
Occasional travel
IT - Software
DSS, Inc. is a leading health information software development and systems integration company, offering services and solutions utilized daily by thousands of clinicians and administrative staff across both public and private sectors nationwide.
OVERVIEW
We are seeking an experienced Senior Database Administrator (DBA) with extensive SQL Server expertise to join the database infrastructure management and administration team. The successful candidate will be responsible for ensuring the performance, availability, and security of critical databases. This role requires deep technical knowledge, strategic thinking, and the ability to support enterprise-level database environments.
The Senior Database Administrator will:
Database Administration & Management
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
Performance & Optimization
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
High Availability & Disaster Recovery
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
Security & Compliance
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
Leadership & Collaboration
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
Periodic travel required for core team meetings
Process Improvement
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
Infrastructure & Tools
Knowledge of storage systems and storage optimization
Experience with monitoring tools (Extended Events, RedGate, DataDog, etc.)
Understanding of networking concepts related to database connectivity
Qualifications
Required Qualifications
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 Qualifications
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)
EDUCATION:
Bachelor’s degree in an applicable discipline
OVERVIEW
We are seeking an experienced Senior Database Administrator (DBA) with extensive SQL Server expertise to join the database infrastructure management and administration team. The successful candidate will be responsible for ensuring the performance, availability, and security of critical databases. This role requires deep technical knowledge, strategic thinking, and the ability to support enterprise-level database environments.
The Senior Database Administrator will:
Database Administration & Management
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
Performance & Optimization
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
High Availability & Disaster Recovery
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
Security & Compliance
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
Leadership & Collaboration
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
Periodic travel required for core team meetings
Process Improvement
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
Infrastructure & Tools
Knowledge of storage systems and storage optimization
Experience with monitoring tools (Extended Events, RedGate, DataDog, etc.)
Understanding of networking concepts related to database connectivity
Qualifications
Required Qualifications
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 Qualifications
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)
EDUCATION:
Bachelor’s degree in an applicable discipline
group id: 10429440
