Sr Staff Software Development Engineer (DB)

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.

Key Responsibilities:

• 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.

Required Skills & Experience:

• 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.