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.
