Resume

Sign in

Oracle Database Administrator

Location:
Houston, TX
Salary:
100K
Posted:
May 23, 2020

Contact this candidate

Resume:

Christabel Undih Ndifon

724-***-****) adddvb@r.postjobfree.com

Oracle / Microsoft Azure/MSSQL SERVER Database Administrator

Experienced Oracle/ Ms sql server Database Administrator with over 6 years of Oracle experience. Highly skilled in database cloning and refreshing and tuning and assigning indexes. Excels at troubleshooting issues in a variety of environments and server types to resolve issues with little impact to performance and with little database downtime. Easily able to work in teams to achieve common goals. Skilled in installing, configuring, upgrading, and migrating databases as needed. Maintains strict database security and integrity standards for databases. Areas of expertise include:

Oracle 10g, 11g, 12c,19C

MSSQL SERVER 2008-2017

Sun Solaris 9.x, 10.x

AIX 5.3, 6.1

TOAD

OEM Cloud Control

Goldengate

Performance tuning

RMAN

Data guard

Upgrades and patches

Cloud migration

Oracle Enterprise Manager (OEM)

Real Application Cluster (RAC)

SQL SERVER MANAGEMENT STUDIO

Data pump

AWR

ADDM

STA

ASH

EXPLAIN ANALYZE

Explain Plan

STATSPACK

Putty

Database replication

Single and real application cluster

Database security

Database backups

Data migration

SQL*Plus

SQL*Loader

Remedy

Service Now

Strong interpersonal skills

Excellent written and verbal communicator

Ms sql Server Backup/recovery

Linux and windows operating system support

Active Directory, Azure Active Directory setup and troubleshooting.

VMware installation, configuration and operation.

TechnicalSupport for physical machines, virtual machines and azure based service

Knowledge of Information Technology Infrastructure Library (ITIL)

PROFESSIONAL EXPERIENCE

Work Experience & Achievements

Shell Oil Company, Houston TX – Contractor (CGI Consulting / Mindlance) October 2019 - Current

Cloud Ops (Azure Engineer)

Create User Accounts in Azure Active Directory and Active Directory.

Troubleshoot user account issues that occur (Ad and AAD) and assist users with password reset and account configuration.

Troubleshoot Linux and Windows based virtual machine issues.

Assist in analyzing and resolving network issues occurring in Azure Environment.

Patch Virtual Machines and make sure the environment is up to date.

Upgraded from 12C to 19C database

Monitored cloud control, error notification configuration, listener installation, and added all needed functions to cloud control

Used stated requirements to size SGA, database buffers, shared SQL area, and log buffers.

Created, configured, and setup RMAN catalog databases, used to register targeted databases

Monitored tablespace free space, table space requirements, and indexes, ensuring high database performance

Resolved tickets for multiple environments, provided dev support, and collaborated with development for application tuning

Aided with capacity and resource planning

Debugged high priority and sudden database service interruption issues including ORA-600 and ORA 7445 errors, resolving them efficiently and providing root cause analysis

Used RMAN to implement required recovery strategies and recover databases in instances of crashes and media/disk failures

Use Automation tools such as Azure Automation run books and run automation scripts using PowerShell and python to create resources in Azure environment.

Execute operations using Python and PowerShell scripts to retrieve data, change configuration and to troubleshoot issues in the environment.

Create backup, troubleshoot backup issues, and restore virtual machine in Azure Environment.

Support teams to setup and configure replication of their virtual machines using Azure Site Recovery for disaster recovery.

Use Service Now to Manage incidents created by users having issues with their Virtual Machines and Applications.

Monitor Security alerts in Azure environment (Azure Security Center Alerts), report the incidents by creating Service Now incidents tickets and engaging the different teams.

Collaborate with other teams in resolving issues that occur in IT infrastructure.

Create restricted resources for users, developers, and other staff members.

Engage other partners in case of major incidents and drive the incident to mitigation and resolution.

Assist users with virtual machine and account issues in Dev Test Lab environment (Azure DTL).

Provide training to new hires and update documentation for staff.

Provide technical advisory support to product delivery teams. Test, add and troubleshoot storage services (issues in azure storage account and data disk).

Create multiple virtual machines in the same virtual network and test connectivity.

Create virtual machines in availability set to ensure redundancy and test functionality.

Create snapshots and download them to backup virtual machines and data.

Create Key vaults to protect data and credentials in azure stack.

Create SQL databases in azure and test connection and functionality.

Troubleshoot issues with Linux virtual machines.

Create virtual machines in scale sets and test their functionality.

Deploy network security groups, setup, and test inbound and outbound traffic.

Create bugs and collaborate with the development team to troubleshoot bugs Proactively monitor, resolve, or escalate incidents from Office 365 customers.

Document all troubleshooting steps within the tools.

Resolve SQL server incidents (connection, replication, and mirroring)

Run SQL queries for system analysis and troubleshooting

Nabors Drilling Services Houston, TX

Oracle Database Administrator June 2017 – 2019

Troubleshoot RAC issues using Cluster ware and database logs

Utilized Opatch to apply Cluster ware and RDBMS patches such as PSU and bug resolution one-off patches

Upgraded all RAC and standalone databases from 10g to 11g, 11g to 12c to improve performance through increase features

Created, configured, and setup RMAN catalog databases, used to register targeted databases

Installed and tested Goldengate 11 and 12 on DBFS and ACFS filesystems, applying latest patches as needed

Improved target data replication through use of Goldengate integrated and coordinated replicate

Maintained Data guard environment with TBs of log shipping daily, troubleshooting as necessary

Skillfully used OEM, AWR, and ASH to troubleshoot performance issues

Migrated QA and PRODUCTION databases to cloud (AWS)

Designed optimized database parameters and capacity designs for heavy loaded high end OLTP systems

Utilized automated scripts/processes and reports to manage database capacity while collaborating with storage teams for ASM disks

Administered databases running on MSSQL SERVER, performed database tuning and also ensured data integrity and security of the databases as well as upgrading and patching of SQL SERVER

Performance tuned applications and databases using CBO, SQL*TRACE, Explain Plan, AWR, ASH, and ADDM

Automated business processes and daily backups through creation of UNIX shell scripts

Applied all database upgrade, maintenance, and interim (opatch) patches

Used production data regularly to refresh dev and test instances

Resolved network congestion, memory (SGA and PGA), CPU, and IO issues as they arose

Successfully migrated data from server to server with little downtime and productivity issues, including non-ASM to ASM

Setup and implemented 2 node RAC on Linux in 10g and 11gR2 and configured Data guard physical and standby databases for high availability

Implemented ASM and utilized it to manage disks and disk groups on RAC and standalone databases

Scheduled and maintained level 0 and 1 RMAN backups

root cause analysis

Upgraded databases from 11.2.0.3 to 12c for proof-of-concept on QA database

Monitored tablespace free space, table space requirements, and indexes, ensuring high database performance

Efficiently allocated system storage with planning for future storage requirements for new and existing databases

Created proactive performance monitoring with automated jobs alerts through UNIX scripts

Used stated requirements to size SGA, database buffers, shared SQL area, and log buffers.

Implemented different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server in OLTP Environments.

Implemented and successfully tested Database Mirroring in SQL Server.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Implemented and successfully tested Log Shipping in SQL Server. Implemented different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server in OLTP Environments.

Implemented and successfully tested Database Mirroring in SQL Server.

Implemented and successfully tested Log Shipping in SQL Server.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

MSSQL SERVER backups and recovery

Weis Market Inc Sunbury, PA

Oracle Database Administrator. April 2013 – July 2016

Utilized RMAN and Data pump export/import to clone and migrate databases

During install of 11gR2 RAC used ASM to perform disk and disk group management

Monitored OCR and Voting Disk health checks and troubleshot RAC environment issues

Ensured secure and efficient operating of database systems

Managed all stages of databases from planning, testing, implementation, and support

Resolved tickets for multiple environments, provided dev support, and collaborated with development for application tuning

Monitored cloud control, error notification configuration, listener installation, and added all needed functions to cloud control

Converted non-RAC single instance to RAC database instances

Used RMAN to implement required recovery strategies and recover databases in instances of crashes and media/disk failures

Skillfully utilized Cron Tab RMAN to schedule physical hot and cold backups and monitor backup progress

Created all users, groups, roles, profiles, and privileges, assigning users relevant groups and privileges

Optimized and tuned SQL inquiries using SQL*TRACE, TKPROF, and Explain Plan

Used run Installer and Opatch to apply security patches, Critical Patch Updates, and Patch Set Updates

Implemented TTS and Data pump to quickly move user tablespace across databases

Installed and configured Oracle 10.2.0.1 on HP-UN platform

Upgraded from 11g to non-CDB 12c and migrated non-CDB 12c databases to pluggable databases

Implemented tablespace level TDE security and created Oracle Wallets

Created and ran scripts to determine database status including table size growth, extent allocation, free/used space, and fragmentation

Maintained databases including space management, capacity planning, and disaster recovery

Ensured zero downtime while creating physical standby databases using RMAN, working extensively with-it regarding troubleshooting, switchover, and switchback

Performed failover and switchover with Data guard Broker and manually as needed

Used materialized views and Goldengate with Oracle 11gR2 to perform data replication

EDUCATION & CERTIFICATIONS

Bachelor’s in Political Science and Public Administration and a Diplomat in Sociology and Anthropology.

Oracle Certified Associate (OCA 12C)

SQL Fundamentals



Contact this candidate