Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.
We are currently looking to hire Applications Database Administrator. This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance. More details as below.
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
WHAT’S ON OFFER:
You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.
To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to [email protected] Your interest will be treated with strict confidentiality.
CONSULTANT DETAILS: Consultant Name :Jyotsana Madnani
Avensys Consulting Pte Ltd EA Licence 12C5759
Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy.
