Data Base Administrator

Job Summary:

Database Administrator (DBA)

Key Responsibilities:

• Administer and maintain SQL Server databases in a cloud environment
• Optimize database performance through index tuning, query optimization, and execution plan analysis
• Ensure database high availability, replication, and disaster recovery strategies
• Monitor database health and performance using SQL Profiler, Extended Events, and other monitoring tools
• Work closely with developers to improve database design, query performance, and stored procedures
• Manage database backups, restores, and security policies to ensure data integrity
• Automate database maintenance tasks and improve efficiency
• Collaborate with data engineers and analysts to support data pipeline workflows
• Ensure compliance with HIPAA, HITRUST, and other healthcare data security standards
• Troubleshoot database issues and provide timely resolutions

Requirements

Required Skills & Experience:

• 5+ years of experience as a SQL Server DBA in a production environment
• Strong expertise in index tuning, query optimization, and execution plan analysis
• Experience with SQL Server high availability solutions (e.g., Always On, clustering, replication)
• Proficiency in T-SQL scripting, stored procedures, and triggers
• Experience with SQL Server backup and recovery strategies
• Familiarity with Azure SQL, Azure SQL Managed Instances, and other cloud-based SQL Server implementations (Azure SQL Database, Managed Instances, or AWS RDS for SQL Server)
• Understanding of database security best practices, including role-based access control (RBAC), encryption, and auditing
• Experience working with large-scale transactional databases
• Strong problem-solving skills and the ability to work independently in a remote setting

Preferred Skills:

• Experience with Azure SQL Managed Instance, Azure Data Factory, or related cloud technologies
• Familiarity with PowerShell or Python for database automation
• Experience in a healthcare RCM or HIPAA-regulated environment
• Knowledge of ETL processes and supporting data warehousing solutions