Sr. Database Developers

Other Specification

We are looking for a Senior-level SQL Database Developer who have in-depth experience with Microsoft SQL Server, specifically 2012/2014 and ideally 2016. 

The successful candidate will be an experienced Developer with extensive enterprise background using MS SQL Server. The SQL Database Developer will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries, design and code complex stored procedures, and performance tune existing database processes.

• Bachelor’s degree in Computer Science or equivalent.
• In-depth knowledge of standard concepts, practices and procedures related to database management
• 4+ years of experience in software development, using Microsoft SQL Server 2008 R2, T-SQL, and T-SQL language (queries, views, procedures), SQL Server Database Design, Stored Procedure Design and implementation. Must know SQL inside and out
• Experience coding complex stored procedures (using T-SQL)
• Experience with developing SSIS packages
• Proven analytical problem solving and debugging skills
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profile  and other related monitoring and troubleshooting tools
• Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
• Monitoring performance and managing parameters to provide fast query responses to front-end users
• Familiarity with BI technologies (e.g. Microsoft Power BI)
• Excellent English communications skills (written and verbal)

Job Description

• Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
• Performance tuning the stored procedures and T-SQL
• Assist developers with complex query tuning and schema refinement
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
• Tuning T-SQL queries to improve performance