The ideal candidate will be responsible for managing and maintaining our company's databases, ensuring their efficiency, security, and integrity. This is a critical role that plays a key part in supporting our organization's data-driven decision-making processes.
Assist in data extraction, transform and load during data migration from a legacy system to a modern product under development.
Nice to Have
- Experience in healthcare systems or hospital management systems (HIMS).
- Exposure to data encryption, masking, and compliance requirements.
Responsibilities
- Manage end-to-end administration of Microsoft SQL Server databases across multiple hospital sites.
- Install, configure, harden, secure, and maintain database servers to ensure high availability and performance.
- Monitor database performance (CPU, memory, storage, I/O) and proactively identify and resolve performance issues.
- Implement and manage database security, including user access, roles, permissions, and auditing.
- Perform database deployment, patching, upgrades, and version migrations (e.g., SQL Server 2005 → 2022).
- Manage database storage, including data files, capacity planning, and growth optimization.
- Ensure database availability and reliability (targeting near 24/7 uptime in a critical healthcare environment).
- Design, implement, and manage backup, recovery, and disaster recovery (DR) strategies.
- Monitor and troubleshoot SQL Server Agent jobs and automate routine database tasks.
- Support and improve legacy on-premise systems while preparing for future cloud/web-based migration.
- Analyze database queries and provide insights/recommendations to improve performance (in collaboration with development teams).
- Write and execute basic SQL scripts for data extraction and reporting.
- Work closely with infrastructure and application teams to ensure system stability and performance.
- Support audit, compliance, and data protection requirements (e.g., data encryption, masking).
- Contribute to continuous improvement by recommending tools, automation, and best practices.
Qualifications
- Proven experience as a Database Administrator (DBA) with strong focus on Microsoft SQL Server.
- Hands-on experience in database installation, configuration, administration, and performance tuning.
- Strong understanding of database architecture, data storage, and data distribution.
- Experience managing database security, access controls, and auditing.
- Knowledge of backup/recovery processes and disaster recovery planning.
- Familiarity with SQL Server versions (2005–2022) and migration/upgrade processes.
- Ability to monitor and troubleshoot database performance issues independently.
- Basic scripting skills in SQL (data extraction, querying, troubleshooting).
- Experience with automation, monitoring tools, or scripting (e.g., PowerShell) is an advantage.
- Understanding of high availability (HA), clustering, and failover environments.
- Experience in handling production-critical systems with high uptime requirements.
- Exposure to data migration, ETL, cloud (Azure/AWS), or microservices is a plus (not mandatory).
- Strong problem-solving skills with ability to analyze root causes and recommend solutions.
- Ability to work independently while collaborating with distributed teams.
- Willingness to learn, adapt, and grow with evolving technologies (legacy to cloud transition).
