Primary 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.
Requirement
- 8+ 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