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