Database Administrator

Company: S&P Global
Location: Dallas
Posted on: March 19, 2023

Job Description:

S&P Global Market Intelligence
The Role: Database Administrator
The Team:
The Shared Services team is responsible for managing and supporting our Managed Services clients. The role involves being a member of the database team within Shared Services which is responsible for maintaining managed services databases on the cloud including:

• 
  
• 
  Administration
  
  
• 
  Housekeeping
  
  
• 
  Change Management
  
  
• 
  Support and issue resolution
  
  
• 
  Monitoring
  
  
• 
  Tuning
  
  
  Furthermore, the Shared Services team is responsible for all of the infrastructure and automation required to support continuous integration and continuous delivery.
  
  • 
    
  • 
    Maintenance and provisioning of all internal environment and integration databases
    
    
  • 
    Administration of all internal oracle and postgres instances and servers
    
    
  • 
    Development, documentation and governance of all DDL and DML product scripts
    
    
  • 
    Packaging of Database Releases
    
    
  • 
    Providing client troubleshooting support and SQL script development / reviews and general postgres and oracle expertise for the support desk
    
    
  • 
    Offering support and expertise to ensure maximum uptime of environments
    
    
  • 
    Ensure that client SLAs are strictly adhered to and their primary focus will be on continuous performant operations
    
    
  • 
    Involved in core team tasks including data modelling, governance and quality of database artefacts as well as release packaging
    
    
    The Impact:
    
    • 
      
    • 
      Significant customer service focus
      
      
    • 
      Willingness to learn new skills
      
      
    • 
      Excellent Problem Solving Skills
      
      
    • 
      Strong attention to detail
      
      
    • 
      Strong inter-personal skills with practical, can-do approach
      
      
    • 
      Self-motivated, proactive work ethic
      
      
    • 
      Good personal time management and ability to complete individual work assignments without daily supervision
      
      
      What's in it for you:
      Candidates will be required to liaise with the other teams in Shared Services to ensure the overall team works together as a unit. Candidates will also need to be able to liaise with various other groups (e.g. Architecture, Design Authority, Support) to ensure changes to the database or support issues are dealt with comprehensively. Candidates should be familiar with operating in a challenging production environment supported from different locations and should also have a good appreciation of Development processes, toolsets and delivery infrastructure, and be comfortable working with multiple differing systems and tools. The successful applicant will be required to work within a team structure. The candidate should demonstrate a willingness to learn new technologies, processes, toolsets and be comfortable working with multiple differing systems.
      Responsibilities:
      
      • 
        
      • 
        Management of managed services environments
        
        
      • 
        Provide support for any database related issues to all clients, particularly managed services clients
        
        
      • 
        Manage high severity incidents via process and work with all stakeholders to resolve issues as soon as possible including attending client bridge calls
        
        
      • 
        Ensure Database requests are dealt with within defined SLA's
        
        
      • 
        Modelling and scripting database changes for all our products
        
        
      • 
        Ensure client releases are packaged and made available in a timely manner
        
        
      • 
        Be available for on-call rotation
        
        
      • 
        Document all work, particularly around Managed Services
        
        
        What We're Looking For:
        
        • 
          
        • 
          5+ years of experience in similar role with Degree in Technology, Computer Science, IT or a related course
          
          
        • 
          Proficient in Postgres - Administration, Performance and Tuning, psql, PL/pgSQL, pgdump, ora2pg
          
          
        • 
          Good Linux/Unix knowledge
          
          
        • 
          Good Database skills - Data Modelling, Database Release management
          
          
        • 
          Good oracle knowledge and experience - Administration, Performance Monitoring, Datapump & RMAN, SQL, PL/SQL
          
          
          Experience of the following technologies:
          
          • 
            
          • 
            ASM
            
            
          • 
            RAC
            
            
          • 
            JIRA
            
            
          • 
            Shell scripting
            
            
          • 
            Amazon Web Services
            
            
          • 
            Amazon RDS
            
            
            Knowledge of the following technologies beneficial:
            
            • 
              
            • 
              Data Guard
              
              
            • 
              python
              
              
            • 
              Commercial awareness
              
              
            • 
              Knowledge of Corporate Actions business is major plus
              
              
            • 
              Knowledge of financial markets or financial feeds would be very useful
              
              
              Note: This role is limited to persons with indefinite right to work in the United States.
              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 (link to career site page when available), 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 ): 9
              The Location: Dallas, Texas
              Compensation/Benefits Information (US Applicants Only):
              S&P Global states that the anticipated base salary range for this position is $58,300 to $121,000. Base salary ranges may vary by geographic location.
              In addition to base compensation, this role is eligible for an annual incentive 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 .
              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.
              S&P Global Market Intelligence partners with customers to broaden their perspective and operate with confidence by bringing them leading data sources and technologies that embed insight in their daily work.
              
              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.
              
              IFTECH202.1 - Middle Professional Tier I (EEO Job Group), IFTECH203 - Entry Professional (EEO Job Group)
              Job ID: 282408
              Posted On: 2023-03-06
              Location: Dallas, Texas, United States

Keywords: S&P Global, Dallas , Database Administrator, IT / Software / Systems , Dallas, Texas