Senior T-SQL Developer for Enterprise Banking Systems | Remote Position

Are you a seasoned T-SQL Developer seeking to leverage your expertise in mission-critical financial environments? We're recruiting an experienced Senior T-SQL/MS SQL Developer to join our team working on a significant banking project. Your database engineering proficiency will be instrumental in designing robust solutions that power enterprise-scale financial operations. Key Responsibilities - Architect and implement sophisticated database solutions according to business and technical requirements. - Perform thorough system analysis of business requirements, verifying compatibility with existing system architecture. - Develop complex stored procedures, functions, and views using advanced T-SQL techniques. - Integrate developed solutions into the enterprise system performance monitoring framework. - Adhere to and enhance Continuous Integration procedures for database deployments. - Design and execute comprehensive unit testing protocols, developing automated test suites. - Conduct in-depth analysis of existing codebase, database architecture, relationships, and constraints. - Optimize SQL queries to achieve maximum performance in high-transaction banking environments. - Engineer methodologies to improve the execution efficiency of MS SQL queries. - Create detailed technical documentation for database infrastructure and integration solutions. - Collaborate with cross-functional teams to align database solutions with business objectives. Required Skills and Experience - 5+ years of hands-on experience implementing business logic at the DBMS level. - Extensive practical experience in T-SQL development for enterprise applications. - Advanced proficiency with MS SQL Server 2019-2022 environments and features. - Comprehensive understanding of MS SQL Server principles: data storage structures, indexing strategies, statistics management, transaction processing, isolation levels, and locking mechanisms. - Demonstrated expertise in query performance tuning and execution plan analysis. - Strong background in database architecture design and optimization techniques. - Experience with version control systems for database code management. - Ability to write clean, maintainable, and well-documented code. - Excellent analytical problem-solving skills with meticulous attention to detail. Nice to Have - Experience with MS SQL Server Reporting Services (SSRS) for financial reporting. - Proficiency with SQL Server Integration Services (SSIS) for ETL processes. - Familiarity with SQL Server Analysis Services (SSAS) for data analytics. - Background in banking or financial services industry projects. - Knowledge of data warehouse design and implementation. - Experience with Query Store for performance monitoring. - Expertise in Intelligent Query Processing capabilities. - Understanding of Always Encrypted security features. - Familiarity with cloud-based database solutions (Azure SQL, AWS RDS). - Microsoft SQL Server certifications. Why Join Our Team When you work with us, you'll be at the forefront of database technology in the financial sector, implementing solutions that impact millions of banking transactions daily. We provide a fully remote work environment with flexible scheduling, competitive compensation, and the opportunity to solve complex challenges alongside skilled professionals. You'll have access to continuous learning resources and the chance to expand your expertise with cutting-edge database technologies. If you're passionate about database engineering and ready to apply your T-SQL mastery to solve sophisticated banking challenges, we're eager to connect with you.