Principal Oracle DBA Consultant

Nexttec Technology Outsourcing; Riyadh; On-site; SAR 350,000 - 520,000; Full time

Job summary

Nexttec Technology Outsourcing seeks a Principal Oracle DBA Consultant to lead and optimize client Oracle databases, design robust schemas, implement backup strategies, and guide junior DBAs.

You will monitor performance, perform patches, manage RAC/Data Guard, and stay current with Oracle features. Excellent communication and on-call readiness are required.

Qualifications

• Bachelor's degree in Computer Science, Information Technology or related field.
• Minimum of 8 years of experience as an Oracle DBA.
• Proficient with Oracle 12c/19c and Oracle Enterprise Manager.
• Ability to patch, upgrade, backup and restore databases.
• Experience with RAC, Data Guard, RMAN backups and recovery.
• Knowledge of SQL/PLSQL tuning using AWR/ASH.
• Experience with monitoring tools and documenting DB policies.
• DB migration across various OSs.
• Knowledge of security parameter settings; able to work in fast-paced environments.
• Strong communication and collaboration skills; on-call availability.

Responsibilities

• Provide technical leadership in managing and optimizing Oracle databases for clients.
• Work with clients to understand business needs and tailor database solutions.
• Design, implement and maintain database structures and schemas.
• Monitor performance and adjust configurations for optimal operation.
• Troubleshoot issues and implement backup/recovery strategies.
• Develop and implement training and support for junior DBAs.
• Keep accurate documentation of configurations, procedures, and standards.
• Stay updated with latest Oracle technologies and trends.

Skills

Oracle DBA

RAC/Data Guard

RMAN backups

SQL/PLSQL tuning

OEM monitoring

Exadata management

GoldenGate

OCI ExaCS / DBaaS

Oracle security settings

Patching & upgrades

Performance tuning (AWR/ASH)

On-call availability

Education

Bachelor's degree in Computer Science/IT

Tools

Oracle Enterprise Manager

GoldenGate

OCI ExaCS

Job description

Position: Principal Oracle DBA Consultant

Company Overview:

Nexttec Technology is a leading outsourcing company that provides innovative and cutting-edge solutions to businesses worldwide. We specialize in providing technology solutions to help our clients achieve their goals and stay ahead in the competitive market. Our team is made up of highly skilled and experienced professionals who are passionate about delivering exceptional service to our clients.

Position Overview:

We are seeking a highly skilled and experienced Principal Oracle DBA Consultant to join our team. As a Principal Oracle DBA Consultant, you will be responsible for providing technical expertise and guidance to our clients in managing and optimizing their Oracle databases. You will work closely with our clients to understand their business needs and provide customized solutions to meet their database requirements.

Key Responsibilities:

• Provide technical expertise and guidance in managing and optimizing Oracle databases for our clients
• Work closely with clients to understand their business needs and provide customized solutions to meet their database requirements
• Design, implement and maintain database structures and schemas
• Monitor database performance and make necessary adjustments to ensure optimal performance
• Troubleshoot and resolve database issues in a timely manner
• Develop and implement backup and recovery strategies
• Conduct regular database maintenance and upgrades
• Stay updated with the latest Oracle database technologies and trends
• Provide training and support to junior DBAs and other team members
• Collaborate with other team members and departments to ensure seamless integration of database solutions with other systems
• Keep accurate documentation of database configurations, procedures, and processes
• Participate in project planning and provide input on database requirements and timelines

Qualifications:

• Bachelor's degree in Computer Science, Information Technology or related field
• Minimum of 8 years of experience as an Oracle DBA
• Knowledge in Oracle versions 12c and 19c and Oracle Enterprise Manage.
• Ability to perform Oracle patches and upgrades along with backup and restoration
• Knowledge of high availability (RAC), standby (Data Guard), and backup and recovery (RMAN)
• Experience tuning SQL and PL/SQL using AWR, ASH.
• Experience with Database Monitoring tools. Also documenting database policies, procedures, and standards
• Experience DB migration between various OSs.
• knowledge of Oracle security parameter settings.Ability to work in a fast-paced environment, good multi-tasking and time management skills.
• Excellent communication skills within groups and teams.
• Ability to provide off-hour support and on-call required.
• Strong communication and interpersonal skills.
• Ability to manage/monitor databases via OEM.
• Knowledge of Database Vault & Audit Vault, DB firewall, and encryption Wallets.
• Knowledge of Golden Gate installation & monitoring, performance tunning.
• Strong Knowledge of Instance & SQL tuning, analysing AWR / ASH / ADDM, SQL tuning skill extract execution plan & fix slow queries.
• Exadata management.
• Knowledge of OCI EXACS. DBAAS, etc .
• Knowledge of ZDLA is a plus
• Supler cluster management is a plus

Why Work with Us?

• Competitive salary and benefits package
• Opportunity to work with a diverse range of clients and industries
• Collaborative and supportive work environment
• Professional development and growth opportunities
• Access to the latest technologies and tools
• Opportunity to make a significant impact and contribute to the success of our clients