Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Database/DevOps Engineer
EndavaDatabase/DevOps Engineer
Oct. 2021Romania Technologies and tools used during the years • PostgreSQL, Oracle, MS SQL, MongoDB • SQL, PL/SQL, PL/pgSQL • Java, Bash • Oracle SQL Developer Data Modeler • Ansible, Terraform, Docker, ActiveMQ, Nginx, Nagios, Grafana, Prometheus • Microsoft Azure, AWS • DBeaver, PL/SQL Developer, Oracle SQL Developer • Git, GitLab Personal projects below: ActiveMQ implementation in the OpenEMR stack Duration: 07.2024 — till now EMR is a medical billing application designed to streamline financial operations in healthcare management. The project aimed to integrate ActiveMQ into the application's stack to improve message transfer between the application and the PostgreSQL database. Team 2 specialists Position DBA/DevOps Engineer Responsibilities • Implementing an application stack using Docker, consisting of the application, ActiveMQ, Nginx, and a PostgreSQL database • Leveraged Ansible to automate the configuration and deployment of Docker environments and the application stack • Employed Terraform to deploy and manage virtual machines, ensuring a scalable and repeatable infrastructure • Conducted in-depth analysis of database performance, identifying bottlenecks and areas for improvement • Implemented performance tuning techniques to optimize database queries, indexing, and resource usage • Managed code versioning using Git/GitLab, ensuring proper version control and collaboration across the development team • Created detailed architecture diagrams to visually represent the structure and components of deployed applications • Conducted thorough testing of deployed applications and their components to verify proper operation and performance Partitioning of a buyline table Duration: 01.2024 — 03.2024 Some large queries triggered by the application were only accessing a few days (or up to one month) of recent data, referred to as "hot data." To improve the overall application performance, particularly for these high-consumption queries, we decided to implement range partitioning (by month) for a big table. Team 15 specialists Position PostgreSQL DBA Responsibilities • Collaborated with cross-functional teams to diagnose and address performance issues impacting database operations • Led discussions to evaluate various optimization strategies, ultimately deciding that range partitioning was the most effective solution • Conducted extensive testing of the range partitioning solution in lower environments, replicating data volumes similar to production • Analyzed the performance of problematic queries and execution plans to validate the effectiveness of the partitioning strategy • Negotiated a downtime window that minimized disruption to business operations while allowing sufficient time for the implementation • Executed the range partitioning change in the production environment, carefully monitoring the process to ensure a smooth implementation • Continuously monitored database performance post-implementation, analyzing key metrics to assess the impact of the change • Coordinated with the application team to evaluate performance improvements from their perspective, ensuring alignment between database and application optimizations Technologies and tools • PostgreSQL, Bash scripting Migration of database information from PostgreSQL to MongoDB Duration: 01.2024 — 03.2024 The purpose of the migration was to move audit tables to MongoDB to achieve better horizontal scaling. The goal was to improve the performance of insert and select statements by using sharding (spreading the audit collection across multiple servers). Team 3 specialists Position PostgreSQL DBA Responsibilities • Collaborated with the customer to thoroughly discuss and validate the benefits of the proposed solution, ensuring alignment with their business goals. • Presented technical details and expected outcomes, addressing any questions or concerns the customer had regarding the implementation • Deployed the solution on AWS, leveraging the Database Migration Service (DMS) to facilitate seamless data migration • Configured the DMS instance and established two connectors, one for the source database and one for the target MongoDB database • Ensured that the connectors were correctly set up to maintain secure and efficient data transfer between the two environments • Developed and executed a replication task within DMS to migrate both existing data and ongoing modifications into the designated MongoDB collection • Coordinated with the development and operations teams to validate the successful migration of data and to troubleshoot any issues that arose during the process Technologies and tools • PostgreSQL, MongoDB, AWS ZFS Filesystem replication for all preprod databases Duration: 07.2023 — 12.2023 The native PostgreSQL solution of restoring a database from production to preprod daily was taking too much time, especially for large database clusters. As an alternative, we implemented a solution using ZFS filesystem snapshots for incremental restores. Instead of restoring a full backup, we relied solely on daily incremental restores, significantly reducing the time required for the process. Team 10 specialists Position PostgreSQL DBA Responsibilities • Tested ZFS replication (replicated databases using ZFS incremental snapshots) to determine if the solution suited the use case • Wrote Bash scripts for the implementation, integrating them with other components • Planned the entire implementation process, provided deadlines to the customer, and allocated team members from both the application and DevOps teams • Attended meetings with other teams to ensure the solution met their needs • Built a logging system for the replication script • Created cron jobs across all environments to replicate data as a whole, ensuring synchronization with the same timestamp • Created Confluence documentation to record the entire process • Assisted the DevOps team in integrating the replication process into Ansible • Gave a presentation to multiple teams about the entire replication process Technologies and tools • PostgreSQL, Ansible, AWS, Bash scripting, VS Code PostgreSQL Migrations from version 11 to version 13 Data Academy presentation Duration: 11.2022 — 02.2023 "Oracle Database Performance in Production Systems" presentation. It consisted of two parts: a theoretical section and a hands-on workshop. Team 1 specialist Position Oracle DBA Responsibilities • Documented the presentation, including the scope and structure, to ensure the audience understood the key concepts • Created the PowerPoint presentation, covering topics such as performance and response time, potential production issues related to performance, execution plans, indexes, DMLs, and partitioning • Delivered the theoretical part of the presentation • Conducted the hands-on session: created a scenario with large tables, both partitioned and non-partitioned, implemented indexes, wrote queries, generated execution plans, and provided explanations • Ran an SQL trace on a query and explained the TKPROF output Technologies and tools • Oracle Concepts, Oracle SQL Trace, TKPROF
Oracle Database Administrator
rinf.techOracle Database Administrator
Sep. 2020 - Sep. 2021RomaniaFinance Assistence Peformance Duration: 08.2021 — 10.2021 The project task was to investigate performance issues in a financial module. The goal was to improve the purging process, which was not keeping up with the insertion rate. Team 5 specialists Position Oracle DBA Responsibilities • Met with the application team and customer to fully understand their concerns • Analyzed AWR reports, initially focusing on overall performance at the global level • Identified slow processes and gathered detailed execution information by utilizing SQL trace and TKPROF • Successfully met expectations by improving performance through table reorganization, index creation, and advising developers on how to rewrite specific queries • Identified a significant query that took considerably longer to execute compared to other database servers due to a pushing predicates issue Technologies and tools • Oracle (AWR, SQL Trace, Tanel Poder Snapper ASM storage multiple migrations Duration: 05.2021 — 08.2021 The project involved improving I/O performance by replacing the disks at the storage level. After the disk replacement, it was necessary to update the ASM disks and reconfigure the disk groups accordingly. Team 1 specialist Position Oracle DBA Responsibilities • Collaborated with the infrastructure team to receive detailed information about the new disks, including specifications and configuration details • Developed and tested scripts ahead of time to facilitate the seamless addition of new disks into the Automatic Storage Management (ASM) environment • Proceeded with the migration during a maintenance window, ensuring caution despite the online process • Performed a thorough sanitization of the ASM environment post-migration to confirm that all components were functioning correctly Technologies and tools • Oracle (ASM, Cloud Control)
Oracle Database Administrator
SCC FranceOracle Database Administrator
Mar. 2018 - Sep. 2020RomaniaMultiple migrations from Oracle 11g/12c to Oracle 19c Duration: 02.2018 — 11.2020 To comply with the new application version, an upgrade/migration to a new database version, specifically version 19c, was mandatory. Team 20 specialists Position Oracle DBA Responsibilities • Designed the new server for the database, determining memory, CPU, and storage capacity requirements • Decided on the appropriate technologies for the new database based on application details, including Oracle Multitenant, RAC, or single instance • Selected the stable Oracle version for the upgrade • Developed the migration plan and shared it with all relevant parties, including DEV teams, test teams, and project managers • Created procedures and scripts to migrate the database to Oracle 19c, including RMAN scripts and Linux commands • Tested the entire migration process in a testbed environment, migrating the test database to 19c along with the application upgrade and performing a thorough sanitation • Executed the production migration to Oracle 19c • Investigated potential bugs or performance issues post-migration, working closely with the DEV team to resolve any problems Technologies and tools • Oracle (RMAN, Cloud Control), Bash PostgreSQL performance and security enhancement Duration: 02.2018 — 08.2018 Projects focused on enhancing the performance, security, and disaster recovery capabilities of a PostgreSQL database environment. Team 5+ specialists Position PostgreSQL DBA Responsibilities • Implemented PostgreSQL replication and disaster recovery using the pgBackRest tool • Tested a PostgreSQL sharding solution (CITUS) to evaluate performance with large tables spread across multiple servers • Investigated performance issues using OS tools like OSWatcher and database tools such as pGBadger, pg_stat_statements, and Explain Plan • Used pgrepack to reclaim empty space within databases • Automated various deployments using Ansible scripting, and integrated manually performed modifications into the Ansible inventory • Handled security-related requests, including user creation and grant management • Addressed connectivity-related issues such as pg_hba misconfiguration and AWS-related issues like security group rules and NACLs • Worked with connection pooling tools like pgBouncer • Used version control tools like Git and managed project repositories on GitLab • Deployed various applications from public repositories in Docker containers Technologies and tools • PostgreSQL, Ansible, Docker, GitLab, Git
Database Administrator
Oracle RomaniaDatabase Administrator
Apr. 2015 - Jan. 2018RomaniaA cloud technology company that provides organizations around the world with computing infrastructure and software to help them innovate, unlock efficiencies and become more effective. Team 10+ specialists Position Oracle Support Engineer Responsibilities • Handled service requests through the MOS ticketing system • Performed testing and opened new bugs • Provided existing fixes to customers by investigating and matching them with service request cases • Improved MOS documentation by creating new notes with discovered fixes • Coached new database administrator employees by providing knowledge transfer Technologies and tools • Oracle
Application Emgineer
Mind SoftwareApplication Emgineer
Jul. 2005 - Mar. 2015RomaniaImportant project: Configuration of PCI Compliance for all the production entities Duration: 05.2012 — 10.2012 Implementation of PCI compliance in order to align the company with the security standards. The idea was to configure certificates for every application in order to encrypt “in flight” data. Team 30 specialists Position Application Engineer Responsibilities • Held multiple meetings with Dev, Test, and Support teams to establish standards and determine necessary modifications at the application level • Initially tested the changes in lower environments, prepared configurations and scripts, including SSL certificate generation, configuration, and SQL scripts • Estimated the production downtime and discussed it with the customer to set clear expectations • Implemented the changes in production, including application and database configuration, JBoss server certificates (trust and key), Oracle certificates, and execution of SQL scripts • Conducted thorough testing after the implementation was completed Technologies and tools • Oracle Wallet, SQL, Bash, Cert Gen

Requests

Touchpoint image
11Applied by 1
Looking for a Job
Senior Database Administrator/Dev Ops Job Search
Show more
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
📝
Get Recommended to New Customers
👋
Connect with Like-Minded People
💸
Raise Capital
🚀
Find a side project
😎
Reach Top Niche Experts
⚡
Find Jobs on a Hidden Market
💼
Find a Perfect Co-Founder
🙌
Find a Trusted Mentor
🤝
Hire Top Global Professionals
See more people like Andrei on Intch
IT
490477 people
16
Frontend developer @ Blacksea digital
15
Digital Transformation Consultant | Marketing Technology Strategist @ Independent Consultant (Self Employed)
15
Software developer
ITData Engineer
38210 people
15
Senior Appian Developer @ PwC
24
CEO, Founder, Engineer @ Astrali
21
SQL Developer @ Radburg