Senior SQL Server DBA

About this role

<h2 data-path-to-node="0">Senior SQL Server DBA & Performance Specialist</h2> <p data-path-to-node="2">Latin America | 100% Remote</p> <h3 data-path-to-node="3">About CodeRoad</h3> <p data-path-to-node="4">CodeRoad provides end-to-end software development services, helping businesses scale with ideal infrastructure solutions. From staff augmentation to dedicated IT teams and general software engineering, our nearshore technology services empower businesses to thrive in an ever-evolving digital landscape.</p> <h3 data-path-to-node="5">About the Role</h3> <p data-path-to-node="6">This role serves as the ultimate technical anchor for our client's database infrastructure within the high-demand automotive sector. We are looking for an expert-level SQL Specialist who goes far beyond standard administrative tasks, anchoring the health, security, and scalability of massive <strong data-path-to-node="6" data-index-in-node="293">Microsoft SQL Server Enterprise</strong> databases. You will be the primary guardian of database integrity, ensuring sub-second performance and high availability at scale.</p> <p data-path-to-node="7">This role is critical to the modernization and stability of our client's core operations. You will own the optimization of a massive library of complex legacy stored procedures, directly impacting system reliability and business continuity. Your deep-dive troubleshooting under pressure will prevent downtime, empower engineering teams, and directly influence the company’s ability to scale.</p> <h3 data-path-to-node="8">Key Responsibilities</h3> <ul data-path-to-node="9"> <li> <p data-path-to-node="9,0,0"><strong data-path-to-node="9,0,0" data-index-in-node="0">Optimize</strong> complex legacy SQL stored procedures, execution plans, indexes, and resource usage to resolve performance bottlenecks and ensure high availability.</p> </li> <li> <p data-path-to-node="9,1,0"><strong data-path-to-node="9,1,0" data-index-in-node="0">Diagnose</strong> and debug deep-seated database logic flaws, acting as the master troubleshooter for mission-critical system errors.</p> </li> <li> <p data-path-to-node="9,2,0"><strong data-path-to-node="9,2,0" data-index-in-node="0">Lead</strong> the core administration, security, and maintenance of <strong data-path-to-node="9,2,0" data-index-in-node="59">SQL Server 2019</strong> environments, including proactive monitoring, patching, replication, and upgrades.</p> </li> <li> <p data-path-to-node="9,3,0"><strong data-path-to-node="9,3,0" data-index-in-node="0">Build</strong> and manage robust backup, recovery, and disaster recovery strategies to ensure zero data loss.</p> </li> <li> <p data-path-to-node="9,4,0"><strong data-path-to-node="9,4,0" data-index-in-node="0">Collaborate</strong> directly with development teams to review database code, enforce architecture best practices, and proactively prevent performance degradation.</p> </li> </ul> <h3 data-path-to-node="10">Requirements</h3> <ul data-path-to-node="11"> <li> <p data-path-to-node="11,0,0"><strong data-path-to-node="11,0,0" data-index-in-node="0">5+ years</strong> of professional experience as a Microsoft SQL Server DBA or Database Specialist.</p> </li> <li> <p data-path-to-node="11,1,0"><strong data-path-to-node="11,1,0" data-index-in-node="0">Expert-Level SQL Mastery</strong>: Proven expertise in dissecting, troubleshooting, and rewriting highly complex SQL stored procedures.</p> </li> <li> <p data-path-to-node="11,2,0"><strong data-path-to-node="11,2,0" data-index-in-node="0">Tech Stack</strong>: Deep technical command of <strong data-path-to-node="11,2,0" data-index-in-node="38">SQL Server Enterprise Edition (2019 V.15.0.440.1)</strong>.</p> </li> <li> <p data-path-to-node="11,3,0"><strong data-path-to-node="11,3,0" data-index-in-node="0">Advanced English</strong>: Fluent written and spoken English proficiency, with the ability to clearly articulate technical issues to stakeholders.</p> </li> <li> <p data-path-to-node="11,4,0"><strong data-path-to-node="11,4,0" data-index-in-node="0">Ownership Mindset</strong>: Strong autonomy, proactive problem-solving skills, and the resilience to handle high-pressure scenarios with minimal guidance.</p> </li> </ul> <h3 data-path-to-node="12">Nice to Have</h3> <ul data-path-to-node="13"> <li> <p data-path-to-node="13,0,0">Prior experience in the <strong data-path-to-node="13,0,0" data-index-in-node="24">Automotive industry</strong> or data-heavy logistics sectors.</p> </li> <li> <p data-path-to-node="13,1,0">Exposure to cloud database migrations (e.g., <strong data-path-to-node="13,1,0" data-index-in-node="45">AWS RDS SQL Server</strong> or <strong data-path-to-node="13,1,0" data-index-in-node="67">Azure SQL Managed Instance</strong>).</p> </li> <li> <p…