Key Responsibilities:
- Manage and administer Oracle databases (versions 12c, 19c, and newer) in production and development environments.
- Perform advanced database performance tuning, query optimization, and index management.
- Design and implement high availability (HA), disaster recovery (DR), and backup strategies (RMAN, Data Guard).
- Automate routine database tasks using PL/SQL, Shell scripting, or Ansible.
- Apply patches, perform upgrades/migrations (on-prem and cloud), and manage version control.
- Implement and enforce database security, roles, and user access controls.
- Monitor database health and proactively identify and resolve potential issues.
- Provide L3 support for escalated incidents and lead root cause analysis.
- Collaborate with development, infrastructure, and DevOps teams to support application and system integration.
- Participate in on-call rotation and support weekend deployments when necessary.
- Document architecture, configurations, and procedures for audit and knowledge transfer.
Requirements
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 6 years of hands-on Oracle DBA experience with at least 3 years in a senior/L3 role.
- Expertise in Oracle, ASM, RMAN, Data Guard, and GoldenGate.
- Strong knowledge of Oracle internals, performance diagnostics (AWR, ASH, TKPROF), and troubleshooting tools.
- Experience with cloud platforms (OCI, AWS RDS for Oracle, or Azure Database for Oracle).
- Familiarity with ITIL processes and incident/change/problem management.
- Scripting experience (Shell, Python, or similar) for automation and monitoring.
- Excellent communication skills and the ability to work in a high-pressure environment.
- Willing to Learn SAP HANA
Avatar Techno Services Pte Ltd. is a Consulting and Solution Provider company in the Information Technology Industry, specialized in providing sound, secure and cost-effective IT solutions to Small & Medium enterprises thereby empowering and accelerating their growth.
Incorporated in 2019, Avatar Techno Services was initially under the banner of ILC Pte Ltd., providing IT Consulting services in Singapore to a handful companies in Singapore and overseas.
Within a short-span, we have grown from simple operation providing mono-service, to a team of dedicated staff, each of which is a professional in its own field.
We have a solid reputation in the technology industry for providing excellent services to our clients. Our values are represented by our integrity, thought leadership, and commitment to maintaining a high-level of excellence in the constantly evolving world of Information Technology. We strive to build a long-lasting relationship with our customers and client satisfaction is our key performance indicator. We take pride in becoming a preferred partner for most of our clientele.
Growing over the years with our maturity in service and excellence, we progress with a clear vision of brilliance in IT.
Avatar Techno Services provides customers consulting, integration, and implementation services and specialized in bringing business process capabilities, industry experience, and solution & market expertise that can help our clientele to deploy IT solutions, maximize functionality, and rapidly achieve Return on Investment