Oracle DBA

Job Title: Oracle DBA Job Location: London, UK Job Type: Open for Perm/Contract/FTC (Duration 1 year) 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 rachana@falconsmartit.com