SQL Database Administrator

About the company: Sightview Software LLC is a healthcare technology company providing intelligent EHR and practice management solutions built exclusively for eye care. We support ophthalmology, optometry, and optical practices with software designed to streamline clinical workflows, surgical planning, patient engagement, and business operations. Our platform includes EHR, practice management, optical management, ASC solutions, MIPS reporting, and revenue cycle management services—helping eye care providers focus on delivering exceptional patient care while improving efficiency and financial performance. For further information, kindly read more on About us What would you do? About the role: Sightview is seeking a Database Administrator with 2–4 years of experience to support and maintain Microsoft SQL Servers and Amazon Aurora (MySQL and Postgres) database platforms in a production AWS environment. This role is primarily focused on database monitoring, maintenance, performance optimization, and operational support, working closely with Site Reliability, Infrastructure, DevOps, and Application Engineering teams. The ideal candidate has hands-on experience with Microsoft SQL, AWS-managed database services, Windows Server environments, automated schema and deployment workflows, and thrives in a structured, reliability-focused environment. Key Responsibilities: Database Operations & Maintenance • Administer and maintain SQL Server (Windows) and Aurora (MySQL/Postgres) in AWS • Run routine maintenance, monitoring, and health checks • Manage backups/restores, snapshots, and recovery • Ensure availability, integrity, reliability, and security • Track storage growth, capacity, and performance trends • Support engine upgrades and patching via approved change processes Monitoring & Incident Response • Proactively monitor database health and performance • Respond to alerts and production incidents • Troubleshoot slow queries, locking/blocking, and resource contention • Participate in escalation/on-call rotations as required Performance Tuning & Optimization • Tune queries and database performance for SQL Server and Aurora MySQL • Analyze execution plans and indexing strategies • Partner with application teams to improve data access patterns • Identify and remediate recurring performance issues Schema Changes & Deployment Automation • Support schema updates, data migrations, and version-controlled database changes • Assist database deployments via CI/CD pipelines • Support rollback and recovery procedures • Collaborate with DevOps to improve automation and deployment reliability Windows Server & Infrastructure Support • Support SQL Server running on Windows Server, including OS-level troubleshooting • Coordinate with infrastructure teams on availability, resilience, and capacity planning • Ensure compliance with Sightview security and audit standards AWS EC2 & Storage Operations (EBS/Snapshots) • Support AWS EC2 workloads hosting or supporting database services • Manage EBS volumes (provision/resize, encryption, performance) • Manage EBS snapshots for backup/recovery and pre-change protection • Monitor and troubleshoot instance/storage health via CloudWatch and AWS console tools Documentation & Standards • Maintain operational documentation and runbooks • Follow Sightview database best practices and standards • Support audits and compliance initiatives as required Skills and qualifications (mandatory): · 2–4 years of hands-on DBA(Microsoft SQL, MySQL, Postgres) experience · Working knowledge of backup/recovery, database security, and performance tuning · Experience in AWS and Windows Server environments · Familiarity with database deployment automation and strong troubleshooting skills Skills and qualifications (preferred): · Experience with RDS/Aurora monitoring and CloudWatch · SQL Server high availability and/or replication features · Scripting (PowerShell, Bash, Python) · Exposure to Infrastructure as Code (Terraform, CloudFormation) · Familiarity with DevOps and/or SRE practices