Oracle Database Administrator

Apply for Oracle Database Administrator at Kalsoft in Muscat, MA, OM. This full‑time on‑site position offers great opportunities for career growth.

Position:
Oracle Database Administrator

Location:

Onsite – Oman
Eligibility:
Omani Nationals Only

Experience:

12+ Years

Employment Type:

Full‑Time (Contractual)

• Ensure 24x7 availability, reliability, and performance of Oracle database environments supporting critical business applications.
• Design, implement, and maintain disaster recovery (DR) solutions to minimize downtime and ensure business continuity.
• Configure and manage high‑availability solutions including Oracle Data Guard, Active Data Guard, Oracle Golden Gate, Oracle RAC, and clustered database environments.
• Plan, implement, and administer Oracle RAC, Active‑Passive clustering, and enterprise database architectures.
• Develop and execute comprehensive backup and recovery strategies using RMAN, Data Pump (expdp/impdp), and operating system‑based backups.
• Automate backup, monitoring, and maintenance activities using RMAN scripts, cron jobs, Bash, Perl, or other scripting tools.
• Perform database restoration and recovery with minimal impact during system failures or disaster scenarios.
• Administer database security including users, roles, privileges, profiles, auditing, resource management, and database hardening.
• Monitor database environments proactively, identify performance bottlenecks, and implement tuning for SQL, PL/SQL, memory, storage, I/O, and network performance.
• Install, configure, upgrade, patch, and maintain Oracle Database software across multiple versions.
• Manage Oracle ASM, table spaces, data files, storage structures, and capacity planning activities.
• Perform database performance analysis, troubleshooting, and optimization for enterprise‑scale applications.
• Support large‑scale database migration, replication, data movement, and upgrade initiatives using Oracle Data Pump, Streams, SQL
  * Loader, Transportable Table spaces, and related technologies.
• Collaborate with application architects, infrastructure teams, and developers to support database design, optimization, and deployment.
• Design and maintain database objects including tables, indexes, views, sequences, packages, procedures, functions, and clusters.
• Develop and maintain technical documentation covering database architecture, configurations, installation procedures, migration plans, and operational standards.
• Create performance testing plans, establish test environments, and support production deployments.
• Provide proactive operational support, database monitoring, incident management, and on‑call support for enterprise production environments.

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related discipline.
• Minimum 12+ years of hands‑on experience in Oracle Database Administration within enterprise environments.
• Extensive experience managing Oracle Database versions including 8i, 9i, 10g, 11g, 12c, and 18c or later.
• Minimum 7+ years of experience administering Oracle Data Guard, Active Data Guard, and Oracle Golden Gate environments.
• Minimum 5+ years of experience implementing and managing Oracle RAC, clustered databases, and high‑availability solutions.
• Strong expertise in RMAN backup and recovery, disaster recovery planning, backup automation, and database restoration.
• Solid experience with Oracle ASM, OCFS, clustered file systems, storage management, and capacity planning.
• Advanced knowledge of SQL and PL/SQL performance tuning, execution plans, indexing strategies, and query optimization.
• Strong understanding of Oracle database security, auditing, user management, resource management, and database hardening.
• Experience with scripting languages such as Bash, Perl, or Shell scripting for database automation and monitoring.
• Hands‑on experience with database replication, distributed databases, data migration, and large‑scale data movement.
• Experience working with Oracle Cloud, AWS, Microsoft Azure, or other cloud database platforms will be an added advantage.
• Strong knowledge of Data Warehousing concepts including ETL, OLAP, Cubes, schema design, analytics, and query optimization.
• Exp…