Alex Omoko
Pittsburg,CA
Summary
- Multi-talented Database Administrator with 9 years of expertise in designing, testing and coding database solutions in various environments. Highly skilled in multiple technologies such as SQL and MySQL. Motivated self-starter consistently meets deadlines and succeeds in high-pressure environments.
- Tech-savvy professional with advanced training and experience in DBA. Delivers above-average results to delight customers and drive internal enhancements. Always seeking new and improved strategies to achieve objectives.'
- Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
- Hardworking employee with customer service, multitasking and time management abilities. Devoted to giving every customer a positive and memorable experience.
- Organized and motivated employee eager to apply time management and organizational skills in various environments. Seeking entry-level opportunities to expand skills while facilitating company growth.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Database Administrator
Tessera Data
01.2019 - 11.2023
- Created new tablespaces for applications to store their data in the database.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Performed daily backups of the databases using RMAN utility.
- Monitored performance of queries and tuned them as needed using Explain Plan tool.
- Implemented data replication between two different databases using DataGuard feature of Oracle Database Server.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Resolved customer queries related to database issues promptly and accurately.
- Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Provided technical support for developers by creating views and indexes as per their requirements.
- Installed, configured, and maintained Oracle 11g and 12c databases on Linux servers.
- Developed and implemented database security measures to ensure data protection.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Coordinated with other teams such as network administrators and system admins for resolving complex issues.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Conducted training sessions for junior DBAs regarding best practices related to database administration.
- Participated in capacity planning initiatives to forecast future resource needs based on current trends.
- Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
- Provided support for complex issues related to software tools, applications and databases.
- Analyzed and developed technical and functional specifications for databases.
- Migrated existing databases from one platform to another with minimal downtime.
Database Administrator
Data2Logistics
San Jose, CA
08.2016 - 12.2018
- Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
- Defined synchronization plan for patch management.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Performed quality assurance processes to support data warehouse improvements.
- Developed strategies to assess applications designed to client standards while eliminating security risks.
- Supported planning for software development and purchases and coordinated implementation.
- Coordinated security compliance and audit preparation with cyber security team.
- Partnered with project management teams on development of scope and timelines.
- Communicated with data architects, programmers and engineers to keep projects on track.
- Developed and implemented security initiatives to protect important company data.
- Solved complex analytical problems using statistical models from data.
- Consulted with internal departments to identify customer needs to include in project objectives.
- Wrote scripts and processes for data integration and bug fixes.
Power BI Developer
Landslide business consulting
Antioch, CA
03.2011 - 01.2016
- Developed and implemented database security measures to ensure data protection.
- Installed, configured, and maintained Oracle 11g and 12c databases on Linux servers.
- Created new tablespaces for applications to store their data in the database.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Created data verification and testing methods to resolve technical issues and prevent glitches.
- Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Performed quality assurance processes to support data warehouse improvements.
- Developed strategies to assess applications designed to client standards while eliminating security risks.
- Supported planning for software development and purchases and coordinated implementation.
- Coordinated security compliance and audit preparation with cyber security team.
- Participated in evaluation, design and implementation of new and major enhancements of business applications.
- Partnered with project management teams on development of scope and timelines.
Data Analyst
Slot Systems
Ikoyi, Lagos State, Nigeria
05.2010 - 06.2011
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Developed dashboards with Tableau to monitor key performance indicators.
- Created predictive models to forecast customer behavior.
- Provided data-driven solutions to support decision making.
- Gathered requirements from stakeholders to design data models and reports.
- Leveraged SQL queries to extract, transform and load data into databases.
- Translated raw data into meaningful information using statistical techniques.
- Conducted exploratory analysis of complex datasets using Python libraries such as NumPy and Pandas.
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Optimized existing database structures for better performance on analytics tasks.
- Implemented machine learning algorithms like Linear Regression, Logistic Regression and Random Forest for classification and prediction purposes.
Power BI Analyst
Tekmok Consulting
Lagos, Lagos State
01.2008 - 12.2009
- Developed strategies to optimize operational efficiency and reduce costs.
- Identified opportunities for process improvements across the organization.
- Analyzed large datasets using statistical methods and software programs.
- Provided recommendations based on data analysis results.
- Performed cost-benefit analysis to evaluate project feasibility.
- Developed financial models to analyze data and identify potential risks.
- Conducted market research to identify trends and customer needs.
- Created reports, presentations, and other documentation for stakeholders.
- Monitored industry news to stay informed of new developments in the field.
- Prepared forecasts of future performance based on historical trends.
- Gathered requirements from stakeholders to inform system design decisions.
- Designed test plans to ensure quality assurance standards were met.
- Collaborated with cross-functional teams on projects related to analytics initiatives.
Education
Bachelor of Science - Counseling Psychology
Delta State University
Abraka, Nigeria06-2008
Skills
- Disaster Recovery
- Writing Queries
- Database Development
- Continuous Process Improvement
- Data Testing
- Microsoft PowerShell
- Information Systems Management
- Database Analysis
- Data Conversion and Migration
- Microsoft SQL
- Database Management
- Compiling Data
- Data Migration
- Database Administration
- Data Modeling
- Presentations
Languages
English
Professional
Nigeria Pidgin
Professional
Certification
- MCSA Microsoft Certified
- PL-300 Certified
- Azure Data Engineering
Accomplishments
- Best Employee Of The Month (Tessera Data - 2021)
- Customer Service Award ( Data2Logistics - 2019)
References
References available upon request.
Timeline
Database Administrator
Tessera Data
01.2019 - 11.2023
Database Administrator
Data2Logistics
08.2016 - 12.2018
Power BI Developer
Landslide business consulting
03.2011 - 01.2016
Data Analyst
Slot Systems
05.2010 - 06.2011
Power BI Analyst
Tekmok Consulting
01.2008 - 12.2009
Bachelor of Science - Counseling Psychology
Delta State University
- MCSA Microsoft Certified
- PL-300 Certified
- Azure Data Engineering
Similar Profiles
Michail ChamourikosMichail Chamourikos
Retail Sales Executive at Tessera Mens' WorldRetail Sales Executive at Tessera Mens' World
Marios PolyzoidisMarios Polyzoidis
Waiter at Tessera CafeWaiter at Tessera Cafe
RIA GUHARIA GUHA
Research Associate II at Tessera TherapeuticsResearch Associate II at Tessera Therapeutics