Database Administrator

**Database Administrator**:

- Gurgaon, India
- Business Management
- 305229

**Job Description**:
**About The Role**:
**OSTTRA India**

**The** **Role**: Database Administrator**

**The Impact**:Together, we build, support, protect and manage high-performance, resilient platforms that process more than 100 million messages a day. Our services are vital to automated trade processing around the globe, managing peak volumes and working with our customers and regulators to ensure the efficient settlement of trades and effective operation of global capital markets

**What’s 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 10+ 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 company’s 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.
- 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

**The Location**: Gurgaon, India

**About Company Statement**:
OSTTRA is a market leader in derivatives post-trade processing, bringing innovation, expertise, processes and networks together to solve the post-trade challenges of global financial markets. OSTTRA operates cross-asset post-trade processing networks, providing a proven suite of Credit Risk, Trade Workflow and Optimisation services. Together these solutions streamline post-trade workflows, enabling firms to connect to counterparties and utilities, manage credit risk, reduce operational risk and optimise processing to drive post-trade efficiencies.

OSTTRA was formed in 2021 through the combination of four businesses that have been at the heart of post trade evolution and innovation for the last 20+ years: MarkitServ, Traiana, TriOptima and Reset. These businesses have an exemplary track record of developing and supporting critical market infrastructure and bring together an established community of market participants comprising all trading relationships and paradigms, connected using powerful integration and transformation capabilities.

**About OSTTRA**

OSTTRA was formed in 2021 through the combination of four businesses that have been at the heart of post trade evolution and innovation for the last 20+ years: MarkitServ, Traiana, TriOptima and Reset. OSTTRA is a joint venture, owned 50/50 by S&P Global and CME Group.

With an outstanding track record of developing and supporting critical market infrastructure, our combined network connects thousands of market participants to streamline end to end workflows - from trade capture at the point of execution, through portfolio optimization, to clearing and settlement.

Joining the OSTTRA team is a unique opportunity to help build a bo