Администратор баз данных (DBA)

Был больше месяца назад

По договорённости

31 год (родился 08 января 1994)

Тбилиси, готов к переезду: Москва, Рязань и ещё 1 город

Занятость

полная занятость

Гражданство

Грузия

Контакты

Телефон

Почта

Будут доступны после открытия

Профессиональные навыки

Linux
SQL
MS SQL
PostgreSQL
Работа с базами данных
MS SQL Server
Bash
СУБД
MySQL
Python
Показать еще

Фото, имя и контакты доступны только авторизованным пользователям

Опыт работы 10 лет и 7 месяцев

- Май 2018 – работает сейчас
- 7 лет и 7 месяцев
Database Administrator
AppClick ( Out Source It Company ), Тбилиси
http://appclick.tech
Обязанности и достижения:
• Managed and optimized large-scale databases. • Work on serval Platforms like (Red Hat – Debian – Ubuntu Server - Centos Server – Windows Server) • Cloud (Google Cloud, Azure). • Ensure proper system setup for smooth operation, including hardware and software compatibility • Analyze database logs and system performance metrics to preempt issues before they affect users. • Implement and manage database security measures to prevent unauthorized access. • Perform routine database maintenance tasks such as database repair, updates, patching, and upgrades. • Manage data storage, partitioning, and archiving strategies to optimize database performance. • Setup and configure database systems such as SQL Server, PostgreSQL, ORACLE, ClickHouse, or MySQL • ensuring high availability and minimal downtime • Implemented and monitored backup and recovery solutions to prevent data loss and ensure business continuity • Performed security audits and enforced compliance policies to protect sensitive data. • Led successful database migrations. • Developed proactive monitoring systems, resolving issues before escalation. • Created and maintained comprehensive database designs, models. • Streamlined data retrieval with optimized SQL queries and enhanced security through data encryption. • Ensuring seamless transitions with minimal business disruption. • Ensured disaster recovery readiness and adhered to regulatory data retention requirements. • Monitors and reports database functions and overall system health. • Develops database applications, stored procedures and SQL statements for various applications, Triggers • Maintains and configures overall database security for databases and applications. • Write and manage scripts for automating routine database tasks (backups, health checks). Data Ingestion Pipelines: Configured and managed ETL pipelines to ingest large-scale datasets into ClickHouse from various sources such as Kafka, S3, and HTTP endpoints. Query Optimization: Improved query performance by leveraging materialized views, efficient indexing strategies (e.g., sparse primary keys), and partitioning techniques. Performance Monitoring: Monitored query performance and cluster health using ClickHouse's built-in tools and system tables; reduced resource usage by fine-tuning configurations. Troubleshooting: Debugged and resolved performance bottlenecks and data anomalies using ClickHouse logs, query profiling, and system queries.
- Май 2015 – май 2018
- 3 года и 1 месяц
Software Developer
AppCLick
http://AppClick.tech
Обязанности и достижения:
• Deploy Application Desktop Application Using (C++ - QtFramework - HTML Reporting – QtChart – QtNetworking) • Developed RESTful APIs for mobile and web clients, • ensuring secure communication between client and server Using (PHP – Nginx or Apache - VPS Cloud – Postgresql – Mysql - Mariadb). • Deployed applications using Docker on AWS cloud infrastructure, ensuring scalability and cost-efficiency. • Configured and optimized Nginx as the web server for efficient handling of HTTP requests and server resource allocation. • Used Redis for session and caching mechanisms, improving application speed and reducing database load. • ntegrated third-party payment gateways like Stripe for secure and efficient transaction handling. • Utilized SMSMISR API to add SMS and call functionality within the platform, enhancing communication features.

Образование

- Бакалавр
- 2015
Helwan University
Факультет: Computer Science
Специальность: IT

Обо мне

Дополнительные сведения:

Experienced Database Administrator with over 6 years of expertise in managing and optimizing databases, including 3 years working with PostgreSQL, 1 year and 6 month with MySql/Mariadb, and 2 years with Microsoft SQL Server. Proficient in ensuring high availability, minimal downtime, and secure data handling through advanced protocols and monitoring solutions. Proven track record of leading successful database migrations, streamlining data retrieval through optimized SQL queries, and implementing encryption for enhanced security. Proficient in database programming languages such as SQL, PL/SQL, and T-SQL, with hands-on experience in PHP, JavaScript, and Python. Skilled in cloud platforms like AWS, DigitalOcean, and Vultr, with a focus on maintaining business continuity through robust backup and failover strategies. A strong communicator and mentor, known for creating comprehensive database documentation and fostering a collaborative environment. Certified in a wide range of database and cloud technologies, ensuring up-to-date solutions that meet industry standards. Linux, SQL, MS SQL, PostgreSQL, Работа с базами данных, MS SQL Server, Bash, СУБД, MySQL, Python, Nginx, ETL, Windows Server, Unix Shell Scripts, SQL Server, Transact-SQL, RHEL, Ubuntu, Clickhouse, Power BI, Azure, Администрирование серверов Linux, DBMS, C++, MariaDB, Apache Kafka, or, ORACLE