Manager Oracle

Esambi Epie

Phone: 614-***-**** Email: ******@*******.***

Career Objective: ORACLE DBA & EXPERIENCED SQA and DB Analyst

Dynamic, adept, hands-on experience and results-oriented Oracle Database Administration (DBA) professional, with over 3 years of experience Software & SQL Database Quality Assurance (SQA), seeking a stimulating and rewarding career in the IT industry. Proficient in Oracle Database Management Systems (Architecture, Backup and Recovery, Performance tuning, Security, database replication), SQL Systems, Linux / Windows platforms. Throughout my career, I have had opportunities to develop different skills, especially my communication skills by having to coordinate with stakeholders at various levels of the organization (managers, associates, clients, system administrators, business data analysts and development teams). In addition, I possess exceptional customer service, organizational, analytical, problem-solving and leadership skills with ability to work independently and as part of a team towards an efficient and effective delivery of projects

Summary

Proficient in Oracle 10g, 11g and 12c versions involving database administration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, tablespace management and security.

Experience in performing user management strategies, including creating user accounts, roles, granting access permissions and privileges to the users, altering passwords and granting/revoking access to system/object and auditing user actions.

Skilled in the installation, configuration and maintenance of Oracle 11g software on Windows and Linux OS platforms, including maintaining Databases running on Unix/Linux (Red Hat Linux) and Windows Operating Systems.

Aptitude to create and manage Oracle 11g databases, various Database Backups; such as RMAN (Full/Incremental backups), in traditional hot/cold backups, LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import utility tools.

Knowledgeable in Database Refresh and Cloning with RMAN, manual methods and fine-tuning Flashback Technology, DBPITR; utilizing AWR, ADDM, SQL Tuning Advisor, and Optimizer Statistics to tune the database.

Knowledgeable in populating /loading data into database tables using SQL*LOADER, analyze tables, test recovery strategies and restructure database objects.

Knowledgeable in the concept of Data Guard for disaster recovery, data protection, performance and availability, performance, scalability, resilience in nodes (instances), implementing and maintaining standby databases.

Knowledgeable in planning and reviewing of database designs (Oracle 11g) with the application teams using ERD, DDL, DBCA and other tools, including creating primary keys, foreign keys and table constraints for data integrity, including views to simplify database queries for database users.

Possess extensive knowledge on database administration (DBA) for Oracle 10g, 11g and 12c, including planning, creation, administration and troubleshooting of Oracle OLTP (multiple instances)/ OLAP database.

Adept in Oracle Enterprise Manager (OEM), TOAD for database monitoring/performance/diagnostics, ongoing assessment of database performance, the identification of problem areas, monitors performance and evaluates areas to improve efficiency.

Competent in examining alert logs to troubleshoot data-based problems and debugged database freezing up problem, due to database running out of space and the archive logs not backed up.

Experience in issuing commands to shut down and start the database, reviewing AWR & ADDM reports, implementing SQL profiles and baselines, query performance, including memory, I/O, contention, and SQL statement tuning.

Possess excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team or individually as necessary.

Multilingual communication acumen in English, French and German languages.

Technical Skills:

Operating Systems

Windows XP/7/8/10; Red Hat Enterprise Linux 6.2, Windows

Internet Technologies

HTML, XML

Testing Tools

MTM (TFS), SOAP UI, HP ALM, Ruby/Cucumber/Watir/Gherkin, SQL*Loader, Data pump, Explain Plan, OPatch utility

Defect Management

HP ALM/QC

Databases

Software/Application Tools: Oracle 11g, R2 DBCA, DBUA, OUI, SQL Server 2000 Recovery Manager (RMAN) SQL*PLUS, DBCA, SQL Server Management Studio, OUI Windows 10, XP, Linux Red Hart

OEM, OEM Grid Control Oracle Data Guard, Oracle Management

Documentation -Other Skills

UNIX Shell Scripting, Solaris Service (OMS), ASM, SQL AIX Real Application Cluster GUI Tools: Tuning Tools: Web Tools: OEM SQL, AWR STATSPACK, ADDM, Vi Scripting, Putty, Winscp.

Professional Experience

SQA & Database Automation Analyst Huntington National Bank Columbus, Ohio 2017-Present

As a QA Analyst, I performed manual/ automated testing on its digital platform (Retail Online Application (ROL) modules. Responsible for Database Analysis, Database Testing, procedures, and creating numerous reports using custom SQL or stored procedures. Proficient in writing SQL queries and testing databases on the back-end, pull-up data from tables, testing database integrity.

Responsibilities:

Proficient in the phases of the Software Development Life Cycle, SDLC) from analysis, design, development, testing, implementation and maintenance, including Bug Life Cycle and database testing procedures.

Created detailed test cases, regression test suites and scripts in Microsoft Test Manager (MTM) and Team Foundation Servers (TFS) including performing extensive Functional & System Testing on the Applications.

Knowledgeable in conducting quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.

Proficient in communicating effectively with business units, IT Development, Product Management and other support staff on testing timelines, deliverables, status and other information.

Exceptionally skilled in performing American with Disability Acts (ADA) Testing using different screen readers (Jaws, Voice Over, Sortsite) on cross-border browsers and applications.

Executed queries on passport mainframe to validate data integrity, the integration between application and database, including performing manual / automation testing of various modules of web-based applications and web services.

Experience in creating and executing database queries using SQL commands to create and execute ad-hoc queries and data imports to respond to business and other requests as well as testing the underlying data changes caused by interactions of software applications.

Comprehensive knowledge of database management systems, SQL Queries, and UNIX, Oracle and DB2 environments. Skilled in Analysis, Design and Developing test cases for SQL objects verification and testing.

Developed SQL Queries for checking the Data Transaction and Database Integrity (Mainframe Application).

Identified all bugs present in database and coordinated with software developers and resolved all issues.

Knowledgeable in the administration of Oracle and DB2 databases.

Previous work experience includes Senior Research Specialist at SMG – March 2004 to May 2014

Education / Training

Oracle Database Administration Certification,

Kudrant Academy, US 2018

Master of Science (MS) 2000

University of Bonn, Germany

Master of Sciences (MS) 1994

University of Giessen, Germany

Certificate (RDBMS) 2001

Sinclair Community College, Dayton, OH

Automated Software Testing Training- NewFound Technologies – Columbus, OH- 2015

Manual and Automation Software Testing – Online Training- June-Sept.- Columbus, OH - 2015

Certificate – Manual & Automation Testing-in-person –Intellix Software Inc. 2016

Dedicated Technology Services Inc. Online Training (Ruby Fundamentals, Auto-Testing etc.) 2017

SQA Automat. & DB Analyst – Huntington National Bank (ROL) 2017 to Present

Contact this candidate