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.