Jude Ntam

Oracle Database/MS SQL Server Administrator

Email: adza13@r.postjobfree.com

Tell: 612-***-****

I am a proactive, proficient database administrator, with 9+ years of experience in the daily administration of production and projects in Oracle10g, 11g, 12c, 18c, 19c databases as well as installation and configuration of standalone and Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN), database migration and refresh using Oracle Data Pump, space Management, Oracle database replication using Data Guard, and 12c/13c OEM Cloud Control configuration/administration.

Core Competencies

Oracle Software Installation, Configuration and Administration

Experience in multi-node RAC environments.

Highly experienced in Cloning Oracle databases for developmental purposes.

Data pump expdp/impdp utilities. Excellent experience in Installation, configuration, Maintenance of Oracle software on Operating Systems Solaris, Linux, Aix and Windows platforms.

Experience in creating databases, Tablespaces, tables, indexes, setting privileges and user logins.

Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Upgraded the Databases from Oracle 10g/11g to 11g, 12c, 19c and applied patches

(SSMS) SQL Server Management Studio

Quick learner and elated about new challenges.

Senior Oracle DBA/MS SQL Server Admin Feb 2020 - Present

Minnesota IT Services.

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

Installed and configured software for Oracle 10g, 11g, 12c, 19c on both Windows and UNIX platforms using Oracle OFA.

Upgrade of Oracle Enterprise Manager (OEM) 13.4 to 13.5 and apply OMS, Agents patches.

Extensive experience implementing Oracle Advanced Security: Transparent Data Encryption (TDE) to enforce data-at-rest encryption and Data Redaction.

Provide operational support for Production/QA/Development environments

Work on projects as assigned and drive them to completion according to current standards and procedures of the group

Executing backup and recovery operations in accordance with the SLA and my environment as well as migration and replication of Data.

Provide after-hours support on a rotating schedule with occasional work on the weekend

Configured patching of our legacy databases and cloning using OEM 13c Release 5.

I also used block change tracking (BCT) which reduced the backup time from 8hrs down to 45mins.

Upgrade of GRID and Oracle Databases Software from 12.1.0.2 to 19c, as well as convert non-CDB database to a CDB database.

Supports software Development, Migration/Replication, and Integration efforts as needed

Identifying problematic SQL code using Oracle data dictionary views, SQL tuning Advisors, 10046 and 10053 level tracing, tkprof, TOAD and SQL Developer.

Built and maintained security and integrity controls in coordination with security team using the VPD, user privileges, roles, TDE and Oracle Wallets to ensure highly controlled and audited user access.

Applied Interim Patches, Bundle Patches and Security Patches Update (SPU) on Oracle Exadata Storage Servers, InfiniBand Switches, Database Servers, Grid and Databases.

Routinely upgrade the Oracle Fusion Middleware environments to new versions and apply OMS, Agents, Grid and Database Patches.

Not only provides feedback about work done, but also coach associates around personnel issues with support of the manager.

Resolve critical business issues by providing technical expertise for Oracle RDBMS and Grid Infrastructure, including RAC, Data Guard, and other underlying infrastructure technologies inside the database: ASM, OEM Cloud Control, RMAN Backup/Recovery, and Oracle Cloud.

Database reorganizations and refresh schema-using Export/Import.

Extensive experience implementing Oracle Advanced Security: Transparent Data Encryption (TDE) to enforce data-at-rest encryption and Data Redaction.

Performed Database upgrade from Oracle 11g, 12C, 18c and 19c respectively.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.

Manage day-to-day tasks, requests, and incidents in OracleandMS SQL Server.

Performed full cumulative and differential backups using RMAN and implemented recovery strategies.

Comprehensive knowledge of LDAP, Active Directory, Squid Proxy and Kerberos.

Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump.

24x7 remote support and on call Database support using RSA-VPN.

Oracle DBA/MS SQL Server Administrator June 2019 - Feb 2020

Entrust Datacard - Shakopee MN

Installs new versions of DBMS and apply patches to assigned database systems and software tools as required by product roadmap/life cycle and support requirements.

Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.

Extensive experience installation and implementing Level 1/2/3 OEM 12c/13c Cloud Control.

Applies knowledge and experience with database technologies, development

methodologies, and front end /backend programming languages (e.g., SQL).

Installed and configured Oracle 10g, 11g, 12c, 18c and 19c software on Unix/Linux OS.

Fixed various database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Identified long-running database queries, refined queries for better performance, and worked with end-users to implement changes.

Provides technical consultation for enterprise and application project teams

Involved in session management and monitored the critical wait events, blocking sessions in the database.

Automated processes using CRONTAB.

Performed database upgrade using both DBUA and manual method, and database patching.

Experience rolling patching on Exadata (8-Node, 4-Node) database machines.

Successfully configured and managed Data Guard for disaster recovery, data protection and high availability.

Performed Data Guard failover as required for maintenance. This includes coordinating with application owners and sys Admins to when the failover can be performed.

Performed data and metadata migration to newly installed servers using Data Pump Expdp/Impdp.

Installed, configured and maintained Standard/Enterprise editions of SQL Server 2012, 2014 and 2016.

Experience in data replication using snapshot, materialized views and dblinks.

Created database objects like views, procedures, functions, triggers, tables, synonyms and indexes.

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

Cloned production databases as needed for testing and development using RMAN.

Worked on database security including Auditing (standard auditing, fine grain, valued based and statement auditing) and Encrypting (Transparent Data Encryption- TDE).

Applied Oracle quarterly patches and Interim patches (CPU/PSU) to databases using OPatch utility.

Experience in monitoring Oracle instances and maintaining databases performance using OEM (Oracle Enterprise Manager) 12c and OEM 13c Grid Control.

Involved in each phase of the lifecycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, dev, and prod support activities.

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

Monitors, administers, and tunes all SQL Server, Oracle, and Epic Cache databases ensuring application performance is optimal at all times.

Provide end-to-end technical support and problem resolution, monitors root cause analysis, troubleshoots and resolves database degradation.

Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards.

Provide on call 24x7 as required by on-call schedule and/or necessity of database dependent teams outside of regular business hours

Oracle Database Administrator July 2017 to Oct 2019

SkyWater Technology - Bloomington, MN

Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan and Stats pack reports.

Create reports to monitor database information (including statistics on schemas, tables, indexes, and space usage).

Database Growth and Space management, capacity planning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.

Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and My day-to-day involves the overall Maintenance of Oracle Databases, Backup and Recovery and other database related activities

Implemented Oracle TDE to provide transparent encryption of stored data thatensuresdata integrity.

I have carried out Auditing, Capacity Planning, Configuring and Managing Hot Standby Databases using Data Guard, RAC.

Maintain accurate and complete database programming documentation

Expertise in maintaining Database Security through auditing, authentication and TDE.

Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data.

Implementing Oracle's Transportable Tablespace (TTS) feature using Datapump export/import allowing users to quickly move a user Tablespace across Oracle databases.

Implemented various backup strategies for Large / Medium sized databases using RMAN

Worked extensively on Cloning /Duplicate of databases using RMAN.

Installed, configured and maintained Real Application Cluster (RAC) / ASM on Redhat Linux boxes.

Performed Data Guard switchover/failover as per the requirements.

SQL Queries/Application storage allocation to support application enhancement.

Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Perform maintenance operations daily, weekly and monthly on Oracle and SQL servers and databases, and information systems for the purpose of ensuring efficient program operations.

Design and oversee backup processes for database servers, including clustering, mirroring, and replication. Develop, and test database and information system backup and recovery plans as part of the disaster recovery aspects of a database.

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Oracle Database Admin Feb 2014 to March 2017

Prime Therapeutics LLC - Eagan MN

Experience with database optimization, performance tuning, backup and restoration, table space allocation/management, managing the overall health and status of the database, managing the database schema, creating triggers and storage procedures, monitoring alert logs and resolving database-related issues.

Building database scheme, tables, procedures and permissions; creating, testing, and executing data management languages. Developing database utilities and automated reporting.

Implementing and maintaining database security and encryption, while ensuring data is stored securely and optimally.

Designs, creates, and maintains databases in a web based environment.

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

Manage database server environments and perform day-to-day administrative tasks.

Proactively monitor and respond to database server CPU, memory, disk, and other contentions.

Responsible for maintaining the integrity and performance of company databases

Provide administration and support for MS SQL and Windows Server.

Perform routine backups, including use of Oracle's Datapump export and RMAN

Clone databases using 13c OEM for testing and developmental purposes.

Provide routine maintenance including problem defect analysis and resolution, object management, physical database layout, rollback segment management, and temporary space management

Used RMAN Duplicate and performed Hot/Cold backups, cloning and migration

Applying upgrade patch, maintenance and interim (OPatch) patches on all the databases.

Created, managed and monitored tablespaces using OEM and SQL.

Performed full cumulative and differentialbackup using RMAN.

Certifications

Oracle Certified Associate (OCA)

Oracle 12c and 19c New Features Certified.

Professional Scrum Master (PSM)

Contact this candidate