Apply on Employer Site

DSS, Inc. · 1 month ago

Database Administrator, Senior (IT)

Baton Rouge, LA

Full-time

Onsite

Senior Level

7+ years exp

Document Storage Systems Inc. is a leading provider of health information software solutions and systems integration services. They are seeking a highly skilled Senior Database Administrator to ensure the optimal performance, availability, and security of their mission-critical databases, while also collaborating with development and infrastructure teams.

Enterprise SoftwareInformation ServicesInformation TechnologySoftwareTraining

Comp. & Benefits

No H1B

U.S. Citizen Only

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 Server AdministrationT-SQL ProgrammingPerformance TuningBackupRecoveryAlways On Availability GroupsSQL Server Management StudioDatabase SecurityAWS TechnologiesDevOps PracticesData WarehousingC# Development.NET DevelopmentSQL Server Integration ServicesSQL Server Reporting Services

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

Bachelors degree or a combination of education and experience will be considered for this position

Microsoft Certified Database Administrator (MCDBA) required

7-plus years of MS SQL Development and Administration

7 years of Development environment experience in the process of data modeling and normalization to ensure that databases are designed to promote data integrity

7 years IT operation experience with strong understanding of database structures, theories, principles, and practices

Four-plus years of working with MS SQL as the backend for an enterprise application for thousands of concurrent customers