10.0 - 14.0 years

0 Lacs

pune, maharashtra

On-site

As a Senior T-SQL Developer with over 10 years of experience, you will be responsible for supporting mission-critical, transactional data systems for a global US-based bank. Your expertise in SQL Server performance optimization and database design will be crucial in maintaining scalable, secure, and compliant database environments in the banking and financial services industry. You will design and develop robust T-SQL objects such as stored procedures, functions, triggers, and complex queries, utilizing joins, CTEs, and window functions. Your role will involve analyzing and optimizing slow-running queries using execution plans, performance statistics, and indexing strategies. Participating in database schema design, applying normalization principles, defining relationships, and suggesting indexing for performance based on access patterns will also be part of your responsibilities. Your deep knowledge of transactions, locking, isolation levels, and deadlock resolution will be essential in implementing reliable and consistent transaction logic. You will utilize tools like SQL Server Management Studio (SSMS), DMVs, Activity Monitor, and Query Store for performance monitoring and troubleshooting. Additionally, you will conduct code reviews, enforce SQL coding standards, and collaborate with cross-functional teams to ensure the delivery of high-quality, secure SQL code. Your must-have skills include expert-level T-SQL programming, strong query optimization abilities, solid understanding of schema design and data modeling, and experience with SQL Server monitoring tools. Your proven track record of peer collaboration and delivering production-ready code in high-compliance environments, particularly in the banking/finance sector, will set you up for success in this role. While not mandatory, nice-to-have skills for this position include exposure to Azure SQL or Azure Synapse Analytics, familiarity with CI/CD for SQL, experience with SQL unit testing frameworks, exposure to monitoring tools like Redgate or SentryOne, basic knowledge of SSIS/SSRS/SSAS for ETL and reporting, and an understanding of data security and compliance practices such as SOX and GDPR. If you are a technically deep professional who thrives in a regulated, performance-sensitive ecosystem and can contribute independently to both development and optimization, this Senior T-SQL Developer role in Pune (Hybrid) may be the perfect fit for you.,

Posted 1 week ago

Apply

Senior SQL Server Developer Hallmark Healthcare

7.0 - 11.0 years

9 - 13 Lacs

Hyderabad

Work from Office

Key Responsibilities: Design, develop, and maintain complex stored procedures, functions, views , and business logic using T-SQL. Analyze and optimize existing T-SQL code for performance, scalability, and maintainability. Conduct code reviews of legacy SQL components and implement performance improvements. Create and maintain optimized database schemas , with proficiency in normalization and denormalization techniques . Perform root cause analysis and troubleshooting of issues related to query performance, deadlocks, blocking, and long-running transactions . Utilize tools such as SQL Server Profiler, Execution Plans, Extended Events, DMVs, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor for performance tuning and diagnostics. Collaborate with application teams to design efficient data access patterns and support scalable architectures. Ensure data security through proper user roles, permissions, encryption techniques, and secure development practices. Document database designs, stored procedures, and troubleshooting steps in a clear and standardized format. Stay current with the latest SQL Server features and best practices, recommending adoption where relevant. Develop and maintain error and event handling mechanisms, including precedence constraints, breakpoints, checkpoints, and logging. Experience working with data archival , job scheduling, and integration with legacy systems. Required Qualifications: Minimum 7 years of experience as a SQL Server Developer. Expert-level knowledge of T-SQL programming , stored procedures, and performance optimization. Strong understanding of SQL Server internals , including indexing strategies, transaction management, and execution plans. Proficient in performance analysis and tuning using Profiler, Execution Plans, Extended Events, and DMVs . Solid grasp of database security principles, including access control and encryption. Proven experience working with large and complex T-SQL codebases . Ability to write logical, efficient, and scalable SQL code . Comfortable working independently as well as part of cross-functional teams. Strong troubleshooting and analytical skills. Experience working with Azure SQL Database or other cloud-based deployments. Preferred Qualifications: Experience with CI/CD pipelines for managing database deployments. Familiarity with version control systems for database code (e.g., Git, Redgate SQL Source Control). Domain experience in healthcare or workforce management platforms is a plus. Experience with creating, populating, and maintaining data marts , with strong knowledge of data warehousing structures , including Star and Snowflake schemas .

Posted 2 weeks ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.