About CodeRoa
dCodeRoad 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
About the Ro
leThis 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 Microsoft SQL Server Enterpri se databases. You will be the primary guardian of database integrity, ensuring sub-second performance and high availability at scale.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.
Key Responsibilit
- iesOptim ize complex legacy SQL stored procedures, execution plans, indexes, and resource usage to resolve performance bottlenecks and ensure high availabili
- ty.Diagn ose and debug deep-seated database logic flaws, acting as the master troubleshooter for mission-critical system erro
- rs.L ead the core administration, security, and maintenance of SQL Server 2 019 environments, including proactive monitoring, patching, replication, and upgrad
- es.Bu ild and manage robust backup, recovery, and disaster recovery strategies to ensure zero data lo
- ss.Collabor ate directly with development teams to review database code, enforce architecture best practices, and proactively prevent performance degradati
Requirem
- ents5+ y ears of professional experience as a Microsoft SQL Server DBA or Database Special
- ist.Expert-Level SQL Mas tery: Proven expertise in dissecting, troubleshooting, and rewriting highly complex SQL stored procedu
- res.Tech S tack: Deep technical command of SQL Server Enterprise Edition (2019 V.15.0.44 0
- .1).Advanced Eng lish: Fluent written and spoken English proficiency, with the ability to clearly articulate technical issues to stakehold
- ers.Ownership Min dset: Strong autonomy, proactive problem-solving skills, and the resilience to handle high-pressure scenarios with minimal guida
Nice to
- HavePrior experience in the Automotive ind ustry or data-heavy logistics sec
- tors.Exposure to cloud database migrations (e.g., AWS RDS SQL S erver or Azure SQL Managed Ins
- nce).Experience with third-party monitoring and tuning tools (e.g., Re dgate, SolarWinds Database Performance Ana ly
- zer).Familiarity with database automation and scripting via Power S
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
