Job Description
This role entails providing expertise in Linux system administration and Oracle database management within the Information Technology department while also serving as a liaison to the software development team. The ideal candidate will be a seasoned Senior DBA with experience managing databases exceeding 1TB in a highly available Production environment. Primary responsibilities will include environment setup, production support, and overseeing software upgrade deployments in the production environment.
Core Responsibilities and Expertise ( including the following other duties may be assigned). :
- Oracle Enterprise Linux Administration:
- Installs, configures, and maintains Oracle Enterprise Linux (OEL) environments, ensuring secure, stable, and optimized performance.
- Database Installation and Management:
* Installs Oracle software, creates and configures databases, and maintains database instances.
* Develops and manages database objects, user accounts, roles, and security policies.
- Backup, Recovery, and Disaster Management:
* Designs and implements reliable backup and recovery processes using tools such as RMAN and Data Guard.
* Actively participates in the disaster recovery process to ensure business continuity.
- Performance Tuning and Optimization:
* Conducts in-depth Oracle database performance analysis, system sizing, and capacity planning.
* Continuously tunes and optimizes database performance, including stored procedures and dynamic SQL, leveraging Oracle-specific features.
* Performs ongoing analysis, refactoring, and tuning of OLTP/DSS schemas to ensure high performance.
- Standards, Best Practices, and Leadership:
* Develops, enforces, and communicates Oracle database standards, procedures, and best practices.
* Provide senior-level technical leadership to the DBA team and act as a lead DBA for critical projects.
- Technical Support and Troubleshooting:
* Provides DBA and Linux system administration support across multiple applications in test and production environments.
* Diagnoses, troubleshoots, and documents database issues efficiently to minimize downtime.
* Assists the support team in diagnosing and resolving performance problems in customer production environments.
- Mentoring and Developer Collaboration:
* Mentors application developers on designing high-performance, scalable data models and optimizing interactions with persistence layers.
* Specifies, designs, and implements load tests and performance diagnostic tools to identify bottlenecks and improve system performance.
- Project Management and Multi-tasking:
* Manages multiple projects concurrently and adapts to shifting priorities while ensuring timely completion.
* Participates in on-call rotations and is available for off-hours and weekend support during upgrades, maintenance, or troubleshooting.
- Cross-Platform Database Support:
* Provides support for multiple database platforms, ensuring consistent performance, security, and stability across environments.
- Experience as Oracle EBS Database Administrator
- Experience with upgrading, patching, and maintaining Oracle EBS applications.
- Experience with Oracle WebLogic, Concurrent Manager, and Workflow administration is a plus.
- Familiarity with Linux/Unix administration for Oracle EBS environments.