Database Administrator - Ciudad de México - Solera

Solera

Empresa verificada

Ciudad de México

hace 1 semana

Publicado por:

Rodrigo Fernández

Reclutador de talento para beBee

Descripción

Who We Are

The Role

This position is responsible for acting as a primary technical resource for the support and administration of SQL Servers in both large scale production and development environments across multiple products.

This position continually evaluates the entire SQL Server topology to identify and create plans to address performance issues, architectural shortcomings, and other opportunities for improvement.

The fundamental goal is to ensure the production environment is always operational and performing optimally. This position requires strong organizational and collaboration skills and partnering with numerous distributed teams is a must for success.

This position is a key resource contributing to the technical growth and development of the SQL DBA team through mentoring and training of other team members.

What You'll Do

Ensure production SQL Servers maintain the company's requirements for HA/DR, Security, and RPO/RTO
Provide oncall support (as part of a rotation) for production alerts or issues both during and outside normal working hours
Provide support during maintenance windows or deployment/release activities
Join warroom calls to triage and troubleshoot outages as they occur, including afterhours and weekends
Build and improve automation around configuring and administering SQL Servers
Optimize performance of SQL Servers and determine the most effective ways to increase performance including hardware purchases, server configuration changes, or index/query changes
Continuous evaluation and implementation of proactive measures to improve performance and stability of SQL Server
Create and maintain procedural and technical documentation
Collaborate with other teams in enterprise level projects and provide support / guidance as needed
Lead assigned quarterly projects from initial concept and drive to successful completion
Identify technical developmental opportunities and provide guidance to Mid and Junior Level DBA team members

What You'll Bring

Bachelor's Degree in Information Systems, Computer Science or related field or related experience

Experience / Requirements:

Experience in large SQL Server environments (8+ years preferred)
Excellent communication and collaboration skills, excellent organizational skills, proven ability to prioritize multiple activities and objectives to thrive in a rapidly changing environment
Ability to write effective technical documentation with attention to detail and accuracy
Familiarity SQL Monitoring and Alerting Management systems
Skilled in SQL Server Data Replication (Transactional, Snapshot)
Indepth knowledge of SQL Server HA and DR features (Always On, Mirroring)
Project Management skills
Ability to manage / maintain ETL & DW processes (SSAS, SSIS, SSRS knowledge)
Oncall troubleshooting within a 24/7 production environment and providing escalation support as necessary
Expert knowledge of SQL Server 2012 and up
Ability to communicate clearly and effectively with various departments such as Engineering, IT Infrastructure, Project Management, etc...
Solid experience with SQL Server in cloud (Azure preferred) and VMware platforms
Agile Methodology familiarity
Experience using PowerShell or other scripting techniques to manage a large environment
Indepth Windows operating system knowledge

Physical Demands (Travel, etc.)

Attend training conferences and sessions that may require travel
While oncall be available by phone 24/7 and be able to get online immediately should an outage occur