We are looking for a Data Warehouse (DWH) Administrator
About us
Kyivstar.Tech is a Ukrainian hybrid IT company and a resident of Diia.City. We are a subsidiary of Kyivstar, one of Ukraine’s largest telecom operators.
Our mission is to change lives in Ukraine and around the world by creating technological solutions and products that unleash the potential of businesses and meet users’ needs.
Over 600+ KS.Tech specialists work daily in various areas: mobile and web solutions, as well as design, development, support, and technical maintenance of high-performance systems and services.
We believe in innovations that truly bring quality changes and constantly challenge conventional approaches and solutions. Each of us is an adherent of entrepreneurial culture, which allows us never to stop, to evolve, and to create something new.
What you will do * DWH Management and Support: Administering, monitoring, and ensuring the continuous operation of the Data Warehouse (DWH) infrastructure * Performance Optimization: Performing regular tuning of SQL queries, indexes, partitioning, and DWH configuration parameters to achieve maximum processing speed * Security and Access Management: Configuring and controlling user access rights (roles, privileges) in compliance with internal security policies * Backup & Recovery: Developing, implementing, and regularly testing backup strategies and Disaster Recovery Plans (DRP) * Monitoring and Reporting: Implementing and maintaining monitoring systems, analyzing logs, and providing warnings for potential issues (space limits, blocking, low performance) * ETL/ELT Process Management: Collaborating with ETL developers (e.g., Informatica, DataStage) to optimize data loading processes and ensure their reliable operation * Storage Management: Controlling and managing disk space, archiving, and purging obsolete data * Troubleshooting: Rapid identification and resolution of critical incidents and performance issues
Qualifications and experience needed * DWH Platforms: Deep knowledge and proven experience in administering one or more enterprise-grade DWH platforms (e.g., Oracle Exadata/DB, Teradata, MS SQL Server, PostgreSQL/Greenplum, Snowflake) * SQL and PL/SQL: Proficient in SQL and experienced in writing/optimizing complex procedures, functions, and scripts * Networking and OS: Understanding of network protocols (TCP/IP), and knowledge of Linux/Unix administration sufficient for managing DWH instances and related tools * Performance: Experience in diagnosing and tuning DWH performance at the database, operating system, and hardware levels
A plus would be * 3-5 years in a Data Warehouse (DWH) Administrator or Senior Database Administrator role * ETL Tools: Experience with or understanding of ETL system architectures (e.g., Informatica PowerCenter) * Automation: Experience in writing scripts for automating routine tasks (Shell scripting, Python)
Personal Attributes * High level of responsibility and self-organization * Ability to work in a 24/7 environment (if necessary) and respond quickly to critical incidents * Analytical thinking and systematic problem-solving skills * Excellent communication skills for interacting with developers, business analysts, and other teams
What we offer * Office or remote — it’s up to you. You can work from anywhere, and we will arrange your workplace * Remote onboarding * Performance bonuses for everyone (annual or quarterly — depends on the role) * We train employees: with the opportunity to learn through the company’s library, internal resources, and programs from partners * Health and life insurance * Wellbeing program and corporate psychologist * Reimbursement of expenses for Kyivstar mobile communication