Propitious Technologies - Oracle Developer - Database Architecture & Design

POSITION OVERVIEW : Oracle Developer

POSITION GENERAL DUTIES AND TASKS :

Requirements :

• Database architecture and design : Architect, design, and implement robust, scalable, and high performance Oracle database solutions to support mission-critical business applications.
• Advanced PL / SQL development : Develop, maintain, and optimize complex PL / SQL packages, stored procedures, functions, and triggers, utilizing advanced features such as bulk collections, dynamic SQL, and autonomous transactions.
• Performance tuning : Serve as a subject matter expert in performance tuning and query optimization for large-scale enterprise environments. Use advanced tools and techniques, such as AWR, ADDM, SQL Trace, and execution plan analysis, to resolve performance bottlenecks.
• Technical leadership and mentorship : Lead and mentor junior and mid-level developers, conduct code reviews, and promote best practices in Oracle database development.
• Data modelling and governance : Design and enforce data modelling standards. Ensure data integrity, consistency, and compliance with data governance policies across all database systems.
• Complex data integration : Design and implement sophisticated ETL (Extract, Transform, Load) processes and data migration strategies for large volumes of data.
• Solution delivery and project management : Lead database-related projects throughout the entire software development lifecycle (SDLC), from requirements gathering and design to deployment and post implementation support.
• Troubleshooting and production support : Provide advanced, third-level production support for critical database issues, offering real-time problem resolution.
• Strategic planning and innovation : Stay current with the latest Oracle technologies and industry trends. Evaluate and recommend new solutions, contributing to the strategic roadmap for the company's database and data management practices.
• Ownership : Take ownership of assigned deliverables, proactively identify areas for improvement, and implement solutions. Demonstrate initiative in addressing issues, optimizing processes, and proposing innovations to enhance data engineering practices.
• Business and regulatory compliance : Takes accountability in considering business and regulatory compliance risks and takes appropriate steps to mitigate the risks.
• Maintains awareness of industry trends on regulatory compliance, emerging threats and technologies in order to understand the risk and better safeguard the company.
• Highlights any potential concerns / risks and proactively shares best risk management practices.

Skillset :

(ref : hirist.tech)