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 global 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. Security and Compliance
• Security Management: Implement and audit security policies, access management (ACLs, roles), and data encryption (data at rest and in transit) to meet corporate security and compliance standards.
• RCA and Reporting: Thoroughly investigate and provide detailed Root Cause Analysis (RCA) reports for major incidents, including timeline and clear counter-measures for management and clients.
• Vendor and Stakeholder Management: Effectively manage relationships with technical Vendors and HQ teams regarding database support, licenses, and emerging technologies.
Essential daily functions
• Managing and maintaining the Client’s databases
• Perform daily checklist to ensure proper database health.
• Comply with security standards.
• Ensure database backup is being completed and aligned with client’s policy
• Identifying, installing and maintaining upgrades to the database infrastructure.
• Troubleshooting and repair.
• Develop and implement strong database management using techniques and effective methodologies.
• Participate in the maintenance of the various database instances.
• Developing a backup/disaster recovery plan for a database emergency.
• Planning database infrastructure for new applications and services.
• Incident attention and resolution according to SLA's.
• Provide information for monthly report on database status to Clients.
• Open and follow services request with Vendor or HQ if needed.
• Developing and managing service level agreements (SLA) for the database environment
• Responsible for providing backend support for the development and testing environments for database systems, as well as other production databases and new projects.
• Manage the processes for Cloning, Refreshing, Patching, Backups, Purges, etc.
Descripción
Requerimientos
Required Competencies and Technical Skills
We seek a database professional who combines deep technical mastery with leadership and influencing skills (Staff IC mindset).
A. Deep Technical Knowledge (Must-Have)
• Multi-Engine Mastery: Demonstrated advanced experience in administration, tuning, and troubleshooting of SQL Server, Oracle, and Tibero.
• NoSQL Databases: Familiarity or experience with NoSQL technologies (e.g., MongoDB, Cassandra, Redis).
• Automation and Scripting: High proficiency in T-SQL, PL/SQL, and shell scripting or Python/PowerShell for operational automation tasks.
• HA/DR Technologies: Practical experience with High Availability technologies such as SQL Server Always On, Oracle Data Guard, or clustering.
B. Soft Skills and Technical Leadership
• Self-Directed Learning: Strong ability to independently learn new technologies (cloud, automation) and adapt to methodological changes.
• Project Leadership: Proven ability to take ownership of complex database projects from design (architecture) through to final implementation.
• Strategic Communication: Superior verbal and written communication skills to articulate complex technical issues (e.g., RCAs, capacity risks) to technical staff, management, and clients in a professional manner.
• Crisis Management: High sensitivity and demonstrated ability to remain calm and effective under emergency and high-pressure situations.
• Accountability: Strong sense of urgency and accountability for all database-related tasks and deliverables.
Cargando ofertas similares...