Senior Oracle Database Developer

Job Description:

The Senior Oracle Database Developer will be responsible for the architectural design, development, and implementation of high-quality database solutions for critical business applications. The ideal candidate will possess advanced knowledge of Oracle database architecture, performance tuning, and SQL development alongside a strong capability in leveraging PL/SQL to build complex database applications. This role demands a keen analytical mindset and innovative problem-solving skills to ensure the secure, efficient, and robust functioning of databases. The Senior Developer will collaborate closely with cross-functional teams to gather requirements and translate them into technical specifications, while also mentoring junior developers and promoting best practices in database development. The candidate is expected to demonstrate leadership in project management, exhibit exceptional communication skills, and maintain compliance with security standards and data governance.

Job Requirements:

• Minimum of 5 years of progressive experience in Oracle database development within a complex enterprise environment.
• Proven expertise in Oracle PL/SQL programming, including writing, optimizing, and debugging stored procedures, functions, and triggers.
• Strong understanding of Oracle Database architecture, including partitioning, data models, and indexing strategies.
• Demonstrated experience in database performance tuning and optimization techniques, ensuring high availability and disaster recovery strategies.
• Familiarity with Oracle E-Business Suite or similar enterprise applications is highly desirable.
• Comprehensive knowledge of data migration strategies, ETL processes, and tools to facilitate data integration.
• Experience working with Agile/Scrum methodologies, demonstrating the ability to manage multiple projects simultaneously in a fast-paced environment.
• Strong analytical skills with the ability to identify database issues and provide innovative solutions.
• Ability to mentor and train junior developers on best practices in database development.
• Proficiency in database security practices and ensuring compliance with data governance frameworks.

Job Responsibilities

• Design, develop, and implement complex database solutions that meet business requirements while ensuring performance and security standards.
• Collaborate with stakeholders to define database requirements and create technical specifications for application development.
• Conduct performance tuning and optimization of SQL queries, stored procedures, and overall database architecture to enhance application performance.
• Lead and participate in database migration and deployment projects, ensuring minimal downtime and adherence to project timelines.
• Provide ongoing support and maintenance for the databases; troubleshoot issues, perform root cause analysis, and implement necessary fixes.
• Document database designs, processes, and procedures to ensure clear communication and knowledge sharing within the team.
• Mentor junior database developers, providing guidance on best practices, code review, and career development.
• Stay updated on the latest Oracle database technologies and industry trends to continue improving the database environment.
• Develop and enforce standards for database design and coding practices, ensuring they align with industry best practices.
• Participate in security audits and compliance checks to safeguard sensitive data, implementing recommendations as needed.

Required Skills

• Extensive experience in Oracle Database development, with proficiency in PL/SQL and SQL query optimization.
• Strong analytical and problem-solving skills to effectively address complex database issues.
• Excellent project management skills, with a proven ability to lead database-related initiatives from inception to completion.
• Exceptional communication and interpersonal skills, capable of conveying technical concepts to non-technical stakeholders.
• In-depth knowledge of database architecture and design principles, ensuring scalability and reliability.
• Familiarity with data modeling tools and techniques for efficient database design.
• High level of proficiency in using Oracle development tools, such as SQL Developer, Oracle Enterprise Manager, and APEX.
• Understanding of data governance and compliance requirements related to database management.
• Ability to work collaboratively in a team environment while also displaying strong independent work capabilities.
• Adaptable to change and able to function effectively in a high-pressure, dynamic work environment.