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