Database Administrator

Auxis; Bogotá; Presencial; COP 120.000.000 - 180.000.000; Jornada completa

Descripción de la vacante

Auxis is seeking a skilled Database Administrator to maintain and optimize client databases, ensure security, data integrity, and reliable operations. You will design, implement, monitor, and tune databases, leveraging MS SQL, Azure SQL, and related cloud services to support data-driven applications across environments.

The role requires hands-on experience with clustering, high availability, and Always On configurations, plus 24x7 on-call duties and ongoing process improvements.

Formación

• 6+ years in large-scale MS SQL Server environments.
• 2 years with Azure SQL Database and/or AWS RDS and/or MS Dataverse.
• Experience in clustering, HA, and Always On.
• Cloud-based services experience in heterogeneous environments.
• On-call rotation participation

Responsabilidades

• Administer databases for efficiency, security, and integrity.
• Monitor health and performance of systems.
• Ensure high performance and availability.
• Manage backup schedules and monitor for issues.
• Test recovery procedures periodically.
• Optimize queries via T-SQL, indexes, partitioning, and other techniques.
• Provide 24x7 support for production systems.
• Mentor team members and drive automation opportunities.

Conocimientos

MS SQL Server

Azure SQL Database

AWS RDS

MS Dataverse

High Availability / Always On

24x7 on-call support

Educación

Bachelor's in Computer Science / Engineering / IT

Azure Data Engineer Associate

Herramientas

Azure Monitor SQL Insights

Dynamic Management Views

Descripción del empleo

Job Summary

As a Database Administrator (DBA), you will play a critical role in maintaining, optimizing, and securing Auxis’ client databases. Your responsibilities will encompass database design, implementation, monitoring, performance tuning, security management, and data integrity assurance. Your expertise will contribute to the efficient operation of data-driven applications and ensure the availability and reliability of crucial business information.

Job Summary

As a Database Administrator (DBA), you will play a critical role in maintaining, optimizing, and securing Auxis’ client databases. Your responsibilities will encompass database design, implementation, monitoring, performance tuning, security management, and data integrity assurance. Your expertise will contribute to the efficient operation of data-driven applications and ensure the availability and reliability of crucial business information.

Responsibilities

• Administer databases regarding efficiency, security, and system integrity.
• Monitor the system's health and performance.
• Ensure high levels of performance and availability.
• Ensure that all database backup schedules are implemented and monitored for issues.
• Test database recovery procedures periodically.
• Optimize query performance through TSQL improvements, indexes, partitioning, and other techniques.
• Optimize use of operational resources.
• Provide 24x7 support for critical production systems.
• Manage complex technical problems.
• Oversee the compliance of Auxis operating processes.
• Maintain technical expertise in MS SQL technologies.
• Maintain awareness of current and future technologies and best practices relevant to operations.
• Act in a mentoring capacity to other team members.
• Make recommendations on performance improvement and automation opportunities to improve operations.

Skills And Experience

EXPERIENCE:

• 6+ years’ experience in large-scale MS SQL Server environments, supporting several clients.
• Desirable: 2 years’ experience with Azure SQL Database and/or AWS RDS and/or MS Dataverse.
• Experienced in Clustering Services, High Availability, and Always On configurations.
• Proven experience with cloud-based services and shared operations in heterogeneous environments.
• Participate in 24x7 on-call support rotation.

EDUCATION:

• Computer Science, Engineering, IT bachelor's degree or equivalent work experience
• Azure Data Engineer Associate.

TECHNICAL SKILLS:

• Excellent understanding of Azure SQL with proven experience with performance monitoring, analysis, and tuning of relational databases. This includes the use of T-SQL, Query Store, hints, Dynamic Management Views, Azure Monitor SQL Insights, indexes, statistics, and query plan analysis.
• Excellent knowledge of database backup and recovery.
• Familiarity with database design, documentation, and coding, clustering, and replication.
• Knowledge of client-server applications.
• Knowledge of ITIL.

DESIRED TECHNICAL PROFICIENCIES:

• Azure Database Administrator Associate.
• AWS Certified Database – Specialty.

LANGUAGE SKILLS:

• English Level B2+