YIMKOUA HYOUSSEU

*** ******** ****, *******, ** *4207 Email: acptc4@r.postjobfree.com Phone number: 716-***-****

OBJECTIVE

To obtain a database engineer or administrator position and utilize my extensive experience gained in administrating RDBMS instances using database administration tools and utilities; US citizen.

PROFESSIONAL SUMMARY

* Professional and highly motivated, having over 5 years of DBA and Development work and academic experience in the software industry with Oracle 11g R2, MySQL(4.x,5.x) and SQL Server 2000/2005/2008.

* Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, Oracle Server installation, upgrade, migration.

* Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as an Oracle DBA.

* Strong Oracle and MySQL skills but also significant general system administration skills on UNIX/Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.

* Expertise with Shell Script, PHP backend, system integrations & development.

* Experience in the administration of Web based Internet/Intranet Client/Server multi-tiered distributed application, major in database technologies in Sales, Quality & Standards domains.

* Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle 11g.

* Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.

* Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.

* Expertise in snapshot, import/export, database optimization with the help of explain plan.

* Experienced in implementing row data changes using DML(Lock Table, Call, Explain Plan, Insert, Update, Select, Delete, Merge), DDL(Update, Alter, Truncate, Create, Drop, Comment, Rename), DCL(Grant, Revoke) and TCL(Commit, Rollback, Savepoint, Set-A-Transaction) changes.

TECHNICAL SKILLS

* Operating Systems: Windows XP, UNIX, windows 7 & 8, Solaris, Red Had Linux Enterprise, IBM-AIX, HP-UX, SUSE Linux Enterprise, Windows Server 2003/2008.

* Databases: Oracle 11g R1, 11g R2, Oracle 10g R1, 10g R2, Oracle 9i, SQL Server 2005, 2008, 2012, MS Access 2010, MySQL, IBM DB2.

* Database & Multimedia Applications: SAP ECC 6.0, SAP NetWeaver 7.0, SQL*Plus, SQL Developer, SQL Data Modeler, SQL Server Management Studio Express, DBCA, DBUA, EMCA, OLAP, OLTP, Oracle Data Pump Utility [Export/Import Processes], RMAN, Oracle Enterprise Manager, ODB Configuration Assistant, SQL Loader, Oracle Data Guard Software, Active Data Guard, Snapshot Standby Technology, Data Guard Switchover Process, Oracle Weblogic Server 11g/12c, Fusion Middleware, Oracle Net Configuration Assistant, Fusion Applications, Oracle Identity Manager 11g, Oracle RAC (Real Application Clusters), Oracle Grid Control EM, Oracle Access Manager 11g, GoldenGate 11g R1 R2, 12c v1, SOA suite, Portal, E-business suite 11i R12, Oracle Streams, Repository Creation Utility (RCU), Exadata, Exalogic, Oracle Jdeveloper, Oracle Jrockit JDK/JRE, SunDISK JDK/JRE, J2EE, Java EE, TCP/IP, DNS, BMC-Remedy ITSM 8.0, BMC-Remedy SRM 8.0, DGMGRL Client, Data Guard Broker Server Management, LDAP Directory Server Management, IBM Lotus Notes, IBM Lotus Sametime, Amazon Web Services (AWS), Oracle Application Express (APEX 4.1, 4.2.x), Amazon EC2 (Virtual Nodes/Servers), Oracle Coherence 11g 12c, Oracle Net Manager, Oracle Automatic Storage Management (ASM), Linux x84-64 VMWare

EDUCATION

University of Maryland University College, Adelphi, MD Not Enrolled

Masters of Science, Information Technology – Software Engineering, Database Mgt

University of Maryland College Park December 2009

Bachelor of Arts (B.A.), Laws, Ethics & Torts

WORK EXPERIENCE

Oracle DBA II/GoldenGate Build Engineer

Ntech Solutions Inc M & T Bank – Buffalo, NY November 2014 – Present

* Functioned as Primary resource for GoldenGate software build, configuration and administration using GGSCI client on AIX servers; Goldengate release version 12.1.2.0.

* Creation and configuration of Oracle database (POC) on test environment; ASM/12c database installs on Linux x86-64 VMware. Also created/managed user, tablespaces, datafiles

* Performed schema refreshes of test cert databases from PROD databases; using dumpfiles from nightly exports/direct import across network/DB links.

* Worked on high availability tools(Flashback database,RMAN backup) and setup restore points for required PIT recoveries.

* Supported Oracle production databases as primary on-call DBA.

* Monitored access rights to servers/databases; assigned system/object privileges to users, roles [connect, resource]; developed SQL commands including DML DDL operations to test increased access rights to existing and/or new account holders. . .

* Exported privileged user's account from production database onto live environment during schema reorg operation; dropped database user with SQL statement 'Drop user /*username*/ cascade'; then restored user account by importing user into live database, querying data dictionary view for 'invalid' objects, compiling schema to change status for objects to 'valid'.

* Performed database administration duties including user account creation, password setup tasks. • Provided operational support for Oracle 11g databases on IBM AIX operating systems/servers.

* Configured automation for RMAN backups; monitored health of database instances using OEM grid control 10g, OEM cloud control 12c.

* Provided guidance for application owners on database/server requirements of parallel tuning environment.

* Worked to identify tuning problems in Oracle database using OEM grid control 10g; generated ADDM reports and reviewed findings such as system logjams causing slow run-time for executed batch jobs.

Oracle DBA II

CyberData Technologies Inc US Census Bureau – Suitland, MD April 2014 – November 2014

* Tasked with interfacing with client in order to develop reliable backup and recovery strategies. Performed various tasks in administration of databases including instance creation, performance tuning, storage management [Multi Gigabytes ASM instance], and general troubleshooting. Participated in multiple database development activities such as SQL scripting, and various database server configurations and interfaces for disparate applications, servers, and systems [Ex. SAS].

* Participated in new database installations, configurations, security implementing transparent data encryptions and schema changes, tuning and backups using export data pump utility [‘expdp’ command] embedded in internally developed cronjob process [shell script].

* Assisted in admrinistration for large RDBMS servers and application servers, Installation & Performance Tuning, & Security Management, Backups, Restores & Recoveries using RMAN and NetBackup software partitions including Netbackup clients, master backup servers, and Netbackup agent *Oracle version*.

* Performed new databases design, estimations for maximum server capacity based on storage space requirements, configurations, backups/Export dumps to RHEL filesystems, recoveries, security, schema changes, tuning and data integrity.

* Maintained Enterprise databases using DML, DDL commands, and modified generated DDL scripts from Application Development team for object creations, modifications, deletions.

Oracle DBA II

Samara-Tech LLC – Rockville, MD August 2013 – March 2014

* Provided DBA implementation and support for SAP/Oracle migrations and upgrades, including environments using Oracle Data Guard.

* Installed and configured multiple instances of Oracle 11g. Involved in the configuration of Oracle Patches/Upgrades.

* Administered Oracle and SQL Server databases to include database backup and restoration, performance tuning, database creation, replication and migration on Windows server 2003 2008 instances and Linux servers. Designed and developed HR-related reports, interfaces, conversions, extensions and workflows.

* Provided system DBA engineering, implementation and support for Siebel Applications and SAP using Oracle databases in order to improve database availability, backups and recoveries, and performance tuning methods.

* Provided Oracle DBA (24X7) support to Florida Community Bank for their installs (Development, Test and Production Oracle 11g2 Real Application Cluster (RAC) Database).

* Wrote highly complex SQL, UNIX shell and PL/SQL scripting involving reviewing and tuning SQL and PL/SQL code, triggers & stored procedure to finish the project on time and save the organization cost.

* Consistent database security for different database schemas, and modified DML/DDL scripts for Oracle 10G, 11G databases.

* Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages, with active archived logs transfer to Standby/RAC databases.

Oracle DBA I

Adrenna Inc – Fairfax, VA August 2011 – August 2013

* Performed installations, new databases design, configurations, backups, recoveries, security, upgrades and schema changes, tuning and data integrity for UNIX/Linux servers and Windows Server 2003/2008 platforms.

* Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files.

* Managed GoldenGate as a complement to Oracle's HA and DR systems.

* Involved in setups, configurations and management of Oracle Enterprise Manager 11g applications for Windows server 2003 environment.

* Configured Streams Replication for schemas and database objects by setting up capture processes for data loads, apply processes to propagate and data writes to target databases, row data changes including DML, DDL changes. Ex. 3 million data rows from the source database were applied/replicated to a target database within a period of 25 mins.

* Executed generated DDL scripts to create database objects (tables, views, materialized views, indexes and synonyms) on Oracle, SQL Server database instances.

* Worked with the Development team on the AWS Management Console; lending input as an Oracle DBA on best practice configuration, installation for Oracle RDBMS, including database design with application consoles (developed by adrenna development team) built on Amazon Web Services.

* Set up WebLogic domain with a single Server instance for developers on their windows server 2003/2008 and UNIX machines.

* Performed GoldenGate 11g installations, configurations, trouble shooting, and daily maintenance on Linux/Unix and Windows server 2003/2008 instances

* Prepared systems and supported QA team to tune SQL statements against database and its objects.

* Supported WebLogic Server Clustering, Load balance, Failover and Performance tuning.

* Worked closely with the chief architect to perform software configurations so they improved connectivity with the DBMS.

* Modeled, implemented and maintained Oracle advanced replication tools [GoldenGate 10g, 11g] and Oracle streams to provide data replication on source, target database servers for test, dev, and production environments.

* Wrote and edited documentation for user's manuals, system design and use case documents, requirements traceability and version description documents for Learning Management Systems.

* Installed Oracle Weblogic Servers on UNIX, Linux, Windows clients, Windows servers and Solaris environments.

* Replicated, extracted data and applied development database data to production databases using GoldenGate 11g.

* Installed and configured Oracle Fusion Middleware applications on Linux/UNIX domains.

* Trouble-shooting for different kinds of failures in Weblogic Servers, immediate fixture of the issue and performing root cause analysis.

Oracle DBA I

Gilfus Education Group – Fairfax, VA May 2011 - August 2011

* Performed installations, new databases design, configurations, backups, recoveries, security, upgrades and schema changes, tuning and data integrity.

* Performed setup, configuration and management of Oracle Enterprise Manager 11g.

* Assisted in the integration of a bug tracking system into current enterprise’s production environment.

* Monitor and troubleshoot database backups, disk space, and server availability.

* Assisted in deploying application, database & OS upgrades as required.

* Migrated Non-ASM databases to ASM database environments with RMAN.

* Performed replications and extractions on oracle databases in production using GoldenGate 11g. 12c.

* Installed, configured and upgraded Oracle Identity manager on development, QA and Production servers.

* Trained less experienced personnel and collaborated with clients, analysts, engineers, and developers.

* Performed troubleshooting for the production issues related to re-deployed OIM applications.

* Installed and configured Oracle Fusion Middleware applications on Linux/UNIX domains.

* Responsible for implementation for fusion middleware applications which comprised of UNIX environment, Weblogic application server and oracle database.

* Provided system DBA engineering, implementation and support for Siebel Applications and SAP using Oracle databases in order to improve database availability, backups and recoveries, and performance tuning methods.

* Researched, then incorporated applied solutions for the Oracle Identity Manager (OIM) and Oracle Identity Analytics which included the automated provisioning for more than 80 connected systems and also manual provisioning for disconnected system for thousands of active users.

* Performed installations, maintenance for RAC, Data Guard, ASM environments.

* Assisted with high availability configurations using Oracle Flashback Features, and RMAN backups, restores and recoveries activities.

IT Specialist/Database Administrator

T-rex Corporation – College Park, MD August 2010 - May 2011

* Installed, configured and upgraded operating systems and software applications including database applications and associated peripherals on-site at multiple office locations.

* Assisted in configuring database security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts for single node, standby/Active Data Guard databases.

* Installed, configured and maintained wired and wireless networking technologies.

* Utilized my skills in troubleshooting to resolve hardware and software issues.

* Assisted in the Installation, configuration and administration of Golden Gate replication software using ggsci scripting tool.

* Implemented 10g RAC/11g RAC/Active Data Guard with ASM files system using Oracle clusterware.

* Processed customer and account source documents by reviewing data for deficiencies.

* Provided system DBA engineering, implementation and support for Siebel Applications and SAP using Oracle databases in order to improve database availability, backups and recoveries, and performance tuning methods.

* Administered and maintained data entry requirements by following data program techniques and procedures.

* Performed software and hardware installations followed by the creation of manuals for future references.

REFERENCES

Narvinder Singh

Senior Data Architect

M & T bank

acptc4@r.postjobfree.com

470-***-****

Sreehesh Manathanath Antony Kulandairaj

Business Analyst Business Analyst

M & T bank M & T bank

acptc4@r.postjobfree.com acptc4@r.postjobfree.com

716-***-**** 716-***-****

Contact this candidate