Uploaded File
add photo
Valantine
valantineangwafor@outlook.com
571-447-2698
Alexandria, VA 22302
Senior PostgreSQL Database Consultant
9 years experience W2
0
Recommendations
Average rating
20
Profile views
Summary

Experience
Senior PostgreSQL Database Consultant
Information Technology
Jan 2019 - present
Experience providing 24/7 support for mission critical multi-terabyte Databases and high transaction volumes
  • PostgreSQL 9.6 10.X Database Administration in AWS Cloud
  • Setting EC2 and RDS instances to run on PostgreSQL 10.7 then SSH into the instances to install PostgreSQL
  • Setup and use Foreign Data Wrappers to access data in remote and Oracle databases
  • Experience in working closely with the application development teams to resolve any performance related issues and provide application support.
  • Providing off hours support to avoid affecting database availability during normal business hours. Experience in setting up Enterprise DB Replication
  • Measure database performance and troubleshoot complex database issues, I/O bottlenecks and SQL Tuning
  • Experience in Migration from Oracle to Postgresql used ora2pg and MTK for EDB Working Knowledge of connection poolers (pgPool and pgBouncer)
  • Perform routine maintenance on several database environments including application of updates, patches, and hotfixes
  • Installation/configuration and implementation of PEM, BART, xDB/EFM, Performance Dashboard. Championed database refreshes from production environment to lower environments.
  • Designing and building data models, schemas, views, and tables to support application requirements Working knowledge of Database Security mechanism, obfuscation, auditing and, data encryption using tools such as PG-Crypto.
  • Extensive experience designing and executing backup and recovery concepts and procedures
  • Experience in using Splunk, Datadog and CloudWatch for Availability and Performance.
  • Experience in scripting languages (Shell, Bash, Perl) for automating DBA administrative tasks.
  • Installation, configuration, maintenance and tuning of SQL Server databases.
  • Successfully upgraded SQL server 2008 to 2016.
  • Involvement on Disaster Recovery Strategies design, and involvement on monitoring, troubleshooting and managing issues and problems related with Replication, especially on Transactional Replication and other tolerance capabilities including Failover Clustering, Mirroring and Log shipping
  • Experienced in Design, implementation and generating documentation of SQL Server on both physical/logical standby databases in high availability mode.
  • Installed, Configured, and Administered Database Mirroring, Always On, and
  • Replication as High Availability (HA) and Disaster Recovery (DR) Solutions
  • Assisted SQL Server developers to optimize the SQL queries and stored procedures.
AWS Data Replication Database Backups DBA Disaster Recovery Oracle PostgreSQL SQL SQL Server SQL Server Developer
Remove Skill
Oracle/ PostgreSQL Database Administrator
Information Technology
Jul 2016 - Dec 2018
Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux/Unix and Windows environments.
  • Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
  • Implemented Data guard, creating both logical and physical standby databases in 11g and 12c RAC environment for production database.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • Participated on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
  • Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
  • Installation of 12c OEM and customize it to the company's needs.
  • Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
  • Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.
  • Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Statspack for best performance.
  • Manage alerts, notifications, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.
  • Automated the Data Replication process using Materialized Views for reporting databases.
  • 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.
  • Implementing Datapump, conventional export/import utility of Oracle 12c
  • Loading data from flat files to database using SQL Loader, External Tables.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g and 12c environments
  • Documented the Standard Processes for peers to follow.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes. Implemented data guard for the critical production databases and tested switchover and failover.
  • Logical standby databases for the real time DML apply in the remote databases.
  • Disaster recovery plan for the production to standby database to check the data consistency.
  • Maintain databases build database backup and recovery routines, monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.
  • Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.
Adobe Flash Data Replication Database Backups DBA Disaster Recovery Oracle Performance Tuning PostgreSQL SQL SQL Loader UNIX Windows
Remove Skill
Oracle Database Administrator
Information Technology
Mar 2013 - Jun 2016
Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms and RHL.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning. Implementing Datapump, conventional export/import utility of Oracle 11g, 10g organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g and 12c environments.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Plan and coordinate 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.
  • Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases. Experience with load balancing using Pg pool.
  • Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes. Implemented data guard for the critical production databases and tested switchover and failover.
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Experience in User Management by Granting, Revoking Privileges according to requirement. Experience in Space Management by Monitoring and Managing Tablespaces.
  • Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.
  • Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.
  • Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
Adobe Flash Data Replication Database Backups DBA Load Balancing Oracle Performance Tuning PostgreSQL SQL
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Environmental Science and Geology
not provided
computer analyzed makeup CAM
not provided
equipment time management system
not provided
Certifications
EDB Certified Associate badge for PostgreSQL 13
AWS Certified Solutions Architect Associate
Skills
Data Replication
2022
17
DBA
2022
17
SQL
2022
17
Disaster Recovery
2022
14
Oracle
2022
14
PostgreSQL
2022
14
Adobe Flash
2018
11
Database Backups
2022
11
Performance Tuning
2018
8
SQL Loader
2018
8
AWS
2022
6
UNIX
2021
6
Windows
2021
6
AIX
2016
3
Data Migration
2016
3
Linux
2021
3
Load Balancing
2016
3
Production Support
2016
3
RHEL
2021
3
Solaris
2021
3
SQL Server
2022
3
SQL Server Developer
2022
3
UAT
2016
3
HA
0
1
Microsoft Excel
0
1
OLTP
0
1
Languages
French, Fluent/Bilingual