SQL SERVER DBA

  • Gazprom

Job Description

InfraOps SQL DBA is responsible for the development and management of the Information Technology databases for the Gazprom Marketing and Trading (GM&T) business. The key tasks of this role are to maintain flawless day to day operations of databases and enable the expansion of the GM&T business by supporting production and non-production environment by installing, administering and managing SQL databases and managing incidents and service requests. ABOUT US Gazprom Marketing & Trading (GM&T) is a subsidiary of the Gazprom group – the world’s largest gas producer and one of the world’s largest energy companies. Headquartered in London, GM&T operates to provide Gazprom group with a global marketing reach, round the clock operational coverage and excellent customer service. Established in 1999, GM&T has grown from a single office in London into a truly global organisation, with around 1000 employees worldwide. With offices in Europe, Asia and the USA, GM&T trades energy commodities including gas, power, oil, LPG, helium, emissions, LNG and FX and also operates a retail business, trading as Gazprom Energy. Our culture is defined by our people. Through living our values every day we continue to create a culture that enables us all to succeed. We work as one team with our customers, our parent company and each other in order to understand each other’s needs. With an unstoppable passion for excellence, growth and learning, we’re committed to creating an environment that fosters the development of knowledge, skills and experience, so that our people can thrive and prosper in their careers with us. We believe that we have the best team in the industry which makes us a trusted partner across international capital and energy markets. Our diverse employee base, with a wealth of expertise, knowledge and experience makes GM&T a truly exciting place to work. We encourage new ideas and initiatives as innovative thinking is central to how we do business. Most importantly, we are a growing and developing business where inspired individuals can make a difference and help shape our future. ROLE OBJECTIVES InfraOps SQL DBA is responsible for the development and management of the Information Technology databases for the Gazprom Marketing and Trading (GM&T) business. The key tasks of this role are to maintain flawless day to day operations of databases and enable the expansion of the GM&T business by supporting production and non-production environment by installing, administering and managing SQL databases and managing incidents and service requests. DUTIES & RESPONSIBILITIES Ensure day-to-day running of SQL Server estate through monitoring of disk space, backups, log shipping, Responsible for monitoring of disk space, backups, log shipping, database mirroring, clustering, availability groups and troubleshooting failed jobs Proactive performance tuning and optimization of SQL server estate Conduct relevant SQL Servers audits Ensuring SQL Server estate is kept evergreen with latest service packs Ensuring DEV/QA/UAT environments are correctly refreshed when requested Checking and deploying code to DEV/QA/UAT/Live environments Participate in the support Rota including on-call availability Own and resolve P1 – P4 Incidents and Service Requests SKILLS & COMPETENCIES Proven track record in Database administration of SQL Server 2008 – 2014 with a particular focus on performance tuning OLTP & OLAP databases Experience working with clustering, availability groups and database mirroring A thorough understanding of Windows Server 2008 – 2012R2, virtualisation and SANs Business intelligence awareness through experience in reporting services, integration services and analysis services EXPERIENCE Core Skills: Excellent interpersonal and team skills Excellent time management skills and the ability to prioritize workload and demands Ability to work and remain calm in a pressurized environment Ability to work both as a part of the team and individually Experience working on an on-call Rota and handling out-of-hours incidents Technical Skills: Database administration on 32-bit and 64-bit SQL Server versions SQL 2016, 2012, 2008, 2008 R2, including performance tuning, indexing, clustering, Availability Groups and database mirroring An understanding of Windows Server (2008 R2 and 2012 R2), infrastructure and Enterprise Storage (SANs) Business intelligence awareness through experience in reporting services, integration services and analysis services Knowledge of SSAS and SSRS beneficial though training will be provided in these areas Knowledge of MongoDB is preferable EDUCATION Degree level education (Computer Science preferred) or relevant experience. Technical certification (such as MCDBA) is preferred ITIL v3 Foundation