Senior Lead Database Engineer Senior Lead Database Engineer …

S&P Global
à Boulder, CO, États-Unis
CDI, Plein-temps
Soyez parmi les premiers à postuler
Competitive
S&P Global
à Boulder, CO, États-Unis
CDI, Plein-temps
Soyez parmi les premiers à postuler
Competitive
Senior Lead Database Engineer
The Team:
  • You will be part of a world class Database Operations Engineering team supporting various product offerings of S&P Global powered by various middle tier, database, and OS technologies and used by tens of thousands of users globally
  • Our team is a diverse, global team of intelligent, ambitious professionals recruited from top industries in a fast-paced environment
  • Our team is responsible for database provisioning, support/administration, architecture, reliability, performance, High Availability, and scalability of large-scale data ingestion, processing/aggregation, and retrieval systems
The Impact:
  • This is an extremely visible role as the database infrastructure is the backbone of S&P Global
  • S&P Global products rely on numerous datasets to allow our customers to find the companies, securities, and markets they are interested in, to explore the relationships between entities, and to search using public identifiers (CUSIPs, ISINs, SEDOLs, Tickers, etc.)
  • The database backend is in allowing our customers to value their portfolios, monitor market moving events, understand their risk, maintain their back-office systems, etc.
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, Oracle, SQL Server/Attunity/NiFi Replication, SQL Server Clustering, SQL Server Availability Groups, NoSQL, SOLR, Vertica, petabyte levels of total storage, etc.).
  • As a critical member of the team, you will have the opportunity to collaborate with a global team of database administrators and engineers with varying ranges of experience from Jr. DBAs that you can mentor to team members who are experts in their domain and willing to share their knowledge
Responsibilities :
  • As a Senior lead, you are responsible for day-to-day monitoring and performance management of the Database Administrators and the Database Systems running critical S&P Global Market Intelligence products by aligning with our Company's Pay for Performance policy and efficient implementation of Global HR Practices including hiring and Performance Management.

    Your responsibilities will include:
    • 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, virtual, and bare-metal database infrastructure
What We're Looking For:
  • Bachelor's degree in Computer Science, Information Systems or Engineering
  • 10+ years of hands-on database administration, support, and performance tuning experience
  • Must have extensive experience in MS SQL Server
  • Some familiarity/experience with AWS
  • Proficient in database support, administration, performance tuning, and database monitoring
  • 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

    Compensation/Benefits Information (US Applicants Only): S&P Global states that the anticipated base salary range for this position is $82,600 - $230,200 . Base salary ranges may vary by geographic location. In addition to base compensation, this role is eligible for an annual incentive bonus/a sales commission plan. This role is eligible to receive additional S&P Global benefits. For more information on the benefits we provide to our employees, visit https://www.spgbenefitessentials.com/newhires .
20 - Professional (EEO-2 Job Categories-United States of America), IFTECH202.2 - Middle Professional Tier II (EEO Job Group)

Job ID: 263816
Posted On: 2021-08-13
Location: Virtual, Virginia, United States
S&P Global logo
Offres similaires
Plus d'offres
Close
Loading...