Database Administrator

The Team: The OSTTRA Technology team is composed of Capital Markets Technology professionals, who build, support and protect the applications that operate our network. The technology landscape includes high-performance, high-volume applications as well as compute intensive applications, leveraging contemporary microservices, cloud-based architectures

Whats in it for you: We are looking for highly motivated technology professionals who will strengthen our specialisms, and champion our uniqueness to create a company that is collaborative, respectful, and inclusive to all.

You will have 8+ years experience of DBA to meet the needs of our expanding portfolio of Financial Services clients. This is an excellent opportunity to be part of a team based out of Gurgaon and to work with colleagues across multiple regions globally.

ROLE SUMMARY:

We are looking for an experienced Oracle DBA to be a part of the companys Infrastructure team.

This team is responsible for managing databases on both cloud (AWS & GCP) and on-premises.

We support and maintain several database technologies like Oracle, PostgreSQL, SQL Server & MySQL, but Oracle being a dominant estate. So, multi database experience is required along with atleast one cloud experience preferably AWS.

We are looking for an experienced hands-on Oracle DBA that can work across the Operations and Engineering side. We are embarking on several migrations into the cloud, so experience with oracle database migrations would be must.

KEY ACCOUNTABILITIES:

• Database Operational Support Work in shift model (24*7) and providing on-call support during weekends and holidays.
• Support application release activities.
• Handling day-to-day issues like user access, performance tuning, backup and recovery, standby management, migrations etc
• Handling incidents
• Design & build optimized cost-effective fault-tolerant database solutions.
• Handle homogenous and heterogenous database migration using golden gate, datapump, DMS, pgdump/pg_restore, logical replication, dataguard (Oracle and PostgreSQL).
• Develop automated solution for manual procedures.
• Manage databases in cloud environments such as AWS RDS (code the infrastructure with Terraform)

REQUIREMENTS:

• 8+ years of experience with Oracle database as a DBA
• 2+ years of experience in PostgreSQL.
• 2+ years of experience in managing Oracle RDS & EC2
• Experience in Oracle database migration and management in AWS (RDS, EC2).
• Experience with migration technology like golden gate etc
• Extensive experience with Oracle 19c, Oracle Dataguard, RMAN, any cloning software (NetApp, Delphix), RAC, Performance Tuning.
• Understanding of some storage technology like EBS, Netapp from database perspective.
• Experience in cloning and refreshing Oracle and PostgreSQL database.

Added Advantages:

• Experience in automation with python
• Experience with infrastructure coding tools (preferably Terraform)
• Experience with Git
• Experience in any OS clustering
• Experience with AWS Aurora clusters