SQL Server DBA/Architect

Everscale Group; Ciudad de México; Presencial; MXN 400,000 - 600,000; Jornada completa

Descripción de la vacante

Una empresa innovadora busca un DBA/Arquitecto de SQL Server para liderar la administración y diseño de bases de datos. En esta emocionante posición, serás responsable de garantizar el rendimiento óptimo y la seguridad de las bases de datos, colaborando con equipos de TI para implementar soluciones de alta disponibilidad y recuperación ante desastres. También jugarás un papel clave en la monitoreo y optimización del rendimiento de las bases de datos. Si tienes pasión por la tecnología y un fuerte enfoque en la mejora continua, esta es la oportunidad perfecta para ti.

Formación

• Experiencia comprobada como DBA de SQL Server con comprensión sólida de la administración.
• Conocimientos en seguridad de datos y cumplimiento de normativas.

Responsabilidades

• Administrar bases de datos SQL Server para un rendimiento y seguridad óptimos.
• Diseñar e implementar soluciones de alta disponibilidad y recuperación ante desastres.

Conocimientos

Administración de bases de datos SQL Server

T-SQL scripting

Monitoreo y optimización del rendimiento

Resolución de problemas

Comunicación efectiva

Educación

Licenciatura en Ciencias de la Computación

Licenciatura en Tecnología de la Información

Herramientas

SQL Server

Azure SQL Database

Herramientas de monitoreo de rendimiento

Descripción del empleo

The SQL Server DBA/Architect role is a full-time position responsible for the administration, design, and architecture of SQL Server databases. The job involves ensuring optimal performance, security, and availability of databases, collaborating with various IT stakeholders, and implementing high availability and disaster recovery solutions. The DBA/Architect will also play a key role in monitoring and tuning database performance and maintaining comprehensive documentation.

Responsibilities:

1. Database Administration:
   Manage and administer SQL Server databases for optimal performance and security.
   Implement backup and recovery strategies and conduct regular testing.
2. Database Design and Architecture:
   Design and implement database architecture based on business requirements.
   Collaborate with application developers to ensure efficient database utilization.
3. Security and Compliance:
   Implement and maintain database security protocols and ensure compliance with regulations.
   Conduct security audits and implement corrective measures.
4. High Availability and Disaster Recovery:
   Design and implement solutions for high availability and disaster recovery.
   Regularly test backup and recovery procedures.
5. Performance Monitoring and Tuning:
   Monitor database performance and optimize through tuning and query optimization.
   Recommend hardware and software upgrades for performance improvements.
6. Collaboration and Communication:
   Work closely with IT teams for seamless integration of database systems.
   Provide technical guidance and support to junior DBA staff.
   Communicate effectively with stakeholders to gather requirements.
7. Documentation:
   Create and maintain comprehensive documentation for database configurations and procedures.
   Develop and enforce database standards and best practices.

Qualifications:

1. Bachelor’s degree in computer science, Information Technology, or related field.
2. Proven experience as an SQL Server DBA with a strong understanding of database architecture and administration.
3. In-depth knowledge of SQL Server features, including replication, clustering, and Always On availability groups.
4. Proficiency in T-SQL scripting for automation and maintenance tasks.
5. Experience with performance monitoring tools and troubleshooting techniques.
6. Familiarity with data security and compliance standards.
7. Strong problem-solving skills and the ability to work independently or collaboratively.
8. Excellent communication and interpersonal skills.

Preferred Qualifications:

1. Microsoft Certified: SQL Server certification
2. Experience with cloud database services (e.g., Azure SQL Database).
3. Knowledge of other database systems (e.g., MySQL, Oracle).
4. Familiarity with DevOps practices and tools.