SQL DBA II

This is a fully remote position, open to applicants in Florida.

📋 Description

• Take responsibility for the health and reliability of SQL Server environments encompassing Production, Staging, and Development, including SQL Server hosted on AWS RDS.

• Ensure database availability aligns with established SLAs, SLOs, RTOs, and RPOs.

• Provide support and administration for MySQL and PostgreSQL platforms in both cloud and on-premises settings.

• Monitor and enhance database performance and capacity utilizing execution plans, Query Store, wait statistics, Extended Events, indexing analysis, observability platforms, and diagnostic tools.

• Manage access and permissions following least-privilege principles.

• Design, implement, test, and verify backup, restore, high-availability, and disaster-recovery plans.

• Collaborate with Software Development, Data Engineering, QA, Infrastructure, and other technology teams throughout the development lifecycle.

• Enhance T-SQL, query and schema design, indexing, CI/CD workflows, automated deployments, data migrations, integrations, and post-deployment validation.

• Automate repetitive database tasks using infrastructure-as-code, PowerShell, and other scripting technologies.

• Improve monitoring, alerting, dashboards, incident response, root-cause analysis, and technical documentation.

• Diagnose complex production issues, identify and mitigate operational risks, and continuously enhance database engineering practices.

⛳️ Requirements

• Minimum of 5 years of hands-on experience in SQL Server transactional database administration, including production database environments.

• Strong expertise in SQL Server administration covering configuration, security, permissions, maintenance, backups, restores, troubleshooting, and operational support.

• Significant experience with AWS database and infrastructure services, particularly RDS, Secrets Manager, S3, CloudWatch, and related technologies.

• Advanced capabilities in SQL Server performance analysis and optimization, including execution plans, Query Store, index design, wait statistics, blocking analysis, query tuning, Extended Events, and related diagnostic tools.

• Solid understanding of SQL Server concurrency and transaction behavior, including isolation levels, locking, blocking, and deadlocks.

• Experience in designing and supporting high-availability and disaster-recovery solutions, including Always On Availability Groups, backup and restore strategies, and RTO/RPO planning.

• Strong proficiency in T-SQL and PowerShell, with experience in using automation for database administration and operational workflows.

• Working knowledge of MySQL and PostgreSQL administration, including configuration, monitoring, security, backup and restore, and troubleshooting in production environments.

• Experience with source control and database CI/CD practices utilizing Git, GitHub, GitHub Actions, or similar technologies.

• Familiarity with monitoring and observability platforms such as Datadog, Prometheus, CloudWatch, or similar.

• Ability to independently troubleshoot complex production database issues, conduct root-cause analysis, manage assigned tasks, communicate risks and blockers, and escalate as necessary.

• An associate’s degree in Computer Science, Information Technology, a related field, or equivalent professional experience.

• Must reside in Florida.

🏝️ Benefits

• Employees have the option to work remotely.

• Primarily remote work with in-person collaboration, team meetings, or company events approximately 10% of the time.

• Health insurance is provided.

• Retirement plans are available.

• Paid time off is offered.