Company Overview:
Join a leading Revenue Cycle Management (RCM) company that is dedicated to optimizing healthcare financial operations. We leverage cloud-based data solutions to enhance efficiency and decision-making in healthcare. We are seeking an experienced Database Administrator (DBA) to manage, optimize, and secure our SQL Server databases in a cloud environment.
Job Summary:
As a Database Administrator (DBA), you will be responsible for designing, implementing, and maintaining SQL Server databases in a cloud environment. You will optimize both development and production workloads, ensure high availability, and improve database performance through advanced tuning techniques such as index optimization, query tuning, and partitioning. This role requires strong expertise in SQL Server, including database security, backups, replication, and disaster recovery.
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
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