Lead Database Engineer

Segment : S&P Global Corporate The Role: Lead Database Engineering The Team: We are looking for an engineer helping with helping build Database Operations Engineering supporting various product offerings of Sustainable1 The Impact: This engineer will work to improve and enhance the architecture, design, scalability, and performance of our cutting-edge Sustainable1 platforms What’s in it for you: This is the place to hone your existing database and leadership skills while having the chance to become exposed to fresh and divergent technologies (e.g., AWS, PostgreSQL, SQL Server Analysis Services, SQL Server, Attunity/Qlik, NiFi Replication, SQL Server Clustering, SQL Server Availability Groups, NoSQL, etc.). Responsibilities: Support, administer, manage, and tune multi-terabyte database systems Ensure any data replication latency is investigated and resolved quickly Automate tasks to improve efficiency and quality of the team and infrastructure Manage periodic database/software releases for QA, Pre-Production, Production, and DR as part of the overall SDLC Deploy and maintain database instances including configuration enhancements, patches/hotfixes, database engine upgrades, hardware/storage migrations, etc. Solve, non-routine problems and use cost/benefit analysis to determine the best solution Troubleshoot database engine and query performance issues in real-time Work with IT Server Management and other groups and make sure that all issues, incidents, and problems are resolved in a timely manner Participate in and coordinate projects with other teams within Operations as well as other peer groups like Development and QA teams Leverage existing methods and procedures on new or special assignments Periodically review current processes and suggest improvements as new tools/methods are discovered Contribute to best-in-class product support resources including run books, tools, monitoring processes, and knowledge bases Support database backups/refreshes in non-prod environments Participate in weekly, Tier-3 Support on-call rotation Support cloud, virtualized, and bare-metal database infrastructure What We’re Looking For: Bachelor's degree in Computer Science, Information Systems, or Engineering Must have extensive (10+ years) experience in MS SQL Server including hands-on database administration, support, performance tuning, and monitoring Some familiarity/experience with AWS Experience with Transactional Replication and Log Shipping Basic knowledge PowerShell (or other scripting/program language) Excellent communication skills, with strong verbal and writing proficiencies Preferred Qualifications: Experience in a start-up, Agile, or Dev Ops environment ITIL V3 Foundation Certified AWS Certified Solutions Architect Experience with additional RDMS like NoSQL, SOLR, Vertica and PostgreSQL Familiarity with SQL Server Analysis Services Understanding of Database Mirroring, Availability Groups, and Windows Clustering Ability to troubleshoot problems involving Client Libraries (like ADO.NET), Operating Systems, Network, and Storage Experience with Data Lakes, or Data Bricks Return to Work Have you taken time out for caring responsibilities and are now looking to return to work? As part of our Return to Work initiative , we are encouraging enthusiastic and talented returners to apply, and will actively support your return to the workplace. Grade/Level (relevant for internal applicants only): 11 The Location: Hyderabad ,Gurgaon, Ahmedabad About Company Statement: S&P Global delivers essential intelligence that powers decision making. We provide the world’s leading organizations with the right data, connected technologies and expertise they need to move ahead. As part of our team, you’ll help solve complex challenges that equip businesses, governments and individuals with the knowledge to adapt to a changing economic landscape. ----------------------------------------------------------- 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: [email protected] 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), IFTECH202.2 - Middle Professional Tier II (EEO Job Group) Job ID: 275733 Posted On: 2022-08-04 Location: Hyderabad, Telangana, India