Database Administrator Oracle

Protus K Matara

Email: *********@*****.***

Phone: +1-952-***-****

DATABASE ADMINISTRATOR

Oracle Database Administrator, with 9+ years of experience in supporting Oracle Databases 11g, 12c and 19c and PostgreSQL Version 15 platforms. Extensive knowledge in Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery. Database and data Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control.

Proficient in Oracle Database Tuning, SQL Tuning using Explain plan, Application Tuning, ASH, AWR and ADDM reports. SQL Server Management System. Good communication and creative problem-solving skills. Quick in adapting to new environment and willing to learn new technology.

AREAS OF EXPERTISE INCLUDE

Experience in data security using Oracle tools and other services to protect the organization’s critical information and exceeding the industry standard.

Understanding of security and backup procedures to ensure database integrity and availability.

Experience with various tools, such as SQL Loader, SQL, RMAN, and Oracle Enterprise Manager

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

Using JIRA, Miro, CONFLUENCE and Rally for tracking project progress

Advanced and innovative problem solving, research, analysis, critical thinking, risk assessment and management and decision-making skills for complex admin issues.

Strong interpersonal communication skills (verbal and written).

Backup and Recovery using RMAN.

Migrating test/development databases to the cloud storage OCI platform

Using Scrum Master skills and Agile methodologies in SDLC projects

Patch/releases updates application for security and bug fixation.

Understanding and ability to work with CI/CD Pipelines, Terraform, AWS CloudFormation, DevOps Azure Resource Manager.

Implementation, maintenance and enforcement of effective industry standard processes and policies within our QA, DEV, and Production environments.’

Always documenting disaster recovery plan for a better future use and for training

TECHNICAL EXPERTISE:

Operating Systems

Unix, Red Hat Linux Version 7.7, Windows, Solaris, Windows Server 2019, SQL Server Management System, SQL Server 2014,2016 Oracle EBS 12, PostgreSQL

RDBMS

Oracle 10g, 11g, 12c, 18c and 19c. PostgreSQL Version 15, Exadata X6M-2, MySQL

Tools/Utilities

OEM 13c, Cronicle Scheduler, OneLogin, JumpCloud, SSO, Data Guard, MobaxTerm, RoyalTS, WinSCP, SQL Developer. Oracle Management Server, Putty, SQL Trace, TOAD, SQL*Plus, Export/Import, Data Pump, Apex Oracle, RMAN, ASH, AWS, ADDM, and Golden Gate, AWS, OCI, Pentaho Spoon for ETL (Enterprise and community version) SharePoint, Azure DevOps tools, PeopleSoft

Languages

PL/SQL, SQL, Perl Scripting, UNIX Shell Scripting, PowerShell

PROFESSIONAL EXPERIENCE:

Cerner Oracle Corporation - Kansas City, MO March 2022 – present

Oracle DBA

●Provisioning access to users as per SLA. Creating, granting privileges and deleting access of the users to the databases. Setting security parameters and policies to minimize vulnerabilities to our sensitive data storage systems.

●Use tools like Okta on our SaaS and on-premises applications.

●Using AuthO platform with our development and security team for easy management, simplification and extensibility to make identification easily accessible.

●Experience with Jump Cloud to manage cloud users with password protection deployment with encryption and the native 2FA.

●Regularly checking and working with the security team to scan our systems against data breaches.

●Making sure that 2FA requirements are met and used by authorized users.

●Ensuring new/promoted users are created, given appropriate privileges, managed and monitored to uphold the integrity of the systems.

●Participate in one-ff access to contractual users who need temporary access to emails or other alerts. And deprovisioning of the same once the assignment is over. Also participate in offboarding of users once they leave the company by removing their access.

●Install, configure, and upgrade Oracle database software to meet organizational requirements.

●Monitoring Key Performance Indicators (KPI) to improve the performance of the database.

●Embracing Agile frameworks and methodologies to Integrate and deploy, upgrade, and patch our systems.

●Using best practices by implementing Wallet where the Master Key of our databases and all other digital certificates. The Wallet is kept outside the database software in case of a disaster this can be used to access the said database.

●Migrating databases from our on-premises to Exadata storage infrastructure for higher availability and reliability.

●Migration of Oracle databases on Premises to OCI platform for easy management and security of our databases.

●Using PostgreSQL to manage and retrieve data from our databases. DDL, DML operations

●Experience with STIGs methodologies for security protocols within our networks, servers, logical designs, and computers to enhance overall security of the systems.

●Moving data to Exadata for large storage capacity. Patching Exadata in preparation for upgrading in a rolling session to enable zero downtime and High Availability.

●Working with Oracle on their Quarterly release to improve our systems and security of our databases.

●Worked with application teams to troubleshoot any issues using OEM, ADDM, AWR and ASH reports.

● As part of the Oracle Operations team, we monitored 100’s of databases using OEM grid to ensure stability. Set up monitoring templates, rules, groups, and notifications. Worked with application teams on requests.

● I worked closely with the Compliance and Audit team to scan all our Oracle databases for company and SOX violations correcting issues that arose from those scans.

●Perform periodic database cycling to fresh and updates the logs/data lags between primary and standby databases.

●Conducts capacity planning studies and performance tuning; applies knowledge of emerging technology trends and develops alternatives with respect to hardware and software.

●Setting up and implementing NetApp for backing up databases

●Perform database tuning by reviewing ASH, AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning, and coalescing of database objects for faster query performance.

●Managing, troubleshooting, and resolving Oracle database and application issues. Working with Oracle Support engineers to solve and deploy their solutions for a better performance.

●Participate in an ongoing migration of some clients to Exadata platform for size accommodation and better/faster performance.

●Help maintain services, queries, jobs, and stored procedures once they are deployed by measuring and monitoring availability, latency, and overall system health.

●Administer Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

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

●Perform administrative activities like user creation and administration, profiles, privileges and roles administration, space, and schema management using tools like SQL Developer and TOAD

●Using DevOps tools as an integration between developers and operators to enable automation to be smooth in managing the data.

Delta Dental LLC - Minneapolis, MN Feb 2021 – March 2022

Associate Database Administrator

●Using DevOps tools as an integration between developers and operators to enable automation to be smooth in managing the data.

●Using SQL Developer for monitoring and managing databases, setting up user accounts and accessing granting.

●Monitoring user activities and checking logs for better performance and security compliance.

●Design and implement solutions to ensure database availability and recoverability.

●Securing data and data masking to protect PII/PHI. Importing and exporting files using a secure platform.

●Performance tuning includes memory, I/O, lock contention, and SQL statement tuning. Checking the logs periodically to catch any hiccups or hurdles.

●Analyze queries, I/O bottlenecks; detect and mitigate performance and lock issues. Logical Volumes layouts, disk layouts and capacity planning

●Conduct cold and hot clones of the databases for refreshments and backups of control files.

●Knowledge and understanding of ETL (Extract, Transform and Load) tools or related technologies. Management of Multitenant Architecture using Pentaho Spoon version 9.0

●Participate in a risk assessment process and placement of local datacenters.

●Performing Data-guard failovers and switchovers as required for maintenance. This includes coordinating with application owners and sys admins to when the failover can be performed by business continuity and service availability.

Honeywell - Minneapolis, MN April 2017 – Jan 2021

Business Systems Management

●Monitoring the performance of the database and identifying bottlenecks, mitigation of the same and keeping a continuous improvement culture.

●Migrating databases from on Premises datacenters to the OCI platform for high availability and data security

●Proficient in managing Database structures, Storage allocation, creation of views-trigger and indexing of tables and tablespaces.

●Setup and configure Oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using Export/Import scripts.

●Perform database tuning by reviewing ASH, AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning, and coalescing of database objects for faster query performance.

●Implementing security protocols to prevent cyber-attacks working together with Cyber security team.

●Deploy and implement Oracle Grid Control (10g, 11g and 12c) to monitor all databases.

●Managing our RAC and Grid Infrastructure Administration for high availability of our systems

●Ongoing upgrading project 12c to 19c in a development and testing environments.

●Perform DR and Restoration drills for Production environments as per Audit and compliance.

●Applying release updates as per Oracle support recommendations and following the security protocols as advised by our cyber security personnel for any vulnerabilities.

●Support and resolve data inquiries with accuracy and in a timely manner; Triage, troubleshoot and help remediate issues.

Deluxe Corporation - Arden Hills Jan 2016 - Mar 2017

Oracle Database Administrator

●Data restoration and recovery using RMAN.

●Managing, troubleshooting, and resolving Oracle database application issues

●Logical Volumes layouts, Disk layouts and capacity planning.

●Executed and provided ADDM, AWR and database health check reports.

●Data guard and RAC. Maintained various SLA's including ticket response and resolution time.

●Applying Oracle patches and maintaining ASM

●Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.); Resolve database related issues.

●Oracle v11.2.0.4 and Oracle v12.1 including database upgrades and patching Installation and maintenance experience with Data Guard for database high availability Oracle ASM and RAC Oracle partitioning and compression.

●Database performance tuning and resolving database performance issues

EDUCATION/CERTIFICATIONS

Bachelor’s Degree Information Management Systems

Oracle Database 12C: SQL Fundamentals

Oracle Cloud Infrastructure: Foundations

Security+ CompTIA Certificate

Public Trust

Professional Scrum Master (PSM1) Certificate

Contact this candidate