Data Modeller

Job Title:

Senior Cloud Service DBA

Department & Team

Technology

Location:

INDIA

Reporting To:

Senior DBA – Team Lead

Role Purpose:

This role will be a mix of project, BAU and innovation and will encompass typical database administration duties that you may expect in a large-scale telecommunications environment: performance tuning, replication, database design, backups, high availability, encryption, security, configuration etc.

The Client DBA Team is responsible for the delivery, maintenance and support of all Database platforms used by Clients twenty-four hours a day, seven days a week. The team’s primary function is to ensure all relational and non-relational databases are optimised for performance, designed with agreed levels of fault tolerance.

1. Network Services Team – Responsible for IP Network and its associated components

2. Infrastructure Team – Responsible for Server and Storage systems

3. Database Services Team – Responsible for all Databases

4. Cloud Architect Team – Delivering future strategy, ongoing cloud performance optimisation.

The DBA function forms part of Client’s Tier 3 support function and works closely with the internal NOC, Service Desk, Infrastructure, IP Networks and Cloud Architect teams. To enable the business in achieving its stated objectives by assisting the other technology teams to achieve world-class benchmarks of customer service and support.

To highlight, a key requirement of the role will be involvement in defining our future strategy around database modernisation in the cloud.

Responsibilities:

Operations

· Involved in new solutions design discussions and to recommend suitable, secure, performance optimised database offerings based on business requirements

· Ensure all databases in the AWS and Azure are configured for performance, scale and high availability where required

· Take responsibility of modernisation of Clients database estate in the cloud, leveraging open source technologies and cloud native hosting platforms

· Drive innovation by constantly reviewing latest public cloud platform database service releases such as Babelfish in AWS to fast track adoption of native services

· Ensure security considerations are at the forefront when designing and managing database solutions

· Optimise query performance

· Ensure all key databases have deep insight monitoring enabled to enable improved capabilities around fault detection

· Perform regular database maintenance when required and ensure databases are backed up according to agreed RTO / RPO information

· Maintenance work to be planned meticulously to minimise/eradicate self-inflicted P1 outages

· Monitoring database costs regularly and identify strategies to minimize cost as part of internal FinOps practices

· Ability to provide technical system solutions, determine overall design direction and provide hardware recommendations for complex technical issues

· Provisioning, deployment, monitoring cloud environment using automation tools like Terraform

Skills & Experience:

Certifications:

· SQL Server Database Administration - REQUIRED

· AWS Certified Solutions Architect Associate – Highly Desirable

· AWS Certified Database Specialty – REQUIRED

· Azure Database Administrator Associate – Highly Desirable

Skills & Experience:

· Ideal candidate has been supporting traditional server based relational databases for over 8 years who then transitioned into AWS and Azure public cloud for the last 5 years

· SQL Server / MSSQL 2008 / 2012 / 2014 / 2016 / 2017 / 2019 (including Always-On and Analysis Services)

· Postgres / MYSQL as standalone and managed service platforms

· Strong database migration experience (Particularly MSSQL to open source and leveraging AWS native platforms including RDS, Athena, Aurora)

· Extensive AWS experience in a commercial environment, architecting database best practices

· Strong experience supporting AWS / Azure based datalake/data warehouse environments. Required to support internal BI teams

· Solid experience and understanding which workloads are best suitable for which specific database platforms in AWS and Azure

· Extensive experience and understanding of database security, including appropriate encryption and authentication best practices

· Good working knowledge of Microsoft Power BI

· Good knowledge of Azure cloud database services

· Any working experience around non-relational databases (internally hosted or managed service such as DynamoDB in AWS will be favoured)

· Good working knowledge of Windows and Linux Server Operating Systems

· Excellent presentation skills to both an internal and external audience

· The ability to share and communicate your specific expertise to the rest of the Technology group

Behavioural Fit:

· Professional appearance and manner

· High personal drive; results-oriented; make things happen; “can-do attitude”

· Can work and adapt within a highly dynamic and growing environment

· Team Player; effective at building close working relationships with others

· Effectively manages diversity within the workplace

· Strong focus on service delivery and the needs and satisfaction of internal clients

· Able to see issues from a global, regional and corporate perspective

· Able to effectively plan and manage large projects

· Excellent communication skills and interpersonal skills at all levels

· Strong analytical, presentation and training skills

· Innovative and creative

· Visionary and strategic view of technology enablers (creative and innovative)

· High verbal and written communication ability, able to influence effectively at all levels

· Possesses technical expertise and knowledge to lead by example and input into technical debates

· Depth and breadth of experience in infrastructure technologies

· Enterprise mentality and a global mindset

· Sense of humour

Role Key Performance Indicators:

· Design and deliver repeatable, best in class, cloud database solutions

· Pro-actively monitor service quality and take action to scale operational services, in line with business growth

· Generate operating efficiencies, to be agreed with Infrastructure Services Manager

· Establish a “best in sector” level of operational service delivery and insight

· Help creates an effective team

· Continuous improvement