SUMMARY

• An accomplished and seasoned professional PostgreSQL Database Administrator, with 5+ years of extensive knowledge and proficiency in database administration.
• I have worked on databases performing various DBA services and across a multitude of platforms (LINUX, UNIX, SOLARIS and WINDOWS) in production, development and test environments.
• An enthusiastic, proactive team player who is fast at picking up new technology with great attention to details as well as great communication skills, with a strong aptitude to analyze and resolve problems.
• I have a well - honed ability to adapt and thrive in a dynamic fast paced and challenging work environment.

TECHNICAL SKILLS

• 9.5, 9.6, 10, 11
• LINUX (CENTOS 7, UBUNTU, )
• PGADMIN, PGCTL, MOBAXTERM, PUTTY,
• PGADMIN, PGCTL, PGBOUNCER, PGPOOL, PGBASEBACKUP, PGDUMP, PSQL, PGRESTORE, PGANALYSE, EXPLAIN ANALYSE, AUTOVACUUM, PG LOCKS, EDB - MTK, ORA2PG.
• 10g, 11g, 12C
• LINUX, WINDOWS, UNIX (SOLARIS, AIX).
• REMOTE TOOLS: CISCO VPN, VNC, WINSCP, PUTTY
• OEM GRID CONTROL, TOAD, SQL*PLUS, SQL DEVELOPER, LOG MINER, AWR
• ADDM, ASH, EXPLAIN PLAN, STA, SAA, STATSPACK, HINTS, INDEXES, PARTITIONS
• MATERIALIZED VIEWS, SQL TRACE, SQL PROFILE, TKPROF, PLSQL, RMAN
• USER MANAGED, CLONING, DATA PUMP, EXP/IMP, FLASHBACK, POINT IN TIME RECOVERY
• TRANSPORTABLE TABLESPACE, SQL*LOADER, DBLINK, PATCHING (OPATCH Utility) & UPGRADE.
• PGBACKREST, PGBASEBACKUP, PGDUMP, PGBOUNCER, PGADMINRAC, DATA GUARD
• SQL Developer, My SQL, Oracle Enterprise Manager, Linux Red hatDBMS, RMAN, PostgreSQL-DB, SQL Server 2008,2012,2016,2017

PROFESSIONAL EXPERIENCE

POSTGRESQL DBA

Confidential - Austin, TX

Responsibilities:

• Installed and configured PostgreSQL versions 9.5,9.6,10,11.
• Managed and monitor databases using PGAdmin and PSQL.
• Create roles, Privileges, tables, indexes, also using primary and foreign key constraints.
• Upgraded database versions using pg dump, Pg restore and pg upgrade from version 9.5-11.
• Configured streaming replication including cascading replication and monitored on -going replication.
• Used pg restore and point-in-time-recovery to restore data files.
• Performing maintenance activities like vacuum, vacuum full, analyze etc.
• Configuring PGBouncer for connection pooling.
• Configuring PGBadger for generating statistic reports.
• Experience of tuning PostgreSQL server settings & troubleshooting performance issues.
• Managing Users and Tablespace on PostgreSQL Servers.
• Working knowledge of PGAdmin tool.
• Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Using customized scripts to perform maintenance, Successful installation and maintenance of PostgreSQL 9, 10 and 11.
• Create Databases, schemas, users, tables.
• Grant roles and privileges as requested.
• Administer databases using PGADMIN.
• 24/7 support with on call rotation in all prod, QA and dev environment.
• Proactive Performance monitoring and tuning using PGANALYSE, ANALYSE, EXPLAIN, AUTOVACUUM.
• Using TCP-IP Protocol, configured SQL.
• Net files on server - client machines and resolved client connectivity issues.
• Perform backups on regular basis by implementing a stable and effective backup strategy as per the SLA using PGBACKREST.
• Management of schema objects, partitioning of tables & indexes.
• Perform physical and logical streaming replication.
• Migrate from Oracle to PostgreSQL using EDB MTK.
• Handled High volume Oracle production databases around 5TB size along with Physical standby databases.

ORACLE DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Performed Installation, configuration and troubleshooting of Oracle 10.2.0.1 database on HP-UX platform.
• Install and configure block change tracking to work with RMAN merged incremental backups.
• Involved in the installation and configuration of two node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL platform.
• Involved in team effort to evaluation of Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Monitored and performed database sizing, tablespace management, rollback management, transaction management and security administration like creating Users, Groups, Roles, Profiles.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Performed incremental backups using Recovery Manager (RMAN).

JUNIOR ORACLE DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Automated and monitored database health, backup and recovery activities through Cron jobs and also customized various Unix Shell Scripts in sending Email for ORA-Errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage.
• Monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
• Performed database, schema & table level refresh from production to test/development environment using RMAN and Data pump utilities.
• Also Implemented Oracle's Transportable Tablespace (TTS) feature (Oracle 11g, 12c) to quickly move Tablespaces across Oracle database servers.
• Involved in a Client-Server environment using TNSNAMES, LISTENER, Net Configuration Assistant and other configuration files.
• Use Oracle Flashback Technology for logical recovery purposes with sometimes the need to create a Guaranteed restore point right after a recovery or during switchover operations.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).