Specialist - Product Development

Job Description

About the Role We are seeking an experienced Senior MSSQL Developer with 3+ years of professional database development experience to lead our database initiatives. In this role, you will be responsible for designing, implementing, and optimizing enterprise-grade database solutions that support our Angular frontend and Spring Boot backend applications. You will serve as the subject matter expert for all database-related activities and mentor junior team members while establishing best practices for database development. Key Performance Indicators Architect and implement 2-3 complex database solutions per quarter with 98% requirements fulfillment Improve overall database performance by 35% within first year Reduce database-related production incidents by 40% year-over-year Achieve 99.9% database availability through proper design and maintenance Implement data governance standards resulting in 100% compliance with data regulations Lead at least 5 knowledge transfer sessions per quarter on database best practices Responsibilities Design and architect sophisticated database solutions for enterprise applications Lead database modeling efforts ensuring scalability, performance, and data integrity Develop and maintain complex stored procedures, functions, triggers, and views Implement advanced performance tuning techniques for high-volume, mission-critical databases Design and develop database security architecture including encryption, access control, and audit trails Create and maintain comprehensive database documentation including data dictionaries and ERDs Establish database coding standards, patterns, and best practices for the development team Develop and implement database migration strategies with minimal downtime Collaborate with application developers to optimize database integration with Spring Boot backend Mentor junior database developers and provide technical guidance Analyze and troubleshoot complex database performance issues Design and implement database monitoring solutions and preventative maintenance procedures Evaluate and recommend database technologies and tools to improve development efficiency Qualifications Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience) 3+ years of professional MSSQL development experience with progressively increasing responsibilities Proven track record of designing and implementing at least 5 enterprise-grade database solutions Experience optimizing database systems processing 1M+ transactions daily Demonstrated ability to reduce query execution time by 50%+ for complex operations Experience leading database projects and mentoring junior developers Strong understanding of database security principles and implementation Excellent analytical and problem-solving skills Effective communication skills for both technical and non-technical stakeholders Technical Skills Required : Advanced Microsoft SQL Server expertise (2016 or later versions) Expert-level T-SQL programming including complex stored procedures, CTEs, and dynamic SQL Proficiency with database performance tuning, query optimization, and execution plan analysis Experience with database high availability solutions (AlwaysOn, clustering, mirroring) Advanced indexing strategies and statistics management Database security implementation including row-level security and data masking Experience with SSIS, SSRS, and SSAS Proficiency with database version control and deployment methodologies Good to Have : Working knowledge of Spring Boot and Java for backend integration Familiarity with Angular or modern front-end frameworks Experience with Hibernate or other ORM frameworks Understanding of microservices architecture Experience with cloud database solutions (Azure SQL) Knowledge of NoSQL database technologies Measurable Achievements Expected in First Year Design and implement a comprehensive database monitoring solution reducing incident response time by 60% Architect at least 3 major database modules supporting new business initiatives Implement query optimization strategies resulting in 40% overall performance improvement Establish automated testing procedures for database changes with 95% code coverage Develop and document company-wide database standards and best practices Create a mentoring program for junior database developers Implement database security enhancements achieving 100% compliance with industry regulations