Oracle Database Administrator

Summary: The Oracle Database Administrator role involves designing, creating, and managing Oracle databases, with a focus on performance tuning, security, and collaboration with development teams. The position requires extensive experience in PL/SQL development and database administration, particularly in an Oracle 21c environment. The role also includes mentoring junior developers and leading a team of DBAs to ensure efficient database operations. Strong communication skills and the ability to align database solutions with business needs are essential for success in this position.

Key Responsibilities:

• Design, create, and configure Oracle databases including setting appropriate database parameters.
• Perform database performance tuning and optimization to ensure high availability and efficiency.
• Manage database backup and recovery using Oracle tools and utilities.
• Utilize database tools such as Data Pump for export/import operations.
• Monitor database health and troubleshoot issues proactively.
• Implement and manage database security policies and user access controls.
• Work with cloud services, specifically AWS S3 for storage and AWS RDS for managed database instances.
• Develop, maintain, and optimize complex PL/SQL stored procedures in a large-scale Oracle 21c environment.
• Implement best practices for PL/SQL development, including code organization, error handling, and performance optimization.
• Refactor and modernize existing PL/SQL code to improve efficiency and maintainability.
• Collaborate with development teams to design and implement database logic using PL/SQL.
• Create and maintain documentation for PL/SQL procedures and packages.
• Perform code reviews and mentor junior developers in PL/SQL best practices.
• Collaborate with development, infrastructure, and business teams to align database solutions with business requirements.
• Lead and mentor a team of DBAs and coordinate tasks to ensure smooth database operations.
• Communicate effectively with stakeholders, providing updates, reports, and recommendations.

Key Skills:

• Extensive experience (7+ years) in Oracle database administration and PL/SQL development (ideal skill is DBA on Oracle 21c on RDS).
• Advanced proficiency in PL/SQL, including complex stored procedures, functions, and packages.
• Strong understanding of PL/SQL best practices, such as using consistent naming conventions and code formatting.
• Implementing proper error handling and exception management.
• Utilizing modular design principles for maintainable code.
• Optimizing PL/SQL performance through efficient coding techniques.
• Experience managing large-scale PL/SQL codebases with thousands of stored procedures.
• Expertise in PL/SQL debugging and troubleshooting techniques.
• Proficiency in version control systems for managing PL/SQL code.
• Excellent business communication and interpersonal skills.
• Demonstrated leadership abilities and experience managing a team.
• Problem-solving mindset with attention to detail and ability to work under pressure.

Salary (Rate): £300/DAY

City: Wimbledon

Country: UK

Working Arrangements: undetermined

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT