Наш клієнт:
Our client is an international technology company focused on protecting complex industrial and operational environments, helping ensure the resilience of essential infrastructure while driving innovation in the cybersecurity space.
Ваші завдання:
- Lead the overhaul of CTD’s database schema to support high-load and scalable systems.
- Manage the transition from MariaDB to PostgreSQL while ensuring low risk to production environments.
- Design and develop a reliable Data Access Layer (DAL) for consistent data interaction.
- Establish clear models for transaction handling and session management.
- Improve database performance through effective indexing strategies and partitioning techniques.
- Set up database governance policies along with performance guidelines and best practices.
- Analyze and align database performance with system-level resources such as CPU, memory, and I/O.
- Develop monitoring, observability, and diagnostic solutions to simplify troubleshooting.
- Work closely with R&D, Product, and Support teams to ensure smooth collaboration and delivery.
Необхідний досвід та навички:
- 5+ years of experience as a Database Administrator (DBA).
- Strong practical experience working with MariaDB/MySQL and PostgreSQL.
- Proven track record of building and maintaining high-scale data systems.
- Expertise in query performance optimization, including advanced indexing and partitioning strategies.
- Deep understanding of transaction processing and concurrency control mechanisms.
- Hands-on experience handling high-throughput workloads and systems.
- Strong knowledge of data retention strategies and their implementation.
- English proficiency at Upper-Intermediate level or higher.
Було б добре:
- Hands-on experience designing and implementing Data Access Layers (DAL).
- Proven experience migrating MySQL/MariaDB databases to PostgreSQL.
- Solid familiarity with Python and working with ORMs.
- Practical experience operating in on-premise environments.
- Experience using and implementing database observability and monitoring tools.
Умови праці
5-денний робочий тиждень, 8-годинний робочий день;
Віддалена робота.