SQL Server DBA AVP

Job description

About Us:

Mitsubishi UFJ Financial Group, Inc.

(MUFG) is one of the worlds leading financial groups.

Headquartered in Tokyo and with over 360 years of history, MUFG has a global network with over 2,700 locations in more than 50 markets.

The Group has over 180,000 employees and offers services including commercial banking, trust banking, securities, credit cards, consumer finance, asset management, and leasing.

The Group aims to be the worlds most trusted financial group through close collaboration among our operating companies and flexibly respond to all of the financial needs of our customers, serving society, and fostering shared and sustainable growth for a better world.

MUFGs shares trade on the Tokyo, Nagoya, and New York stock exchanges.

MUFG Bank, Ltd.

is Japans premier bank, with a global network spanning more than 50 markets.

Outside of Japan, the bank offers an extensive scope of commercial and investment banking products and services to businesses, governments and individuals worldwide.

In Asia, MUFG has a presence across 20 markets Australia, Bangladesh, Cambodia, China, Hong Kong, Indonesia, India, South Korea, Laos, Malaysia, Mongolia, Myanmar, New Zealand, Pakistan, Philippines, Singapore, Sri Lanka, Taiwan, Thailand and Vietnam.

It has also formed strategic partnerships with some of the most prominent banks in Southeast Asia, further augmenting its unrivalled network across the region VietinBank in Vietnam, Krungsri in Thailand, Security Bank in the Philippines and Bank Danamon in Indonesia.

MUFG Global Service (MGS):

Established in 2019, MUFG Global Services (MGS) is 100% subsidiary of MUFG Bank Ltd having offices in Bengaluru and Mumbai.

MGS has been set up as a Global Capability Centre / Centre of Excellence to provide support services across various functions such as IT, KYC/ AML, Credit, Operations, Trade Finance etc.

to MUFG Bank offices globally.

With a current headcount of over 1000 employees, MGS India has plans to significantly ramp-up its growth over the next 18-24 months while servicing MUFGs global network across Americas, EMEA and Asia Pacific

Job Title: Data Platforms Oracle Reliability Engineer with AWS Cloud Expertise

Job Overview:

The Bank is seeking an experienced Senior Oracle Database Administrator with knowledge of AWS Cloud technologies.

The ideal candidate will have a deep understanding of Oracle administration coupled with expertise in AWS services, particularly AWS RDS Oracle/Aurora and DMS.

Individuals with proficiency in infrastructure as code tools like Terraform, scripting languages such as Python, Java script, Bash, PowerShell, and experience with serverless computing using AWS Lambda functions are preferred.

Responsibilities include:

Design and Implementation:

• Design, deploy, and manage Oracle databases on premises and in AWS RDS, ensuring optimal performance, availability, and scalability.
  
  
• Collaborate with cross-functional teams to architect and implement hybrid cloud database solutions aligned with business requirements.
  
  
• Develop and maintain infrastructure as code using Python, Bash, Ansible, PowerShell and Terraform to automate the provisioning and configuration of a hybrid cloud database environment.
  
  
• Migrate on premises databases to AWS using DMS, DMS CDC and development custom CDC scripts.
  
  
• Collaborate with data engineers, DevOps, and other stakeholders to define database requirements and solutions.
  
  

Maintenance and Optimization:

• Monitor and maintain the health, performance, and security of ahybrid cloud database environment.
  
  
• Support of Production environments with strong troubleshooting skills.
  
  
• Implement cost optimization strategies and ensure efficient utilization of database resources.
  
  
• Perform database migrations, upgrades, and patching activities with minimal downtime and risk.
  
  
• Implement and manage database backups, replication, and disaster recovery strategies to ensure data integrity and availability.
  
  
• Continuously improve database infrastructure and architecture to support evolving business needs and best practices and optimal flexibility.
  
  

Automation and Scripting:

• Utilize Python, Bash, Ansible, PowerShell and Terraforms scripting to automate database administration tasks, streamline processes, and enhance operational efficiency.
  
  
• Automate the configure and manage database security policies, access controls, and encryption in compliance with industry standards and regulations.
  
  
• Utilize Terraforms for managing cloud resources and deployments, ensuring consistency and reliability in infrastructure management.
  
  
• Collaborate with DevOps teams to integrate database deployments into CI/CD pipelines and automate release processes.
  
  
• Ensure all automation is robust, reusable, and adheres to industry standards.
  
  

Security and Compliance:

• Implement and enforce security best practices for Data Platforms in a hybrid cloud environment.
  
  
• Ensure compliance with relevant regulations and internal policies through proper configuration and auditing.
  
  

Documentation and Support:

• Document database configurations, procedures, and best practices for knowledge sharing and team collaboration.
  
  
• Provide support and troubleshooting assistance to other team members and stakeholders to resolve database-related issues, performance bottlenecks, and scalability challenges in Hybrid cloud environments.
  
  

Job Requirements:

• Bachelors degree in computer science, Information Technology, or related field; or equivalent work experience.
  
  
• Proven working experience as a SQL Server/Oracle Database Administrator, with at least 10 years of hands-on experience with Oracle and Oracle RAC.
  
  Candidates with knowledge or experience with AWS Cloud environments are preferred.
  
  
• Solid understanding of Oracle performance tuning, query optimization, and troubleshooting techniques.
  
  
• Experience with database security principles and best practices, including encryption, access controls, and compliance.
  
  
• Excellent problem-solving skills and the ability to troubleshoot complex database issues in hybrid cloud environments.
  
  
• Experience with agile methodologies.
  
  
• Strong communication and collaboration skills, with the ability to work effectively in a team-oriented environment.
  
  
• Knowledge of AWS services, particularly AWS RDS and related cloud technologies.
  
  
• Knowledge of infrastructure as code tools such as Terraform for automating cloud infrastructure provisioning and management.
  
  
• Knowledge of Python, Bash, Ansible and PowerShell scripting for automation, orchestration, and integration tasks.
  
  
• Knowledge of DevOps practices and tools for continuous integration and deployment (CI/CD).
  
  
• Relevant certifications such as AWS Certified Solutions Architect or AWS Certified Database - Specialty are a plus.
  
  

Business Acumen:
Financial Services Domain experience - 25%

Data Skills:

Data Warehousing, Data Mesh and Data Lakes, Data Governance - 25%

Tech Skills:

Core Competency in ETL Admin - 25%

Human Skills:

Strong Inter-personal skills + leadership & management skills - 25%

Required Skill Profession

Computer Occupations