Senior Software Engineer - Microsoft SQL Developer

15 hours ago

Apply Now

Receive Emails with Similar Jobs

Upland Software

WebsiteLinkedInAll Job Openings

Knowledge Management • Contact Center Productivity • Cloud Fax • Account-Based Selling • Digital Marketing

1001 - 5000

💰 $115M Post-IPO Equity on 2022-07

Description

• Design, develop, maintain and optimize SQL Server databases for RightAnswers Knowledge Management application. • Implement ETL processes to support data integration and business intelligence needs. • Analyze complex datasets and provide insights to stakeholders through effective querying and reporting. • Manage database performance, including query tuning, indexing strategies, and resource optimization. • Ensure database availability, scalability, and disaster recovery through effective monitoring and maintenance. • Collaborate with software development teams to ensure database designs align with application requirements. • Troubleshoot and resolve database-related issues, including application performance bottlenecks. • Work with support and cloud teams to troubleshoot and triage customer production database issues when needed. • Stay updated with the latest SQL Server technologies and recommend upgrades or changes when appropriate.

Requirements

• 5+ years proficiency in Microsoft SQL Server development and administration (2016 and above preferred). • Minimum of 5 years’ experience in T-SQL programming, including writing and optimizing complex queries, triggers and procedures. • Hands-on experience with ETL tools like SSIS and reporting tools. • Expertise in database performance tuning, including indexing, query optimization, and execution plans. • Knowledge of database design principles, including normalization, data modeling, and partitioning. • Knowledge of SQL Server administration tasks such as backups, restores, user permissions, and server configurations. • Familiarity with high-availability configurations (e.g., Always On, Clustering, Replication). • Knowledge of scripting languages (e.g., PowerShell) for automating administrative tasks.