SUMMARY

• Experienced professional Oracle and PostgreSQL database administrator with progressive more than 5 years as oracle dba 4 years as PostgreSQL DBA.
• I am very flexible to novelties, enthusiastic, adaptable to changing environments, proactive and team player with exceptional writing, verbal, analytical, and possesses excellent problem - solving skills & ability.
• I have worked with PostgreSQL databases where I migrated data from oracle to PostgreSQL in AWS cloud as well setting up PostgreSQL databases for high Availability, Disasters recovery, scalability and load balancing. proficient in PostgreSQL and Oracle RDBMS installation, configuration, patching, troubleshooting performance issues, Query optimization, hands-on experience in large and dynamic environments
• I have handled performance tuning, conducted backups and ensure integrity and security of databases. managed Postgres DB in the AWS environment. Postgres RDS and Aurora-Postgres
• Deep knowledge in PostgreSQL RDBMS installation, configuration, patching, troubleshooting, performance tuning backup and recovery. hands-on experience in large and very dynamic environments.
• Configuration of EDB and Community version PostgreSQL for production, pre-production and non-production environments.
• Upgrading databases servers leveraging pg upgrade and logical replication.
• Administrated PostgreSQL databases throughout SDLC including the non-production (Sandbox, development, test,) and production environment
• Experienced with optimizing database performance through exhaustive pro-active testing
• Performed Installation/configuring PostgreSQL. Mainly PostgreSQL VERSIONS 9.6, 10.11 and 11
• Performed cross platform Data Migration from Oracle databases to PostgreSQL database in AWS Cloud using SCT and DMS.
• Managed and monitored databases using pgAdmin and PEM.
• Planned and implemented streaming replication slots on a reporting system worked with Automation tools like crontab and Anisible writing new shell scripts Making changes in existing shell scripts
• Leverage pgbadger, pg hero for Performance tuning mostly. SQL Tuning using EXPLAIN ANALYZE and PG STAT ACTIVITY, PG STAT ALL TABLES, PG STAT STATEMENTS and Cloud watch on AWS.
• Performing core DBA tasks such as, creating roles, granting privileges, creating tables.
• Implementing the use of indexes, and primary & foreign key constraints as required
• I have provided production based on a ticketing system. And Assisted in defining and implementing MAINTENANCE PLAN for the database system.
• Performing maintenance activities like vacuum, vacuum full, analyze etc
• Experience of tuning PostgreSQL server settings & Troubleshooting performance issues.
• Configuring pg Badger for generating pg log statistic reports.
• Configuring and troubleshooting Pg Bouncer for connection pooling.
• Used Customized scripts in crontab, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns
• Experience in handling logical and physical database BACKUPS using pg dump, pg dumpall, pg basebackup as well as pgBackrest.
• Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recovery.
• Perform BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema REFRESHES
• Configuring streaming replication (including cascading replication)

TECHNICAL SKILLS

Database & Software: Oracle - 10g, 11g and 12c (OLPT and OLAP databases) PostgreSQL - 9.5,9.6, 10, 11 and 12

Operating System: Linux, Unix, Ubuntu, AIX, Solaris and Window.

Oracle Skills: TOAD, OEM Grid Control, Performance tuning, Database Security, Migration, Cloning, RMAN, RAC and Non-RAC, ASM DATAGAURD, GOLDENGATE, UPGRADE AND PATCHING (CPU & PSU), AWR, ADDM, STASAA, ASH, EXPLAIN PLAN, SQL TRACE, Backup & Recovery, Data Pump Export/Import, Transportable: Table Space, ZDLRA, Shell Scripting, SQL, SQL*Loader, PeopleSoft (HR, Finance and SCM), etc.

PostgreSQL skills: Pg Admin,pgbadger Pg Bouncer, Psql, Pg basebackup, Pg backrest, Pg dump, Pg restore, Pg upgrade, EXPLAIN ANAYZE etc.

PROFESSIONAL EXPERIENCE

Confidential

PostgreSQL DBA

Responsibilities:

• Administrated PostgreSQL databases throughout SDLC including the non - production (development, QAT) and production environments.
• Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.
• Configured REPLICATION between MASTER and SLAVE, and monitoring replication on a daily basis, using views like pg stat replication set up logical and physical replication slots and pg recievewal. configured logical replication, for schema and table migration. performed cross platform migrations Oracle to PostgreSQL where I documented and performed migration from ORACLE Databases to PostgreSQL database in AWS Cloud.
• Configured PgBouncer for connection pooling and load balancing.
• Configured pgbadger for log analysis and collection of statistics and PostgreSQL extensions like pg stat statetments, PostgreSQL foreign data wrapper etc.
• Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns as well full vacuum.
• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.
• Support daily administrative jobs like, monitoring and tuning databases and system for best performance.
• Successfully installed, patched and upgraded PostgreSQL 9.5,9.6, 10,11 and 12.
• Managed and monitored databases using pgAdmin, PEM, cloud watch
• Setup and maintenance of postgresql master-slave clusters utilizing streaming replication. promoted slave to master.
• Cross-datacenter disaster recovery and backup architecture initialized Clusters, created Databases, tablespaces, tables and users.
• Performed schema management, database sizing, maintaining privileges. perform backups on regular basis by implementing a stable and effective backup strategy as per SLA using PGBACKREST.
• Query optimization and troubleshooting
• Scheduled maintenance activities, Auto vacuum, full vacuum, Analyze and Re indexing to improve query response time.
• Performed SQL query optimization by creating and modifying indexes, setting transaction isolation levels and changing query structures.
• Write ad-hoc SQL Queries and analysis, creating and modifies tables, views and Stored Procedures based on business requirements.
• 24/7 support with on call rotation in all prod, QA and dev environment.
• Performing Regular database maintenance activities, database tuning and troubleshooting to improve performance.
• Managing users and their activities, and general database resource management
• Shell Script customization for automation jobs and database growth including the table and tablespace growth.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Tune top long-running queries on the production database server
• Monitored DB locks and determine strategies to address them. responsible for backup, recovery and upgrading all databases as well as monitoring to optimize performance
• Provided operational services and technical support for the database environment within the organization
• Create new users who can login to AWS console and also assign them to groups.
• Create policies for new user to have either admin or limited privileges in AWS Environment.
• Implemented Credential rotation for IAM users in AWS console.

Oracle DBA/Postgres dba

Confidential

Responsibilities:

• Upgraded Oracle 11g to Oracle 12C database version.
• Automate some task like backups and uses scripts to monitor tablespace growth.
• Monitoring database for growth and added space to tablespaces as per demand.
• Generating AWR reports on regular basis to identify database performance at peak load.
• Tuning SQL statement by analyzing explain plan and ADDM reports.
• Performance Tuning Experience - AWR, ADDM, ASH, SQL Tuning Advisors, EXPLAIN PLAN, SQL Trace with TKPROF and Toad.
• Implemented scripts to monitor and get information on free space, alert log errors.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Upgrade/Migration of databases from Oracle 10 to 11g, cross platform migration from different platforms.
• Perform Primary/Standby database switchover using Data Guard Broker.
• Automate, developed and maintained Linux shell scripts to collect and monitor database metrics and Produces Database health reports Using AUTOSYS.
• Utilized 13C OEM to administer multi-node RAC database also managed redo and undo in RAC environment Load balancing of RAC instances.
• Monitoring space, wait events, locks and long operations running on database.
• Supporting day-to-day Database administration activities like creating databases, troubleshooting tablespace issue, mount point space issue, high CPU utilization, locking/blocking sessions.
• Implemented Golden Gate Replication Unidirectional and Bidirectional replication.
• Supported Oracle Financial Services lending and Leasing (OFSLL) application.
• Supported Monitoring session waits for database performance and resolving performance issues.
• Experienced in using 10g, 11g and 12c features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Control Monitoring and Recycle Bin.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN)
• Extensive experience Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.
• Data guard Broker configuration and Managing Physical Standby databases using Oracle Data guard Broker.
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Experience on working with data guard physical/logical standby databases.
• Documented Standard Operation Procedures (SOP) for peers to follow.
• Applying upgrade patch, maintenance and interim patches on all databases.
• Expert in performance tuning, i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL Net, V$ views, DBA views and Data Modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Refreshing Dev and Test instances with data from Production on regular basis.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Used TOAD and OEM 12C for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Provide support for Oracle databases including applying patches, performance tuning, Backup and recovery issues with RMAN, trace analysis, service creation for apps to fail over, cluster and system management.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.
• Implemented Unidirectional and Bidirectional Golden Gate for real time data replication.
• Installed/configured/upgraded PostgreSQL 9.6 & 10 migrated databases from Oracle to PostgreSQL using EDB MTK.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.
• Configure REPLICATION between MASTER and SLAVE, and monitoring replication on a daily basis.
• Exposed to cross platform migrations Oracle to PostgreSQL where I documented and assisted during migration from ORACLE Databases to PostgreSQL database in AWS Cloud.
• Configured PgBouncer for connection pooling and Pg Badger for generating statistical reports.
• Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, DMS and SCT.
• Support daily administration, monitoring, performance tuning.