Database Administrator Sql Server

Eugene Udensi

ad5s1t@r.postjobfree.com • 205-***-****

www.linkedin.com/in/eugene-udensi • Queen Creek, AZ

Summary

Cloud Solutions Architect • Database Administrator/Engineer • AWS Eng./ Azure Cloud Administrator

Information technology professional with 10+ years of success ranging from Oracle, SQL Server and other RDBMS database design, development, and administration to business analysis to solutions architecture and cloud engineering with AWS & Azure platforms. Strategic leader with proven ability to plan and implement small- to large-scale projects aligning business goals with technology solutions to drive process improvements, competitive advantage, and bottom-line gains. Expertise creating, migrating, and deploying innovative and complete security architecture for cloud data protection and migration. Adept at defining requirements and driving plans to transform services, break silos, and implement creative and effective solutions in multiple areas of business. Skilled at installing, configuring, upgrading, maintaining, and resolving performance issues, database capacity issues, backup, replication, and other distributed data issues on Oracle and other RDBMS.

Technical Proficiencies

Operating Systems

UNIX (Solaris), LINUX /Red Hat Linux, Windows, Exadata,

Databases & Utilities

Oracle 10g, 11g, 12c, & 19c, SQL Server, RDS, Asure Managed Database, SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DBCA, DBUA, OEM Grid, Data Pump, Export/Import

Tools

Oracle Enterprise Manager (OEM), Explain Plan, AWR, ADDM, ASH, Top, Toad, Putty, NX client, WinSCP, Any Desk, AWS-RDS, AWS DMS, GitHub, Jenkins, Kubernetes, Ansible, Artifactory, Docker, Oracle E-Business Suite, Terraform, CloudFormation, SSMS, SQL Developer, Azure Portal, CloudEndure, Azure Migrate

Professional Experience

PVC College, Blythe, CA, July 2023 – Present (Contract Position)

Operational Reporting Systems Manager / Azure Cloud Administrator / Database Administrator

Tools & Technologies: SQL Server, SSMS, SSIS, SSAS, SSRS, Data Warehouse, Windows, Power BI, SQL Developer, OEM, RMAN, Golden Gate, PuTTY, SQL Plus, Colleague UI, Colleague Self-Service, GitHub, Kubernetes, Azure Portal, PowerShell, Terraform,

Managed Colleague front and back-end application, SIS comprising databases and UI for data entry and retrieval. Made sure the system is maintained, secured, accessible, and properly programmed. Managed Colleague users connecting to functional screens and applets (mnemonics), assigning, and maintained security classifications, assigning, and maintained users to security classifications, setting field-levels, generating save-lists and reports and some networking activities. setting up package compilers and data management.

Working as cloud administrator on Microsoft Azure environments, involved in Azure ADConnect configuring virtual machines, Storage accounts and Azure resource groups.

Experience with cloud computing and Virtualization

Strong Endpoint device support experience (i.e., desktop computers, laptops, Surface hubs, Surface Pro).

Administered Azure AD users, groups, and devices, and participated in migration between on-premises and Azure AD through AD connect.

Experience with Microsoft 365 and office 365 and office 365, including Teams, SharePoint Online, OneDrive, and Exchange Online.

Hands on experience with Unix/Linux environments.

Working experience with Git and GitHub repositories.

Administered Azure on physical server and virtual servers using virtualization technology, using Hyper-V, Xenserver and VMware.

Performed automation tasks in PowerShell, Azure CLI and JSON form ARM templates.

Deployment of Virtual Machines to Virtual Networks using Azure portal or PowerShell.

Working Experience with Microsoft Azure Administration like configuring availability sets, virtual machine scale set (VMSS) with load balancers, Virtual networks, network security group (NSG), Docker and Kubernetes.

Configuration of Azure Virtual Networks, Subnets, DHCP, DNS, Network Security Groups, Load Balancers, Front door, Application Gateway, and Traffic manager.

Provision, manage and monitor storage accounts.

Ability to install Operating Systems on Servers and Devices

Aegis Mortgage Corp, Dallas, TX, August 2020 – July 2023.

Oracle Database Administrator / SQL Server Database Administrator

Tools & Technologies: Oracle, Linux, Oracle Enterprise Manager, RMAN, UNIX, Perl, SSMS, SQL Developer

Lead implementation of Oracle ASM 12c software, partitioning disks in Linux and building multitenant RAC database with two-node cluster and ASM storage. Configure, integrate, maintain, and upgrade all development, staging, and production databases, managing user and space allocations and monitoring performance. Diagnose and resolve performance and capacity issues. Use ETL to load and extract data from source systems, enforce data quality and consistency standards, and deliver data in presentation-ready format.

Migrated application data from Non-CDB to CDB multitenant environment, allocating and managing space and overseeing disaster recovery.

Ensured database availability and security, using RMAN for incremental and cumulative setup, configuration, backup/restore, and maintenance of standby databases (Oracle Data Guard).

Installed and configured Oracle Golden Gate 11g/12c replication to remote sites to enable disaster recovery, achieving maximum availability and fault tolerance.

Designed and developed Golden Gate databases to meet business uses, managing cluster maintenance mode blackouts and minimizing downtime.

Successfully implemented backup and recovery processes using RMAN, including both hot and cold backups.

Streamlined database operations, creating materialized views, adding, and deleting indices, and integrating hints wherever possible.

Developed and maintained data extraction and transformation processes, ensuring that all data were loaded correctly and extracted in and out of company system with 100% success rate.

Tested, debugged, and documented Oracle PL/SQL packages and types compliant with company policies, standards, and industry best practices, ensuring 97% satisfaction in performance.

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Integrated Exadata monitoring into the existing IT monitoring framework. Provided and implemented performance and tuning recommendations of all components in the Exadata machines.

I maintained the Exadata software and firmware storage servers in the Database machine including routine health check, patching, and upgrades according to the suggestions from oracle support.

(synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management (Tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).

Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQL Net, V$ and DBA views.

Managed Oracle database backend for a commercial application front-end.

Health & Human Services (DHHS), Montgomery, MD, July 2019 – July 2020 (Contract Position)

Oracle DBA / AWS Solution Architect & Azure Cloud Administration

Tools & Technologies: Azure Portal, R, STATA, Cloud Shell, Python, CRM, Terraform, Lambda, Account Factory, Clout Endure, Docker, SNS, CloudWatch, MS Project, ETL, OEM, Golden Gate, RDS, TOAD, Oracle Database Vault, Transparent Data Encryption (TDE), Scripting & Automation using (bash, python & SQL), Linux, UNIX, GitHub, Jenkins, Kubernetes.

Design, develop, and implement fault-tolerant, highly available infrastructures using Terraform following specifications for Cloud application deployment. Implement IAM best practices and role-based access control to ensure business continuity and effective disaster recovery. Develop serverless architecture integrating SNS, CloudWatch, and other AWS services. Use MS Project to create detailed project plans, gathering and defining requirements and developing efficient breakdown schedules. Facilitate stakeholder meetings from initial project charters through planning and execution phases. Built baseline VPC and network design leveraging VPC peering and Transit Gateway; implemented control tower preventive and detective guardrails.

Migrated applications to AWS cloud using Cloud Endure, using Docker to build, test, and deploy applications in multiple environments.

Successfully migrated from the Oracle on-premises environment to AWS Cloud with 100% management productivity.

Performed automation tasks in PowerShell, Azure CLI and JSON form ARM templates.

Deployment of Virtual Machines to Virtual Networks using Azure portal or PowerShell.

Working Experience with Microsoft Azure Administration like configuring availability sets, virtual machine scale set (VMSS) with load balancers, Virtual networks, network security group (NSG), Docker and Kubernetes.

Configuration of Azure Virtual Networks, Subnets, DHCP, DNS, Network Security Groups, Load Balancers, Front door, Application Gateway, and Traffic manager.

Experience with cloud computing and Virtualization

Strong Endpoint device support experience (i.e., desktop computers, laptops, Surface hubs, Surface Pro).

Administered Azure AD users, groups, and devices, and participated in migration between on-premises and Azure AD through AD connect.

Experience with Microsoft 365 and office 365 and office 365, including Teams, SharePoint Online, OneDrive, and Exchange Online.

Working as cloud administrator on Microsoft Azure environments, involved in Azure ADConnect configuring virtual machines, Storage accounts and Azure resource groups.

PAYCHEX, Austin, TX, August 2017 – July 2019

Oracle Database Administrator/AWS Cloud Solutions Architect / Azure Cloud Administrator

Tools & Technologies: Oracle Enterprise Manager (OEM), SQL, AWR, ADDM, Oracle 11g/10g, Exadata, STATSPACK, SQL Track, TKPROF, Explain Plan, Golden Gate, Ansible, Artifactory, Docker, GitHub, Jenkins, Kubernetes, Maven, Sonar Qube.

Managed and monitored database operations and application servers, loading data from flat files and organizing databases, schemas, and tables to improve performance. Used import/export utilities to clone and migrate small-sized databases and move data between 10g and 10g/11g environments. Conducted troubleshooting and performance tuning for Golden Gate. Ensured functionality of databases, diagnosing, and correcting issues and reporting on system availability. Prepared weekly performance reports. Created, maintained, and evolved AWS cloud infrastructure for running applications, managing continuous integration and deployment (CI/CD) methodology for server-based technologies. Built and maintained cloud-native applications using DevOps tools.

Successfully installed and configured Oracle 11.1.0.7 and Oracle 10.2.0.5 databases on AIX platforms.

Planned, implemented, and grew AWS cloud infrastructure, building, releasing, and managing configuration of all production systems.

Developed RMAN Backups, Data Pump, and disaster recovery management policies.

Created & Modified ASM disk groups and allocated space on devices & space management.

Used RMAN for incremental and cumulative backup/restore, setup, configuration, and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability, and data protection.

Install and configure Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point.

Duplicated all the non-production database on Exadata server according to the Data Warehouse development project’s requirement.

Participated in primary technical resources in SQL tuning in Exadata Production and performance Testing environments by using statistics, hints, SQL tuning set etc.

Performed Zero Downtime Migration to Oracle Exadata with Oracle Data guard and Oracle Golden Gate.

Configured, managed, and monitored Oracle Databases on Amazon Web Service (AWS).

Collaborated with architecture and engineering teams to design and implement scalable software services, ensuring best-in-class system security.

Functional and technical support of Order Management, including Advanced pricing, modules of Oracle EBS.

Promoted process improvements, troubleshooting, and resolving issues across all platform and application domains.

Oversaw pre-production acceptance testing to ensure high service and product quality.

Designed and built web environments on AWS, working with services that included EC2, ELB, RDS, and S3

Working as cloud administrator on Microsoft Azure environments, involved in Azure ADConnect configuring virtual machines, Storage accounts and Azure resource groups.

Experience with cloud computing and Virtualization

Strong Endpoint device support experience (i.e., desktop computers, laptops, Surface hubs, Surface Pro).

Administered Azure AD users, groups, and devices, and participated in migration between on-premises and Azure AD through AD connect.

Experience with Microsoft 365 and office 365 and office 365, including Teams, SharePoint Online, OneDrive, and Exchange Online.

Capital One Bank, Baltimore, MD, July 2015 – July 2017 (Contract Position) Oracle Database Administrator

Tools & Technologies: Scripting & Automation using (bash, python & SQL), RAC, Data Guard, Golden Gate, Oracle 10g, 11g, 12c, and 19c, SQL*Loader, Oracle Enterprise Manager (OEM), SQL Tuning Advisor, ADDM, AWR, PL/SQL, ELT, Oracle SQL Developer, TOAD, Oracle Database Vault, Transparent Data Encryption (TDE)

Managed and monitored database operations and application servers, loading data from flat files, and organizing databases, schemas, and tables to improve performance. Migrated Application data from NON-CDB to CDB Multi-tenant environment and move data between 10g, 11g, 12c and 19c environments. Conducted troubleshooting and performance tuning for Golden Gate. Ensured functionality of databases, diagnosing, and correcting issues and reporting on system availability. Developed RMAN Backups, Data Pump, and disaster recovery management policies.

Implemented Oracle ASM 12c software installation and configuration (Grid Infrastructure) and partitioning Disks in Linux.

Extensively worked Oracle ASM Lib Utility for managing ASM disk storage & Oracle 12c ASMCA.

Implemented Oracle 12c Multi-tenant RAC database with 2 node cluster and instances using ASM storage.

Worked on taking backup and restore cluster ware storage (Voting Disk, OCR Disk).

Worked to take backup on Oracle RAC database by using RMAN utility in a CDB (Multi-tenant) environment.

Created databases in RAC environments and in ASM (Automatic Storage Management).

Designing & implementing Oracle Golden Gate 11g/12c replication to remote sites (active/passive and active/active) for disaster recovery.

Installed Golden Gate using Zero Time Migration, Integrated and Classic Capture/Extract.

Configured Golden Gate 12c against RAC and non-RAC databases using Cluster Ware Database file system.

Used Golden Gate in combination with Active Data Guard and RAC 12c Container databases to achieve maximum availability and the Highest Fault tolerant database system.

Worked on recovering GOLDEN GATE corruptions and managing cluster maintenance mode blackouts.

Generate and review AWR/ADDM/ASH reports, trace queries & transactions and utilize OEM (SQL Tuning Advisor) during performance optimization tasks.

Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.

Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.

Experience in writing UNIX/SHELL scripts for providing the reports.

Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space, in adherence to the Optimal Flex Architecture.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Supported the Oracle EBS payables, Fixed Assets, Purchase and Tax enhancements.

Extensive experience in RMAN recovery testing, RAC, and standalone database.

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.

LJ Power, Seoul, South Korea, Jan 2013 – Jan 2015 Business Analyst

Tools & Technologies: Python, Tableau, SWOT analysis, Google Analytics, Brainstorming, MS Office: Word, Excel, PowerPoint, Visio, Jira, SQL, Trello Project, Microsoft Project

Facilitated stakeholder meetings from project charter development through planning, execution, and monitoring, documenting project risks and lessons learned to improve future project execution. Gathered and defined requirements from project stakeholders, developing work breakdown structures and milestones. Used Python to conduct market research, identifying market size and other parameters, as well as legal requirements for market penetration.

Successfully managed and delivered two system enhancement projects within budget, meeting more than 60% of milestones.

Education & Credentials

Master of Business Administration, International Business Bachelor of Science, Business Administration

Ajou University, Suwon, South Korea Madonna University, Ihiala, AN Microsoft Certified Azure Fundamentals AWS Certified Solutions Architect

Microsoft Certified Azure Administrator Associate OCA (Oracle Certified Associate)

Contact this candidate