About the role
The candidate will have responsibilities across the following functions:
DatabASe Platforms:
- Maintains databASe security, integrity, and availability.
- Manages databASe performance and capacity.
- Works with team members to establish routine maintenance, monitoring, alerting, and metrics collection/logging to proactively identify database-related issues, ensuring the databASe is highly responsive at all times.
- Reviews performance stats and recommends changes for SQL query tuning/optimization.
- Participates in off-hours 24/7 on-call support on a rotational bASis.
Business Intelligence and Data Integration Platforms:
- Manages the platform on an ongoing bASis while performing monitoring, patching and support functions.
- Leads and conducts code reviews, design reviews, testing, and debugging activities at the application level.
- Remediates platform issues and bottlenecks impacting software development activities.
- Implements service and application monitoring across all platforms to ensure continuous availability and operational continuity of critical systems.
- Participates in DevOps, Agile, and continuous integration frameworks, including, but not limited to GitHub Actions and Azure DevOps CI/CD Pipelines.
- Evaluates, understands, and implements patches and environment upgrades.
- Demonstrates strong technical aptitude in cloud architecture, services, and design concepts.
- Works in an Agile environment; collaborates with Operations, Development, and QA functions to develop solutions and systems that are predisposed to scalability, security, and simplified maintenance, utilising automation whenever possible.
- Follows security management practices, including the ongoing promotion of awareness on current threats, auditing of server logs, and other security management processes.
- Manages/Coordinates virtual and physical servers including server provisioning, upgrading, installing, monitoring, maintaining, and performance optimisation.
- Identifies and resolves problems, often anticipating issues before they occur or before they grow; develops and evaluates options, implements solutions, communicates results to ensure corrective and timely action is taken, and manages incident resolution to ensure all components work together.
- Participate in off-hours 24/7 on-call support on a rotational bASis.
The core requirements for the job include the following:
Database Platforms:
- 5+ years of Data Warehousing experience with at leASt 2 years being on multiple platforms.
- 5+ years of hands-on experience with Google BigQuery and/or Azure Synapse.
- Effective use of AI and/or LLMs to increase efficiency in deliverables.
- Strong understanding of Dimensional Modelling.
- Understanding of CI/CD pipelines, Azure DevOps, and GitHub Actions.
- Understanding of networking principles.
- Knowledge of Terraform and/or Infrastructure as Code (IaC) methodology.
- Participate in off-hours 24/7 on-call support on a rotational bASis.
Business Intelligence and Data Integration Platforms:
- 5+ years' experience managing production BI & Data Integration environments.
- 5+ years' experience scripting using PowerShell, Bash, JavaScript, Python, or other scripting languages.
- 5+ years' experience with Power BI platform security setup and capacity management.
- 5+ years' experience with DBT platform security setup and capacity management.
- 5+ years' experience in automation using Release pipelines.
- 5+ years' experience with version control (GHE preferred) and automation tools such AS ADO, Terraform, Ansible, Puppet, etc.
- Effective use of AI and/or LLMs to increase efficiency in deliverables.
- Working knowledge of Linux/Unix/AIX Operating Systems, shell scripting, package management systems, and other utilities.
- Experience with SaAS, PaaS, and Cloud solutions.