Database Administrator Ii

Company Description

Wood Mackenzie is the global leader in data, analysis and consulting across the energy, chemicals, metals, mining, power and renewables sectors.

Founded in 1973, our success has always been underpinned by the simple principle of providing trusted research and advice that makes a difference to our customers. Today we have over 2,000 customers ranging from the largest global energy companies and financial institutions to governments as well as smaller market specialists.

Our teams are located around the world. This enables us to stay closely connected with customers and the markets and sectors we cover. Collectively this allows us to offer a compelling combination of global commodity analysis with detailed local market knowledge.

We are committed to supporting our people to grow and thrive. We value different perspectives and aspire to create an inclusive environment that encourages diversity and fosters a sense of belonging. We are committed to creating a workplace that works for you and encourage everyone to get involved in our Wellness, Diversity and Inclusion, and Community Engagement initiatives. We actively support flexible working and are happy to consider alternative work patterns, taking into account your needs and the needs of the team or division that you are looking to join.

Hear what our team has to say about working with us:
**Job Description**:
Wood Mackenzie has an exciting opportunity for a Database Administrator to join a dynamic global business to help drive change and innovation.

We are looking for a skilled Database Administrator or Database Reliability Engineer to 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 provide database availability and all aspects of 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
- Adhering to 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
- Creating and reviewing team procedures and best practice documentation

**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
- Collaborate with engineering and development teams to ensure database architecture aligns with organizational standards and best practices
- Review and contribute to procedure documentation
- Lead successful team projects to completion

**Qualifications**:
**Requirements**:

- 2-5 years of experience in Database Architecture, Database Engineering, and Database Administration roles
- Bachelor’s degree (or equivalent) in IT/IS/CS or equivalent work experience
- Proficiency with one or more of these database platforms.
- Microsoft SQL server
- PostgreSQL server
- 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
- Experience with Microsoft SSIS troubleshooting.
- Experience with Infrastructure as Code

Additional Information
**Additional Preferred Skills**:

- Knowledge of Microsoft SSAS
- Proficiency with Oracle and Oracle Grid infrastructure
- Proficiency in Linux administration (RHEL/Ubuntu).
- Proficiency in configuration management tools (Ansible/Salt Stack).
- Experience with programming / scripting languages such as Bash, Python, and PowerShell.
- AWS and/or Azure certifications

All you information will be kept confidential according to EEO guidelines.