Responsibilities
- Responsible to provide Oracle Database, MS SQL Server administration and support for projects/clients
- Create database objects (tables, indexes, etc.)
- Write database procedures, functions, and triggers
- Assist developers with database activities
- Tune database queries
- Assist application team to troubleshoot application/database related issues. Manage and coordinate with vendors to provide database support for the customers
- 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
Requirements
- 5+ years’ database administration experience of Oracle RDBMS & support on Solaris/Unix/Linux environment. Knowledge on managing Oracle Golden Gate & MS SQL Servers will be an advantage. Strong in PL/SQL
- Experiences on Oracle databases troubleshooting and maintenance
- Experience on 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
- Experiences on Oracle databases and Oracle Golden Gates troubleshooting and maintenance will be useful
- Experiences in shell scripting
Licence No:12C6060
