Upland Software - MS SQL Developer

Job Title: Senior MS SQL Database Developer
Experience Required: 8+ Years
Location: Remote
Employment Type: Full-Time

Job Summary:

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.

Required Skills:

• 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.

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.

• Company Link : https://uplandsoftware.com/