Lead Database Administrator

Job Description

About the Role: The Team: You will be part of a World Class Database Reliability Engineering (DBRE)/DSE team supporting various product offerings of S&P Global Market Intelligence powered by various middle tier, database and OS technologies and used by tens of thousands of users globally. The team is responsible for ensuring Greater Reliability, High Performance, High Availability and Scalability. You will work with a global team of intelligent and ambitious professionals recruited from top industries. The team is responsible for the database support, administration, scalability, performance tuning, release and architecture of large-scale data processing, aggregation and retrieval systems. . Responsibilities and Impact: Database Administrator you will Enhance Support, Administer, Manage, and Tune multi-terabyte Database Systems that will enable S&P Global Market Intelligence to ingest, manage, process and serve-up Market Data Products (CreditPro, CreditModel & PD Model) as well as our highly transactional and dynamic web based CIQ Pro, CIQ Classic, Platform & Risk Solutions Portal. Own the delivery of small to medium size projects where you will drive\contribute directly as an individual and take help of few others in the team. Lead key database releases for Dev, QA, Alpha, Production and DR as part of the overall SDLC. In-depth knowledge of database administration/management processes and strategies. Solve complex, non-routine problems and determine the best solution through cost/benefit analysis. Exercise judgment within defined procedures and policies to determine appropriate action. Work with other teams as a lead and frequently interact with functional peer groups. Work with IT Service Management and other groups and make sure that all events, incidents and problems are resolved as per the SLA. Lead or participate in initiatives in analyzing database resources for optimum configuration, performance and storage architecture information and provide enhancements and recommendations as needed. Provide technical expertise in identifying and evaluating databases and developing procedures that are cost effective and meet user requirements Provide high level support around production performance of software and codes in relation to the database/product Willing work on 24/7 shifts Perform database backups/ refreshes in non-prod environments. Participate 24x7 on call tier 3 support on a weekly rotating schedule Contribute to process and troubleshooting documentation. Should be able to support virtualized environment What Were Looking For: Basic Required Qualifications: Bachelor's degree in Computer Science, Information Systems or Engineering 5+ years of hands-on large scale database administration, support and performance tuning experience Experience with a Oracle / Postgres/ Mysql/AWS aurora/RDS Experience with leading small to medium size projects is a plus. Experience in a start-up or Agile or Dev Ops environment is a plus. ITIL V3 Foundation Certified is a plus. AWS/Oracle Cloud Certified is a plus. Additional Preferred Qualifications: Excellent Postgres/Oracle hands on On-prem/AWS cloud experience (Experience with additional data platforms like MySQL is a huge Plus). Extensive experience with database support, administration, performance tuning, architecture, scalability, and stability and database monitoring. Robust Experience with Golden Gate, RAC/ (RMAN) appliance and Data Guard is a must. Good knowledge on PL/SQL, Shell Scripting or any other scripting or programming language is a must. Knowledge on Informatica is a plus. Work on Complex significant and unique issues where analysis of situations or data requires an evaluation of intangibles ability to multi-task and manage priorities effectively. Excellent communication skills, with strong verbal and writing proficiencies.