Reinhard Kiplangat (OCA)

Address: **** ******** **, ****** ****,Mn 55112

Email: adn1f1@r.postjobfree.com

Tel: 719-***-****

LinkedIn Profile: http://www.linkedin.com/in/reinhard-kiplangat-2b52a719a

SUMMARY

An accomplished and seasoned Senior Oracle Database Administrator (SDBA) with over 7+ years of experience with extensive knowledge in Oracle database administration. Oracle Certified Associate (OCA) in Oracle 12c SQL Fundamentals, proficient in Oracle 10g,11g, 12c, 18c and 19c on Windows, and Red Hat Linux. Expertise knowledge in database configurations and installations, Database Design and development (SDLC), Monitoring, Tuning, Migration, Upgrades, Backup & Recovery and Security Implementations. Enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail with strong organization, verbal and written communication skills able to multitask successfully and thrive in a dynamic fast paced and versatile work environment.

Experience in data encryption using Oracle TDE to protect the organization’s critical information and exceeding the industry standard.

In-depth understanding of security and backup procedures to ensure database integrity.

Experience with various tools, such as SQL*Loader, SQL, RMAN, PL/SQL and Oracle Enterprise Manager (OEM) 12c and 13c.

User Management, creation, monitoring and management of database users. Altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.

Monitoring & Reorganizing Tablespaces/Tables/Indexes.

Databases Performance Tuning / Maintenance.

TECHNICAL EXPERTISE

●Operating Systems: Unix, Linux- Red Hat Linux 5.4, Red Hat Linux 6, Windows 2000 Server, Solaris, AIX

●RDBMS: Oracle 10g, 11g, 12c, 18c and 19c.

●Tools/Utilities: RMAN, OEM Oracle Management Server, SQL*Plus, Export/Import, Data Pump, RMAN, AWS, ADDM T-SQL, Python R, Teradata..

●Utilities:RMAN, ADRCI, SQL*Plus, RDA-HCVE.

●High Availability Solutions: RAC, Data Guard, and ASM

PROFESSIONAL EXPERIENCE

US Bank, Richfield, MN

Oracle Database Administrator May 2017 – Present

Senior Oracle Database Administrator for Cargil and Best Buy campuses. Ensured high availability and recovery for over 1200+ employees’ databases. Worked collaboratively with other DBAs to ensure optimal performance of the database

●Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance.

●Monitoring and reporting daily backup with RMAN, configuring and managing backups (full and incremental).

●Performed Installation, security and patch upgrades over successive Oracle generations using the OUI and DBCA.

●Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle Instances.

●Created database objects such as tables, views, synonyms, sequences and triggers.

●Created user accounts and assigned appropriate privileges.

●Database Security monitoring and security compliance auditing.

●Monitors and resolves Data guard problems, maintains flashback capability, troubleshoots database problems including performance issues and resolves them with the AWR, Performance views and SQL Tuning advisor.

●Implemented a backup and recovery policy and uses RMAN.

●Responsible for monitoring and troubleshooting the database environment.

●Table space monitoring, Performance monitoring and tuning for performance improvement.

●Implemented database security using Oracle’s Transparent Data Encryption (TDE) to protect the organization’s critical information and exceeding the industry standard.

●Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) reports and automatic session history.

●Administered tablespaces (data file) on space management and adjusted for future needs.

●Installed and configured Oracle OEM 12C on Dev and test environments.

●Planned and performed Backup/Recovery using RMAN base on SLAs, test backup for corruption, Work with Flash Recovery Area as well.

●Expertise in implementing data refreshes using RMAN utility, Transportable Tablespace (TTS) feature, Data Pump and conventional Export/Import of Oracle 11g, 12c.

●Run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

●Maintained the data integrity and security using integrity constraints and database triggers.

●Part of team which provides 24X7 on call support for production and development databases.

●Used OEM extensively to monitor the general health and troubleshoot/diagnose problems in the - Strong skills in applying CPU, PSU and One-off Patches using "run Installer" and Perl based utility “opatch" as part of the maintenance activity.

●Upgraded MariaDB from version 10.0.12 to 10.0.24

●Back up of PostgreSQL databases using pg dump and restoring from backup.

●Disaster recovery analysis and testing on both MySQL and PostgreSQL databases.

●Implementing user level security, object level security, data encryption, data masking, Fine Grained Auditing using DBMS_FGA package.

●Having strong Unix scripting (Shell/Perl) knowledge.

●Expertise with migrating data to Vertical from Oracle, Teradata and SQL Server Database.

●Database Migration specialist- Expertise in migrating data from any traditional RDMS (Oracle, MySQL, and DB2) to Confidential Vertica.

●Experience with Development/Test/ Production QA which included documentation of processes, creation of test scenarios and executions of tests, via T-SQL scripts, to ensure UI standards met the required specifications.

●Installing, Configuring and Maintaining SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment.

●Working knowledge of MS Access, VB6, VBA,T-SQL and SQL, HTML,CSS, JavaScript,MS SQL and other relational databases, MS Office Suite applications, SQL Server 2008, Visual Studio IDE, Windows and Linux OS.

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

●Experience in upgrading and migrating various versions of PostgreSQL database on different platforms

●Database design and modulation Environmental management using MS visio 2010, PostGreSQL

●Database physical modeling and normalization using SQL Developer and pgModeler

Kroger Company, Colorado Springs, CO

Oracle Database Administrator Jan 2013 – April 2017

As an Oracle DBA for Kroger Company, administered and supported development of Oracle 11g, 12c databases by installing and configuring the Oracle Server. Created databases and database objects and cloned production databases as needed for testing and development using RMAN and Grid Control.

●Implemented proactive database monitoring using SQL Trace. Mr. Performed database design and maintenance using Oracle partition technologies.

●Implemented backup and recovery procedures using RMAN and Data Pump utility for Oracle databases and test regularly in conjunction with Operations. Maintained 24*7 Availability by implementing standard processes and troubleshooting live issues.

●Monitored and optimized database performance, troubleshooting performance issues using OEM and AWR.

●Performed SQL Tuning and provided consultation such as creating Materialized views, table partitions, adding indexes, dropping unnecessary indexes.

●Managed database security by creating and assigning privileges to users depending on the user’s activity, auditing and performing other security related tasks including Transparent Data Encryption and acknowledged HIPAA laws.

●Monitored bugs from the alert log and trace files and used DDL statements to CREATE and ALTER within a dynamic SQL script, created schemas, synonyms and roles.

●Used RMAN for database refresh with hot backups, incremental backups and validated to ensure the backups were secured and usable for recovery.

●Participated as part of a teamwork effort for SDLC principles and the development of documentation for new procedures and processes for technical projects.

●Managed users by creating them, assigning roles, managing passwords and privileges including other security related tasks.

●Managed Automatic Storage Management (ASM) and Non-ASM database file systems.

●Used Oracle Enterprise Manager (OEM) for database monitoring and performance tuning.

●Installed Oracle databases on Linux OS and analyzed SQL statements, reorganize database objects and designed indexes.

●Performed day to day database administration tasks like database creation as well as working on projects such as upgrades (from 9i, 10, 11g to 12c) and patching.

●Database upgrades, resource capacity planning, platform migrations, application consolidations and data center rationalization.

●Managed 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).

●Experience with applying Patches such as CPU/PSU patches, One-Off Patches, Interim patches as per the oracle recommendations.

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

●Upgrading database from version 10.2.0.4 to version 11.1.0.7

●Hand-on experience in administration of MySQL databases.

●Excellency in UNIX Shell Scripting.

●Experience with Teradata Viewpoint 15 & TD 14.10/15

●Good understanding of Teradata Database System Control settings.

●Gathering and analyzing user or business requirements and providing support to the technical team in designing, development and documenting MS Access databases and related system using VBA and SQL programming as per established standards and procedures.

EDUCATION/CERTIFICATIONS

B.Sc in Computer Science Jan/2019

Western Governors University

Associates of Arts in Economics and Mathematics Jan/2016

Pikes Peak Community College

Oracle Database 12c Administration Certified Associate (OCA) April/2020

Oracle University

Contact this candidate