Postgresql / Oracle Database Administrator (Consultant) Resume Example Verizon

POSTGRESQL / ORACLE DATABASE ADMINISTRATOR (CONSULTANT)

Summary

Skills

Operating Systems
HP-UX 11.x. Sun Solaris 8, 9, 10. AIX 5.x, 6.x, Linux Enterprise Server 9, 10. Windows 2010, 2012
RDBMS
Oracle 19c, 12c, 11g, 10g, MySQL, PostgreSQL from 9.6.x to 12.x, Oracle 10g, AWS solution Architect.
Languages
SQL, PL/SQL, UNIX Shell Scripting.
Software/Applications/Tools
TKPROF, EXPLAIN PLAN, AWR, and ADDM.
Toad, RMAN, Putty, NX client, WinSCP, Remote Desktop Connection, VNC, Jira, SQL Developer, SQL Server and Cisco VPN Client, BART, PEM, pgbadger, Nagios
Database Utilities
SQL
Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL
Loader, RMAN, DataPump, Export, Import, psql, pg_dump, pg_basebackup, pg_upgrade
Key Skills
Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
Responsible for backup, recovery, and upgrading of PostgreSQL databases.
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
Extensive experience with Cloning and Refreshing pre-prod/dev databases with prod databases.Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL
PLUS, AWS Console, SQL Server, TOAD etc.
Enforced Security Administration, system monitoring by adding and removing users, auditing, and analyzing security problems.
Wrote scripts to inform DBAs regarding the status, performance, and space management of the database.
Experience in Linux (RHEL 5.0, 6.0), Oracle Enterprise Linux 6.5, Centos.
Installation, configuration, and Hardening of standalone Linux servers.
Proficiency in Linux Command Line and Operating System.
Configuration and management of network services (HTTP, NFS, SCP NTP).
Experience in Performance Tuning (I/O, Memory & SQL Tuning) by using tools/utilities like Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.

Experience in maintaining Oracle Data Guard and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
Good knowledge in Hot/Cold Backup, Recovery, and Cloning of databases using RMAN.
Installed and Configured the Oracle Databases (10g/11g) RDBMS, Performing Pre-installation, and Post-Installation Tasks
Expertise in Installing and configuring ASM and RAC for high availability databases.
Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
Strong troubleshooting, problem solving, analytical and design skills.
Experience in cloning Database from Production to Test and Development and from Development to Production.
Experience in cloud computing (AWS & IBM Cloud).
Good knowledge in Agile Methodology & DevOps Culture.
Have comprehensive knowledge and experience in Creating, Installing, Managing, Upgrading, Patching Oracle RDBMS, Cloning, Backup and Recovery Strategies, Managing Security, Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle DATAGUARD, Performance Monitoring and Tuning, Real Application Clusters (RAC) and Oracle Flashback Technology and documentation.
Extensive knowledge on database administration for Oracle 10g, 11g and 12c, 19c with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.
Excellent experience in installation, setup, and configuration of Oracle 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
Hands on experience in configuring, managing, troubleshooting, and migrating single instance databases to multimode 10g, 11g R1, R2 and 12c, 19c RAC environments on various flavors of UNIX systems for high availability and load balancing.
Data loading using SQL
LOADER, Logical backups using full export and DATAPUMP.
Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL
LOADER.
Participated in planning and implementation of off-site Disaster-Recovery planning and testing
Worked with development and operations staff in resolving problems quickly and efficiently
Configured and maintained Physical, Logical, Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for disaster recovery procedures
Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user tablespace across Oracle databases.
Good experience in applying Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of an Oracle server to higher version available.
Proficient in Zero Downtime Migration to Oracle Exadata Using Oracle Golden Gate.
Experienced in capacity planning and estimating the growth of Oracle databases
Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM), ZFS Storage, Exadata and Golden Gate
Expertise in installing, configuring, and maintaining Standalone and RAC databases.
Administrative, Agile, AIX 5.x, IBM AIX, Application Development, Architect, ASM, Auditing, Automate, Automation, Backup, Bash, Bi, Business solutions, C, Capacity planning, Catalog, Cisco, Interpersonal, Consulting, CPU, Encryption, Clients, Client, Customer service, Data migration, Data Modeling, Data warehouse, Database administration, Database, Databases 9.6, Databases I, Databases, Database design, DBMS, Data warehousing, DC, Debugging, Designing, Disaster-Recovery planning, Disaster recovery planning, Disaster Recovery, Documentation, Estimating, Features, Flash, Functional, HP-UX, HTTP, IBM, DB2, Indexing, Linux 6.5, Linux, Managing, Materials, Meetings, Memory, Mentoring, Windows, Migration, Modeling, MySQL, Enterprise, Network, NFS, OLAP, OS, Operating Systems, Operating System, Optimization, Oracle, DBA, DB, Oracle DBA, Developer, Oracle Enterprise Manager, PL/SQL, Peak, Perl, Pl, Postgres, PostgreSQL 9.6, PostgreSQL, Problem solving, Problem-solving skills, Python, Quality, Quality control, QA, RDBMS, Oracle RDBMS, Real-time, Real Time, SAP, Scheduling, SDLC, Servers, Shell scripting, Scripts, Shell scripts, Shipping, Simulation, SLA, Service level agreement, SMS, Sun Solaris, Sun Solaris 8, SQL, SQL Server, SSL, Statistics, Strategy, Strategic, Strategic Planning, Tables, TOAD, T-SQL, Troubleshoot, Troubleshooting, UNIX, UNIX Scripting, UNIX Shell Scripting, Upgrades, Upgrade, Upgrading, Utilities, VPN

Experience

Verizon | Irving, TXPostgreSQL / Oracle Database Administrator (Consultant)04/2020 - Current

PostgreSQL Installation, Configuration, Migration, Upgrades and Patches.
Server versions ranged from PostgreSQL 9.6, 10, 11 and 12.
Working as Lead PostgreSQL DBA and handling various duty of PostgreSQL DBA and providing support to consulting clients for various projects for ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR activities.
Configuring and fixing the Issues with Pgadmin-III client application.
Responsible for monitoring environments using monitoring tool viz.
Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
Installing and configuring new servers as per customer's request.
Cloning the Development, test and UAT environments with production data as per customer's request.
Design and implement disaster recovery for the PostgreSQL Database.
Configuring the backup jobs on customer system.
Experienced in performing PITR.
Patch, Upgrade and keep the PostgreSQL DBs current.
Develop and enhance scripts to automate and execute various DBA tasks.
Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
Identifying and resolving database issues.
Support developers for efficient SQL query and Identifying long running queries and optimizing.
Setup/Maintenance of Test/Development/UAT Servers setup.
Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Active participant in discussions related to Backup Strategy, DC/DR architecture.
Maintained, patched, and upgraded servers as required.
Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
Optimize postgresql.conf for performance improvement.
Review all PostgreSQL logs for problems.
Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.
Performed day-to-day activities like resolving tickets for multiple environments, provided environments, provided Production support, coordination with development for Application tuning.
Provided daily production support, worked on tickets assigned to my queue, making sure I meet the SLA for each ticket, making sure the stream controllers are running, attaining meetings and sending in daily reports.
Responsible for creating users, Groups, roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Performed daily health checks on different servers and sending in reports for constant follow-up to developers, constantly monitoring the performance (V$ dynamic performance views at peak load) of the databases and viewing Alert log files.
Supported Production DBA on OLTP, Data warehouse environment.
Involved in Change/Release/Patch management, Production development, data center migration and Upgrade.
Administration including design, deployments, tune, troubleshoot.
Efficient to manage 50+DB.
Experience in monitoring, backups, scheduling instance startup and shutdown schedules, refreshes management, configuration of the AWS console.
Experience in migration and deployment of data to test, dev and prod.
For troubleshooting and performance resolution, I have gathered table statistics manually or using the OEM, I have run the AWR report, ADDM report, explain plans, SQL Tuning advisor and multiple other tools.
Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
Expertise in loading data from flat files using external tables, SQL.
Loader.
Experience with SQL, PL/SQL, UNIX Scripting.
Define and implement database schema and configurations working with our development teams.
Maintain and Monitor Oracle Golden Gate configuration for Real Time Replication of Data.
Timely respond to user Requests meeting our service level agreement.
Actively participate in monthly code releases as Main Oracle DBA Support.
Perform Monthly, Bi-weekly and weekly Production Refresh to Non-Prod environment.
Regularly provide Data to developers and Testers for analytics.
Monitor System and database performance.
Support 24/7 Oncall Rotation.
Apply Quarterly PSU Patches for Bug fixes.
Support Developers with daily deployments and monthly code release.
Respond to users' requests within record time meeting our SLA.
Participate in Quarterly Fail-over simulation exercise for DataGuard for the purpose of disaster recovery.
Resolve system and database vulnerabilities to stay compliant.
Mentoring New-Hires and less experienced Team members bringing them up to speed.
Demonstrated expertise in creating architecture blueprints and detailed documentation.
Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

BP Energy | Houston, TXPostgreSQL/AWS (Solution Architect)/ Oracle Database Administrator (Consultant)09/2019 - 03/2020

Installing and configuring new servers as per customer's request.
Cloning the Development, test and UAT environments with production data as per customer's request.
Design and implement disaster recovery for the PostgreSQL Database.
Configuring the backup jobs on customer system.
Experienced in performing PITR.
Patch, Upgrade and keep the PostgreSQL DBs current.
Develop and enhance scripts to automate and execute various DBA tasks.
Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
Identifying and resolving database issues.
Support developers for efficient SQLquery and Identifying long running queries and optimizing.
Setup/Maintenance of Test/Development/UAT Servers setup.
Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Active participant in discussions related to Backup Strategy, DC/DR architecture.
Maintained, patched, and upgraded servers as required.
PostgreSQL Installation, Configuration, Migration, Upgrades and Patches.
Server versions ranged from PostgreSQL 9.6, 10, 11 and 12.
Operation support for Oracle & DB2 database 11g/12C.
Administer and managed large Databases of 10TB.
Provide front-line database support for Customers-facing Applications & Databases.
Track and close Tickets using SLACK and documentation using confluence.
Proactive monitoring of System & Database performance such as blocking Locks issues and long running queries, Load spike, resource contention, space issues etc using DB Artisan, Toad & OEM 13C top, Grafana Dashboard, to avoid any form of outage.
I have also created users, grant necessary privileges, roles and profiles; I have also been involved in database security where I managed users Profiles and passwords.
I have set and reset user's passwords, while creating, granting and revoking roles to users.
In administering database security, I have also configured and managed database auditing such as enabling standard, value-based and fine-grain auditing and monitor database activities.
Experience in maintenance and configuration of user accounts for dev, QA and Prod servers, creating roles for EC2, RDS, S3, and CloudWatch.
Experience in migrating and implementation of multiple applications from on premise to cloud using AWS service like SMS, DBMS, CloudFormation, S3, Route53, Glacier, EC2, RDS, SQS, and SNS.
Experience in migration and deployment of data to test, dev and prod.
Experience in monitoring, backups, scheduling instance startup and shutdown schedules, refreshes management, configuration of the AWS console.
To ensure the security of my databases I have implemented Auditing by enabling standard, value-based and fine-grained auditing and maintain audit trail.
I have also implemented some advanced security measures as projects such as TDE (transparent data encryption), network encryption and SSL authentication or database encryption.
For troubleshooting and performance resolution, I have gathered table statistics manually or using the OEM, I have run the AWR report, ADDM report, explain plans, SQL Tuning advisor and multiple other tools.
Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
Demonstrated expertise in creating architecture blueprints and detailed documentation.
Created bill of materials, including required Cloud Services (such as EC2, S3 ) and tools Involved in the end to end deployment process.
Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Performed Oracle Change data capture (CDC) Capturing changes in DB tables and storing them in special oracle tables which is used in accelerating data warehousing, enable real-time data integration across the enterprise, which improves the availability and performance of your databases.
Lift and shift of an existing on-premises application to AWS.
Selecting the appropriate AWS service based on data, database, or security requirements.
Identifying appropriate use of AWS architectural best practice.

Humana Inc | Louisville, KYPostgreSQL / Oracle Database Administrator03/2016 - 08/2019

Installed, Configured, Setup, Maintained and Supported Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database on Test, Development and Production environments for various home-developed applications like Portfolio Management Systems and vendor applications such as SAP Business solutions.
Configured Oracle Golden Gate 11g and 12c for multiple databases as well as Monitoring and Troubleshooting GoldenGate issues.
Involve in 24x7 on-call support for 12c databases of at least 2.0 TB, 3 Node production 11g RAC databases using OEM 12c for Alert Monitoring and Notification.
Experience with SQL, PL/SQL, T-SQL, bash and shell scripting.
Migrated to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
Troubleshooted and resolved slowness or performance issues with extensive investigation using OEM or scripts and later follow-up with respective application teams with RCA and proposed solutions.
Configure Dataguard and Broker for administration of seamless switchovers.
Upgraded DBs from 11g to 12c with physical standby DBs in place and applied upgrade patch, maintenance and interim (opatch) patches on all the databases.
Analyzed and Utilized AWR, ASH and ADDM reports, EXPLAIN PLAN, SQL Baselines, SQL Profiles and SQL Tuning Advisor to troubleshoot and provide tuning recommendations to the application team.
Refreshed Dev and Test instances with data from Production on a regular basis using the datapump utility.
Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Flashback Database, compression techniques and several others.
Usage of enhanced 12c New features like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging.
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Working with Application Development team to address any issues they encounter and provide support and resolution action plan.
Managed all indexing, debugging optimization and performance tuning using SQL Profile and SQL server Agent.
Involved in data integration by identifying the information needs within and across functional areas of an enterprise database upgrade and migration with SQL Export Utility.
Configured and administered SQL Clusters (Active/Passive, Active/Active) Database mirroring, Replication and Log shipping.
Responsible for all backup, recovery, and upgrading all of the PostgreSQL databases.
Participates in monthly failover from Source to Target for planned maintenance activities.
Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases 9.6, 10, 11 and 12.
Monitored and trained junior DBA.
Led projects like streaming Replication, Logical Replication,.
Performed Point in time recovery.
Conducted a lot of capacity planning.
Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
Migrated from Oracle to PostgreSQL with MTK, EDB Portal.
Migrated from On-Premise Oracle to Amazon RDS database with SCT and DMS.
Migrated from On-Premise PostgreSQL to Amazon RDS database.
Managed and Administer PostgreSQL on AWS RDS.
Using SSL with PostgreSQL DB Instance.
Managing upgrades of the PostgreSQL database version from 9.6,10 to 11.
Installed and configured SQL Server, Importing data into PostgreSQL on Amazon.
Used python to create and connect to a database, create tables, insert and update data.
Implemented automation for Unix and Linux environment using Python and Shell scripts.
Refreshed the Development, test and UAT environments with production data.
Active participant in discussions related to Backup Strategy, DR architecture.
Patch, Upgrade and keep the PostgreSQL DBs current.
Develop and enhance scripts to automate and execute various DBA tasks.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Establish and maintain security and integrity controls.
Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
Schedule and Ensure night cron jobs for backups, re-Indexing & vacuuming & refreshing materialized views executed properly on 24/7 high availability PostgreSQL production and development databases.
Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples to optimize performance.Expertise in Analyzing data Quality checks using shell scripts.
Implemented Disaster Recovery and High Availability solution with PostgreSQL like Streaming Replication (1 Master 2 Slaves) with EFM for automatic failover.
Configured Logical Replication for real time replication.
Configured PgBouncer for Connection Pooling.Take backups with pg_dump, pg_dumpall, pg_basebackup and BART for incremental Backup.
Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.

Mayo Clinic | Waukon, IAPostgreSQL / Oracle Database Administrator06/2013 - 02/2016

Installing and Configuring PostgreSQL from source or packages on Linux machines.
Experience designing database structures, indexes, views, partitioning.
Implementing backup and recovery.
Install and configured and troubleshoot Ansible.
Experienced in administering and maintaining medium enterprise database servers on Linux servers.
Responsible for issue resolutions participates in meetings and presentation.
Participating in daily meetings to discuss about the new database design, modeling and creation.
Controlling migrations of Shema, database through the development life cycle.
Setup and maintenance of Postgres master-slave clusters utilizing streaming replication with EFM for automatic failover.
Cross-datacenter disaster recovery and backup architecture.
Performing schema management, database sizing, maintaining privileges.
Data migration while upgrading database versions ranging from 9.6, 11 and 12.
Extensive experience with hot Standby (PostgreSQL 9.6, 11 and 12).
Fixing the memory issues and suggesting the best practices.
Responsible for monitoring environments using monitoring tool PEM, Nagios,Check Postgres.pl, custom scripts and other supporting tools like pgBadger.
Performance monitoring and optimization.
Experienced in migrating from Oracle to PostgreSQL with MTK.
Experienced in migrating from on premise Oracle to Amazon Aurora, RDS database.
Experienced in migrating from on premise PostgreSQL to Amazon Aurora RDS database.
Experienced in migrating from MySQL to Amazon Aurora RDS database.
Managed databases on Amazon RDS.
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
Scheduled and monitored Physical backups (hot & cold) in CRONTAB using RMAN utility.
Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump.
Performed Installation and configuration of Oracle 11.2.0.1 database on Linux platform.
In addition, successfully performed some migrations from Oracle 11g and 12c to RAC Databases.
Used to run scripts for space management of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as well and when required.
Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Maintained the data integrity and security using integrity constraints and database triggers.
Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “Opatch”.

Education and Training

Bachelor's Degree in Crop Production Technology

Oracle 12c certified Associate
Scrum Master Certified
Oracle Cloud Infrastructure
AWS Certified Solution Architect

Resume Overview

Companies Worked For:

Verizon
BP Energy
Humana Inc
Mayo Clinic

Job Titles Held:

PostgreSQL / Oracle Database Administrator (Consultant)
PostgreSQL/AWS (Solution Architect)/ Oracle Database Administrator (Consultant)
PostgreSQL / Oracle Database Administrator

Degrees

Bachelor's Degree in Crop Production Technology
Oracle 12c certified AssociateScrum Master CertifiedOracle Cloud InfrastructureAWS Certified Solution Architect

PostgreSQL / Oracle Database Administrator (Consultant) Resume Example

Resume Score: 80%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes