DBRE III

• Jul 2022 - Present

Sr. DBA

• Apr 2020 - Jul 2022

Administration of various databases (Oracle, PostgreSQL, Snowflake)Migration from Oracle to PostgreSQL in AWS CloudCDC using Qlik Replicate (formerly Attunity)Automating usage of AWS Cloud resources using Terraform, Ansible, Pulumi

DB Expert

• Oct 2018 - Dec 2019

Consulting billing and charging staff (junior DBAs and users)Exploring new features of Oracle 18c/19c in test lab for future upgrade

Sr. Oracle DBA

• Jul 2014 - Oct 2018

Database optimization and tuningAutomation of test/dev environment recreationUpgrade version 11gR2 to 12cR1 on Linux platformUpgraded OEM from version 12c to 13cChanged backup strategy of production databases using RMANImplemented Active Data Guard technology with Real-time QueryImplemented Oracle Restart

Oracle DBA

• Aug 2012 - Jul 2014

Administration of about 20 instances of Oracle Database varying in purposes (OLTP, OLAP) and size ranging from 400GB up to 5TB. Migration from Oracle 10g on Windows to 11g on Solaris platform.Upgrade version 11gR2 to 12cR1 on Linux platform.Adopting of Oracle 13c Cloud Controller in heterogeneous environmentSetup Oracle Active Data Guard for mission critical OLTP databases.Architectural planning for deployment of new database applications from A-Z.Creation of backup/restore procedures using RMANOrganization of optimal data loading into Oracle Databases using tools such as SQL*LoaderExport and Import using DATA PUMPMonitoring databases 24/7 Security analyses and implementation of existing database infrastructure to conform ISO27000 standards Experiencing advanced technologies such as ASM, RAC, DataGuard on Oracle 11g/12cExploring new features of Oracle 18c/19c in test lab.Notable projects completed:1. DBA during Convergence Billing phase | and || implementationEstimation and planning of the new system database.Choosing rapid data migration techniques.Monitoring and controlling migration process.Post-migration tuning and troubleshooting of database.2. DBA Architect during Loyalty Manager system implementationChoosing virtual environment for Oracle Database and applications.Participation in database design process.Designing ETL packages to organize flat file processing.Tuning database for the maximum performance.Planning backup and restoration according policies.Configuring Physical Standby of database for High Availability.Creation of design and deployment documentation.

CRM Administrator

• Aug 2011 - Aug 2012

Administration of various CRM database servers.Maintenance and optimization of Oracle 10gR2/11gR2 database servers for CRM applications in dev/test/prod environment.

Unix and VoIP Administrator

• Aug 2007 - Aug 2011

Department of development of intellectual networks and servicesCreated an automated monitoring infrastructure using several key technologies including UNIX shell scripting and SQL. This allowed our HelpDesk team to effectively monitor network and performance statistics for remote devices and servers running various OSs.Successfully designed and developed a centralized backup/recovery strategy and procedures for several UNIX (FreeBSD,Linux) servers and MySQL, PostgreSQL databases.Implemented the company’s new DNS, Mail, Web ServersImplementation of virtualization technology based on KVM.Performing installation, configuration, update and migration of various FreeBSD/Linux servers.Design and implementation of various high availability solutions for a VoIP network diverse class 4 and 5 soft switches using Mera MVTS PRO, Mera Centrex, Asterisk/Trixbox.Administration of PortaOne (PortaSwitch, PortaBilling) system.Configuration and administration of various VoIP equipment by Cisco (AS5350, AS5400 etc.)Administration of cPanel (on FreeBSD) and Plesk (on Linux).

Linux Administrator

• Sep 2000 - Aug 2007

Linux system administration for various local companies which specialized mostly on web development including installation and configuration of LAMP (Linux, Apache, MySQL, PHP).LAN design, system configurations including DNS (bind), VPN (openvpn, ipsec), NFS, Samba, Apache, configuration of UNIX/Linux firewalls (iptables, ipfw), transparent proxy (using SQUID).Building secure environment for data processing Linux servers (POS terminals). Building bastion hosts in DMZ. Linux system administration for various local companies which specialized mostly on web development including installation and configuration of LAMP (Linux, Apache, MySQL, PHP).LAN design, system configurations including DNS (bind), VPN (openvpn, ipsec), NFS, Samba, Apache, configuration of UNIX/Linux firewalls (iptables, ipfw), transparent proxy (using SQUID).Building secure environment for data processing Linux servers (POS terminals). Building bastion hosts in DMZ.