Position: Applications Database Administrator
Job Description
The APPS DBA will be responsible for database system administration and support. The DBA will be required to assist application team on databases system implementation setup maintenance support and troubleshooting application database related issue for clients.
To provide effective and efficient delivery of infrastructure projects services and database administration support to customers. Support development team on PL/SQL programs and Shell Scripting.
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.
- 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
Application DBA with Plsql experience