Veeraiah Nalabolu

Postgresql Dba @Leidos

Baltimore, MD, US

Resposiblities:• Migrated Oracle 12c databases to PostgreSQL9.6 Using Ora2Pg tool.• Installed and configured the Ora2pg tool and PostgreSQL9.6 using Ansible automation tool.• Migrated Oracle database objects like Tables, Views, triggers and procedures on separate files using Ora2Pg migration tool and imported using manual method.• Migrated Oracle data to Postgres using Ora2Pg migration tool and directive type copy and imported data using manual method.• created PostgreSQL database clusters and database using Ansible automation tool.• Expertise in creating Users, Roles and Profiles and Privilege management with role-based using ansible automation tool.• Expertise in Backup and Restore using pg_dump and pg_restore utilities.• Expertise in PostgreSQL cluster Filesystem backup using pg_basebackup and Point In-Time Recovery (PITR) when required using a continuous Archive Backup.• Expertise in PostgreSQL database High Availability setup through Streaming Replication.• Expertise in configuring application pooling using pgBouncer/pgpool tools.• Expertise in scheduling the Maintenance activities like VACUUM, REINDEX and CLUSTER.• Expertise in writing the shell scripts to automate database maintenance backup cron jobs.• Expertise in tuning the PostgreSQL cluster maintenance task auto vacuum tuning auto vacuum threshold and scale factor. etc parameters • Expertise in performance tuning of the PostgreSQL cluster tuning the memory parameters and complex SQL queries.• Expertise in PostgreSQL database Upgrades like dump/restore, pg_upgrade manual and • pg_upgrade link methods.• Expertise in using the source control using Git, Bitbucket and Ansible Devoops tools.• Expertise in configuring the database monitoring alerts using Nagios and check_postgresql.pl.Tools: Ora2Pg, Ansible, Git, PgAdmin, repmgr, Nagios, Toad and Sql Developer.

Northwestern Polytechnical University

Master's degree, Computer Science

JNTUH College of Engineering Hyderabad

Bachelor's degree, Electrical, Electronic and Communications Engineering Technology/Technician