Alexey is a Senior Database Administrator with 15+ years of experience coding, testing, and supporting database solutions on various SQL Server, PostgreSQL, and Oracle DB versions and configuration. His areas of expertise include DB installing, maintaining, upgrading, backup and recovery, troubleshooting, as well as DB programming (stored procedures, functions, triggers, etc.) and debugging. Alexey is highly skilled in design and tuning, bottlenecks detecting, strategic planning, database monitoring and growth, performance improvement, and process automation. He builds, documents, supports, and integrates systems according to standards.
Working on the complete database design for a healthcare and insurance system, including creation, administration, backup and recovery, and lifetime production support.
SQL ServerDatabase Administration (DBA)
SQL Server Reporting Services (SSRS)
Microsoft Data Transformation Services (now SSIS)
HTMLC#.NETJavaScript
Brillix
Senior DBA/DB Developer
2022 - 2023 (1 year)
Tel Aviv, Israel
Worked with company clients on DB migration, installation, and patches.
Improved performance of several dozen procedures, created data transfer and ETL processes, and performed various DB administration tasks.
Worked on database development using SQL, PL/SQL, T-SQL programming (functions, procedures, triggers, etc.).
Oracle 11gDatabase Administration (DBA)
Database Development
Windows
LinuxSQL ServerSQL Server Reporting Services (SSRS)
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS)
Oracle PL/SQLT-SQL
ONE Technologies
Database Administrator
2021 - 2021
Tel Aviv, Israel
Worked on production database maintenance and support and various DB monitoring, administration, and troubleshooting tasks.
Performed databases upgrades, performance improvement and tuning with SQL, PL/SQL, DB backup and recovery, Shell automation, ETL, and RMAN.
Participated in data modeling, data warehousing, disaster recovery implementation, and production support;
Managed database creation, performance tuning, and administration in SQL, PL/pgSQL programming and debugging, Oracle 11g, PostgreSQL 11/12 on Windows/Linux.
Tuned PostgreSQL instances for increased performance during the production stage for a leading global provider in data platform consulting and managed IT services.
Worked on the automation of DBA activities and upgraded existing databases.
Managed the creation, tuning, and administration of databases for an IT solutions provider that delivers advanced civil registry and population management solutions.
Implemented processes for server backup and executed complex databases for critical problems on Windows/Linux.
Implemented system backup procedures and optimized database application performance through tuning.
Performed DB programming including stored procedures, functions, triggers, as well as debugging, bottlenecks detecting, and performance improvement with Oracle 10/11 and SQL Server 2008 on Windows.
Carried out database installations, tuning, administration, backup and recovery, and troubleshooting.
Provided day-to-day support and maintenance for existing databases using native monitoring and troubleshooting tools.
The project involved systems for civil registration and secure documents issues for several countries as well as fingerprints DB systems. Worked on creating, tuning, and administration of several databases, DB programming, performance improvement, debugging, data transfer between different databases, and upgrades of Oracle versions. Closely collaborated with two developer teams. Technologies: Oracle 9/10/11/12 on Windows/Linux.
Worked on the client's maintenance system complete re-engineering and refactoring from Oracle to Amazon Aurora PostgreSQL. Involved in DB programming, performance improvement, and debugging. Technologies used: AWS, Oracle 11g, PostgreSQL 11/12 on Windows/Linux.
Worked on a complete system design and DB creation including all database procedures and functions and database tuning. The project will be in production soon. Closely worked with developer teams, designers, and project managers.
Worked on an automated fingerprint identification system for the Ministry of Internal Affairs of Moldova. Performed the complete DB creation, all DB procedures and functions, and DB tuning and production support for several years. Closely collaborated with two developer teams.
Education
Mobile Devices (Android and iPhone) Programming
John Bryce Training College - Israel
2012 - 2013 (1 year)
Certificate in Databases Administration and Development
