Note: The job is a remote job and is open to candidates in USA. Comagine Health is a national, mission-driven, nonprofit organization focused on health care quality consulting and improvement services. The Database Administrator II will support the administration, monitoring, and optimization of SQL database environments, ensuring security and performance while collaborating with developers and infrastructure teams.
Responsibilities
- Administer and maintain SQL databases across development, test, and production environments
- Collaborate with developers and system architects to design scalable and efficient database solutions
- Optimize database structures to ensure performance, reliability, and data integrity
- Monitor database health and performance to ensure systems remain accessible and efficient
- Identify performance bottlenecks and implement database and query optimization strategies
- Implement database security policies and procedures to protect sensitive data
- Ensure database environments meet security and regulatory requirements
- Develop and maintain database backup and recovery processes
- Support high availability solutions such as clustering and Always On Availability Groups
- Participate in disaster recovery planning and testing
- Develop and maintain scripts for database monitoring, automation, and maintenance tasks
- Identify opportunities to automate operational processes
- Support migration of on-premises SQL Server databases to cloud platforms such as Microsoft Azure or AWS
- Evaluate and recommend cloud-based database services to improve scalability and performance
- Assist with administration and optimization of Amazon Redshift clusters, including performance tuning and cluster monitoring
Skills
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience
- Microsoft Certified: Azure Database Administrator
- 5+ years of experience in database administration, database architecture, or related technical roles
- Advanced experience with SQL Server database administration
- Expertise in database performance tuning and troubleshooting
- Strong proficiency in T-SQL scripting and automation
- Experience with high availability and disaster recovery solutions
- Familiarity with Azure SQL Database, Amazon RDS, or similar cloud database services
- Strong analytical and problem-solving abilities
- Excellent communication and collaboration skills
- Ability to work effectively in a fully remote, distributed team environment
- Assist with administration and optimization of Amazon Redshift clusters, including performance tuning and cluster monitoring
- Microsoft Certified: SQL Server Database Administrator
- Microsoft Certified: Azure Database Migration Engineer
- AWS Certified Database – Specialty
- Exposure to Amazon Redshift architecture, clusters, and optimization preferred
Benefits
- An annual stipend gives you the freedom to enhance your workspace with options that suit your needs.
- Medical, dental and vision insurance
- Paid time off for vacation, illness, and volunteering
- Retirement savings plan with employer contribution
- Adoption financial assistance
- Paid parental leave
Company Overview
Comagine Health is a healthcare consulting firm & they work collaboratively with patients, providers, payers and other stakeholders. It was founded in 2018, and is headquartered in Portland, Oregon, USA, with a workforce of 201-500 employees. Its website is https://comagine.org/.