Data Manager

METCHUM ARIANE

Tel: 904-***-****

**************@*****.***

PROFESSIONAL SUMMARY

Highly Professional database administrator with more than 7 years’ experience designing, coding, testing, and supporting next-generation database solutions in PostgreSQL and Oracle environments. Experience in database design, analysis, modeling, development, administration, implementation, troubleshooting, and quality management. Exceptional analytical, problem-solving, and communication skills. Excellent attention to detail and experience with numerous types of database software. Ability to work well on a team and individually.

DATABASE SKILLS

• Performance Tuning & Capacity Monitoring Ensuring availability

• Configuration and installation

• Upgrade and Patching

• Excellent analytical and problem-solving skills Backup & Recovery

• Outstanding team leadership abilities Data Security

• Data modeling and database design Procedural skills

• Database schema creation and management Ensuring data integrity

• General database management Automation

• General systems management and networking skills Migration

• Streaming replication

• Scripting

• PLSQL developer

• Data warehousing (ETL)

TECHNICAL SUMMARY

Operating Systems:

HP-UX, Sun Solaris 9, 10, AIX, RHEL, Linux Enterprise Server 9, 10. Windows 2012, 2016

RDBMS:

PostgreSQL 9, 10, 11 and 12, Oracle 10g, 11g, 12c

Tools/Utilities:

Bart, Pgbadger, MTK, Pgbench, pg_dump, pg_basebackup, pgbouncer, pgadmin, PEM, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, TOAD.

PgTune, pgcrypto, SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import.

TECHNICAL PROFICIENCIES

CSX Transportation - Jacksonville, FL April 2017 – July 2020

PostgreSQL Oracle Database Administrator

Installing and Configuring PostgreSQL 9.6,10,11 and 12 from source or packages on Linux machines.

5 years plus of proven working experience as a database administrator with a hands-on experience with database standards and end user applications.

Lead DBA and I mentored all the other DBA’s

Capacity Planning

Daily log analysis using pgbadger tool and query tuning.

Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.

Good mastery of PGBOUNCER, REPMGR and BARMAN.

Monitoring databases to optimize database performance and diagnosing any issues.

Maintaining custom vacuum strategies at table and db level.

Extensive knowledge using pg_dump, pg_dumpall for logical backups and pg_basebackup for physical backups.

Configured BART for Incremental backups, implement retention policies and point-in-time recovery requirements for large-scale Postgres deployments.

Designed and implemented table partitioning for handling very large tables.

Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.

Optimize PostgreSQL. conf for performance improvement.

Review all PostgreSQL logs with pgbadger 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.

Improve query performance by following performance enhancement tips and database best practices.

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.

Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.

Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.

Vast Knowledge in memory resizing and tuning.

Proactive in updating the latest security patches to database, which are provided by PostgreSQL Enterprisedb.

Writing queries for reporting purposes, PL/SQL queries, creating and altering stored procedures, functions, triggers, and some Linux shell scripting.

Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques.

Configured pgbouncer and pgpool to automate connection pooling.

Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.

Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking.

Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.

Configure logical replication for real time data replication.

Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.

Daily log analysis using pgbadger tool and query tuning.

Participating in daily meetings to discuss about the new database design, modeling, and creation.

Performed migration from oracle to PostgreSQL using EDB Postgres Migration Toolkit.

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Red Hat Linux 5.3. Database sizes range from 4GB to 1TB (in ODS & EDW environments).

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

Experienced in configuration of ASM for RAC and NON- RAC environments.

Experienced in Data Center migration of databases to prepare the proof of concept, DB migration procedures and scripts, developed templates that include check list for migrating the databases.

Perform Database upgrades, migrations; take logical exports from the QA, DEV etc instances and importing the data on to the production systems etc.

Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.

Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.

Expertise in PL/SQL, SQL, and UNIX Shell Scripting (Implemented UNIX Scripts using CRON JOB for Day-to-Day activities and Windows Task Scheduler).

Extensively worked on setting up auditing in many databases we supported

Installed ASM environment and migrated databases from NON-ASM to ASM.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

Experience with Clearcase & ClearQuest

MicroSoft SQL-Server

Managing and monitoring databases using SSMS

Installation and configuration

Automating Alerts, using SQL to set thresholds and triggers.

Debugging SQL work with developers to fine tune sql/pl to enhance performance

Import table into new database

Backup database (full/log/diff)

Restore database and give it a new name(using SSMS)

Encrypt database using TDE

Performance tuning

High Availability (always on, log shipping, clustering)

Migration

Data Warehousing (SSRS, SSIR)

Walgreen Company - Deerfield, IL March 2013 – April 2017

PostgreSQL Oracle Database Administrator

Setup and maintenance of postgres master-slave clusters utilizing streaming replication.

Cross-datacenter disaster recovery and backup architecture.

Performing schema management, database sizing, maintaining privileges.

Analyze/Develop business description of user needs, program functions, and steps required to develop or modify systems, including Business Requirements Documents and supporting documents, diagrams, data, and database specification.

Establish policies and procedures pertaining to data management, security, maintenance, and utilization.

Perform database installations, configurations, upgrades, and migrations.

Experience with database replication, hot stand-by, clustering, and table partitioning.

Consult with development and architecture teams to help meet continued application growth.

Define and implement database schema and configurations working with our development teams.

Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements.

Audit for data integrity and consistency across systems.

Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.

Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL.

Administration of PostgreSQL databases throughout the development and production lifecycles.

Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments.

Proactively monitor and setup alerting mechanism for both database and supporting hardware to ensure system health and maximum availability.

Create users, establish database security, create resource queue, performance tuning in terms of query execution.

Manage Disaster Recovery environment.

Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using different tools.

Rebuilding the indexes at regular intervals for better performance.

Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

Configure logical replication to replicate real time data.

Designing and testing database installation, implementation, and recovery scenarios.

Determining test to use and collecting appropriate data according to established guidelines.

Participating in analysis, development, and implementation of unique database recovery plans in response to client-impacting outages.

Performing database software installations and upgrades and implementing backup/recovery strategies.

Reviewing and approving application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.

Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, and Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Loading data from flat files to database using SQL*Loader, External Tables.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration, and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

On call Production & Development database support and administration.

Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

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

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Performed Database upgrade from Oracle 10g (11.2.0.5) and to Oracle 12c (12.1.0.2) RAC database.

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.

Migration of Oracle databases from windows to Linux.

Performed SQL tuning and assist developers with coding PL/SQL.

Provided support to Application Database Administrators in designing the database.

Management of schemas, objects partitioning the tables & indexes.

Automation of data load using shell scripting and SQL*Loader.

Responsible for setting and managing user accounts and granting required privileges to users.

EDUCATION

University of Douala 2006 - 2009

Bachelor’s Degree in Computer Engineering

CERTIFICATIONS

Oracle Database 12c Administrator Certified Associate

Oracle Cloud Infrastructure 2019 Architect Associate

AWS Certified Solutions Architect – Associate

Contact this candidate