Database Management (DBA)

About the Role

Your responsibility as a database administrator (DBA) will be the performance, capacity, integrity and security of a database. You'll be involved in the planning and development of the database with the fit recommendation and technology, as well as in troubleshooting any issues.

Responsibilities / หน้าที่ความรับผิดชอบ

• Installation, upgrades, migrations and configuration of databases.
• Design and build databases, schemas, stored procedures, and other database objects.
• Design backup and recovery strategy based on application requirements (schedule, retention, etc.).
• Maintain database security and integrity following policy and governance.
• Set up routine database backup procedures and disaster recovery procedures.
• Perform database performance tuning and capacity planning.
• Setup monitoring and alerting on database performance, system metrics and trends.
• Maintain and manage the database system in accordance with Service Level Agreements (SLA).
• Support day-to-day operations, incident and change management.
• Assist developers and end-users with database usage, query development, and tuning.
• Provide guidance to junior DBAs and handle advanced database administration tasks (replication, migration, data distribution, etc.).
• Competent to work at the highest level of all phases of database administration.

Qualifications / คุณสมบัติ

• 5+ years experience in Database Administration and related DB software tools management.
• Extensive knowledge of Oracle RDBMS, RAC and Data Guard, and MS SQL Server.
• Knowledge of MySQL, MariaDB and PostgreSQL are advantages.
• Experience working in Azure Data Lake and other RDS/cloud environments.
• Experience with ETL tools (IBM DataStage, MS SSIS) is an added advantage.
• Experienced in Data Warehouse and Big Data design and performance tuning.
• Knowledge of NoSQL (MongoDB), GraphQL (DGraph) and Elastic are advantages.
• Knowledge of in-memory database (Redis) is an added advantage.
• On-call / on-site requirements to ensure 24 x 7 support of database operations.
• UNIX and Windows batch scripting knowledge is mandatory.
• Knowledge of automation frameworks (Jenkins, Terraform, Ansible, Git) are advantages.

Skills / Required Skills

• System software, system architecture and IT infrastructure knowledge.
• Banking and financial domain knowledge.
• Project Management, ITIL Foundation (IT process).
• Coaching skill.