Oracle Database Administrator

TalentHue - IT & Corporate Recruitment; Lahore; On-site; PKR 2,500,000 - 5,200,000; Full time

Job summary

TalentHue - IT & Corporate Recruitment is seeking a senior Oracle Database Administrator to support infrastructure and customer-facing applications. The role covers operations, upgrades, monitoring, and design of Oracle environments, including RAC, ASM, and Exadata-oriented setups.

10+ years of experience, Bachelor’s in a related field, and strong scripting and performance tuning skills are required. The position involves coordination with infrastructure teams and adherence to security and SOPs.

Qualifications

• 10+ years of experience in Oracle database administration and operations.
• Advanced knowledge of Oracle Database 12c and 19c configurations and protocols.
• Expert level experience in Oracle RAC, ASM, RMAN and OEM.
• Strong understanding of OCI and Exadata environments.
• Experience with SAN storage technologies and backups.
• Scripting skills in shell (ksh or similar).
• Ability to manage multiple projects, priorities and resources.

Responsibilities

• Initiate and coordinate Oracle DB upgrades across Linux, Unix and Windows.
• Monitor databases, optimize performance, disk and memory usage; document issues and actions.
• Design, maintain, and document Oracle DB configurations and layouts.
• Build and support new logical partitions using Power VM virtualization.
• Lead annual upgrades and patching for related core databases and application servers.
• Troubleshoot DB issues within SLA; provide KPI data and trend analyses.

Skills

Oracle DBA

Shell scripting

Project coordination

Team collaboration

Education

Bachelor's degree in CS/related

Tools

Oracle RAC

ASM

RMAN

OEM

SolarWinds

Nagios

Job description

Follow us on LinkedIn to get job related updates.

5,700

A leading children apparel retailer in USA having its stores all over the globe.

Role Introduction

The Oracle Database Administrator for Infrastructure team will perform Oracle database Administration for the Customer facing and corporate applications. He/she will provide strong operational support to the internal applications as well as Infrastructure teams.

Requirements

• Initiate, plans, coordinates Oracle Database system upgrades on Linux, Unix and Windows environments
• Manages and supports the core systems that include administrative tasks such as monitoring databases as well as application performance, disk and memory usage, log, and database and application assignments; identifies and documents potential issues, prepares necessary corrective and preventative action plans
• Design, maintain, and document Oracle Database configurations/layouts
• Build and support new lpars (logical partitions) using Power VM virtualization
• Responsible for annual upgrades and patching on additional related core databases including but not limited to application servers
• Troubleshooting Oracle database issues within agreed SLA. Provide data and reporting of KPI’s and trends in ad-hoc, weekly, monthly and as sought.
• Develop standard operating procedures and best practices, including written policies and protocols that guide to database administration staffing and vendors.
• Installation, configuration and remediation of various security software on the Database environments
• Configuration and Administration of Oracle RAC, ASM, stand-alone instances
• Responsible for monitoring and alerting on all the Oracle databases, run & maintain hardening scripts.
• Work under minimal super vision & take ownership of Oracle incidents end to end
• Assists application and database teams with data purges, data archival, backups and restorations.
• Review & own technical documentation ensure compliance and accuracy in all documents

Specifications

• 10+ years of experience in operations and project management of Oracle database administration
• Bachelor's in related technology/business areas
• Advanced knowledge of Oracle Databases version 12 and 19c and their configuration and protocols, terms and concepts.
• Expert level experience in Oracle RAC, ASM, RMAN and OEM.
• Excellent understanding of OCI and Exadata.
• Excellent understanding of SAN storage technologies.
• Experience with writing shell scripts in ksh or any other scripting language.
• Ability to adapt to established standards and practices.
• Ability to manage several projects concurrently, assess priorities, and allocate resources.
• Exposure to Rubrik enterprise backup solutions
• Exposure to Microsoft SQL Server, Postgres or DB2 is a strong plus.
• Exposure to SAP Hana, AWS Redshift or MongoDB is strongly preferred.
• Oracle Cloud/ amazon AWS hands on & experience in transitioning infrastructure into various global cloud hosting providers a plus.
• Proficient in monitoring tools – Oracle OEM, SolarWinds & Nagios a plus

Expertise

Skills: ASM , AWS Redshift , DB2 , Microsoft SQL , MongoDB , Oracle Cloud , Oracle RAC , Postgres , RMAN And OEM , SAN Storage Technologies OCI And Exadata , SAP Hana , VM Virtualization

About TalentHue

TalentHue provides scalable, reliable Tech Recruitment, Corporate Recruitment and Consulting (Strategy, Operations, Performance) services. Our Recruitment and HR consultants will work alongside your team to meet the unique needs of your business.

About TalentHue

TalentHue provides scalable, reliable Tech Recruitment, Corporate Recruitment and Consulting (Strategy, Operations, Performance) services. Our Recruitment and HR consultants will work alongside your team to meet the unique needs of your business.