Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Serguei Frampol

Chambly,QC

Summary

Dynamic database administrator and instructor with extensive experience in PostgreSQL, Oracle, and MySQL administration. Proven track record in cloud database deployment and disaster recovery planning. Adept at teaching complex concepts with clarity, leveraging strong technical skills, and a passion for knowledge transfer to drive team success.

Overview

29
29
years of professional experience
1
1
Certification

Work History

DBA, Analyst and Architect

Novadba
Brossard, Quebec
04.2013 - Current
  • PostgreSQL DBA: Multiple deployment of complex database environments, in both on-prem and in the cloud (GCP and AWS), with HA relied on both physical and logical replication types depending on projects. Managed manual extension compiles and installations. Used PMM to set up and configure the monitoring for the team, and for DBAs on call.
  • Deployed complex PostgreSQL Database infrastructures in AWS / hybrid, with automation by Terraform.
  • Oracle and Oracle Applications Database Administrator on various clients and projects. Managed databases of up to 7 TB, running on RAC and additional HA using DataGuard and GoldenGate. Performed sensitive Point-In-Time recoveries on both container and pluggable database levels. Worked with GL and HR E-Buisiness Suite environments (R11 and R12), with extensive patching, and environment refreshes.
  • MySQL DBA: Responsible for Percona Cluster on 5 Nodes, transferred to InnoDB Cluster on 5 Nodes, with backups sent to Azure cloud.
  • Deployed WordPress site updates with Ansible.
  • Worked on complex servers infratructure management automation using Puppet.

Linux Security Instructor

Novadba
Brossard, Quebec
09.2021 - 05.2023
  • Provided teaching on multiple levels of Linux OS - from basics to advanced security and servers set up. Linux infrastructure, filesystems and permissions, kernel basics, bash programming, firewalls, clustering solutions.

Snowflake Instructor

Novadba
Brossard, Quebec
02.2020 - 11.2020
  • Drove 1 week teaching cycles on the basics and advanced features of Snowflake running on GCP or on AWS.

Web Developer

Novadba
Brossard, Quebec
01.2016 - 12.2019
  • Provided support in PHP development, as well in MySQL for WordPress websites.
  • Developed multiple secured payment websites in conjunction with Chase Paymentech and PayPal.
  • Optimized MySQL and PostgreSQL databases for better website performances.

Oracle Apps DBA

Accenture
Montreal, Quebec
11.2008 - 04.2013
  • Managed complex E-Business Suite environments with extensive patching, as well as performance tuning.

Oracle Apps DBA

Reader's Digest
Montreal, Quebec
04.2005 - 11.2008
  • Managed both E-Business Suite environments and standalone Oracle databases.
  • Was responsible for database-level DR exercises.
  • Performed multiple Point-In-Time-Recoveries.

Oracle DBA

France Télécom
Paris, France
08.2000 - 08.2003
  • Managed database tiers for Telecom Fraud Detection systems implemented in Europe and in Latin America (Salvador).
  • Developed PL/SQL code for multiple backends.

PL/SQL Developer

Unilog
Paris, France
12.1996 - 08.2000
  • Developed frontend screens with Forms and Reports (former Developer/2000).
  • Developed multiple backend modules with stored procedures and packages.

Education

Master of Science - Electronic Engineering

Paris-Sud University (Paris XI)
Orsay, France
06-1996

Skills

  • PostgreSQL administration
  • Oracle administration
  • MySQL clustering
  • Automation tools: Ansible, Terraform and Puppet
  • Linux server setup
  • Data replication techniques
  • Cloud database deployment
  • Performance tuning
  • Disaster recovery planning
  • Teaching and training

Certification

  • Oracle Certified Professional, MySQL 5.6 Database Administrator
  • AWS: Cloud Practitioner
  • Microsoft Certified: Azure Data Fundamentals

Languages

English
Full Professional
French
Native/ Bilingual
Russian
Native/ Bilingual

Timeline

Linux Security Instructor

Novadba
09.2021 - 05.2023

Snowflake Instructor

Novadba
02.2020 - 11.2020

Web Developer

Novadba
01.2016 - 12.2019

DBA, Analyst and Architect

Novadba
04.2013 - Current

Oracle Apps DBA

Accenture
11.2008 - 04.2013

Oracle Apps DBA

Reader's Digest
04.2005 - 11.2008

Oracle DBA

France Télécom
08.2000 - 08.2003

PL/SQL Developer

Unilog
12.1996 - 08.2000

Master of Science - Electronic Engineering

Paris-Sud University (Paris XI)
Serguei Frampol