Trabajo de Programador T-SQL para Base de Datos en Hireline, Jalisco - México

Programador T-SQL para Base de Datos

Mexican Company founded over 20 years ago with more than 2000 employees in Mexico, expanding in USA and Europe is looking to grow its development team to redo the existing technology platform.

We are looking for someone with strong experience in reviewing new and existing T-SQL code for performance enhancements. You will work with developers but also analyze SQL and reports to find resource intensive code that requires index tuning or rewrites in order to run efficiently on resource constrained infrastructure. A DBA background is preferred as you will be working directly with another DBA to help offset the existing workload as we offer database performance tuning services.

Duties & Responsibilities:

  • Monitor databases to gather resource consuming queries
  • Review SQL Server code including adhoc queries, views, stored procedures, functions and triggers for modernization and performance improvements
  • Determine and apply appropriate indexes for new and existing queries
  • Help manage SQL Server 2017 servers and a large SQL DB environment
  • Review alerts and remediate any issues that may arise from blocking, deadlocks and poorly performing code
  • Ability to take calls on a 24x7 basis as first level DBA support (rare occurrence)

Skills & Requirements:

  • 3+ years of SQL Server code development & general administration
  • Excellent analytical and problem-solving skills, think outside the box
  • Strong experience with indexing concepts & code tuning techniques
  • General understanding of High Availability technologies (Always On, Replication, etc.)
  • General understanding of SQL Server and monitoring
  • Outstanding verbal and written communication skills
  • Ability to learn and apply new technologies and concepts quickly
  • Strong ability to manage multiple competing priorities