Senior Database Administrator

Company Description

Wood Mackenzie are the global research, analytics, and consultancy business powering the natural resources industry. For 50 years, we have been providing the quality data, analytics, and insights our customers rely on to inspire their decision making.

Our dedicated oil, gas & LNG, power & renewables, chemicals, metals & mining sector teams are located around the world and deliver a variety of projects based on our assessment and valuation of thousands of individual assets, companies, and economic indicators such as market supply, demand, and price trends.

We have over 1,900 employees in 30 locations, serving customers in nearly 80 countries. Together, we inspire and innovate the markets we serve – providing invaluable intelligence to help our customers overcome the toughest challenges, and make strategic decisions that will, ultimately, accelerate the world’s transition to a more sustainable future.

WoodMac.com

Wood Mackenzie brand video

Job Description

We are looking for a skilled Senior Database Administrator or Database Reliability Engineer to join a dynamic global business to help drive change and innovation and help us in the support and constant improvement of our suite of database technologies, on premises and in the cloud.

Role Purpose

The principal responsibilities of this role are to ensure database availability and all aspects of database administration within the Site Reliability Engineering (SRE) team, and to collaborate with the software engineering teams to optimize database performance on multiple data platforms in a global enterprise environment.

This encompasses:

• Working in partnership with the business and the technology teams to ensure database availability, focusing on service availability and proactive issue detection
• Creating and implementing database administration best practices, internal policies, and operational procedures to perform administrative and support responsibilities
• Resolving availability issues as they arise, to include participating in an on-call support rotation
• Mentoring DBA team members as they resolve issues and learn new technologies
• Reviewing application data access patterns and performance metrics to recognize opportunities for continual optimization and performance improvements

Responsibilities:

• Perform all aspects of database support:  deployment, capacity planning, security, maintenance, currency, monitoring, alerting, incident resolution, recovery, and performance tuning
• Work in an Agile environment supporting global engineering teams in a collaborative ownership culture
• Deliver high quality results within allocated timeframes
• Participate in on-call support rotation
• Review and contribute to procedure documentation
• Mentor junior team members and review documentation contributions for accuracy and improvement
• Lead database design efforts to meet reliability, capacity planning, and retention requirements
• Collaborate with development teams to review usage and access patterns to ensure databases are placed on the optimal data platform
• Maintain knowledge of data platform and technology changes for integration into data landscape where appropriate
• Lead cross-team projects to completion

Qualifications

We understand every organization is different and professionals have their own unique history and experience, so we don’t expect to find a 100% match of candidate competencies in respect of the tech stack we use in Wood Mackenzie.

We list our preferred technologies, but if you have transferrable knowledge and you are willing to learn, we will consider your application.

Requirements:

• 5-8 years of experience in Database Architecture, Database Engineering, or Database Administration roles
• Bachelor’s degree (or equivalent) in IT/IS/CS or equivalent work experience
• Expertise in two or more of these database platforms.
  • Microsoft SQL server
  • PostgreSQL server
  • Oracle 12c+ (18+ preferred)
• Experience with cloud PostgreSQL and SQL platforms (Azure and AWS )
• Experience in query review and optimization
• Ability to participate in on-call support rotation 
• Ability to work independently as part of a cross-functional, multi-locational team
• Ability to mentor junior team members and contribute to cross-team proficiency training
• Experience with Microsoft SSIS troubleshooting.
• Experience with Infrastructure as Code

Additional Preferred Skills:

• Knowledge of Microsoft S