Job Description

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.

• 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

Jobline Resources