Oracle Database Administrator

Location : Lahore,

Job Summary :

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. The candidate will participate in the On-Call rotation, troubleshoot problems and take appropriate corrective actions. He / she will keep the managers / team leaders informed of the progress and issues and collaborate with team members and application partners. A strong background in Oracle Database administration and security, ability to work independently and with teams in a fast-paced environment is a must.

Responsibilities :

Key Accountabilities :

• 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
• Disk and File Management
• Responsible for monitoring and alerting on all the Oracle databases
• Log Management
• Database Lifecycle management (LCM)
• Run & maintain hardening scripts
• Perform disaster recovery, backup and restore activities
• 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.
• Periodic system performance, capacity & resource management
• Review & own technical documentation ensure compliance and accuracy in all documents
• Proven problem solving and analytical skills
• Result driven with a positive can-do attitude
• Excellent collaboration and negotiation skills
• Highly team oriented
• Proficient in monitoring tools – Oracle OEM, SolarWinds & Nagios a plus

Education and Experience :

Skills and Behaviors :