Database Administrator / Database Build Engineer

Job Description:

Functionally reports to the Service Build Engineering Lead under Group Infrastructure Platform Services, the Build engineer will be responsible for detail design, build, post provision support and continuously optimize and automate the end-to-end build and provisioning process in accordance to the bank standard.

This role will support and collaborate with Design, planning, solution architect, application and Development teams on infra build requirements, standards and the use, optimization and troubleshooting of all features in Oracle, SQL and Maria database & its tools.

This role will participate in technical discussions to share ideas and provide feedback in continuing the improvement of the Service Build Engineering team in areas such as Optimization, automation, cost savings, technology adoption & operational efficiency.

Key Responsibilities

Oracle/SQL/ MariaDB Database software installation, upgrades and maintenance

Resolve build issues with database or related third party products

Take initiatives to enhance current workflow and process

Maintain database security & compliance and ensure Database is Hardened

Manage project timeline and issue remediation efforts

Take care of DB Performance Tuning, Query Optimization during build phase

Monitor and troubleshoot Oracle & SQL Server related CPU, memory, I/O, disk space and other resource contention.

Strong experience of backups, restores, recovery models, database shrink operations, DBCC commands

Handle project queries promptly, meet deadlines and co-ordinate with multiple infra teams effectively

Should be willing to take up any role in the team when need comes without any hesitation

Key Requirements

Min. 5 years of experience in installation and setup from scratch of various versions of Oracle Database & Microsoft SQL Server is a MUST.

Strong understanding of Database architecture

Proven skills and experience in setting up HA/DR solution for Oracle (RAC, DG & ADG) and SQL Server (Always ON)

Knowledge in Operating Systems like windows and Unix

Experience in raising Technical SR with Oracle/ Microsoft in case of any issues/bug fixes

Strong Experience of RMAN, expdp/impdp

Experience in evaluating and installing new software releases and patches

Experience in developing and executing database security policies, procedures

Must take initiatives to automate manual Database work

Able to document all the process and checklists clearly and keep them up to date

Proven skills and experience in managing complex problem solving and incident management related to Oracle DB and Microsoft SQL Server

Ability to work in a team

Excellent communication and mail writing skills

Added Advantage

Knowledge and Experience in MariaDB is an added advantage

Experience and Knowledge in Powershell/Shellscripting is a plus

Experience and Knowledge in Server Virtualization is a plus

Cloud knowledge is preferred