MS SQL Developer

Summary

Join Upland Software as a Senior MS SQL Database Developer and leverage your 8+ years of experience in designing, developing, and optimizing SQL Server databases. You will be responsible for supporting critical applications and ensuring database system stability, integrity, and performance. Responsibilities include designing and maintaining high-performing databases, troubleshooting queries, optimizing performance, and collaborating with development and infrastructure teams. You will also develop and enforce database standards, implement ETL processes, and support database deployments. Proficiency in T-SQL, performance tuning tools, and database security is crucial. The role requires experience with backup/restore, replication, and high availability configurations.

Requirements

• 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 PlansSQL ProfilerExtended EventsDynamic 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

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

Preferred Qualifications

• 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