Database Administrator

Industrias Hunter, S. de R.L. de C.V.; Tijuana; Presencial; MXN 1.029.866 - 1.373.155; Jornada completa

Descripción de la vacante

A technology firm located in Tijuana is seeking a Database Administrator responsible for maintaining and supporting database environments. The ideal candidate should have at least 5 years of experience with Microsoft SQL Server in a production environment, including backup, recovery, and performance tuning. Familiarity with cloud platforms is preferred. This role offers opportunities to collaborate with cross-functional teams and ensure robust data services for business operations.

Formación

• Minimum of 5 years of experience administering Microsoft SQL Server databases.
• Experience with cloud database services such as Azure SQL and AWS RDS is preferred.

Responsabilidades

• Administer and support Microsoft SQL Server databases including maintenance.
• Monitor database health and performance; establish performance baselines.
• Implement backup/restore processes and perform recovery testing.
• Coordinate maintenance windows and follow change management practices.

Conocimientos

Microsoft SQL Server administration

T-SQL scripting

Database troubleshooting

Database security best practices

HA/DR concepts

Windows Server fundamentals

Networking concepts

Change management

Incident management

Oracle Fusion

Educación

Bachelor's degree in business, computer science, or MIS

Descripción del empleo

Overview

The Database Administrator is responsible for administering, maintaining, and supporting the company’s database environments. This role helps ensure database availability, performance, security, backup/recovery, monitoring, and documentation for on-premises and cloud platforms (e.g., Microsoft Azure and Amazon Web Services). The DBA partners with application, infrastructure, and analytics teams to deliver reliable, scalable data services that support business operations and reporting.

Responsibilities

1. Administers and supports Microsoft SQL Server databases including configuration, patching, and routine maintenance.
2. Provisions and configures database instances (on-prem and cloud) and maintain standard configurations, jobs, and schedules.
3. Implements and validates backup/restore processes; perform recovery testing and support disaster recovery procedures.
4. Monitors database health, performance, and capacity; establish baselines and tune queries and indexes using execution plans and DMVs.
5. Assists with database upgrades, migrations, refreshes, and decommissions; coordinate maintenance windows and follow change management practices.
6. Supports high availability components (e.g., Always On availability groups, clustering, replication) and participate in failover testing as assigned.
7. Implements and maintain database security controls including access management, least-privilege, encryption, auditing, and vulnerability remediation.
8. Maintains monitoring/alerting and operational documentation; respond to incidents, troubleshoot issues, and escalate appropriately.
9. Partners with development teams to support deployments, review schema changes, and troubleshoot application/data issues in on-prem and cloud architectures.
10. Automates repeatable operational tasks using scripting (PowerShell/T-SQL) and contribute to standard runbooks and operational improvements.

Qualifications

Education/Training Required and Preferred:

Bachelor’s degree in business, computer science, or MIS or a combination of education and relevant work experience.

Experience Required and Preferred:

Minimum of 5 years of experience administering and supporting Microsoft SQL Server databases in a production environment, including backup/recovery, performance tuning, and troubleshooting availability and connectivity issues. Exposure to cloud database services and tooling (e.g., Azure SQL, Managed Instance, AWS RDS) preferred.

Knowledge, Skills and Abilities (KSA's) Required and Preferred:

1. KSA #1: Working knowledge of Microsoft SQL Server administration (configuration, security, maintenance, monitoring).
2. KSA #2: Proficiency with T-SQL for troubleshooting, indexing, and performance analysis.
3. KSA #3: Ability to troubleshoot database issues (performance, availability, connectivity) using execution plans, DMVs, logs, and monitoring tools.
4. KSA #4: Knowledge of database security best practices (least privilege, encryption, auditing, patching, role-based access).
5. KSA #5: Familiarity with Windows Server fundamentals and basic networking concepts (DNS, ports, firewalls, certificates).
6. KSA #6: Understanding of HA/DR concepts (Always On, clustering, replication) and ability to follow runbooks for recovery/failover activities.
7. KSA #7: Ability to collaborate cross-functionally and communicate technical information clearly (written and verbal).
8. KSA #8: Working knowledge of change management and incident management practices; ability to document procedures and keep runbooks current.
9. KSA #9: Ability to work outside regular business hours as needed for maintenance windows and on-call support.
10. KSA #10: Knowledge of Oracle Fusion.