Database Administrator Production Support

Sr. Cloud PostgreSQL/Oracle/MySQL/Mongo SME

Name:Veeraiah

Mail:*****.******@*****.***

Ph:650-***-****

Clearence: Public Trust.

LinkedIn: https://www.linkedin.com/in/veeraiah-veeru-nalabolu-314161139/

Professional Summary:

Professional and Highly motivated. overall 10+ years of experience as a PostgreSQL/Oracle/MySQL/Mongo Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting Ansible, Terraform and documentation.

•Installation/Configuration/Managing Community PostgreSQL 9.6,10,11,12,13,14,15 and 16 instances. EDB Advanced Server (AS) 13.14.15 and 16.

•Hands on experience in writing ansible code to install and configure Open Source PostgreSQL and EDB AS Postgres on AWS EC2 instance.

•Hands on experience in writing terraform code to provision AWS RDS and Aurora clusters, Azure Single and Flex server and create GHA (Git Hub Actions) pipeline

•Hands on experience on wring the shell scripts to automate database maintenance scripts like backup and monitoring and schedule them using cron.

•Hands on experience in migrating and upgrading Oracle / PostgreSQL databases to new data centers (DC Relocation).

•Hands on experience installing and configuring Ora2pg tool to migrate on-premises Oracle database to AWS EC2 and on-premises PostgreSQL Databases.

•Hands on experience in migrating cloud databases using Liquibase for schema conversions and DMS for Data conversions and creating pipelines.

•Hands on experience with migrating oracle non-RAC databases using EDB replication server and Oracle golden gate (OGG) to reduce the down time for large databases.

•Good experience on PostgreSQL backup and restore using in built in pg_basebackup utility and using third party tools Barman and pg_backrest.

•Excellent experience on setting up PostgreSQL High Availability and configuring streaming replication using replication slots and third party tools using repmgr and patroni.

•Auto failover of PostgreSQL Streaming Replication using repmgr, patroni, EFM and custom scripts.

•Excellent experience in upgrading PostgreSQL databases using pg_upgrade on-premises databases and logical replication to upgrade PostgreSQL versions starting from 10.

•Hands on experience in upgrading AWS RDS and Aurora performing version compatibility to upgrade to higher version of PostgreSQL.

•Experience in implementing PostgreSQL connection pooling and Acceleration with programs like PgBouncer, Pgpool.

•Experience in Routine Vaccuming, Routine Reindexing and Logfile maintenance in PostgreSQL.

•Experience in Installing and configuring database monitoring tools PEM, Datadog,Dynatrace, Grafana, CloudWatch, check_postgres.pl using Negios Modules.

•Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.

•Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11gr2 RAC environment.

•Hands on experience on setting up High Availability of PostgreSQL instances using Streaming Replication.

•Excellent experience in Installing, Configuring, Up-gradation, Patches Oracle 9.x/10g/11g/12C on Operating Systems such as Sun Solaris, AIX, HP-UX, Red Hat, Linux, and Windows.

•Proficient in setting up Standby Database RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.

•Managed a very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.

•Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

•Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

•Expertise in RMAN database backup and recovery to tapes and disk in catalog and no catalog mode.

•Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

•Experience in using PG_DUMP, PG_RESTORE with Postgres plus for backup and restores.

•Experience in file system level backups, Continuous Archiving and Point-In-Time Recovery (PITR).

•Data loading using SQLLOADER, Logical backups using full export and DATAPUMP.

•Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK,EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

•Strong Knowledge of 11g advanced features like ASM, AWR, ADDM and FLASHBACK.

•Experienced in Installation of high availability RAC environment (2, 3, 4 and 5 node clusters) and upgraded standalone databases to 11g RAC environment.

•Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQLLoader .

•Experience in migrating Standalone Database to High Availability Oracle RAC Environment in ASM.

•Excellent experience of data migration, data archiving and data access techniques

•Experience in using OEM12c (Oracle Enterprise Manager) and OEM agents for Managing and Monitoring Databases.

•Proficient with Oracle Database Upgrade Assistant for Upgrade and Migration of Oracle Data to higher Versions and Different Platforms.

•Expertise in creating Users, Roles and Profiles and Privilege management with role-based security.

•Experienced in Advanced Replication for transferring data between two or more Master sites.

•Strong knowledge of PL/ SQL, SQL, UNIX shell scripting.

•Ability to work independently and as part of a team. Adaptable to a fast growing and changing environment.

•Flexible and have excellent trouble shooting and problem resolution skills.

•24/7 production database support with Support to developers & end-user

Technical Skills:

RDBMS

PostgreSQL, Oracle, MySQL

NoSQL

MongoDB

Cloud

AWS (RDS, Aurora, EC2, S3), Azure (Single Database, Flex Server, Azure VMS, Blob Storage)

Automation

Ansible, Terraform, Bash Script.

Operating System

Linux, Unix

Tools

EFM, Pgbouncer, PgBackrest, repmgr, Patroni, PgAdmin, DbEaver, Toad,RMAN, Git, Bitbucket, JIRA. Golden Gate, ADM, Ora2Pg, MySQL Etrabackup.Percona tool kit

Monitoring Tools

PEM, Negios, Dynatrace,Splunk, Cloud Watch, Datadog. OEM.

Utilities

Pg_dump, pg_dumpall, pg_basebackup, pg_restore, pg_upgrade,EXPDP,IMPDP

Ledios,MD. Jan 18 – Till Date

Sr. PostgreSQL/Oracle DBA/MySQL/MongoDB DBA

•Migrating Oracle 12c databases to PostgreSQL9.6 Using Ora2pg tool.

•Installed and configured the Ora2pg migration tool.

•Installed and configured open source PostgreSQL9.6 to PostgreSQL 15 and EDB AS 12 to 15 using both Source code and rpm.

•Analyze Database workloads and provision AWS Aurora, RDS Multi-AZ clusters using Terraform.

•Automated PostgreSQL database installation and cluster creation using Ansible on AWS EC2 instances.

•Expertise is creating parameter groups for AWS RDS, Aurora clusters and Azure Flex Servers.

•Generating Oracle DDL as a flat file using Ora2pg and Importing the flat files manually (manual import) on postgreSQL9.6 database.

•Migrating Views, triggers and procedures on separate file, exporting using ora2pg conf directive allow.

•Migrating Oracle data to PostgreSQL using ora2pg, Oracle Goldengate and AWS DMS and evaluate using Dbsolo tool.

•Expertise in creating Users, Roles and Profiles and Privilege management with role-based security using ansible and shell scripts.

•Securing the data via network configuring the TLS1.1.

•Creating and managing PostgreSQL extensions like dblink, FDW and pg_audit.

•Supporting database release using Liquibase tools.

•Tuning the PostgreSQL queries, procedures, functions.

•Backup and restore using pg_dumpall and pg_restore utilities and refresh database between Aurora, RDS and EC2 environments.

•Filesystem backup using pg_basebackup,pgbackrest,pgbarman and Point In-Time Recovery (PITR) when required.

•High Availability setup through Streaming Replication. Auto failover of PostgreSQL Streaming Replication using repmgr, Patroni and EFM.

•Setting up application pooling using PgBouncer/PgPool.

•Scheduling maintenance activities like VACUUM, REINDEX and CLUSTER.

•Install and configure database monitoring tools PEM, DataDog, Negios,Splunk and Dynatrace. Configuring CloudWatch monitoring tool for RDS, Aurora clusters.

•Analyzing Postgres logs using PgBadger tool.

•Upgrading PostgreSQL 9.6 to 10.1 using the pg_upgrade link method and PostgreSQL v>10 logical replication methods.

•Performing Aurora, RDS cluster minor and major version upgrades.

MySQL:

•Installed and configured the MySQL on AWS Ec2 and RDS multi-AZ clusters.

•Managing and Trouble shooting MySQL 5.* in both on prem and Cloud Databases.

•Performed database changes like schema and tables creation using Liquibase.

•Configured databases backups and recoveries using Xtrabackup tools as needed.

•Performed MySQL logical dumps to refresh databases across the environment.

•Configured MySQL Innodb cluster for High Availability.

•Configured MySQL Database monitoring and worked on capacity planning.

•Worked on MySQL processes, security and queries optimization.

•Analyzed code to improve query optimization and to verify that the tables are using indexes.

•Upgraded MySQL databases from 4.1 to 5.1.

•Develop shell scripts to backup and recover, upgrades and configure the monitoring tools.

•Develop Ansible playbooks to install, configure MySql databases and replication setup.

•Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.

•Supported 24/7 on-calls.

•

Environment: AWS RDS, Aurora, postgresql, EDB Postgres,Ansible, Terraform, Ora2pg, DBsolo, pgaudit,ORACLE 10/11g, 12C, SQL SERVER, AIX 5, RHEL (Red Hat Enterprise Linux) 6, SQL, RMAN, TOAD, OEM GRID, DATAGUARD, Golden Gate.liquibae

WellsFargo,

charlotte, NC

May 2017 – Dec2017

Sr. PostgreSQL/Oracle DBA

Description: The project involved supporting critical applications which use PostgreSQL databases and oracle 11gR2 and 12c Databases. It involved production support of Critical databases hosting on Exadata.

Responsibilities:

As Postgres DBA:

•Installed (source and rpm), configuring and managing PostgreSQL and Oracle instances.

•Monitoring Oracle and PostgreSQL instances through Nagios.

•Backup and restore using pg_dump and pg_restore utilities.

•File system backup using pg_basebackup and Point In-Time Recovery (PITR) when required.

•High Availability setup through Streaming Replication.

•Configured Data Guard broker to manage standby databases for switchover and failover operations.

•Analyzing Postgres logs using pgBadger tool.

•Auto failover of postgres Streaming Replication using repmgr, pg_lookout and pg_keeper.

•Multi master replication using Bucardo.

•Managing backups through pgBarman and pgBackrest tools.

•Maintenance activities like VACUUM, REINDEX and CLUSTER.

•Executing maintenance activities with low maintenance window using pg_squeeze.

•Tuning memory related parameter for better performance of postgres instances.

•Setting up application pooling using pgBouncer/pgpool.

•Automating pgBadger reports and backup/restore using shell script.

•Migration/upgrade of postgres databases (9.4 to 9.6).

•Setting up WAL Archiving in Postgres.

•Recovering the Postgres DB using a continuous Archive Backup

•Taking SQL dumps for backups

•Setting up Statistics Collection Configuration and viewing collected statistics

•Performing Regression tests by running the tests against temporary installation and on existing installation.

•Viewing locks in postgres Database in the pg_locks system table and determine the effect of lock contention on overall database performance.

•Determining the disk usage and Disk full failures.

•Monitoring the database activity with Dynamic Tracing.

Oracle DBA responsibilities:

•Installed oracle 11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.

•Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

•Installed OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

•Migrating databases to Oracle Exadata Database Machine X4-V2.

•Monitored & performed Exadata Cell storage server administration tasks using Cellcli & Dcli utility.

•Implemented and used Exadata Hybrid Columnar Compression (EHCC) for large objects in a Multi-terabyte Databases.

•Applied patches to Exadata cell storage servers using Patchmgr utility via rolling fashion method and to compute nodes using db node update.

•Implemented Active Data guard, by creating Physical Standby databases in 11gRAC & 12C environment for the Production databases.

•Upgraded 11g databases to 12c.

•Experience in Installing oracle 11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.

•Configured high availability services Load balancing and SCAN features for clustered databases.

•Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

•Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.

•Experience in patching RAC databases in rolling fashion to maintain high availability.

•Setup Oracle Audit Vault and Database Firewall for monitoring and blocking SQL statements according to the company standard policies.

•Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.

•Experience in Enabling, Disableling Oracle Database Vault.

•Used Oracle’s Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.

•Enabled Fine-Grained auditing at the Object level & specific DML Operations.

•Helping other DBAs in RAC, standalone installation of databases with ASM.

•Performed cross Platform 11g database Migrations from AIX to Linux platforms.

•Performed Point-In-Time Recovery of the database using RMAN.

•Worked on Data migration from SQL databases to Oracle Databases through MS-Access.

•Provided 24x7 Support for Production/Development databases.

•Performance tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components.

Environment: ORACLE 10/11g, 12C, SQL SERVER, AIX 5, RHEL (Red Hat Enterprise Linux) 6, SQL, RMAN, TOAD, OEM GRID, DATAGUARD, Golden Gate.

DTCC,coppell,TX March’16-May’17

Sr Oracle/PostgreSQL DBA

Responsibilities:

•Installed (source and rpm), configuring and managing PostgreSQL and Oracle instances.

•Monitoring Oracle and PostgreSQL instances through Nagios.

•Backup and restore using pg_dump and pg_restore utilities.

•Filesystem backup using pg_basebackup and Point In-Time Recovery (PITR) when required.

•High Availability setup through Streaming Replication.

•Configured Data Guard broker to manage standby databases for switchover and failover operations.

•Analyzing Postgres logs using pgBadger tool.

•Auto failover of postgres Streaming Replication using repmgr, pg_lookout and pg_keeper.

•Multi master replication using Bucardo.

•Managing backups through pgBarman and pgBackrest tools.

•Maintenance activities like VACUUM, REINDEX and CLUSTER.

•Executing maintenance activities with low maintenance window using pg_squeeze.

•Tuning memory related parameter for better performance of postgres instances.

•Setting up application pooling using pgBouncer/pgpool.

•Automating pgBadger reports and backup/restore using shell script.

•Migration/upgrade of postgres databases(9.4 to 9.6).

•Setting up WAL Archiving in Postgres.

•Recovering the Postgres DB using a continuous Archive Backup

•Taking SQL dumps for backups

•Setting up Statistics Collection Configuration and viewing collected statistics

•Performing Regression tests by running the tests against temporary installation and on existing installation.

•Viewing locks in postgres Database in the pg_locks system table and determine the effect of lock contention on overall database performance.

•Determining the disk usage and Disk full failures.

•Monitoring the database activity with Dynamic Tracing.

•Supported as 24X7 Production/development DBA to 25+ databases on 10 different servers with 2 TB in size.

•Installation and configuration of Oracle Database Software 11gR2.

•Installed, Configured and maintained Postgres Databases.

•Implemented ASM on RAC. Managing disks and disk groups with ASM.

•Performed migration from 10.2.0.4 to 11.2.0.4 for large databases up to 7.5 TB.

•Installed and Configured 3 Node 11gR2 RAC on Red Hat Linux and added 2 Node to make it a 5 Node RAC.

•Tons of experience in installation, configuration, troubleshooting RAC environments.

•Involved in the project implementing and configuring Real Application Clusters (RAC) on Oracle 11g on different nodes using ASM.

•Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.

•Enabling and disabling Oracle Database Vault.

•Performed Cloning for Oracle 11g databases to transport it to different machine, from development to testing environment applied patches using Opatch when required.

•Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances using RCONFIG.

•Migrating single Instance Databases to 2 Node RAC environments using Rconfig.

•Built physical standby databases for RAC and standalone databases on Linux and UNIX platforms.

•Load balancing of RAC instances.

•Monitoring and administration of databases through OEM12c Cloud control 12.1.0.3.

•Using Oracle Data Pump Network Link utility making faster exports/imports on large databases and saving lot of time.

•Upgrading database from Oracle version 9i and 10g to 11g and migration of data.

•Installation, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).

•Performance report and subsequent tuning, monitoring of production database.

•Setting up Physical Standby Database environment using Dataguard in /11g in Max Availability Mode.

•Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.

•Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.

Environment: Oracle 11g/10g/,RAC, AIX 6.1,GG, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v5.8.

Freedompay, Philadelphia, Pennsylvania

Jan’15– Dec’15

Sr,OracleDBA

Responsibilities:

•Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.

•Part of a 5-member DBA team managing 450+ production/QA/Development instances with databases sizes varying from few GB's to 75 TB's.

•Developed UNIX shell script to automate the process of RMAN backups using RMAN Catalog.

•Developed SQL Scripts to perform database checks.

•Manage Oracle 11g/10g RAC databases of size 500g to 8TB.

•Installed, configured, add, remove nodes in RAC environment and migrated single instances to RAC environment and performed RAC administration.

•Involved in designing of disaster recovery using Data Guard, High Availability using 10g RAC

•Adjusting Optimizer settings for improve SQL performance.

•Role transition (Switchover/Failover) in Data guard.

•Experience in upgrading the old OEM agents to the new OEM 12c agents and configuring different targets in 12c cloud control.

•Created and setup rulesets for in OEM12c for user-defined metrics.

•Worked on setting up Active directory based authentication in OEM 12c for determining the User Identity Access to enterprise manager cloud control.

•Enabled Fine-Grained auditing at the Object level & specific DML Operations.

•Used Data masking Pack as a security feature to secure the production environment data in other Non-Prod environment.

•Involved in POC for DB Installation and configuration 11gR2 on Linux VM Environment’s.

•Experience with Automatic Storage management implementation and also analyzing different problems including CSS related issues.

•Adding, deleting and creating different ASM disk groups.

•Performance analysis using AWR/ASH/ADDM reports and wait event analysis.

•Manage Oracle 11gR2 RAC database varying from 2-6 nodes.

•Administered 10g/11g Real Application Clusters (RAC) system on Linux x86-64 bit systems on ASM storage environments.

•Involved in maintenance tasks like bouncing production databases and changing log modes of DB.

•Test and Implemented NetApp Snap Manager for Oracle solution for configuring Backup & Restore for DB versions from 10.2.0.4, 11.1.0.7 and 11.2.0.2.

•Installed Oracle 11gR1 & 11gR2 database for developers to test applications.

•Performed regular Database Administration activities which involved - Database

•Upgrades from 10g to 11gR1 and 11gR2. Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.

Environment: Oracle 11g/10g/ AIX, HP-UX,HP 9000, Windows NT 4.0, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v4.5.

Education: Masters from Northwestern Polytechnic University (2015 Jan to 2015 December).

Contact this candidate