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