Specialist - Product Development

Role Overview: As a Senior MSSQL Developer with 3+ years of professional database development experience, you will lead database initiatives by designing, implementing, and optimizing enterprise-grade solutions supporting Angular frontend and Spring Boot backend applications. Your expertise will be crucial in ensuring database performance, scalability, and data integrity while mentoring junior team members and establishing best practices for development. Key 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 Additional Company Details: (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,