Oracle Database Administrator

Job Description

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 for L2 Ops (Database Specialist) who has proven track record in IT Industry. This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance. More details as below.

L2 Ops (Database Specialist)

Work Mode: Hybrid, 2-3 days work from office

Shift: night shift

Location: Pasay City

Responsibilities:

• Database Housekeeping: Perform regular maintenance tasks to ensure database systems (MS SQL, Oracle, PostgreSQL, MySQL, DB2) are clean, organized, and running efficiently.

• Change Implementation: Implement changes to database configurations, schemas, and settings as required.

• Incident Resolution: Respond to and resolve database-related incidents promptly to minimize downtime and impact.

• Problem Resolution: Investigate and resolve recurring database issues to improve system stability and performance.

• Installation & Database Creation: Install database software and create new databases as needed.

• Database Administration: Manage and maintain database systems, ensuring their reliability, availability, and performance.

• User Management: Manage database user accounts, permissions, and roles.

• Database Patch Management: Apply patches and updates to database systems to ensure they are up-todate and secure.

• Database Space Management: Monitor and manage database storage to ensure optimal space utilization.

• Cluster Administration (RAC): Administer and manage database clusters, including Oracle Real

Day-to-Day Operations:

• Monitoring: Continuously monitor database systems (MS SQL, Oracle, PostgreSQL, MySQL, DB2) for performance, availability, and security issues using relevant monitoring tools.

• Incident Management: Respond to and resolve database-related incidents and outages.

• Maintenance: Perform regular maintenance tasks such as backups, patching, and upgrades.

• Change Management: Implement changes to database configurations and settings as required.

• User Support: Provide support to database users, including troubleshooting and resolving access issues.

• Reporting: Generate reports on database performance, incidents, and capacity planning.

Basic Qualifications:

• At least 3 years of experience in database technologies: MS SQL, Oracle, PostgreSQL, MySQL, DB2 in a global enterprise environment.

• Strong knowledge of SQL and database administration.

• Familiarity with automation tools and scripting languages: Python, Bash.

• Ability to work in a 24x7 on-call after hour rotation environment.

• Relevant experience with following products is a plus; InnoDB and MyISAM storage engines, SSIS, SSAS, and SSRS.

• Experience with database monitoring tools: such as Oracle Enterprise Manager, SQL Server Management Studio, pgAdmin, MySQL Workbench, IBM Data Studio.

• Understanding of backup and recovery strategies.

• Knowledge of database security best practices.

• Experience with cluster administration, including Oracle RAC.

• Relevant certifications: Oracle Certified Professional, Microsoft Certified: Azure Database Administrator, etc.

• Familiarity with ITSM like ServiceNow

• High school or equivalent diploma

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 : Seema Verma

Avensys Consulting Pte Ltd

EA Licence 12C5759

Privacy Statement:

We take your personal data protection seriously and adhere to both EU and local data protction regulations.

Upon submission of your CV, you grant Avensys Consulting permission to retain your personal information in our electronic database, unless you specify otherwise. This data will be used to evaluate your suitability for current and potential job openings within our organization. Should you wish to have your personal data removed at any point, a simple notification to us will suffice.

Rest assured, we will not disclose your personal information to any third parties, and we remain steadfast in our commitment to providing equal opportunities to all applicants.