28 ноября приходите на новый хабрасеминар. В этот раз мы поговорим про HR-бренд, создающий образ компании, привлекательный для будущих сотрудников. Подробности и регистрация
Профессиональные навыки
Участие в профессиональных сообществах
Опыт работы
Ведущий оператор в сфере телекоммуникационных услуг
Senior PostgreSQL Database Administrator, Senior PostgreSQL Database Programmer
Февраль 2011 — По настоящее время (8 лет и 10 месяцев)
Experienced Senior Database Administrator, Senior Database Developer with over 10+ years of experience in PostgreSQL. Strong knowledge in designing, coding, testing and profiling PostgreSQL database in the highly loaded environment. Experienced with sharding techniques based on PL/Proxy. Strong knowledge on PostgreSQL contribs (hstore, ltree, intarray, dblink, pg_trgm, pgcrypto, etc) and on internals of PostgreSQL itself. Experienced in PostgreSQL profiling tools like pg_stat_statements, pg_stat_kcache, amcheck, amcheck_next, pg_metricus, pgbadger and others. Good experience in PL/pgSQL and ETL scripting and query optimization. • Responsible for providing 24x7 support for production PostgreSQL databases (80+ servers, 10000+ Databases, 500Tb+ data) for different cloud products (OCS, VoIP, CRM, Call Tracking, DNS) • Migrate database schema, business logic (PL/SQL to PL/pgSQL), functions, triggers, views, data from Oracle database to PostgreSQL database • Migrate PostgreSQL database schema and data from regular tables to partitioning tables (triggers, pg_partman, pg_pathman, built-in) • Migrate PostgreSQL databases from different replication systems (londiste, pglogical, streaming replication, logical replication) • Upgrade PostgreSQL databases and application tools from/to PostgreSQL versions 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10 with minimal downtime • Create plan for backup, recovery, disaster recovery, and fault tolerance of databases in co-location and multi-datacenters environment (barman, pg_basebackup, PITR, ceph, repmgr, PgBouncer) • Create monitoring center, new monitoring metrics, log analysis of PostgreSQL databases (Zabbix, Grafana, Prometheus, mamonsu, pgbadger, powa) • Migrate OLAP data to Greenplum Database and PostgreSQL materialized views • Create and maintain staging databases environment as well as hot standby databases (ansible, barman, repmgr, various scripts) • Stress tests of application releases in development cycle, PostgreSQL versions and new hardware (pgbench, Tsung, JMeter) • Provide technical resolution to PostgreSQL database related problems (pg_stat_statements, pg_stat_kcache, amcheck, amcheck_next, pg_metricus, pg_repack, execution plan analysis) • Maintain very large legacy code written in PL/pgSQL, develop database architecture, regular review a new code • Recruit, hire and train new employees