Contact Us 877.823.3669

SQL Database Architect in Orlando, FL at SNI Technology

Date Posted: 5/17/2018

Job Snapshot

Job Description

Responsibilities and Duties

  • 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

Qualifications and Skills

  • Bachelor's degree in Computer Science or equivalent.
  • In-depth knowledge of standard concepts, practices and procedures related to database management
  • Required 8 years solid experience with Microsoft SQL Server 2008 R2 and above. Must know SQL inside and out.
  • Required 8 years T-SQL language (queries, views, procedures)
  • Required 8 years SQL Server Database Design, Stored Procedure Design and implementation
  • 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 Profiler 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)