Document Storage Systems
Database Administrator, Senior (IT)
Document Storage Systems, Baton Rouge, Louisiana, us, 70873
Overview
DSS, Inc. is a leading health information software development and systems integration company, offering services and solutions utilized daily by clinicians and administrative staff across public and private sectors nationwide. Senior Database Administrator (DBA) – Responsibilities
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 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 for data at rest and in transit. Coordinate with security teams on database-related 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 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 Physical Demands
Standing 10% per day; Sitting 80% per day; Walking 5% per day; Stooping 5% per day; Lifting up to 50 lbs unassisted; Computer Work 80% per day; Telephone Work 10% per day; Reading 10% per day. Equal Opportunity and Accommodations:
DSS 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. Seniority level
Mid-Senior level Employment type
Full-time Job function
Information Technology Industries: Hospitals and Health Care Referrals increase your chances of interviewing at Document Storage Systems by 2x Get notified about new Senior Database Administrator jobs in Baton Rouge, LA. We’re unlocking community knowledge in a new way, with insights added directly into each article, started with the help of AI.
#J-18808-Ljbffr
DSS, Inc. is a leading health information software development and systems integration company, offering services and solutions utilized daily by clinicians and administrative staff across public and private sectors nationwide. Senior Database Administrator (DBA) – Responsibilities
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 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 for data at rest and in transit. Coordinate with security teams on database-related 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 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 Physical Demands
Standing 10% per day; Sitting 80% per day; Walking 5% per day; Stooping 5% per day; Lifting up to 50 lbs unassisted; Computer Work 80% per day; Telephone Work 10% per day; Reading 10% per day. Equal Opportunity and Accommodations:
DSS 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. Seniority level
Mid-Senior level Employment type
Full-time Job function
Information Technology Industries: Hospitals and Health Care Referrals increase your chances of interviewing at Document Storage Systems by 2x Get notified about new Senior Database Administrator jobs in Baton Rouge, LA. We’re unlocking community knowledge in a new way, with insights added directly into each article, started with the help of AI.
#J-18808-Ljbffr