Wood Mackenzie is the global data and analytics business for the renewables, energy, and natural resources industries. Enhanced by technology. Enriched by human intelligence. In an ever-changing world, companies and governments need reliable and actionable insight to lead the transition to a sustainable future. That’s why we cover the entire supply chain with unparalleled breadth and depth, backed by over 50 years’ experience. Our team of over 2,400 experts, operating across 30 global locations, are enabling customers’ decisions through real-time analytics, consultancy, events and thought leadership. Together, we deliver the insight they need to separate risk from opportunity and make confident decisions when it matters most.<a href="https://www.woodmac.com/">WoodMac.com</a><a href="https://www.youtube.com/watch?v=Y4AVwhQJj_w&amp;t=10s">Wood Mackenzie Brand Video</a>Wood Mackenzie Values<ul><li>Inclusive – we succeed together</li><li>Trusting – we choose to trust each other</li><li>Customer committed – we put customers at the heart of our decisions</li><li>Future Focused – we accelerate change</li><li>Curious – we turn knowledge into action</li></ul>Database Administrator IIJob DescriptionWood Mackenzie has an exciting opportunity for a Database Administrator II (DBA) to join a dynamic global business to help drive change and innovation. We are looking for an experienced DBA (Database Administrator) professional to help us improve our suite of databases to be more robust, efficient, automated, and cloud friendly.Role Purpose This role's main responsibility is to provide operational database management within the Site Reliability Engineering (SRE) team and work with the software engineering teams for new and existing databases. This encompasses:<ul><li>working in partnership with the business and the technology teams, bringing awareness and insight of the different operational constraints / opportunities for projects targeting cloud-based or on-premises databases.</li><li>design, implementation, and maintenance of cloud and on-prem database environments.</li><li>promotion of mutual feedback in cross-functional groups, following database administration best practices.</li><li>a strong focus on service availability and proactive detection of problems.</li><li>ability to articulate technical and business concepts to different audiences and be able to influence technical decisions with solid metrics collection and proof of concepts.</li></ul>Responsibilities:<ul><li>Write infrastructure as code (Terraform, AWS CloudFormation) for use with database automation and creation</li><li>Help plan and manage database projects, ensuring successful implementation and delivery with the assistance of Senior and Principal DBAs (Database Administrators).</li><li>Develop, improve, and implement backup and recovery strategies for mission-critical databases.</li><li>Contribute to the design and optimization of databases, ensuring scalability and performance.</li><li>Act as a mentor to more junior DBAs, sharing knowledge and best practices.</li><li>Evaluate, recommend changes to, and contribute to changes in DBA processes and workflows.</li><li>Participate in / conduct post-mortems of production incidents.</li><li>Collaborate with cross-functional teams to align database strategies with business objectives.</li><li>Migrate legacy servers to newer versions and to the cloud where applicable.</li><li>Assist with operational security and compliance.</li><li>Raise potential threats to operational and security teams.</li><li>Participate in 24/7/365 on-call support rotation every few weeks.</li></ul>QualificationsWe understand every organization is different and professionals have their own unique history and experience, so we do not 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 what you do not know, we will consider your application.Skill Requirements:<ul><li>2-5 years' experience with Database Administration</li><li>Work with software engineering teams to provide direction in database queries and indexes for optimum efficiency and supportability.</li><li>Work in an Agile environment supporting multiple software engineering teams.</li><li>Substantial experience with one or more of the following database platforms.<ul><li>Microsoft SQL server</li><li>PostgreSQL / Enterprise Database (Postgres Advanced Server)</li></ul></li><li>Proficiency with Azure Postgres, Azure SQL, AWS Aurora, and/or AWS RDS (Relational Database Service).</li><li>Proven experience with planning / managing database projects.</li><li>Proven experience with backup and recovery strategies including testing.</li><li>Experience with database design principles and optimization for scalability and performance.</li><li>Mentorship experience for more junior DBA members.</li><li>Assist and direct routine system/database maintenance.</li></ul>Additional Preferred Skills:<ul><li>Proficiency with infrastructure as code using Terraform / Cloud Formation.</li><li>Intermediate to advanced Linux administration skills (Ubuntu/RHEL).</li><li>Experience with configuration management tools (Ansible/Salt Stack).</li><li>Proficiency with programming / scripting languages such as Bash, Python, and PowerShell.</li><li>Proficiency with command line tools to quickly triage and fix production issues.</li></ul>Equal OpportunitiesWe are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex, national origin, disability or protected veteran status. You can find out more about your rights under the law at <a href="http://www.eeoc.gov/">www.eeoc.gov</a> If you are applying for a role and have a physical or mental disability, we will support you with your application or through the hiring process.

In the middle of the energy transition, businesses and governments are faced with significant challenges. But the pace and scale of change mean every decision is made&nbsp;under mounting pressure.&nbsp; Now, more than ever, companies need reliable data, analytics and actionable insight. Wood Mackenzie is the&nbsp;leading global provider of data and analytics solutions&nbsp;for the renewables, energy and natural resources sectors . Wood Mackenzie&rsquo;s services&nbsp;include data, analytics, insight, events and consultancy.&nbsp; A trusted partner for over 50 years, Wood Mackenzie&rsquo;s team has over 2,300 experts across more than 30 global&nbsp;locations who cover the entire supply chain. Wood Mackenzie&rsquo;s data and analytics empowers energy producers, governments and financial institutions to be confident in&nbsp;their investment decisions in the face of rapidly evolving markets. Part of the Veritas group.

Database Admin II

Wood Mackenzie is the global data and analytics business for the renewables, energy, and natural resources industries. Enhanced by technology. Enriched by human intelligence. In an ever-changing world, companies and governments need reliable and actionable insight to lead the transition to a sustainable future. That’s why we cover the entire supply chain with unparalleled breadth and depth, backed by over 50 years’ experience. Our team of over 2,400 experts, operating across 30 global locations, are enabling customers’ decisions through real-time analytics, consultancy, events and thought leadership. Together, we deliver the insight they need to separate risk from opportunity and make confident decisions when it matters most.<a href="https://www.woodmac.com/">WoodMac.com</a><a href="https://www.youtube.com/watch?v=Y4AVwhQJj_w&amp;t=10s">Wood Mackenzie Brand Video</a>Wood Mackenzie Values<ul><li>Inclusive – we succeed together</li><li>Trusting – we choose to trust each other</li><li>Customer committed – we put customers at the heart of our decisions</li><li>Future Focused – we accelerate change</li><li>Curious – we turn knowledge into action</li></ul>Database Administrator IIJob DescriptionWood Mackenzie has an exciting opportunity for a&nbsp;Database Administrator II (DBA)&nbsp;to join a dynamic global business to help drive change and innovation. We are looking for an experienced DBA (Database Administrator) professional to help us improve our suite of databases to be more robust, efficient, automated, and cloud friendly.Role Purpose&nbsp;This role's main responsibility is to provide operational database management within the Site Reliability Engineering (SRE) team and work with the software engineering teams for new and existing databases. This encompasses:<ul><li>working in partnership with the business and the technology teams, bringing awareness and insight of the different operational constraints / opportunities for projects targeting cloud-based or on-premises databases.</li><li>design, implementation, and maintenance of cloud and on-prem database environments.</li><li>promotion of mutual feedback in cross-functional groups, following database administration best practices.</li><li>a strong focus on service availability and proactive detection of problems.</li><li>ability to articulate technical and business concepts to different audiences and be able to influence technical decisions with solid metrics collection and proof of concepts.</li></ul>Responsibilities:<ul><li>Write infrastructure as code (Terraform, AWS CloudFormation) for use with database automation and creation</li><li>Help plan and manage database projects, ensuring successful implementation and delivery with the assistance of Senior and Principal DBAs (Database Administrators).</li><li>Develop, improve, and implement backup and recovery strategies for mission-critical databases.</li><li>Contribute to the design and optimization of databases, ensuring scalability and performance.</li><li>Act as a mentor to more junior DBAs, sharing knowledge and best practices.</li><li>Evaluate, recommend changes to, and contribute to changes in DBA processes and workflows.</li><li>Participate in / conduct post-mortems of production incidents.</li><li>Collaborate with cross-functional teams to align database strategies with business objectives.</li><li>Migrate legacy servers to newer versions and to the cloud where applicable.</li><li>Assist with operational security and compliance.</li><li>Raise potential threats to operational and security teams.</li><li>Participate in 24/7/365 on-call support rotation every few weeks.</li></ul>QualificationsWe understand every organization is different and professionals have their own unique history and experience, so we do not 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 what you do not know, we will consider your application.Skill Requirements:<ul><li>2-5 years' experience with Database Administration</li><li>Work with software engineering teams to provide direction in database queries and indexes for optimum efficiency and supportability.</li><li>Work in an Agile environment supporting multiple software engineering teams.</li><li>Substantial experience with one or more of the following database platforms.<ul><li>Microsoft SQL server</li><li>PostgreSQL / Enterprise Database (Postgres Advanced Server)</li></ul></li><li>Proficiency with Azure Postgres, Azure SQL, AWS Aurora, and/or AWS RDS (Relational Database Service).</li><li>Proven experience with planning / managing database projects.</li><li>Proven experience with backup and recovery strategies including testing.</li><li>Experience with database design principles and optimization for scalability and performance.</li><li>Mentorship experience for more junior DBA members.</li><li>Assist and direct routine system/database maintenance.</li></ul>Additional Preferred Skills:<ul><li>Proficiency with infrastructure as code using Terraform / Cloud Formation.</li><li>Intermediate to advanced Linux administration skills (Ubuntu/RHEL).</li><li>Experience with configuration management tools (Ansible/Salt Stack).</li><li>Proficiency with programming / scripting languages such as Bash, Python, and PowerShell.</li><li>Proficiency with command line tools to quickly triage and fix production issues.</li></ul>Equal OpportunitiesWe are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex, national origin, disability or protected veteran status. You can find out more about your rights under the law at <a href="http://www.eeoc.gov/">www.eeoc.gov</a>&nbsp;If you are applying for a role and have a physical or mental disability, we will support you with your application or through the hiring process.&nbsp;&nbsp;

Database Admin II

About the Job

About the Company

Wood Mackenzie

Similar Jobs

Senior DevOps Engineer

Senior DevOps Engineer

Senior Site Reliability Engineer (SRE)

Senior Site Reliability Engineer (SRE)

Site Reliability Engineer II

Site Reliability Engineer II

Manager, Database Engineering

Manager, Database Engineering

SENIOR DATABASE ADMINISTRATOR (F/M/D)

SENIOR DATABASE ADMINISTRATOR (F/M/D)

SQL Azure DBA

SQL Azure DBANew

SQL Server - Azure Database Administrator

SQL Server - Azure Database AdministratorNew

Azure DBA

Azure DBANew

Azure Database Administrator

Azure Database AdministratorNew

Senior Software Engineer (Azure Database Administrator)

Senior Software Engineer (Azure Database Administrator)New