Database Administrator, Senior (IT)

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 ofstorage systemsand storage optimization

• Experience withmonitoring tools(Extended Events RedGate DataDog etc.)

• Understanding ofnetworking conceptsrelated 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.

Required Qualifications

• 5 years of experienceas a SQL Server Database Administrator
• Expert-level knowledge ofMicrosoft SQL Server()
• Advanced proficiency inT-SQL programmingand query optimization
• Extensive experience withSQL Server Management Studio (SSMS)
• Deep understanding ofAlways On Availability GroupsandFailover Cluster Instances
• Strong experience withbackup and recovery strategies(full differential log backups)
• Expertise inperformance monitoring and tuningtools and techniques
• Knowledge ofSQL Server securityimplementation and best practices
• Ability to work in the US for a Government Contractor

Preferred Qualifications

• Experience withAWS technologies
• Knowledge ofSQL Server Integration Services (SSIS)andSQL Server Reporting Services (SSRS)
• Experience withdatabase migration projectsand upgrade planning
• Familiarity withDevOps practicesand CI/CD pipelines for database deployments
• Knowledge ofother database platforms(Oracle PostgreSQL MySQL)
• Experience withdata warehousingandbusiness intelligenceenvironments
• Understanding ofcontainerizationfor database deployments
• Experience inregulated industries(healthcare finance government)

EDUCATION:

• Bachelors degree in an applicable discipline
  

PHYSICAL DEMANDS (per observation of incumbents in this position):

DSS Inc. is an Equal Opportunity Employer.

If you need an accommodation seeking employment with DSS Inc. please emailor call . Accommodations are made on a case-by-case basis.