Alexey is a proficient DBA with over 10 years of experience in coding, testing, and supporting database solutions on various SQL Server, PostgreSQL, Oracle DB versions and configuration. Built, documented, supported, and integrated systems according to standards. Areas of expertise include DB installing, maintaining, upgrading, back-up and recovery, troubleshooting, as well as DB programming (stored procedures, functions, triggers, etc), debugging. Alexey is highly-skilled in design and tuning, bottlenecks detecting, strategic planning, database monitoring and growth, performance improvement, and process automation.
Provide support for database related issues, including performance, security, locks, bugs, connectivity, and auditing.
Establish the needs of users and monitor user access and security. Monitor performance and manage parameters in order to provide fast responses to front-end users.
Maximize service availability and oversee database security.
Managed databases 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 aautomation 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 back-up 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 databases installations, tuning, administration, back-up and recovery, and troubleshooting.
Provided day-to-day support and maintenance for existing databases, also using native monitoring and troubleshooting tools.
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 in the project: AWS., Oracle 11g, PostgreSQL 11/12 on Windows / Linux.
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; Transferring data between different databases; Upgrades of Oracle versions. Closely collaborated with two developer teams. Technologies: Oracle 9 / 10 / 11 / 12 on Windows / Linux.
Worked on a complete system design and DB creation, including all database procedures and functions, as well as database tuning. The project will be in production soon. Closely worked with developer teams, designers, and project managers.
Worked as an Oracle DBA for the Ministry of Internal Affairs, Moldova on an automated fingerprint identification system. Performed the complete creation of the databases, all db procedures and functions, db tuning and production support for several years. Closely collaborated with two developer teams.