SQL Server Database Administrator - DBA (Remote LATAM) at Atmosera

We are redirecting you to the source. If you are not redirected in 3 seconds, please click here.

SQL Server Database Administrator - DBA (Remote LATAM) at Atmosera. Location Information: . 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.. We are seeking an experienced . SQL Server Database Administrator (DBA). with expertise in managing high-availability (HA) environments. The ideal candidate will have deep knowledge of . Always On Availability Groups, database performance tuning, and disaster recovery strategies. . This role requires . strong problem-solving skills, proactive monitoring, and collaboration. with IT teams to ensure optimal database performance and availability.. 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.. . . . . . This is a contractor position with the ability to work from home but may require travel to a client site.. . Atmosera is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. All employment is decided on the basis of qualifications, merit, and business need.