Postgres Database Administrator Resume Chicago, IL - Hire IT People

SUMMARY

Highly motivated DBA with over 8 plus years of hands - on experience working in large scale and fast paced environments with proven ability to resolve complex database issues under Pressure.
Proficient in Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning of Oracle and PostgreSQL Databases.
My typical day to day activities includes database support, research, process automation, documentation, database performance tuning, backup/recovery, moving data as required by the clients needs and database security.
High leadership and interpersonal skills with a mastery in handling highly classified/sensitive documentation and projects.
Self-starter and adaptive learner quick to grasp new technologies exceeding business standards and expectations.
Possess excellent written and verbal communication skills with the ability to articulate a variety of concepts to technical and non-technical audiences.
Comfortable working remotely and on-sight.

TECHNICAL SKILLS

Migration, backup and recovery, Streaming replication, Patching.
EXPLAIN PLAN, STATSPACK, AWR, and ADDM, pgADMIN, PG STAT ACTIVITY, pgHero.
RMAN, Pgbackrest, OEM, SQL*Loader, EXP, IMP, Data pump,
Oracle 10g, 11g,12c,PostgreSQL 9.5,10,11
HP-UX 10.x, 11.x, 12c, Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Postgres Database Administrator

Responsibilities:

I have performed cross platform migrations preferably Oracle to PostgreSQL. I documented and assisted as an ORACLE DBA in performing Data MIGRATION from ORACLE Databases to POSTgreSQL database in AWS RDS Cloud.
I have been involved in Installing/configuring PostgreSQL. Mainly T postgres VERSIONS 9.5, 9.6, 10 and 11.
And I have managed and monitored these databases using pgAdmin.
USE pgHero for Performance TUNING mostly. SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY.
Performing BASIC TASKS such as OBJECTS such as, creating roles, granting privileges, creating tables.
Implementing the use of indexes, and primary & foreign key constraints as required.
I provide PRODUCTION SUPPORT based on a ticketing system. And Assisted in defining and implementing MAINTAINANCE PLAN for the database system.
Perform maintenance activities like vacuum, vacuum full, analyze etc
Configuring PgBouncer for connection pooling.
Configuring pgBadger for generating statistic reports.
Experience 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.l0i
Using customized scripts to perform maintenance;
Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns
Experience in handling logical and physical database BACKUPS. 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). I have configured a REPLICATION between MASTER and SLAVE, and monitoring On-Going REPLICATION
Upgrading database version (pg dump/pg restore and pg upgrade).

Oracle DBA

Confidential - New York, NY

Responsibilities:

Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).
Worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
Implemented and configured 11g grid control on RHEL.
Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).
Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
Participated in the configuration of Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
Used Oracle Enterprise Manager (OEM) 11gGrid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

We provide IT Staff Augmentation Services!

Postgres Database Administrator Resume

Chicago, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship