Oracle and SQL Database Administrator

2 Openings
- Bayan Lepas

**Role 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
- 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, Patching

**About UST**:
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.