SQL Server Database Administrator - DBA (Remote LATAM)

Atmosera empowers businesses to redefine what's possible with modern technology and human expertise. Our exceptional experience across Applications, Data & AI, DevOps, Security, and the Microsoft Azure platform enables organizations to accelerate innovation, enhance security, and optimize operational agility. As a Microsoft Partner with seven specializations, GitHub AI Partner of the Year, a member of the GitHub Advisory Board, and a member of the prestigious Microsoft Intelligent Security Association (MISA), Atmosera expertly delivers cutting-edge, integrated solutions that deliver business value. Key Responsibilities Database Administration & Maintenance - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Manage security, roles, permissions, and backups . - Monitor database health and performance proactively. High Availability & Disaster Recovery (HA/DR) - Design, implement, and maintain Always On Availability Groups, Failover Clustering, Log Shipping, and Replication . - Ensure 99. 99% uptime and meet high-performance standards. - Conduct automatic failover testing, backups, and disaster recovery planning . Performance Tuning & Optimization - Identify and resolve SQL query performance issues using execution plans, indexing strategies, and query optimization . - Implement best practices for indexing, partitioning, and resource allocation . - Analyze and optimize T-SQL queries and stored procedures . Monitoring & Troubleshooting - Utilize SQL Server Profiler, Extended Events, DMVs, and third-party monitoring tools (e. g. , SolarWinds, Redgate, SQLSentry ). - Diagnose and resolve database connectivity and replication issues . - Automate monitoring and maintenance tasks for efficiency. Security & Compliance - Implement database encryption, auditing, and access controls to ensure data security. - Ensure timely patching and upgrades to mitigate vulnerabilities. Collaboration & Documentation - Work with developers, DevOps, and infrastructure teams to optimize database solutions.

- Provide technical support and guidance for application teams. - Document database architectures, processes, and recovery plans . Required Qualifications & Skills - 3+ years of experience as a SQL Server DBA . - Expertise in SQL Server Always On Availability Groups and other HA/DR solutions . - Strong understanding of T-SQL scripting, indexing, and query tuning . - Experience with SQL Server 2016, 2019, and/or 2022 . - Knowledge of Windows Server Failover Clustering (WSFC) . - Familiarity with cloud-based SQL solutions (Azure SQL, AWS RDS, Google Cloud SQL). - Experience with PowerShell, automation scripts, and monitoring tools . - Understanding of database security principles and compliance standards . Preferred Qualifications (Nice to Have) - Experience with NoSQL or hybrid cloud databases (e. g. , Databricks ). - Knowledge of CI/CD pipelines and DevOps tools related to databases. - Relevant certifications (e. g. , Microsoft Certified: Azure Database Administrator Associate, MCSA: SQL Server ). - Experience with cloud-based backup and recovery platforms (e. g. , Rubrik, Veeam, Commvault ), including use of the backup and restore interface.