Experience

LuxSoft ltd

• Latvia
• IT Services and IT Consulting
• 1 - 100 Employee

• Remote - Sr. PostgreSQL/DBA Consultant

  • Nov 2021 - Present

  • Database Design over RDS AURORA PostgreSQL. • Database Table Partitioning. • Modern Approaches to redesign existing tables without any downtime. • Custom utilities to Automate repeated Database tasks. • Optimization of long Queries and Query development. • Writing SQL queries, functions triggers, etc. • Design of OLAP / ROLAP cubes, to handle historical data, to reduce the repeated fetching from multiple RDS AURORA PostgreSQL Tables. • Maintenance activities, like a vacuum, and re-indexing. • Data Governance Policies to ensure better security and multitenant data isolation. • Implementation of the right Indexing Approach for performance optimization. • Query Optimization & Parameter tuning. • Managing roles & users’ hierarchy & security of database. • Making strategies for taking Database Backups, Point In-Time Recovery, Database Restore, Database Migration, etc. • Assisting the team and making strategies for the implementation of Maintenance activities and Rollback Plans. • Log analysis using AWS RDS log insights and Pgbadger reports. • Custom Python scripts to perform ETL operations for Data Migration using python3 (pandas). • Python script to migrate large volumes of data between two AWS environments using python3 (pandas). • Custom Python scripts to get the difference between different databases. Show less



A.P. Moller - Maersk

• Denmark
• Transportation, Logistics, Supply Chain and Storage
• 700 & Above Employee

• Database Administrator Team Lead

  • Mar 2019 - Nov 2021

  • Migration of existing Databases to AWS RDS AURORA PostgreSQL. • Design & Develop a Database over RDS AURORA PostgreSQL. • Query Optimization & Parameter Tuning. • Writing SQL queries, functions trigger, etc. • Optimized overall performance of existing databases by 30% to 40%. • Setup connection pooling for AWS RDS AURORA PostgreSQL Databases. • Written Python scripts for (AWS LAMBDA Function) to schedule maintenance scripts like VACUUM, ANALYZE, RE-INDEXING, etc. • Set up Cross Region Replication, MultiAZ Replication, RDS DB Snapshots, AWS security group, and AWS subnet groups. • Set up Cloud Watch to get monitoring alerts. • Installing log analysis and alert tools like Powa, pgBadger, etc. • Making schemes to avoid Dead-Lock situations. • Making schemes to take large cluster backups, setting up logical replication, database versions upgrade, log analysis, archiving of logs, PITR, tracing long-running queries and locking queries, and making schemes to avoid the same situations in the future. • Tuning up different configuration parameters to optimize the performance of DB and avoid High CPU Load. • Optimize database structure for large tables. • Partition tables, Writing Stored Procedures, Triggers, Views, Functions, and Common Table Expression (CTE). • Create an Index to speed up the search. • Creating Roles with different privileges (like read-only users, Roles with max connection limit, roles members of other roles, etc.) Show less



Rimkus Consulting Group, Inc.

• United States
• Industrial Machinery Manufacturing
• 1 - 100 Employee

• Senior Database Administrator/PostgreSQL Developer

  • Oct 2018 - Apr 2019

  • Design and Develop Database over RDS Cloud. • Convert Oracle Schema to PostgreSQL Compatible. • Convert SQL Server Schema to PostgreSQL Compatible. • Migration & Transformation of Data from Oracle Database to PostgreSQL. • Migration & Transformation of Data from SQL Server Database to PostgreSQL. • Set up Cross Region Replication, MultiAZ Replication, and RDS DB Snapshots. • Setup Cloud Watch to get Monitoring Alerts. • Writing out AWS Lambda Functions to schedule maintenance scripts like VACUUM, ANALYZE, etc. • Installing log analysis and alert tools like Powa, pgBadger, etc. • Making schemes to avoid Dead-lock situations. • Making schemes to take large cluster backups, setting up logical replication, upgrading of DB, versions, log analysis, archiving of logs, PITR, tracing long-running queries and locking queries, and making schemes to avoid the same situations in the future. • Tuning up different configuration parameters to optimize the performance of DB and avoid High CPU Load. • Built/modify existing PostgreSQL Database to add new tables or objects or columns to existing tables. • Optimize database structure for large tables. • Involved in the creation of partition tables. • Writing stored procedures, Triggers, Views, Functions, and Common Table Expressions (CTE). • Create an index to speed up the search. • Creating roles with different privileges (like read-only users, roles with max connection limit, roles members of other roles, etc.). • Analyzing logs for any issue, creating and analyzing pgBadger Reports. • Pooling of connections, using pgBouncer. • Finding locking queries, queries idle in transactions, and queries throwing errors. • Cleaning out dead tuples if not get cleaned by auto vacuum demon to reclaim space and optimize performance. Show less



Florida Career College

• Higher Education
• 400 - 500 Employee

• Database Specialist (Contractor)

  • Dec 2017 - Oct 2018

  • Creation of Azure PostgreSQL PAAS instance (Memory Optimized). Creating Vnet rules. • Azure PostgreSQL configuration parameter tuning. • Optimize database structure for large tables. • Involved in the creation of partition tables. • Configuring Backups & Point-In-Time Recovery. • Migrating PostgreSQL On-premises database to Azure PostgreSQL PAAS Instance. • Writing Python scripts to automate maintenance activities like Vacuum, Re-index, etc. • Data Encryption and Backup Encryption. • Assisting and recommending different teams for better performance. Query Optimization. • Setting Up Alerts to Monitor Azure PostgreSQL PAAS Instance. Show less



Riviana Foods Inc. - USA

• Food and Beverage Manufacturing
• 200 - 300 Employee

• • Jun 2013 - Nov 2017

  • Enhancing the security of data by implementing Row Level Security (RLS).• Installing log analysis and alert tools like Powa, Nagios, pgBadger, etc.• Making schemes to avoid Dead-lock situations.• Making schemes to take large cluster backups, setting up replication, upgrade of DB, versions, log analysis, archiving of logs, PITR, tracing long-running queries and locking queries, and making schemes to avoid the same situations in the future.• Built/modify existing PostgreSQL Database to add new tables or objects or columns to existing tables.• Optimize database structure for large tables.• Involved in the creation of Partition tables.• Writing stored procedures, Triggers, Views, Functions, and Common Table Expressions (CTE).• Create an index to speed up the search.• Creating roles with different privileges (like read-only users, Roles with max connection limit, roles members of other roles, etc.) Show less

• • Dec 2011 - Jun 2013

  • Create Roles and Users with required privileges.• Create an index to speed up the search.• Configure Firewall Rules and Private End Points.• Data Encryption and Backup Encryption.• Assisting and recommending different teams for better performance. Query Optimization.• Tuning up different configuration parameters to optimize the performance of DB and avoid high CPU load.• Optimize database structure for large volumes of data distributed over different DB Servers.