About the Role: OSTTRA India The Role: 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 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. 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 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 Candidates should note that OSTTRA is an independent firm, jointly owned by S&P Global and CME Group. As part of the joint venture, S&P Global provides recruitment services to OSTTRA - however, successful candidates will be interviewed and directly employed by OSTTRA, joining our global team of more than 1,200 post trade experts. 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 bold new business with an outstanding heritage in financial technology, playing a central role in supporting global financial markets. Learn more at www.osttra.com. What’s In It For You? Benefits: We take care of you, so you can take care of business. We care about our people. That’s why we provide everything you—and your career—need to thrive at S&P Global. Our benefits include: Health & Wellness: Health care coverage designed for the mind and body. Flexible Downtime: Generous time off helps keep you energized for your time on. Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills. Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs. Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families. Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference. For more information on benefits by country visit: https://spgbenefits.com/benefit-summaries ----------------------------------------------------------- Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to: EEO.Compliance@spglobal.com and your request will be forwarded to the appropriate person.  US Candidates Only: The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf describes discrimination protections under federal law. ----------------------------------------------------------- 20 - Professional (EEO-2 Job Categories-United States of America), BSMGMT203 - Entry Professional (EEO Job Group) Job ID: 305229 Posted On: 2024-08-13 Location: Gurgaon, Haryana, India