Database Administrator, Senior (IT)

DOCUMENT STORAGE SYSTEMS INC•Baton Rouge, LA

3h•Onsite

About The Position

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 The preceding functions are examples of the work performed by employees assigned to this job classification. Management reserves the right to add, modify, change or rescind work assignments and make a reasonable accommodation as needed. SECURITY AND PRIVACY DUTIES AND RESPONSIBILITIES Individuals working for DSS will be subject to security and privacy requirements as explained in HIPAA, FedRAMP, and NIST 800-53. Additionally, they are required to undergo specific FedRAMP training to ensure compliance with all associated controls and responsibilities in the day-to-day performance of their duties. Individuals working in departments that are considered to be in the high-risk category will be required to undergo advanced training based on their role and level of access. Individuals with access to modify data and the configuration baseline will require further training.

Requirements

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

Nice To Haves

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)

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