Oracle and SQL Database Administrator

Bayan Lepas, Pulau Pinang
Tetap
Sepenuh masa

6 hari lepas

Job Description:We are seeking an experienced Oracle and Microsoft SQL Server Database Administrator to manage, maintain, and optimize enterprise databases. The role involves installation, configuration, performance tuning, backup & recovery, and ensuring high availability of mission-critical systems.ACCOUNTABILITIES & DAY TO DAY RESPONSIBLITIES

Database Administration
Install, configure, and upgrade Oracle and MS SQL Server databases.
Create and manage database instances, schemas, and security roles.
Perform proactive monitoring, performance tuning, and optimization of database environments.
Backup & Recovery
Implement and maintain backup, restore, and disaster recovery strategies (e.g., RMAN, Always On, Log Shipping, or third-party tools).
Regularly test recovery procedures to ensure business continuity.
Performance & Optimization
Analyse execution plans, indexes, and queries to enhance performance.
Optimize storage and memory usage for efficiency.
High Availability & Replication
Manage clustering, replication, and failover solutions (Oracle RAC, Data Guard, SQL Always On).
Monitor uptime and ensure SLA compliance
Security & Compliance
Apply patches and security updates to maintain compliance with IT policies.
Implement access controls, encryption, and auditing.
Collaboration & Support
Work with development teams to support database design and query optimization.
Provide L2/L3 support for production incidents and troubleshooting.
Documentation & Automation
Maintain proper documentation for processes, configurations, and procedures.
Automate repetitive tasks using scripts or tools

PRE-REQUISITES:
In order to succeed in this role, it is expected that you will have:Knowledge/Experience

Experience in a similar role for 10 to 15 years
A minimum of 10 years of experience in Oracle & 8 years in SQL

Technical/Professional Skills required:

Oracle 12c/19c administration, Data Guard, RMAN, OEM, RACK
SQL Server 2016/2019 administration, Always On, SSIS/SSRS/SSAS.
Strong SQL and PL/SQL or T-SQL scripting skills.
Experience with performance tuning and query optimization.
Knowledge of Linux/Unix and Windows environments.
Familiarity with cloud platforms (Azure, AWS, or OCI).

Qualifications

Education: Bachelor’s degree in Computer Science, Information Technology, or related field.

KNOWLEDGE, SKILLS, AND EXPERIENCE REQUIRED

10 to 15 years experience as a DBA with both Oracle and SQL Server environments.
Hands-on experience with database upgrades, migrations, and patching.

Key Performance Indicators (KPIs)

Database uptime and SLA adherence.
Backup success and recovery test results.
Number of performance issues resolved proactively.
Timely completion of maintenance and patching tasks.

Preferred Qualifications

Certifications like Oracle Certified Professional (OCP) or Microsoft Certified: Azure Database Administrator Associate.
Experience with database automation tools or DevOps integration.
Familiarity with NoSQL or cloud-native databases.

Soft Skills

Strong analytical and problem-solving abilities.
Excellent communication and documentation skills.
Ability to work in 24x7 support environment and handle on-call duties.

Skills:Oracle, SQL, RAC, Data Guard, RMAN, OEM, RACK, SQL Server 2016/2019, SSIS, SSRS, SSAS, SQL, PL/SQL, T-SQL, Performance tuning, Linux, Unix, Windows, Database upgrades, Migrations, PatchingAbout Company:UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.

UST

Memohon