10 ago
|
Hyundai Autoever Mexico
|
Pesquería
10 ago
Hyundai Autoever Mexico
Pesquería
Database Administrator
Descripción
Propose of the position
The Database Administrator (DBA) is a key member responsible for ensuring the reliability, performance, and security of the company's critical database ecosystem. This role drives the strategy, design, and implementation of complex data solutions, from on-premise to cloud environments, ensuring alignment with integral HQ standards and client SLAs. The DBA acts as the primary technical expert for query optimization, capacity planning, and proactive incident resolution (Root Cause Analysis - RCA).
Core Responsibilities
This role is the technical owner of the Database Lifecycle (DBLC) and focuses on three primary areas:
A. Reliability and Operations Management (SRE Focus)
• Ensure Availability (HA/DR): Design, implement, and maintain High Availability (HA) and Disaster Recovery (DR) architectures, including failover, replication, and clustering strategies for SQL Server, Oracle, Tibero, and NoSQL systems.
• Automation: Develop and maintain scripts (T-SQL, PL/SQL, Python)
and tools to automate routine tasks such as maintenance, patching, provisioning, cloning, and data refreshing.
• Preventive Maintenance: Lead the execution of daily checklists and standardized maintenance plans covering backups, log purging, and indexing, verifying the daily health of the database environment.
• Incident Management: Provide 2nd and 3rd-level support for database incidents, adhering strictly to defined Service Level Agreements (SLAs).
B. Performance and Optimization
• Query Tuning: Proactively analyze and optimize SQL queries, stored procedures, and data models to maximize application performance and throughput.
• Advanced Monitoring: Implement monitoring tools to establish visible metrics and alerts on latency, resource utilization, and query execution plans.
• Capacity Planning: Conduct data trend analysis and capacity planning to manage storage growth and hardware requirements for mission-critical systems.
C. Sec
📌 Database Administrator (Pesquería)
🏢 Hyundai Autoever Mexico
📍 Pesquería