Data Engineer - Database Admin (Distributed databa...

Responsibilities

• Establishes configuration standard and design guideline for database software, covering availability, performance, resilience, monitoring, backup and recovery functional areas.
• Provides technical assistance to development team and operation teams for database systems.
• Troubleshoot and drive system recovery. Escalate problems with actual or potential major impact to problem management and IMS management. Performs root cause analysis and ensure planned actions are carried out to prevent recurrence.
• Ensures the supportability of database software systems. Plans and leads upgrade projects.
• Reviews and approves change requests. Supervise execution for major change
• Conducts performance analysis and tuning
• Automates system operation
• Tracks and drives patch management for all database software. Track, plan and drive software upgrades to ensure continuous supportability.
• Establish backup and recovery procedures
• Perform regular access review and validation.
• Establishes adequate monitoring to ensure efficient and reliable service delivery
• Apply new technology and process to improve system supportability, recoverability, availability and performance.
• Provides operational excellence and skills on databases to support various project phases (requirement gathering, design, procurement, implementation and hand-over to operations).
• Provides technical guidance and mentoring to help develop less experienced engineers.
• Supports audit and compliance activities.

Technical Competencies

• Operating Systems (AIX/Solaris/Linux/Windows)
• Databases (Oracle/DB2/MariaDB)
• Scripting (Shell/Perl/Puppet)
• 2-6 years of production support experience as Oracle DBA or MariaDB
• Demonstrable experience of managing high-performance, high-capacity databases in a critical production environment.
• Distributed Databases
• Experience on, Linux including strong shell scripting skills.
• Excellent troubleshooting, diagnostic & analytical skills.
• Strong initiative and sense of ownership.
• Expert knowledge of database scripting and automation technology