**Requirements and responsibilities** **Duties:** ----------- * Design, develop, and maintain PL/SQL code for Oracle databases. * Create and manage complex database structures including tables, indexes, views, and stored procedures. * Optimize database performance through tuning and query optimization. * Provide support and troubleshooting for database\-related issues. * Work with application developers to integrate database functionality into applications. * Ensure data integrity and security through effective data management practices. * Develop and implement data migration and data transformation processes. * Lead and manage database projects from inception through completion. * Collaborate with cross\-functional teams to ensure project success. * Prepare comprehensive documentation for database designs, configurations, and procedures. * Generate reports and provide insights based on database analysis. * Ensure database systems comply with industry standards and organizational policies. * Implement and promote best practices in database development and management. **Technical Requirements:** --------------------------- * Extensive experience with PL/SQL programming including writing and optimizing complex queries, stored procedures, triggers, and functions. * Strong knowledge of Oracle database architecture, administration, and management. * Experience with Oracle tools such as SQL\*Plus, SQL Developer, and Oracle Enterprise Manager. * Expertise in performance tuning and optimization of PL/SQL code and database queries. * Familiarity with Oracle performance tuning tools and techniques. * Proficient in database design and data modeling techniques. * Experience with ERD tools and data modeling software. * Advanced knowledge of SQL and relational database management systems (RDBMS). * Experience with complex joins, subqueries, indexing strategies, and query optimization. * Familiarity with version control systems such as Git or SVN for managing database scripts and changes. **Non\-Technical Requirements:** -------------------------------- * Strong analytical and problem\-solving skills. * Ability to analyze complex business requirements and translate them into technical solutions. * Excellent verbal and written communication skills. * Ability to effectively communicate with technical and non\-technical stakeholders. * Proven ability to work collaboratively in a team environment. * Experience leading or mentoring junior developers. * Strong organizational and project management skills. * Ability to manage multiple projects simultaneously and meet deadlines. * High attention to detail and accuracy in work. * Strong commitment to delivering high\-quality code and solutions. * Ability to adapt to changing technologies and evolving business requirements. * Willingness to learn and implement new tools and techniques. * Proactive and self\-motivated with the ability to work independently. * Strong work ethic and a commitment to continuous improvement.