Sr Staff Software Development Engineer (DB)

Job Description Summary

This position is responsible for designing highly complex modules, critical components or a whole application/product in its entirety. Has the vision to integrate it across multiple systems. This position works independently and is seen as a technical leader. The position is responsible for driving the design and development efforts related to architecture, scalability, availability and performance in alignment with the product/application roadmap.

Job Description

We are seeking a Sr Staff Database Developer with over 12-15 years of hands-on experience in architecting, developing, and optimizing enterprise-grade database solutions. This senior-level role demands deep technical expertise in SQL Server technologies, a strong strategic mindset, and proven leadership in cross-functional environments. You will serve as a technical authority and mentor, driving high-performance database design, scalable data architectures, and continuous improvement across development and operations.

• Architect, design, and implement highly scalable, secure, and high-performance database solutions that support mission-critical applications.
• Lead initiatives in performance tuning and optimization of complex stored procedures, functions, and database workloads using advanced T-SQL techniques.
• Drive and oversee data and schema modeling strategies, including normalization, partitioning, and advanced indexing for optimal performance.
• Provide strategic guidance on data encryption, security (e.g., Transparent Data Encryption - TDE), and HA/DR solutions including clustering, Always On Availability Groups, and failover strategies.
• Define and enforce best practices for code quality, version control, CI/CD, and collaborative development using tools such as GitHub, SVN, Azure DevOps, etc.
• Lead the design, review, and interpretation of complex business reporting requirements, ensuring data accuracy and performance in large-scale environments.
• Guide data migration strategies including scripting, ETL, and automation for seamless and timely data transitions across environments.
• Oversee the debugging and troubleshooting of complex stored procedures and SQL queries, ensuring optimal runtime and resource usage.
• Provide technical leadership in SQL query analysis, execution plan optimization, and indexing strategies to meet SLAs and performance KPIs.
• Champion cloud migration efforts, with working knowledge of Azure and AWS, and experience supporting hybrid or SaaS-based database architectures.
• Act as a key contributor in cross-functional agile teams, influencing overall architecture and product quality, including testing strategies (functional, regression, stability, and performance).
• Provide mentorship and coaching to junior developers, fostering a culture of innovation, quality, and continuous learning.

• 12-15 years of experience in Microsoft SQL Server and T-SQL programming at an enterprise level.
• Deep expertise in database architecture, performance tuning, and data modeling (both OLTP and OLAP).
• Solid understanding of SQL Server internals, memory and I/O subsystems, and query optimization techniques.
• Experience managing index strategies, file group management, and SQL Agent job orchestration.
• Proven track record of success in collaborative leadership roles, influencing architectural decisions and fostering cross-team alignment.
• Familiar with cloud-based database solutions and deployment models (IaaS, PaaS, containers, etc.).
• Strong communication and documentation skills, capable of engaging both technical and non-technical stakeholders.
• A passion for exploring and evaluating emerging technologies and modern data solutions to solve business challenges.