Benjamin Tatani

Public Trust

240-***-****

advito@r.postjobfree.com

Database Administrator

Summary

An accomplished Database Administrator (DBA) with over 7+ years’ worth of extensive experience working on Oracle 11g/12c/19c and PostgreSQL (v9.x, 10.x, 11.x & 12.x) & Community & Enterprise editions and Amazon RDS across heterogeneous system environment including Linux, HP-UX, AIX, Solaris, UNIX, Windows, CentOS7. Outstanding hands-on experience and skills in RDBMS software installations, optimizing database servers. A proactive team player with excellent interpersonal, analytical and communications skills with prompt responds to customers calls while following due procedures

Education and Training

Oracle Database, Jelani Consulting.

Zion Solutions Consultancy

DBA Workshops: Oracle Database 10g, 11g Administration (2019), Advanced Oracle DBA (2020), intro into Oracle 19c

University of Business Technology. (Oracle Certified Professional)

Manual and Computerized Accounting, Catholic University.

Skills

Backup, Restore & Recovery

Data Pump and Export/Import.

High Availability (Logical and Streaming Replication, Data guard, Golden gate and RAC, MS SQL Server Log Shipping)

Database Security (user access, encryption-SSL, TDE)

Installations, Patches and Upgrades

4 Plus years of Experience in EDB PostgreSQL/EDB administration

Performance Tuning & Capacity monitoring

Database Cross-platforms Migration

Enterprise-Wide Systems

Technical Documentation Correspondence

Database Management Tools:

Oracle Enterprise Manager

MS SQL Server (SSMS)

SQL, PL/SQL, Unix Shell Scripting

Pg4Admin

Dbeaver

ETL (SSIS, SQL* Loader, Information

SQL Developer

Oracle ASM and Grid Control

Operating Systems:

MS WINDOWS (08,12,14)

LINUX (Red Hat Enterprise)

UNIX (Solaris 8/9/10)

OS

Red Hat Linux RHEL 5.x, Solaris, CentOS7 and Windows XP

RDBMS

Oracle 10g, 11g, & 12c, PostgreSQL 9.x, 10.x, 11.x, & 12.x, AWS RDS

Software/ Applications/ Tools

DBCA, DBUA, RMAN, Oracle Enterprise Manager (OEM), OEM Grid Control, 12c Cloud control, Oracle Data Guard, RAC, ASM, SQL Developer, TOAD, Data Pump (expdp, impdp), SRVCTL,SQL*Plus, pgAdmin, psql, pgDash, pgHero, pgBadger, PgBouncer, Pgpool, pg_activity, Vacuum, Vacuum full, EDB Migration Toolkit (MTK), Ora2pg, AWS Data Migration Service (DMS) & Schema Conversion Tool (SCT), EDB Failover Manger(EFM),SQL Server Management studio (SSMS),

Tuning Tools

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, pg_stat_activity, PGTune, pg_stat_statement, pg_stat_user_tables, pgstattuple, MS SQL Server Profiler, SQL Developer.

Certifications:

PostgreSQL Certified Engineer

AWS Certified Solutions Architect – Associate

Professional Memberships:

PostgreSQL Global Development Group

AWS Community

Professional Experience

Advizex 11/2022 – 02/13/2023

Database Consultant

Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.

Researched and solve database problems.

Manage MySQL instances fir LAMp application

Performance tuning and optimizing MySql and Oracle databases for improved efficiency and scalability.

Analyze the existing Oracle database and identify the objects (tables, views, stored procedures, etc.) that need to be migrated.

Collaborating with development teams to understand their data requirements and provide guidance on best practices for database design and implementation.

Create, manage and monitor users’ security, and removing inactive accounts and prevent any unauthorized access to the database based on least privilege.

Performing regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove obsolete data

Maintaining the database schema, including creating new tables, adding columns to existing tables, and deleting unnecessary tables and data.

Ensuring data distribution across tables to maintain even distribution.

gpcrondump for automatic scheduled parallel backups ( gpcrondump / gpdbrestore) based on SLA. Managing obsolete or expired backups to maximize space on ETL servers.

Participate in upgrading Oracle and MySql version from 13c to 18c and version 7 to 8 respectively.

Clearing and removing lock file and clearing database blocking sessions and slow running queries.

Use of gp_bloat_diag to determine shows regular heap-storage tables that have bloat and use of vacuum to clear bloat.

gp_stats_missing to view shows tables that do not have statistics and therefore may require an ANALYZE.

Encrypting Data at Rest with pgcrypto for PII data.

Using gpfdists protects against eavesdropping and man-in-the-middle attacks.

Use of EXPLAIN and EXPLAIN ANALYZE to improve query performance

Working with developers to load data into the landing zone for loading into the schema.

Using gpstop –u to reload database after parameter modification

Setting the log_location configuration variable in the $MASTER_DATA_DIRECTORY/gpperfmon/conf/gpperfmon.conf configuration file to change directory where the log is written.

Providing technical support to end-users, answering questions, and resolving technical issues.

Work as part of a team and provide 7x24 support to business enterprise systems.

A.A.F.E.S 02/2022 – 11/2022

Postgres Greenplum Database Admin

Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.

Perform database upgrades and migrations, including upgrading from PostgreSQL 9.6 to 13.

Design and implement backup/restoration strategies per data retention requirements

Provide insight to team leadership regarding best practices for PostgreSQL

Manage PostgreSQL database servers in all environments

Installing and configuring Greenplum database systems, including setting up database clusters and networking configurations.

Performance tuning and optimizing Greenplum databases for improved efficiency and scalability.

Worked and team with oracle teams for Golden gate setup for heterogeneous migration.

Installed, configured, and administered Oracle 11g, 12c, and 19c databases in Linux and Windows environments.

Conducted performance tuning by identifying and resolving issues related to SQL queries, database objects, and database configuration.

Analyze the existing Oracle database and identify the objects (tables, views, stored procedures, etc.) that need to be migrated.

Implemented database security policies and procedures, including access control, user management, and audit trails.

• Developed and maintained database documentation and runbooks.

Collaborating with development teams to understand their data requirements and provide guidance on best practices for database design and implementation.

Create, manage and monitor users’ security, and removing inactive accounts and prevent any unauthorized access to the database based on least privilege.

Performing regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove obsolete data

Maintaining the database schema, including creating new tables, adding columns to existing tables, and deleting unnecessary tables and data.

Ensuring data distribution across tables to maintain even distribution.

Greenplum Command Center in monitoring database performance to identify slowdowns or potential issues.

gpcrondump for automatic scheduled parallel backups ( gpcrondump / gpdbrestore) based on SLA. Managing obsolete or expired backups to maximize space on ETL servers.

Participate in upgrading GP version from 4.3 to 6.0

Use of gp_bloat_diag to determine shows regular heap-storage tables that have bloat and use of vacuum to clear bloat.

gp_stats_missing to view shows tables that do not have statistics and therefore may require an ANALYZE.

Encrypting Data at Rest with pgcrypto for PII data.

Using gpfdists protects against eavesdropping and man-in-the-middle attacks.

Use of EXPLAIN and EXPLAIN ANALYZE to improve query performance

Working with developers to load data into the landing zone for loading into the schema.

Using gpstop –u to reload database after parameter modification

Setting the log_location configuration variable in the $MASTER_DATA_DIRECTORY/gpperfmon/conf/gpperfmon.conf configuration file to change directory where the log is written.

Providing technical support to end-users, answering questions, and resolving technical issues.

Work as part of a team and provide 7x24 support to business enterprise systems.

HOPE FOUND INC

Database Administrator 04/2019 - 02/2022

Installation, configuration, upgrade and managing of PostgreSQL servers including Version 10.x, 11.x and currently 12.x on community enterprise edition.

Deploying postgresl with helm chart.

Create custom config for storing postgres secrets

Creating PV on kubernetes and using PVC to mount PV on application pod.

Utilize client-side applications like pg4Admin and psql to connect and manage PostgreSQL databases on-premises and on cloud on AWS RDS

Setting up of Cross region replication for disaster recovery solution and continuous availability with.

Provisioning, configuration management, automation, and orchestration of postgresql clusters with ansible playbooks.

Manage postgreSQL database with Ansible i.e create/remove a database, create/remove/upgrade user creds, privilege management for security management.

Configured and proactively managed Streaming Replication (including cascading replication) between Primary and two standby(s) on a PostgreSQL Server for disaster recovery, high availability, and load balancing solutions.

Performed Complete and PIT recovery on PostgreSQL clusters based on pre-defined Service Level Agreement (SLA) in place using pg_restore and psql.

Performed Routine Postgres database and cluster wide maintenance activities like vacuum/vacuum full, Analyse, reindexing, and pg_wal/pg_xlog space maintenance

Configure Enterprise DB Failover Manager (EFM) and Replication Manger (repmgr) on a PostgreSQL server to monitor streaming replication and automate failover for Application continuity.

I was responsible for setting up pgbadger via EC2 where Aurora & RDS logs are analysed for tuning purposes.

Oracle Software Installation and creation of databases and database objects.

Extensive Experience with RMAN Hot & cold Backups, User Managed backups and Logical Backups. Used recovery Catalog to maintain and manage backups.

Implementation of a backup and recovery policy under tight SLA times using RMAN and Data Pump.

Oracle Cluster ware using Srvctl, Crsctl, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage

Developed and implemented backup/recovery and patch scheduling including exported and imported databases frequently into the development and test environments and for archiving purposes.

Monitored different Oracle databases and application servers using Enterprise Manager (OEM) Grid Control and setting threshold for alert notifications as well as scheduling backups with Failure notification.

Used SSMS to Configure and Monitor SQL SERVER LOG SHIPPING from a primary server to a hot standby server for high availability and reporting purposes.

Excellent troubleshooting skills, used AWR, ASH, ADDM and Stats pack Reports for troubleshooting performance issues and Capacity Planning. Extensively used Explain Plan, OS top Command, Tkprof, SQL Trace, v$session, v$sql, SQL tuning advisor, hints, partitions, indexes, materialized views. etc. for query optimization.

CAPITAL ONE BANK VIRGINIA,

Database Administrator 09/ 2017 – 04/2019.

Setup logical Replication on a PostgreSQL Cluster for specific tables and schemas and constantly monitored on-going replication for analysis and reporting

Control access to Postgres clusters using postgresql.conf, pg_hba.conf and. pgpass

Experienced in tuning Postgres cluster parameter settings in Postgresql.conf file to optimize performance and daily Monitoring of Postgres system logs and Wal files.

Used pg_repack with no downtime to remove bloat from tables and re-organizing tables and schemas to improve performance.

Invoked pgbench for performance Load testing on Lower environments before deploying the application to Production

Manage database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption (TDE).

Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.

Provide administrative support and maintenance on Oracle 10g, 11g and 12c and 19c installations, database creation, database security, database optimization and tuning.

Setting up and managing RMAN, Hot and Cold Backups, Exports and Production database support as well as Cloning databases via RMAN and DATAPUMP utilities for various Database sizes.

Provide and maintain high availability and disaster recovery using ORACLE DATA GUARD.

Extensively use AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.

Applied Oracle Patches (CPU/PSUs and One-off patches)

Involved in the installation, configuration, and extended support to Oracle 11g two Node RAC (Real Application Cluster) with ASM file system for load balancing

Configure Oracle Advanced Security on 12c databases to implement TDE at tablespace, table, and column levels.

Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases

Tunned slow running sql, blocking sessions and high cpu consuming sqls with the help of OEM.

Checking top activity for system I/O, user I/O and other processes, monitoring SQL executions for Time & wait statistic, I/O statistic

Implement table and index partitioning to minimize DB down time, increase disk load balancing, improve query speed and enable faster parallel query

Upgraded Oracle databases from 9i to 10g, 10g to 11g and from 11g to 12c manually using scripts and using tools such as database upgrade assistant (DBUA), Data pump, transportable tablespaces and RMAN based on the business needs.

Monitor AWR, ADDM, ASH, TOAD, Alert log, dynamic performance views, DBMS_STATS, Trace Files, and System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

Support in performing, administration, installation, also support mission-focused infrastructure to ensure performance and availability of system and environment schedule and coordinate system maintenance improve efficiency.

Championed database migration from 10g to 11g and database upgrade from 11g to 12c and to 19c using the Oracle Data Pump and DBUA utilities respectively.

Monitor the database health and performance, write queries to alter existing data and to produce custom reporting. Run existing jobs to transform data and evaluate and run SQL scripts to support new application releases. Open and follow-up on service support tickets with Oracle support using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.

Part of support team for 24/7 on-call production support.

Monitored a physical standby database for data protection and high availability.

AMAZON RETAIL, NW DC 03/2015 - 09/2017.

Database Administrator

Implemented Oracle Flashback technology for Oracle 10g & 11g along with Recycle bin for a faster recovery of the databases and database objects.

Developed RMAN backup and recovery strategies and procedures and performed database patching for bug fixes, and mitigate security vulnerabilities

RMAN Hot & cold Backups, User Managed backups, and Logical Backups. Used recovery Catalog to maintain and manage backups.

Performed all aspect of database operations and maintenance (O&M).

Monitored a physical standby database for data protection and high availability.

Refreshed/cloned databases using RMAN and Data pump expdp/impdp utilities to move data from PROD to DEV/TEST environments Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Performed Schema as well as Table level Replication using Oracle Streams and real time replication using oracle Golden gate.

Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, reports and performance issues.

Develop and improve procedures for monitoring (Enterprise Manager) and proactive intervention, preventing customer impact.

Implemented a backup and recovery policy under tight SLA times using RMAN and Data Pump.

Controlled all databases with high alertness to ensure peak performance, stability and reliability and availability.

OEM Monitoring for Databases - checking AWR/ADDM reports. Understanding ADDM reports finding. Running SQL tuning adviser against the query in the Databases.

Monitor and tune Oracle database environments for improved system performance, ensure integrity and recoverability of Oracle database structures with data guard.

Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.

OEM Monitoring for Databases - checking AWR/ADDM reports. Understanding ADDM reports finding. Running SQL tuning adviser against the query in the Databases.

Quickly respond to all database alerts, errors, and warnings.

Utilization of DB Tools/Utilities (e.g., Toad, Enterprise Manager, SQL Developer, RMAN) for optimization of the database.

Plan and take logical and physical backups for development databases, perform test restores ensuring all databases and associated logs are being backed-up

Manage/administer production and development databases and applications servers

Work as part of a team and provide 7x24 support to business enterprise systems

Responsible for creating users, groups, roles, profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Implemented recovery strategies whenever required and successfully recovered databases in case of a database crash, media/disk failures by using RMAN.

Scheduling the physical backups (hot & cold) using RMAN utility and monitoring the scheduled jobs. Part of support team for 24/7 on-call production support.

Contact this candidate