Trabajo de MS SQL DBA en Nice, Jalisco - México

MS SQL DBA

Somos Nice De México estamos expandiendo en México,  USA y Europa y estmos formando un equipo de QA, .Net Software Developers y otras posiciones de IT para re hacer la plataforma de tecnología. 

Nice De Mexico is 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