PROFESSIONAL SUMMARY:

• An Experienced, motivated and Pro - active Database Administrator with over eight years of extensive experience in Postgresql, Oracle, Microsoft Azure, Amazon Web
• Services (AWS) and SqL Servers. Responsible for the implementing, design, optimization of various database environments ranging from small business databases to large enterprise databases. Worked on complete SDLC. Proficient in database capacity planning, automated backup implementation, Performance Tuning on Linux/Unix and
• Windows platform, Production support, Upgrade, patching, monitoring and maintenance of Databases
• Performance Tuning
• Vacuuming
• Database Support
• Migration Oracle Goldengate Installation/Configuration
• Oracle Installation and Upgrade from 11G and currently on 19C
• Use Git and Bitbucket
• Oracle Forms and Reports Development Database-Backed Web Solutions
• SQL Tuning in an Oracle Environment
• Recovery Standby/Failover Administration
• Implement and monitor an Azure infrastructure Design infrastructure
• Oracle RAC & ASM Administration/Installation
• Data Security, Backup & Recovery
• Standby/Failover Administration
• Data Guard and Data Broker installation Cloud application design, and cloud management and monitoring.
• Developing, designing, deploying, migrating, integrating, and configuring an AWS infrastructure
• Serve as a data solution architect for cloud and big data-based data warehousing and analytics initiatives
• Determining workloads requirements
• Running workloads securely on AWS
• Implementing AWS autantication and securing data

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Support Database Administrator

Responsibilities:

• Involved in Installing/configuring PostgreSQL versions 10,11 and 12.
• Manage and monitor databases using pgAdmin and queried using tools like DBeaver and Sql workbench.
• Involved in Installing/configuring PostgreSQL VERSIONS 9.4 to 11.6
• Manage and monitor databases using pgAdmin and queried using tools like DBeaver and Sql workbench.
• Experienced in handling logical and physical database Backups, assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Backup PostgreSQL databases using tools like pg dump and pg dumpall for logical backups and Refreshes, pg basebackup for physical backup, pgbackrest.
• Enabled data replication across regions.
• Used restoration techniques like pg restore and (PITR) Point in Time Recovery.
• In security I has created security IAM user, policy, role, and security groups to control access into AWS resources.
• Installed and configured a log analyzer (Pgbadger) to generate reports for database matrices like wait event, locks, CPU consumption, error messages, database connections, idle transaction, and idle connection.

Confidential, OMAHA, NE

PostgreSQL/Oracle Database Administrator

Responsibilities:

• Participated in cross platform migrations such as Oracle to PostgreSQL.
• Documented and assisted in Data MIGRATION from ORACLE Databases to PostgreSQL database on premises and in AWS Cloud.
• Migration from on prem to AWS.
• Ability to analyze existing tools and databases and provide recommendations.
• Knowledge transfer to team mates on aspects of PostgreSQL and AWS.
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Monitored CPU utilization, memory, Database Connections, and storage space daily using pg stat activity, PEM, Pg view and AWS Cloud Watch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine - tune sql queries for performance improvements.
• Experienced in handling logical and physical database Backups, assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Configuring streaming replication (including cascading replication). configured a REPLICATION between MASTER and SLAVE, and monitored On-Going REPLICATION.
• IN ORACLE
• Implementing data guard with high availability and performance configurations and participated in data guard fail over tests.
• Knowledge in oracle data warehouse dba skills relating to administration and management of OLAP environments, and oracle OLTP.
• Working on Oracle 10g, 11g, 12c (Multi-tenancy), Data Guard, ASM, RAC database, Grid, OEM, CPU patches, Oracle installation, data base Upgrades, Migration, Backup, Recovery, troubleshooting, SR support, Golden Gate, configuring new & leas-rolling configuring manager, extract, pump, and replicate processes.
• Replication of data in heterogeneous data environments using Oracle Golden Gate.
• Troubleshooting and performance tuning golden gate replications and creating monitoring scripts for Golden gate in Unix scripting
• Designing, implementing, and supporting highly available RAC clusters for companywide single sign on application, as well as other data base solutions using advanced replication and standby (data guard) options.

Confidential

PostgreSQL/Oracle Production Support Database Administrator

Responsibilities:

• Used Ansible tool for automation .
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Used restoration techniques like pg restore and (PITR) Point in Time Recovery.
• Upgrading database version (pg dump/pg restore and pg upgrade).
• Used Ansible tool for automation.
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Used restoration techniques like pg restore and (PITR) Point in Time Recovery.
• Participated in cross platform migrations such as Oracle to PostgreSQL.
• Documented and assisted in Data MIGRATION from ORACLE Databases to PostgreSQL
• Involved in Installing/configuring PostgreSQL VERSIONS 9.4 to 11.6.
• Manage and monitor databases using pgAdmin and queried using tools like DBeaver and Sql workbench.
• Upgrading database version (pg dump/pg restore and pg upgrade.
• Installed and configured Enterprise DB Failover Manager (EFM) to monitor the Streaming replication.
• Installed and configured a log analyzer (Pgbadger) to generate reports for database matrices like wait event, locks, CPU consumption, error messages, database connections, idle transaction, and idle connection.
• Experienced in handling logical and physical database Backups, assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Enabled data replication across regions.
• Used restoration techniques like pg restore and (PITR) Point in Time Recovery.

Confidential

Junior Database Administrator

Responsibilities:

• Worked with Microsoft Office Suite, ALM, OEM, Toad and SQL Developer to monitor and manage databases.
• Troubleshooting and performance tuning.
• Performed Patches Installation