Job Description:
The DBA will be responsible for database system administration and support. The DBA will be required to assist application team on databases system implementation, setup, maintenance, support and troubleshooting application database related issue for clients.
To provide effective and efficient delivery of infrastructure projects, services and database administration support to customers.
Responsibilities:
- Responsible to provide Oracle, OGG, MS SQL Server, Maria DB administration and support for projects/clients.
- Create, document, and implement standards and/or complex modelling to monitor and enhance the capacity and performance of the database.
- Coordinating with customers and application project managers for database infrastructure implementation and setup as per application requirements.
- Responsible to plan, schedule, track and coordinate with project manager, application support for database system version upgrade and database server patches.
- Manage, design, and implement database backup and recovery procedure for database recovery. Implement monitoring for database backup.
- Assist application team to troubleshoot application/database related issues. Manage and coordinate with vendors to provide database support for the customers.
- Provide SIT, UAT and Production database application installation, setup, and support.
- Manage and configure the database backup and day to day operations.
Knowledge and Skills:
- 5-10 years’ database administration experience of MS SQL Server & support on Windows/Azure environment.
- 1-2 years’ database experience in installation, configuration, and setup of MariaDB and MS SQL HADR AG Failover Cluster instances & Peer-peer Replication.
- Knowledge or/and experience on Oracle Database, Oracle Exadata, OGG, MySQL, PostgreSQL, MongoDB & Cloud DB Environment models (DBaaS) will be an advantage.
- Experience on Oracle & MS SQL Server database security hardening, monitoring, and capacity planning.
- Ability to coordinate with customer, application project managers & vendors on database infrastructure setup and installation.
- Ability to work under pressure, meet tight deadlines and a commitment to maintain optimum database system availability for customer.
- Strong customer focus with emphasis on commitment to continuous improvement in database system availability and performance
- Ability to work independently and exemplify good working integrity in a team.