Oracle Pl/Sql Developer (Identity & Access Management), Associate Vice President

Do you want your voice heard and your actions to count?

Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we’re 160,000 colleagues, striving to make a difference for every client, organization, and community we serve. We stand for our values, building long-term relationships, serving society, and fostering shared and sustainable growth for a better world.

With a vision to be the world’s most trusted financial group, it’s part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility. This means investing in talent, technologies, and tools that empower you to own your career.

Join MUFG, where being inspired is expected and making a meaningful impact is rewarded.

This is a hybrid position. The selected colleague will work at an MUFG office or client sites up to four days per week and work remotely the remaining day(s). A member of our Talent Acquisition team will provide more details.

Job Summary

As Identity & Access Management (I&AM) Engineer and Developer you will be responsible for design, analysis, evaluation, testing, debugging and implementation of access controls enhancements, reduce risk of access controls failures, business and operational efficiencies. The candidate will be expected to have hands on experience implementing technology solutions to automate and make I&AM sustainable access controls issues monitoring, recording, resolution and evidence collection repositories and UIs.

Major Responsibilities

• Perform hands on Oracle data model and tables design
• Perform hands on Oracle PL/SQL and SQL queries development, tuning and optimization experiences, OLTP transaction processing and experience with manipulating large date sets
• Participates in unit testing and team data quality efforts
• System Integration Testing including integration with upstream and downstream systems
• Helps engineer team to write and document design specs and solutions according to defined processes, policies and standard with information security requirements
• Support in troubleshooting and resolving complex problems

Qualification 

• As an IAM Engineer and Developer you should demonstrate below experience and work on:
  • 7+ years of hands on engineering and development experience
  • Oracle data model and tables design, complex queries development and tuning
  • Oracle PL/SQL and SQL queries development, tuning and optimization experiences, OLTP transaction processing and experience with manipulating large date sets
  • Develop triggers to log audit logs and data change history
• Strong experience and ability to work in the team environment as well as deliver tasks with little supervision, analyze issues and proposed solutions are must
• Preferred but not required Application Development Experience with Java and/or .Net technologies with use of Web Services APIs, JavaScript, XML, JSON, AJAX and others is highly desired
• Strong knowledge and hands on experience with scripting and ETL data manipulation abilities.  Experience within Pentaho Data Integration (PDI) is highly desired
• Solid understanding of IAM Certification, Access Controls, Accounts Inventories with Ownership and LCM, Regional Regulatory & Approval requirements (Access Controls implementation experience is preferred)
• API and Integration development leveraging above technology
• Experience with IAM vendor-based solutions implementations is a plus
• Strong SQL Server and tSQL experience a plus
• Experience with Excel pivot tables and graphic chart for data analysis and reporting
• OS UNIX, Windows and SQL database experience and knowledge are a plus
• Strong and solid understanding of testing and implementation lifecycles for identity access technologies including root cause analysis
• Ability to effectively work with team members across multiple locations and time zones
• Ability to adapt to new and changing environment and handle multiple priorities, including ability to learn quickly and achieve automation goals
• Good understanding of system logical access and audit controls are desirable
• Bachelor’s degree in computer science, Business Administration or equivalent educational or professional experience and/or qualifications.  An advanced degree is also preferred
• Professional certifications such as Certified Information System Security Professional (CISSP), Global Information Assurance Certification (GIAC) are a plus

The typical base pay range for this role is between $110K - $130K depending on job-related knowledge, skills, experience and location. This role may also be eligible for certain discretionary performance-based bonus and/or incentive compensation. Additionally, our Total Rewards program provides colleagues with a competitive benefits package (in accordance with the eligibility requirements and respective terms of each) that includes comprehensive health and wellness benefits, retirement plans, educational assistance and training programs, income replacement for qualified employees with disabilities, paid maternity and parental bonding leave, and paid vacation, sick days, and holidays. For more information on our Total Rewards package, please click the link below.

MUFG Benefits Summary

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.

We are proud to be an Equal Opportunity/Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate on the basis of race, color, national origin, religion, gender expression, gender identity, sex, age, ancestry, marital status, protected veteran and military status, disability, medical condition, sexual orientation, genetic information, or any other status of an individual or that individual’s associates or relatives that is protected under applicable federal, state, or local law. 

#LI-Hybrid