Standard Chartered—Oracle /Postgre SQl Database Adminstrator

Job description

Description: Job Summary Role Overview Hiring a hands-on Database resource with strong experience in both Oracle and PostgreSQL to manage non-production and production databases, optimize performance, and ensure high availability, security, and reliability. Key Responsibilities • Administer Oracle and PostgreSQL databases across dev/test/prod. • Perform performance tuning (SQL, indexes, execution plans, DB parameters). • Manage backup, recovery, replication, and disaster recovery readiness. • Execute DB patching, upgrades, migrations, and schema changes. • Troubleshoot production issues and perform root-cause analysis. • Implement database security, user access control, and audit compliance. • Collaborate with application teams on data design and query optimization. • Create and maintain operational documentation and runbooks. Processes • The selected resource will support production and non-production Oracle and PostgreSQL databases. • The role involves daily monitoring, performance tuning, backup/recovery, patching, and issue resolution. • The selected resource must coordinate with developers and ensure that all required bank processes are followed before executing scripts in both production and non-production environments. • The candidate should be available for on-call support and production troubleshooting if required. • Locate and define new process improvement opportunities. Regulatory & Business Conduct • Display exemplary conduct and live by the Group’s Values and Code of Conduct. • Take personal responsibility for embedding the highest standards of ethics, including regulatory and business conduct, across Standard Chartered Bank. This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct. • Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters. Key stakeholders • Central Database Engineering team • Application development team. • SCPay Tech Hive Leads Skills and Experience • Oracle Database Administration • PostgreSQL Administration • Performance Tuning and Query Optimization • Backup, Recovery, and Disaster Recovery • High Availability and Replication • Linux Administration • Shell Scripting / Automation • SQL / PL/SQL Mandatory Skills • Strong hands-on Oracle DBA experience in 19c and above (21c/23ai preferred). • Strong hands-on PostgreSQL DBA experience (v12+ preferred). • Advanced SQL skills and strong troubleshooting in production environments. • Expertise in backup/restore, replication, and high availability setups. • Linux and shell scripting knowledge. Good to Have • Cloud DB exposure (AWS RDS/Aurora/EC2, OCI, Azure). • Monitoring tools (OEM, pgAdmin/Prometheus/Grafana, etc.). • Automation and database release/migration tooling experience. Qualifications • Education: BE / MCA / MSC / Bachelor's Degree in Computer Science / IT or equivalent. • Certifications: Oracle Database Administration certification, PostgreSQL certification, or relevant cloud database certification is an added advantage About Standard Chartered We're an international bank, nimble enough to act, big enough for impact. For more than 170 years, we've worked to make a positive difference for our clients, communities, and each other. We question the status quo, love a challenge and enjoy finding new opportunities to grow and do better than before. If you're looking for a career with purpose and you want to work for a bank making a difference, we want to hear from you. You can count on us to celebrate your unique talents and we can't wait to see the talents you can bring us. Our purpose, to drive commerce and prosperity through our unique diversity, together with our brand promise, to be here for good are achieved by how we each live our valued behaviours. When you work with us, you'll see how we value difference and advocate inclusion. Together we: - Do the right thing and are assertive, challenge one another, and live with integrity, while putting the client at the heart of what we do - Never settle, continuously striving to improve and innovate, keeping things simple and learning from doing well, and not so well - Are better together, we can be ourselves, be inclusive, see more good in others, and work collectively to build for the long term What we offer In line with our Fair Pay Charter, we offer a competitive salary and benefits to support your mental, physical, financial and social wellbeing. - Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations. - Time-off including annual leave, parental/maternity (20 weeks), sabbatical (12 months maximum) and volunteering leave (3 days), along with minimum global standards for annual and public holiday, which is combined to 30 days minimum. - Flexible working options based around home and office locations, with flexible working patterns. - Proactive wellbeing support through Unmind, a market-leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first-aiders and all sorts of self-help toolkits - A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning. - Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies - everyone feels respected and can realise their full potential.