Upland Software - MS SQL Developer

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.

• 
  

  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.