Job Title: Senior MS SQL Database Developer
Experience Required: 8+ Years
Location: Remote
Employment Type: Full-Time
We are seeking a highly skilled and experienced MS SQL Database Developer with over 8 years of hands-on experience in designing, developing, and optimizing SQL Server databases. The ideal candidate will have deep expertise in writing complex T-SQL queries, stored procedures, performance tuning, and troubleshooting database-related issues. You will be responsible for supporting critical applications and ensuring the stability, integrity, and efficient performance of our database systems.
Responsibilities:Design, develop, and maintain high-performing SQL Server databases, tables, stored procedures, functions, and views.
Analyze, troubleshoot, and optimize slow-running queries and stored procedures using execution plans and SQL Profiler.
Monitor and fine-tune database performance (indexing, partitioning, statistics updates, etc.) to ensure optimal response time and resource usage.
Perform root cause analysis of database issues and proactively prevent performance bottlenecks and outages.
Collaborate with application developers and infrastructure teams to design efficient data models and support application needs.
Develop and enforce database standards, best practices, and procedures.
Implement and maintain ETL processes and data transformation scripts.
Support database deployments, migrations, and patching with minimal downtime.
Create and maintain documentation on database architecture, configurations, and procedures.
8 years of experience working as a SQL Server Developer (MS SQL Server 2016 and above).
Strong proficiency in writing and optimizing complex T-SQL queries, stored procedures, triggers, and functions.
Extensive experience with performance tuning and troubleshooting tools such as:
Execution Plans
SQL Profiler
Extended Events
Dynamic Management Views (DMVs)
Strong knowledge of indexing strategies, query optimization techniques, and database locking behavior.
Experience with backup/restore, log shipping, replication, and high availability configurations.
Familiarity with SSIS for ETL workflows and data integration.
Understanding of database security, role-based access, and auditing.
Proficient in source control tools (e.g., Git) and CI/CD processes for database deployments.
Microsoft Certified: Azure Database Administrator Associate or similar certifications.
Experience with Power BI or other reporting tools.
Exposure to Azure SQL, Synapse, or other cloud-based data solutions.
Strong communication and documentation skills.
Experience working in Agile/Scrum environments.
Company Link : https://uplandsoftware.com/
