Trabajo de DBA Developer / SQL Server en Hireline, Jalisco - México en EmpleosTI.com.mx

DBA Developer / SQL Server

SUMMARY

We are a Platform-as-a-Service (PaaS) in the direct sales industry at our company, we've built out a cloud-based Software-as-a Service (SaaS) platform from the ground up. We've been in business for over a decade and serve millions of users daily.

  

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 DMV’s 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 but not required, as you will be working directly with the Principal DBA to help offset the existing workload as we offer database performance tuning services to our external clients. 

 

Duties & Responsibilities:

  • Monitor databases on-prem and in Azure 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 on-prem servers and a large Azure 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:

  • 5+ 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 DMV’s 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
  

Preferred Skills:

  • Some experience with Azure SQL DB (DaaS) is preferred
  • Experience with .Net coding so you can review embedded SQL in web code.