Peter Adimorah
Hiram
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and Oracle database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements. Team-oriented with strong work ethic.
Overview
10
10
years of professional experience
6
6
Certifications
Work History
Oracle Database Administrator(Golden Gate)
National Consulting Partners (Veteran Affairs )
12.2022 - Current
- Established effective communication channels between IT teams responsible for managing different aspects of Oracle Database infrastructure.
- Streamlined backup processes, ensuring timely recovery in case of data loss or system failure
- Supported building of new system environments and upgrading and patching existing systems.
- Installed, configured, tested and maintained operating systems, application software and system management tools.
- Helped coordinate full system life cycle from requirements to design and implementation.
- Deployed and decommissioned environments for multi or single applications and save company 5%
- Managed and monitored installed systems and infrastructure.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Developed database architectural strategies at modeling, designing and implementation stages to address industry requirements.
- Improved database performance by optimizing SQL queries and implementing indexing strategies.
- Enhanced security measures by implementing data encryption and access controls for sensitive information.
- Reduced downtime by proactively monitoring and addressing potential issues with Oracle Database system.
- Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
- Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
- Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.
- Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
- Planned and installed upgrades of database management system software to enhance database performance.
- Designed data models for complex analysis needs.
- Managed identification, protection and use of data assets.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
- Documented and communicated database schemas using accepted notations.
- Established and secured enterprise-wide data analytics structures.
- Set up and controlled user access levels across databases to protect important data.
- Conducted tests to identify issues and make necessary modifications.
- Implemented security measures to protect vital business data.
- Installed and configured middleware in Linux and Windows environments.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Collaborated with cross-functional teams to ensure seamless integration of Oracle databases with various applications.
- Managed user accounts within Oracle Database environment, granting appropriate permissions while adhering to security protocols.
Oracle DBA
Home Depot
06.2019 - 12.2022
- Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
- Managed Oracle databases, maintaining high levels of performance, availability, and security.
- Provided resources and skill sets to support DBA functions for applications.
- Participated in situation management of incidents to support database operations.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Developed automated processes to manage database creation in virtualized or cloud environment.
- Troubleshot database issues to create and resolve trouble tickets.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Set up and controlled user access levels across databases to protect important data.
- Modified databases to meet needs and goals determined during planning process.
- Reviewed database design to recommend enhancements or improvements.
- Optimized database performance by conducting regular system updates and implementing new features.
- Streamlined database operations for efficient use of resources, applying patches and upgrades when necessary.
- Reduced downtime by proactively monitoring system health and identifying potential problems before they escalated.
- Trained junior DBAs in best practices for Oracle database management, improving overall team performance.
- Developed custom scripts for automating routine tasks, increasing productivity and reducing manual labor.
- Evaluated system needs and recommended appropriate hardware or software upgrades to optimize Oracle database performance.
- Utilized advanced analytical skills to identify trends in data usage patterns and take proactive measures for capacity planning purposes.
- Worked closely with developers to optimize SQL queries for better query performance across various applications utilizing Oracle databases.
Database Administrator
U.S Army Reserve
11.2014 - 11.2022
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
- Developed and updated databases to handle customer data.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Developed scripts and processes for data integration and maintenance.
- Created and updated database designs and data models.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Modified databases to meet needs and goals determined during planning process.
- Conducted tests to identify issues and make necessary modifications.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Set up and controlled user access levels across databases to protect important data.
- Built databases and table structures for web applications.
- Tested programs and databases to identify issues and make necessary modifications.
- Authored and coded database descriptions.
- Coordinated with project management on database development timelines.
- Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Designed and developed analytical data structures.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Created and implemented database designs and data models.
- Implemented BI solution framework for business intelligence projects.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Implemented security measures to protect vital business data.
- Installed and configured middleware in Linux and Windows environments.
Oracle Database Administrator
Wells Fargo & Company
, GA
05.2016 - 04.2019
- Maintained up-to-date documentation on database systems, ensuring accurate records of configurations, processes, and changes made over time.
- Served as subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
- Participated in architectural discussions to build confidence and promote customer success when developing new and migrating existing applications, software and services on AWS platform.
- Responded promptly to user requests for permission changes, new storage and expansion questions.
- Partnered with sales team to design solutions for customers and drive AWS adoption and revenue up 10%
- Performed advanced engineering in configuration, management and deployment of AWS cloud environments.
- Captured and shared best-practice knowledge among AWS community and presented sessions at industry conferences.
- Applied scripting methodologies to automate IT administrative related tasks.
- Conducted deep-dive hands-on training sessions to transfer knowledge to customers considering or already using AWS.
- Authored or contributed to AWS customer-facing whitepapers and tutorials.
- Performed first-level incident response and service resolution for cloud systems.
- Worked as technical leader alongside customers and infrastructure team and contributed to business development.
- Guided other teams to design, develop and deploy data sets and tools that supported product use cases.
- Built databases and table structures for web applications.
- Corrected, modified and upgraded software to improve performance.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Coordinated deployments of new software, feature updates and fixes.
- Designed and developed forward-thinking systems that meet user needs and improve productivity.
- Tested and deployed scalable and highly available software products.
- Analyzed work to generate logic for new systems, procedures and tests.
- Designed and developed analytical data structures.
- Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
- Designed and implemented scalable applications for data extraction and analysis.
- Translated technical concepts and information into terms parties could easily comprehend.
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
- Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
- Optimized dust, temperature and humidity controls for installed systems.
Education
Associate of Science - Information Technology
U.S Army Information Technology Specialist
Master of Science - Accounting And Computer Science
University of Kent
Bachelor of Science - Computer And Information Sciences
University of Lagos
Skills
SQL Server Database
Proficient in T-SQL, stored procedures, and functions
Microsoft Azure
Unix Shell Scripting
MS SQL Server 2000
Terraform
Enhancements and Debugging
SQL Transactional Replications
Teradata Database
Golden Gate
Ansible
NoSQL Databases
Relational Database Management
Cloud Architecture
BI solution framework
Mongo DB
SQL Server Reporting Services
KPI Management
Java
ETL Processes
Capacity Planning
Database Analysis
Database Architecture
Oracle Enterprise Manager
Enterprise Information Architecture
Data Pump
High Availability Solutions
Oracle Installation and Configuration
Extraction Transformation and Loading (ETL)
Oracle PL/SQL
Linux Administration
Database Security Management
Oracle RAC Configuration
Oracle ASM Management
SSIS
Storage Management
Python
Agile Methodology
Network configuration
Performance Tuning
Certification
Microsoft Azure Fundamentals (AZ-900)
Timeline
Oracle Database Administrator(Golden Gate)
National Consulting Partners (Veteran Affairs )
12.2022 - Current
Oracle DBA
Home Depot
06.2019 - 12.2022
Oracle Database Administrator
Wells Fargo & Company
05.2016 - 04.2019
Database Administrator
U.S Army Reserve
11.2014 - 11.2022
Associate of Science - Information Technology
U.S Army Information Technology Specialist
Master of Science - Accounting And Computer Science
University of Kent
Bachelor of Science - Computer And Information Sciences
University of Lagos
Similar Profiles
Jessica CrowderJessica Crowder
Education Technician at Department of Veteran Affairs, National SIMLEARN CenterEducation Technician at Department of Veteran Affairs, National SIMLEARN Center
Mariah JohnsonMariah Johnson
Legal Administrative Specialist at Veteran Affairs VBA NCC ( National Contact Center)Legal Administrative Specialist at Veteran Affairs VBA NCC ( National Contact Center)
MARIANNE GONTAMARIANNE GONTA
Vocational Rehabilitation Counselor at U.S. Department of Veteran Affairs, Veteran Benefits AdministrationVocational Rehabilitation Counselor at U.S. Department of Veteran Affairs, Veteran Benefits Administration
Kaley BrownKaley Brown
Registered Nurse at WellStar Paulding HospitalRegistered Nurse at WellStar Paulding Hospital
Rebecca MasonRebecca Mason
Key Holder/ Acting Store Manager at Party CityKey Holder/ Acting Store Manager at Party City