Paul Tentow

adcg6n@r.postjobfree.com 515-***-****

***** ********* *****, ***** ******, MN 55124

Professional Summary

A professional Oracle Database Developer with an additional extensive knowledge and proficiency in database administration and analysis; object-oriented programing and business-oriented programing. Enthusiastic professional with excellent critical thinking, project management, problem solving and communication skills.

Technical Skills Summary

Databases: Oracle 11g, Oracle 12c, Oracle 12 RAC, Microsoft Access, MS SQL Server.

Languages: PL/SQL, SQL, Shell Scripting, Java, Python, COBOL, HTML, CSS, Visual Basic

Software: Cognos, PowerShell, GitHub, Microsoft Word, Access, Excel, Outlook, Visio, Jira

Operating Systems: Linux, UNIX, Microsoft Windows

Work Experience

Oracle Developer/DBA June 2019 – Present

Minnesota IT Services

Installed and upgraded 11gR2 databases to 12c as well as 9i, 10g to 11.2.0.4 version.

Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical.

Developed and automated backup/recovery strategy using RMAN, data pump and shell scripts.

Was involved extensively in the migration project of legacy databases and flat files to Oracle database. The aim of this project was to make the data available to end users through an application Tempo (SaaS) provided by CGI technology company.

Improved the performance of queries by 98% - execution time drastically reduced from 12 hours to 13 mins and won accolades from managers.

Perform routine SQL queries and PL/SQL code analysis as part of application tuning process.

Implemented the Oracle TDE feature for the mission critical databases with sensitive State of Minnesota data for the Pollution Control Agency; and maintained security using VPD, user privileges, roles, and Oracle Wallets.

Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.

Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.

Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.

Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.

Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.

Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.

Design and analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics.

Collaborate with various departments and perform research on all data processing functions.

Infrastructure DBA/Developer Oct 2018 – June 2019

EMC Insurances, Des Moines, IA

Implemented the high availability and disaster protection using the Oracle Data Guard feature.

Performed Full backups, incremental backups and recoveries using the oracle recovery manager (RMAN).

Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using advances materialized views.

Researched, documented and applied all required patches for the Oracle e-Business Suite.

Integrated third-party software packages into the Oracle e-Business Suite.

Performed analysis on alert notification history using Oracle Enterprise Manager 13c

Used Sandbox, PUTTY and WinSCP to manipulate files and perform bash shell scripting

Collected More detailed information on an alert using PL/SQL codes embedded in shell script.

Wrote pseudo codes and flow diagrams for easy interpretation of codes.

Setup Incident rules and corrective actions in Oracle Enterprise manager

Worked to enhance performance through database turning.

Developed ER diagrams, schemas, logical to physical database mapping and data table parameters

Performed data definition language (DDL) and data manipulation language (DML) using SQL.

Administered database objects, including tables, clusters, indexes,

views, sequences, packages and procedures.

Created new database users as required

Troubleshooted problems regarding the databases, applications and

development tools.

Wrote PL/SQL codes and bash shell scripts in UNIX to generate trouble tickets when an alert is generated from the database and monitored by the Oracle Enterprise Manager (OEM).

Database Administrator May 2016– Oct 2018

Blue shield of California, Eldorado Hills, CA

Proactively and reactively monitor, troubleshoot, tune, implement high availability strategies in a 24x7 support/production environments using TOAD, OEM, Explain, Execution plan, AWR, ASH and ADDM.

Set up, configure, monitor and support data guard environment using OEM 12c; develop and implement replication, archiving, backup and recovery strategies.

Maintain database environments such as Upgrades, Patches, utilizing DBUA (In-place Upgrades)/Data Pump Migration, and OPatch to ensure protection against vulnerabilities.

Use Partitioning at table/index level for more manageability, availability/ performance.

Wrote shell(korn/bash) scripts to automate routine work like backups and refreshes.

Perform several import / exports using Data Pump, WinSCP and batch jobs.

Tuned jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.

Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.

Extracted, Transformed, and Loaded (ETL) into Data Warehouse using informatica.

Installed and configured Oracle 10g/11g/12c servers and created/upgraded databases in UNIX, Linux and windows environments.

Refreshed development, testing environments by cloning production.

Restored and Recovered databases from offline, online and RMAN backup.

Performed data transfer using Export/Import and Data pump.

Grant roles and Privileges to end users.

Implement optimal space utilization in tablespaces by avoiding fragmentation.

Load data into database using SQL Loader.

Perform Data Guard switchover/failover as per requirements

Used Tablespace Manager and Oracle Expert to monitor performance bottlenecks, database response time, instance workload and operating system resource usage.

Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.

Successfully restored 22 TB database having thousands of data files and shrink back to 6 TB of size

Mbatu Credit Union Jan 2009 – July 2013

Oracle PL/SQL Developer/DBA

Yaoundé – Cameroon

Installed and setup Oracle 10g RAC on Red Hat Linux version 4 and AIX 5.3 servers.

Installed and configured Oracle OVM software. Configured Oracle VM Management and Server environments and created Virtual Machines using Oracle OVM.

Installed, configured and managed Data Guard with Data Guard Broker, RMAN backups, and Grid Control.

Assessed database performance to include I/O contention, fragmentation, Table and Index statistics and usage

Developed and provided support to all system interfaces and coordinated with all project managers to provide specifications for all core modules.

Coordinated with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.

Analyzed and ensured efficient transition of all technical design documents and developed various PL/SQL packages, Procedures and functions to provide support to all application developers.

Monitored, developed and recommended changes if required to all PL/ SQL packages and provided stored procedures and design and develop various relational database.

Evaluated all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.

Designed and implemented various structures for all physical objects and recommended changes on applications through efficient statistical structures.

Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.

Collaborated with various departments and perform research on all data processing functions.

Education

Bachelor of Science, Management Information Systems May 2018

Iowa State University, Ames, IA

GPA: 3.89/4.00

Associate of Science, Management Information Systems Dec 2016

Des Moines Area Community College, Des Moines, IA

GPA: 3.50/4.00

Contact this candidate