Oracle DBA

FalconSmartIT; Greater London; On-site; GBP 70,000 - 90,000; Full time

Job summary

A leading IT firm in the United Kingdom seeks an experienced Oracle Database Administrator to design, manage, and optimize databases. The ideal candidate will have over 7 years of experience in Oracle database administration and PL / SQL development, specifically with Oracle 21c on RDS. They should possess excellent communication skills and the ability to lead and mentor a team of DBAs. Responsibilities include tuning databases, managing backups, and ensuring security policies are in place. This role offers the opportunity to work with cloud services like AWS.

Qualifications

• 7+ years of experience in Oracle database administration and PL / SQL development.
• Advanced proficiency in PL / SQL with complex stored procedures.
• Strong understanding of PL / SQL best practices.

Responsibilities

• Design and create Oracle databases with appropriate parameters.
• Perform database performance tuning and optimization.
• Manage database backup and recovery using Oracle tools.

Skills

Oracle database administration

PL / SQL development

Database performance tuning

Cloud services (AWS)

Leadership

Tools

Oracle Data Pump

Oracle 21c

Job description

Role Overview

We are seeking an experienced Oracle Database Administrator (DBA) who will be responsible for designing, creating, and managing Oracle databases. The ideal candidate will have a deep understanding of PL / SQL and its application in large-scale database environments. They should be able to efficiently manage, optimize, and refactor thousands of stored procedures while ensuring code quality and performance.

Excellent business communication skills and leadership experience are essential for this role.

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.

Required Skills and Qualifications

• 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.

Additional Requirements

• Ability to write clear and concise technical documentation for PL / SQL procedures.
• Experience with Oracle 21c features relevant to PL / SQL development.
• Knowledge of SQL tuning and optimization techniques to complement PL / SQL skills.
• Familiarity with DevOps practices for database code management and deployment.

Regards,

Rachana

[e-mail]