SMBC Group is a top-tier global financial group. Headquartered in Tokyo and with a 400-year history, SMBC Group offers a diverse range of financial services, including banking, leasing, securities, credit cards, and consumer finance. The Group has more than 130 offices and 80,000 employees worldwide in nearly 40 countries.
In the Americas, SMBC Group has a presence in the US, Canada, Mexico, Brazil, Chile, Colombia, and Peru. The Group offers a range of commercial and investment banking services to its corporate, institutional, and municipal clients.
Role Responsibilities:
* Perform day to day database administration of Oracle 19C databases (including DataGuard) on Linux VM platform.
* Pro-actively manage oracle database resources ensuring their availability, resilience, integrity, efficiency and compliance at all times.
* Troubleshoot critical database issues and pro-actively monitor the databases and their resources.
* Participate in user/schema creation, privileges assignment, RMAN backups/restores, exports/imports and disaster recovery tests.
* Contribute to performance tuning, database sizing/space management, load balancing and configuration management.
* Maintain the database infrastructure and plan for future capacity requirements.
* Perform database upgrades and security patching.
* Support Application teams with their projects and database related queries/issues.
* Take part in critical engineering and multi-team projects.
* Partner with other infrastructure teams to perform maintenance and upgrades on database infrastructure and to troubleshoot performance, network and hardware issues.
* Produce and maintain internal knowledgebase articles.
* Perform other job-related duties requiring the same general knowledge, skills and degree of responsibility as above.
Qualifications and Skills
* Required years of experience in a similar position: 4+ years.
* A Qualification in Computer Science, Information Systems, or other related field.
* Solid understanding of Oracle Databases and their architecture.
* Hands on 19C Oracle database implementation/admin experience in a multi-platform environment.
* Knowledge of Linux architecture, OS commands and tools, UNIX scripting.
* Demonstrated SQL and PL/SQL knowledge/skills.
* Experience with front-end database administration tools like Toad and SQL Developer.
* Experience with RMAN backups/restores, exports/imports, database upgrading/patching, performance tuning, troubleshooting, OEM.
* Show ability to support Application upgrade projects and deployments, as well as company-wide infrastructure projects as it impinges on database components.
* Strong technical documentation skills.
* Knowledge of DataGuard, Oracle Key Vault, Python, Ansible automation tool are an advantage.
* Highly self-motivated and ability to work on own initiative as well as under direction.
* Keen attention to detail and proven analytical and problem-solving abilities.
* Ability to effectively prioritize and execute tasks in a high-pressure environment.
Interpersonal Skills
* Good communicator (we work globally so strong written and verbal skills are an absolute requirement).
* Experience working in a team-oriented, collaborative environment.
* Empathy with users, active listening, patience and understanding.
Additional Requirements
* Willingness to work part of the week during US business hours.
* Willingness to provide on-call support during off-business hours including weekends on a rotating basis.
* Weekend and late night work may be required on occasion.
#J-18808-Ljbffr