Job Details
DSS Baton Rouge - Baton Rouge, LA Hybrid Full Time 4 Year Degree Negligible Day Information Technology
Description
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 configurationsAnalyze and resolve complex database performance issues and bottlenecksDesign and implement indexing strategies for optimal query performanceMonitor and optimize resource utilization (CPU, memory, I / O, storage)Establish performance baselines and proactive monitoring alertsAssist with developing partitioning and archiving strategiesHigh Availability & Disaster Recovery
Implement and manage high availability solutions (Always On Availability Groups, Failover Clustering)Develop and maintain comprehensive disaster recovery plans and proceduresConduct regular DR testing and documentation updatesManage database replication and synchronization processesEnsure RTO and RPO requirements are met for critical systemsSecurity & Compliance
Implement and maintain database security best practices and policiesConduct security audits and vulnerability assessmentsEnsure compliance with regulatory requirements (HIPAA, SOC 2, etc.)Manage encryption strategies for data at rest and in transitCoordinate with security teams on database-related security initiativesLeadership & Collaboration
Collaborate with development teams on database design and optimizationWork with infrastructure teams on server and storage planningParticipate in on-call rotation and provide escalation supportConduct knowledge transfer sessions and create technical documentationPeriodic travel required for core team meetingsProcess Improvement
Maintain and monitor database monitoring and alerting systemsRecommend and document changes to operating proceduresEvaluate and implement new database technologies and toolsDrive continuous improvement initiatives for database operationsInfrastructure & Tools
Knowledge of storage systems and storage optimizationExperience with monitoring tools (Extended Events, RedGate, DataDog, etc.)Understanding of networking concepts related to database connectivityThe 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.Qualifications
Required Qualifications
5+ years of experience as a SQL Server Database AdministratorExpert-level knowledge of Microsoft SQL Server (2016, 2017, 2019, 2022)Advanced proficiency in T-SQL programming and query optimizationExtensive experience with SQL Server Management Studio (SSMS)Deep understanding of Always On Availability Groups and Failover Cluster InstancesStrong experience with backup and recovery strategies (full, differential, log backups)Expertise in performance monitoring and tuning tools and techniquesKnowledge of SQL Server security implementation and best practicesAbility to work in the US for a Government ContractorPreferred Qualifications
Experience with AWS technologiesKnowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)Experience with database migration projects and upgrade planningFamiliarity with DevOps practices and CI / CD pipelines for database deploymentsKnowledge of other database platforms (Oracle, PostgreSQL, MySQL)Experience with data warehousing and business intelligence environmentsUnderstanding of containerization for database deploymentsExperience in regulated industries (healthcare, finance, government)Education
Bachelor's degree in an applicable disciplineDSS Inc. is an Equal Opportunity Employer. If you need an accommodation seeking employment with DSS, Inc., please email jobs@dssinc.com or call (561) 284-7373. Accommodations are made on a case-by-case basis.
J-18808-Ljbffr