SQL Developer

Job Description

Experienced Senior MS SQL Database Developer with 3-5 years of expertise in designing, developing, and optimizing complex database solutions. Adept at performance tuning, data modelling, and managing enterprise-scale databases. Strong analytical thinker with excellent problem-solving skills and a proven ability to lead database teams, mentor junior developers, and collaborate with cross-functional stakeholders.

What are we looking for in you?

• Database Development: MS SQL Server (2012/2014/2016/2019)
• Programming & Scripting: T-SQL, Stored Procedures, Functions, Triggers
• Database Optimization: Indexing, Query Performance Tuning, Execution Plans
• ETL & Data Integration: SSIS, Bulk Data Load, CDC, Replication
• Reporting & BI: SSRS, Power BI, Data Warehousing
• Cloud & Automation: Azure SQL Database, Automation using PowerShell
• Security & Compliance: Role-Based Access, Encryption, GDPR, HIPAA
• Team & Project Management: Agile/Scrum methodologies, Mentoring Junior Developers, Stakeholder Communication
• Complex DBA Tasks: High Availability (HA), Disaster Recovery (DR), Clustering, Always On Availability Groups
• Problem Solving & Analytical Thinking: Root Cause Analysis, Troubleshooting Database Bottlenecks, Performance Tuning Strategies

Requirements

• Design and develop high-performance SQL databases with optimized indexing and partitioning strategies.
• Write and optimize complex T-SQL queries, stored procedures, and triggers for maximum efficiency.
• Perform query tuning, indexing strategies, and execution plan analysis to improve performance.
• Develop ETL pipelines using SSIS to extract, transform, and load data from various sources.
• Implement database security measures including encryption, role-based access control, and compliance with industry standards.
• Work closely with developers, business analysts, and leadership to support application development and data analytics needs.
• Lead database development teams, mentor junior developers, and provide technical guidance on SQL best practices.
• Manage database deployments, upgrades, and maintenance, ensuring high availability, disaster recovery, and business continuity.
• Solve complex database performance and scalability issues using deep analytical and problem-solving skills.
• Automate database tasks using PowerShell and other scripting tools to improve efficiency.