SQL Server Database Administrator, DBA

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

📋 Description

• Set up, configure, and manage SQL Server instances both on-premises and in cloud environments.

• Oversee database security, including roles, permissions, and backup processes.

• Proactively monitor the health and performance of databases.

• Design, implement, and manage Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.

• Ensure a 99.99% uptime and adhere to high-performance benchmarks.

• Conduct automated failover testing, manage backups, and develop disaster recovery strategies.

• Identify and resolve performance issues in SQL queries through execution plans, indexing strategies, and optimization techniques.

• Apply best practices for indexing, partitioning, and resource management.

• Analyze and enhance T-SQL queries and stored procedures.

• Utilize SQL Server Profiler, Extended Events, DMVs, and third-party monitoring solutions like SolarWinds, Redgate, and SQLSentry.

• Diagnose and troubleshoot database connectivity and replication problems.

• Automate maintenance and monitoring processes.

• Implement database encryption, auditing, and access control measures.

• Ensure timely updates and patches to address security vulnerabilities.

• Collaborate with developers, DevOps, and infrastructure teams to refine database solutions.

• Offer technical support and direction to application teams.

• Document database architectures, workflows, and recovery strategies.

⛳️ Requirements

• Over 3 years of experience as a SQL Server DBA.

• Proficient in SQL Server Always On Availability Groups and other high availability/disaster recovery solutions.

• Strong knowledge of T-SQL scripting, indexing, and query tuning.

• Experience with SQL Server versions 2016, 2019, and/or 2022.

• Understanding of Windows Server Failover Clustering (WSFC).

• Familiarity with cloud-based SQL solutions such as Azure SQL, AWS RDS, and Google Cloud SQL.

• Experience with PowerShell, automation scripts, and monitoring tools.

• Knowledge of database security principles and compliance regulations.

• Experience with NoSQL or hybrid cloud databases (e.g., Databricks) is preferred.

• Understanding of CI/CD pipelines and DevOps tools pertaining to databases is preferred.

• Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server, are preferred.

• Experience with cloud-based backup and recovery solutions like Rubrik, Veeam, or Commvault is preferred.

• Willingness to travel to client sites as needed.

🏝️ Benefits

• Option to work remotely.

• Contractor position.

• Equal opportunity and inclusive workplace.