TECHNO FUNCTIONAL CONSULTANT L1

Required Skills & Experience

Core Oracle DBA Skills (10+ Years)

• 10+ years of hands-on experience in Oracle Database Administration
• Expertise in Oracle Database versions 11g, 12c, 19c, and higher
• Strong experience in database installation, configuration, upgrades, migration, patching, and maintenance
• Hands-on experience with Oracle RAC, ASM, Data Guard, and RMAN
• Expertise in performance tuning, SQL tuning, and query optimization
• Experience with backup, recovery, disaster recovery, and high-availability solutions
• Knowledge of Oracle database security, user management, auditing, and compliance requirements

Oracle Exadata Administration (5-6 Years)

• 5-6 years of hands-on experience administering Oracle Exadata environments
• Experience managing Exadata storage cells, compute nodes, and InfiniBand networks
• Expertise in Exadata performance tuning and optimization
• Experience with Exadata patching, upgrades, and health monitoring
• Strong understanding of Smart Scan, Storage Indexes, Hybrid Columnar Compression, and Exadata-specific features

Oracle GoldenGate (5-6 Years)

• 5-6 years of experience implementing and supporting Oracle GoldenGate
• Experience configuring real-time database replication and synchronization
• Expertise in GoldenGate installation, upgrades, troubleshooting, and performance tuning
• Experience in heterogeneous and homogeneous database replication environments
• Ability to monitor and resolve replication latency and data consistency issues

Responsibilities

• Manage and administer Oracle database environments across production, DR, and non-production systems
• Perform database installation, upgrades, patching, migrations, and cloning activities
• Monitor database performance and proactively resolve issues
• Maintain Oracle Exadata infrastructure and optimize system performance
• Configure and support Oracle GoldenGate replication environments
• Manage Oracle Enterprise Manager for monitoring and alerting
• Implement backup, recovery, and disaster recovery strategies
• Ensure database security, compliance, and data integrity
• Develop automation scripts for routine DBA activities
• Collaborate with application, infrastructure, and support teams to resolve production issues
• Participate in 24x7 on-call support and critical incident management

Mandatory Skills

Oracle DB Infra Consulting Experience: 5-8 Years

Pay

The expected compensation for this role ranges from $60,000 to $135,000. Final compensation will depend on various factors, including your geographical location, minimum wage obligations, skills, and relevant experience.

Benefits

• Full range of medical and dental benefits options
• Disability insurance
• Paid time off (inclusive of sick leave)
• Other paid and unpaid leave options