15h Left) Database Administrator

About the Role OSTTRA IndiaThe Role Database AdministratorThe 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 architecturesThe 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 marketsWhat 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 IndiaAbout 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 OSTTRACandidates 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 What s In It For YouBenefits 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 Equal Opportunity EmployerS 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 and your request will be forwarded to the appropriate person US Candidates Only The EEO is the Law Poster 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