Senior Oracle Database Developer

Job description

Overview The aim of the Sr. Oracle Developer is to work within a team of developers in the delivery of current and emerging business requirements. You will bring your knowledge, expertise and work ethic in the fast paced environment using Agile/Scrum methodology. This is a hands-on role requiring in-depth knowledge in Oracle Database Server development, project experience and project life cycle. Specific emphasis will be on: • Solution Development • Oracle Server Database technology Effective team & communication skills Key Accountabilities and main responsibilities Strategic Focus • To strive for continuous improvement of both technical and business knowledge • To assist with the development of new team standards, methodologies and processes to increase both the quality and efficiency of the development work Operational Management • Responsibility to develop quick to market, high quality IT solutions within an agile environment • This will require full project exposure from start up to completion • Extremely adaptable and quick to pick up new business concepts within a unique business environment • Engage proactively with stakeholders and other cross-functional team members in the development of IT solutions People Leadership • Work within a team of developers assisting in: • time estimates • task allocations • problem solving • Provision of regular feedback, mentoring, coaching and assistance to the team’s development needs Governance & Risk • Ensure adherence to legal and regulatory requirements • Support Link Group assurance programs that deliver effective risk management and compliance practices Experience & Personal Attributes • 6 to 9 years development experience with Oracle Database version 9i /10g / 11g /12c • Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance. Primary Skills: • Create and maintain indexes, constraints, tables, PL/SQL store procedures & packages and produce queries to answer business questions. • Create numerous simple to complex queries involving self joins, correlate sub-queries, functions, cursors, dynamic SQL. • Strong knowledge of T-SQL / PL-SQL • Package creation and maintenance • Using system-supplied packages • Database triggers • Networking • Tablespace management • Oracle database tools • Database backup and recovery • DECLARE, BEGIN & EXCEPTION clause • Designing databases and ensuring their stability, reliability, and performance. • Design, create, and implement database systems based on the end user's requirements. • Improve application's performances. • Prepare documentations for database applications. • Memory management for database systems. • Develop database schemas, tables and dictionaries. • Ensure the data quality and integrity in databases. • Fix any issues related to database performance and provide corrective measures. • Create complex functions, scripts, stored procedures and triggers to support application development. • Take regular database backup. • Test databases and perform bug fixes. • Provide authentication and authorizations for Database • Develop best practices for database design and development activities. • Good understanding of data modelling and database schema design principals • Data normalization • Knowledge of database optimization techniques • Exceptional analytical skills in order to analyse and interpret business needs, and to provide constructive input into the development and technology solutions • Experience with Agile/Scrum methodology Secondary Skills: • Exposure to cloud technologies, e.g. Microsoft Azure, AWS • Excellent interpersonal skills with the ability to develop effective inter-departmental and organisational relationships • Sound organisational skills, with the ability to prioritise conflicting tasks in order to meet strict deadlines • Self-motivated with a strong team spirit. Strong work ethic MUFG Pension & Market Services is a global, digitally enabled business that empowers a brighter future by connecting millions of people with their assets – safely, securely and responsibly. Through our two businesses MUFG Retirement Solutions and MUFG Corporate Markets, we partner with a diversified portfolio of global clients to provide robust, efficient and scalable services, purpose-built solutions and modern technology platforms that deliver world class outcomes and experiences. A member of MUFG, a global financial group, we help manage regulatory complexity, improve data management and connect people with their assets, through exceptional user experience that leverages the expertise of our people combined with scalable technology, digital connectivity and data insights. India Hub is a central part of MUFG's transformation program, which has rapidly expanded over the past 5 years to nearly 1100+ employees, to provide services to our clients across two of our businesses. We have offices in Mumbai and Pune. India Hub has allowed us to streamline our operations and forms one of our global centres of excellence. This has allowed us to focus our skillsets, innovate our current operations and create new capabilities for the future. The Hub has been designed to support flexible operations processing our three businesses - Retirement Solutions, Corporate Markets and Investor Services. In addition, our Global Functions team provide centralized expertise and support—like HR, Finance, and IT—to ensure consistency, efficiency, and strategic alignment across all business units. At India Hub, we are building a dynamic, client-focused, caring, and inclusive culture based on entrepreneurial spirit, effective risk management, empathy, and trust, underpinned by core values. We work collaboratively, supporting and valuing the talents and perspectives of our people, and promoting a flexible work environment where their wellbeing is prioritized. We believe diversity drives better client outcomes, improvement, and growth.