Data Engineer
Resume:
Raheem Audu
Cell: 551-***-****
Email: *********@*****.***
Career objective
A Database Administrator with a proven functional and technical experience and knowledge in implementing and supporting Relational Database Management Systems. I would like to be part of a dynamic environment where people collaborate, innovate, build enduring relationships, excel, and grow professionally in a strong culture of ownership.
Summary
11 years of Collaborating with Experienced Designers, Engineers, and other product teams in an agile development environment to design and deliver great products to customers.
Worked directly with product development teams to design and build scalable, highly.
Hands-on experience with Oracle Database, Autonomous Database, Exadata, Database Migration tools like RMAN, DataPump.
Monitoring existing databases to identify performance issues, and give application teams guidance and oversight to remediate performance issues.
Designed and built best-in-class database solutions for enterprise workloads on OCI.
Lead functional and technical team members across Solution Designs, Integration and Data Migrations.
Spotting strategies, risks and options, and then recommended approaches that sidestep problems and help clients and functions meet their needs.
Building Automation and tools that speed up technical discovery and implementation of workloads.
Setting up, documenting and testing Oracle systems; understanding and applying Oracle methodologies.
Took initiative on documenting not only your own code, but updating and maintaining documentation throughout the code-base to optimize for readability and understanding for any current and future contributors.
Worked closely with AWS Platform Service Engineering and Architecture teams to help ensure the success of project consulting engagements with customer.
Analyzed on-premises database environments such as Oracle, SQL*Server, or other Commercial DB Engines to Open Source Engines like Aurora-PostgreSQL/MySQL or RedShift, DynamoDB.
Working on Integration Strategies for cloud integration and on prem integration.
Coordinating and managing cross-functional solution dependencies across all HCM modules (Core HR, Talent, Performance Compensation, Absence, Benefits, Recruiting, Learn, and Reporting and Analytics).
Managed solutions for HCM module (Design and scope functional solutions, contribute to requirements gathering and documentation, define testing strategy, and coordinating testing activities with development team and stakeholders).
Contributed to defining project scope, goals, success criteria, and deliverables that support business objectives/drivers in collaboration with project sponsor and stakeholders.
Implementing and supporting leading edge analytical solutions on Hadoop Clusters On-Prem and/or in GCP.
Consulting for data/document migrations, product development and systems integration.
Hands on experience migrating data over from various databases/systems via SQL, PL/SQL, and/or XML.
Experienced on continuous integration tools like Jenkins and Version control systems like SVN, GIT Good Scripting skills and proficient in at least couple of them Bash, JavaScript, Perl.
Hands on experience with automation and configuration management technologies such as Ansible, Puppet or Chef Deep knowledge of DB performance/scaling concepts and tuning best practices.
Backup and recovery of databases (RDBMS/NoSQL) for production and non-production environments.
Great understanding of metadata management, data modeling, and related tools.
Developing and expansion of existing Data Architecture.
Experience with data integration, data injection, data pipeline, data validation, or data mining.
Helping to design and build data pipelines, streams, reporting tools, data generators and a whole range of tools to provide information and insight.
Involved in implementation of high availability solutions with 9i, 10g, 11g and 12c RAC, disaster recovery infrastructure (Physical and Logical Standby) using Oracle Active Data Guard, Materialized views, Golden Gate.
Establish performance tuning and analysis as well as best practices for the different Oracle environments residing on Exadata Linux systems, RAC environments, as well as consolidated environments running multiple database applications against the same Exadata system.
Experience with setup and administration of Oracle Database Security environment using Profiles, database Privileges and Roles.
Experience with geo-redundant database deployments (active/active, active/standby, etc.)
Solid Linux fundamentals including kernel and OS tuning, as they relate to DB performance and security.
Great understanding on Postgres upgrades, backup/recovery, patching strategies/capabilities and day to day support of application development personnel.
Experience in writing, debugging, maintaining and tuning Transaction SQL, and stored procedures.
Performing analysis on Exadata’s/Oracle’s CPU, Memory, storage and I/O with regards to how our app (GEO) uses the db and recommend sizing(to db or our app) to optimize performance in all 3 releases as stated in item 1.
Troubleshooting areas for possible bugs or knowledge of known bugs in Exadata and work with Oracle Support / Design to have those fixed and applied within 30 days to Exadata from the time the issue is acknowledged by Oracle as a bug.
Interrupting alert logs and the error messages generated by the Oracle systems.
Generating and interrupting Oracle performance metrics to provide evidence on the DBs performance and stress points.
Responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms.
Familiar with Linux operating system and shell scripting skills.
Developed relationships with customers, comprehend and fulfill their needs, and maintain their satisfaction through regular communication and engagement with their environments.
In-depth knowledge of Cassandra databases architecture and internals.
Analyses, tests and implements physical Database design to support and install Cassandra clusters.
Collaborating with business partners, technical partners, and representatives from other groups to understand and evaluate their requirements regarding data integration, gap analysis, and ensure their needs are met in a timely fashion.
Analyzing system logs and identifying potential issues with computer systems.
Enabled DevOps development activities and complex development tasks that will involve working with tools such as Docker, Kafka and container management systems.
Design, configure, implement and support an automated workflow for cloud and virtual environment provisioning.
Strong understanding of Postgres performance tuning (partitioning, striping, OLAP, data warehouses, data marts and other advanced physical data modeling techniques).
Performed unit testing prior to moving code/configuration to the QA process.
Performed database administration activities in a safe, recoverable and professional manner that ensures optimal operation of all database environments.
Experience using Infrastructure as Code (IAC) tools such as Ansible, Terraform, etc. to automate system configurations and updates that can land in various target locations.
Areas of Expertise
High Availability Solutions (9)
Oracle Installation and Configuration(9+)
Golden Gate (6)
Data Modeling (8)
Disaster Recovery (9+)
Exadata (6)
Data Guard (6)
Kafka (3)
Apache Hadoop(2)
Microsoft Azure (4)
Cloud Architecture
Performance Tuning (9)
Data Migration (6)
Backup and Recovery (9+)
Database Security (8)
PL/SQL (5)
Postgres (3+)
AWS (4+)
Mongo DB (3)
Replication, log Shipping and Mirroring (7)
Ansible
Education
Bachelors Degree – Ahmadu Bello University (2008)
Certifications
AWS Solutions Architect
Microsoft Azure Architect Technologies
Oracle Cloud Infrastructure 2020 Certified Associate
Technical Skills:
Operating System: Red Hat Linux, Windows 2003/2008 Server, VMware Server
Languages: SQL, PL/SQL, UNIX Shell Script, HTML
Database: Oracle RDBMS 10g, 11gR2 and 12c Postgres 9.3, 9.4 MS SQL MongoDB 3.0 and 3.2,
Tools/ Software: TOAD, SQL Developer, SQL*Plus, SQL*Loader, Oracle Enterprise Manager (OEM), DBCA, Apache Kafka, Data Pump, RMAN, SFTP, Telnet, TCP/IP, Secure CRT, putty, Terraform, Oracle Scheduler, Unix Shell Scripting, Visual Studio, Azure DevOps source control, Microsoft Word, Excel, and Power Point, SNOW, Hadoop.
Professional Experience
Accenture - Atlanta, GA Nov 2018 – Present
Senior Database Architect
Designing and testing of any changes to existing global system so that it adheres to our existing practices, procedures, and standards.
Designing, creating, and delivering routine to moderately complex program specifications for code development and support on multiple projects/issues with a wide understanding of the application / database to better align interactions and technologies.
Working directly with the ERP Configuration Group team to guide and architect vertical solutions.
Working closely with the Implementation team and communicating risks and/or roadblocks regarding assigned projects appropriately.
Working directly with product development teams to design and build scalable, highly available, and high performing SaaS and PaaS infrastructures.
Defining and documenting system architectures, systems configurations, and technical operational processes and policies.
Troubleshooting and document issues with applications, technologies, and infrastructure.
Working closely with AWS Platform Service Engineering and Architecture teams to help ensure the success of project consulting engagements with customer.
Developing basic to moderate complex code using front and / or back end programming languages within multiple platforms as needed in collaboration with business and technology teams for internal and external client software solutions.
Ensuring that procedures and infrastructure details are properly documented and shared among the team.
Interacting with users continuously to address their issues and search for the optimum usage pattern to propagate.
Writing and maintaining Unix/Linux shell scripts Identify Root cause analysis of production-related database issues.
Collaborating with engineering teams for solution On regular basis analyze the queries executed across environments, discover bottleneck queries, and propose optimizations.
Solving issues, performance tuning, security remediation/patch management, Upkeep of the platforms.
Analyzing on-premises database environments such as Oracle, SQL*Server, or other Commercial DB Engines to Open Source Engines like Aurora-PostgreSQL/MySQL or RedShift, DynamoDB.
Deploying/implementing new instances of our financial product (Customer facing Analytical platform) in the cloud through cloud formation templates and/or on-prem setup.
Ensuring that every cluster and services are always available without performance issues, using monitoring and alerting tools.
Assisting with determining data migration requirements and security controls.
Defining roles and responsibilities for the data migration activities using a data migration checklist and sign-off process to ensure completion of planned activities.
Performing Tuning in terms of system architecture, scalability, understanding symptoms and problems and knowing when to tune.
Troubleshooting and resolving customer issues related to DB systems availability and performance.
Collaborating with Experienced Designers, Engineers, and other product teams in an agile development environment to design and deliver great products to our customers.
Analyzing, modifying, and developing moderately complex code/unit testing in order to develop concise application documentation. Performs testing and validation requirements for moderately complex code changes.
Giving colleagues and clients the tools to find and use data for routine and non-routine analysis.
Building blocks for transforming enterprise data solutions.
Designing and building modern data pipelines, data streams, and data service Application Programming Interfaces (APIs).
Providing support to leadership for the design, development and enforcement of business / infrastructure application standards to include associated controls, procedures and monitoring to ensure compliance and accuracy of data.
Crafting architectures, data warehouses and databases that support access and Advanced Analytics, and bring them to life through modern visualization tools.
Implementing effective metrics and monitoring.
Implementing large-scale data ecosystems including data management, governance and the integration of structured and unstructured data to generate insights leveraging cloud-based platforms.
Reviewing database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
Installing and configuring connection pooling tools like PgPool and PgBouncer etc.
Installing and configuring the High Availability in Postgres SQL like Streaming replication, Host standby, warm standby. Maintenance of PostgreSQL master-slave clusters utilizing streaming replication Installing and configuring the PostgreSQL Monitoring tools like PEM and AppD.
Online Migration of Oracle Database to the PostgreSQL database using replication tools.
Working with data transformation teams to ensure that the model design and development is properly communicated.
Investigating issues to provide a detailed analysis of your findings in a digestible format by email, instant message or voice.
Configuring log analyized tools like pgFouine and pgBadger etc.
Contributing to requirements specifications for new and enhanced product features to ensure Operations requirements are captured and satisfied.
Developing and expansion of existing Data Architecture.
Translating business needs into data models supporting long-term solutions.
Cloning of databases using RMAN and using latest RMAN features.
Developed procedures to enhance reporting and query capabilities to improve efficiency and accuracy.
Coordinated various efforts in maintaining a vast environment of over 70 databases.
Successfully migrated databases from 9i-10g, 10g-11g, and 11g -12c.
Developing conceptual, logical, and physical data modeling.
Performing tuning of SQL's and procedures. This involved using trace dumps, TKPROF, Stats pack, Net Trace and also used specific Oracle performance parameters on a selected basis.
Xtivia Inc. – Colorado Springs, CO Oct, 2016 – Nov, 2018
Senior Database Lead
Responsible for database architectures, engineering, and administration of all Oracle platforms including the installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
Performed tuning and query optimization using PL/SQL.
Responsible for the enterprise-wide administration of the MariaDB, Oracle RAC and PostgreSQL.
Participated in the design and testing of any changes to existing global system so that it adheres to our existing practices, procedures, and standards.
Worked with business sponsors to coordinate user acceptance testing, conduct application overviews, conduct ‘train the trainer’ sessions.
Administered database security across all database environments.
End-to-end performance tuning of MariaDB, Oracle and PostgreSQL against very large data sets.
Working with engineers who build and support containerized database orchestration platform, Megabase, which hosts MySQL, Postgres, and Redis systems for internal teams.
Helped built automation to migrate database platform to AWS and provide consulting to teams that are migrating workloads to AWS.
Installed and integrate Samba server with AWS instance.
Backup and recovery of databases (RDBMS/NoSQL) for production and non-production environments.
Lead in creating a clear vision for the future Solve production problems and participate in a 24x7 on-call rotation.
Built and Deployed schema changes to production and non-production.
Writing and maintaining Unix/Linux shell scripts Identify Root cause analysis of production-related database issues, collaborate with engineering teams for solution on regular basis.
Responsible for leading the architecture and setup of an AWS hosted Data Lake as well as the ingestion pipeline and processing for 100+ datasets, working closely with Agile software development team(s).
Created and managed schedules for data management (migration, integration, etc.) efforts, working with clients to validate migrated data, working with Agile development teams to understand changes and their impacts towards data migration efforts, among other tasks.
Writing, modifying, troubleshooting and enhancing complex Unix shell scripts and Oracle PL/SQL.
Evaluated why certain QEP’s are chosen and deep knowledge of optimizing the sql that makes up those QEP’s.
Troubleshoot and resolved customer issues related to DB systems availability and performance.
Aware of business issues as they impact overall project plans.
Worked with data transformation teams to ensure that the model design and development is properly communicated.
Developed conceptual, logical, and physical data modeling.
Managed various database structures: Table spaces, data files, control files, redo log and archive log files using OEM, GUI tools and command-line.
Developed relationships with customers, comprehend and fulfill their needs, and maintain their satisfaction through regular communication and engagement with their environments.
Developed procedures to enhance reporting and query capabilities to improve efficiency and accuracy.
Maintained a state-of-the-art knowledge of existing best practices in database administration.
Involved in 24/7 support for both production and development databases including 2-node production RAC database.
Conceptualized and provided Cassandra database solutions based on client requirements.
Responsible for complex database performance tuning, security, database backup/recovery strategy, and implementing monitoring procedures to maximize availability of the Exadata system including any databases.
Translated business needs into data models supporting long-term solutions
Implementation of high availability solutions with 9i, 10g, 11g and 12c RAC, disaster recovery infrastructure (Physical and Logical Standby) using Oracle Active Data Guard, Materialized views, Golden Gate. The projects involve replication across geographical time zones.
Installed, upgraded and patch Oracle databases in PROD to TEST and DEV environments.
Established performance tuning and analysis as well as best practices for the different Oracle environments residing on Exadata Linux systems, RAC environments, as well as consolidated environments running multiple database applications against the same Exadata system.
Configured and implemented Oracle Goldengate replication.
Assisted with data transformation, data load testing, validity of the values of the data elements, and validating data relationships.
Assisted with determining data migration requirements and security controls.
Resolved the issues in conflict with the target and source database in Goldengate.
Experienced using OEM for performance tuning in 12c.
Coordinated data models, dictionaries, and other database documentation across multiple applications.
Ensured data integrity including entity, referential integrity, check constraints and database triggers.
Designed database schemas to align with development and business goals and objectives.
Diagnosed and resolved performance issues associated with SQL tuning and resource contention including locks and deadlocks.
Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
Performed software upgrades and patches of Cassandra and plans the installation and configuration.
Provided daily Cassandra database technical administration and support, including processing change management requests, monitoring, performance tuning and database cloning.
Designed a high-performing database by creating multiplex control files, mirroring redo logs using redo log groups and configuring table spaces
Extensively used ILM tool for data masking.
Performed hot, cold backups and setup/utilize RMAN for backup and recovery
Created user accounts and granted them appropriate roles and disk quotas for production usage
Managed various users’ sessions both in UNIX and WINDOWS environments.
Planned, tested and performed Database backup and recovery plan and upgrade from Oracle Database 11.2.0.4 to 12.1.0.2
Setup jobs; create packages, triggers, functions and notification alerts
Performed daily administration task including managing system security, data integrity, monitoring and deployment of objects in production
Experienced in using database features such as Data pump, Flash-Back, AWR, ADDM, ASM
Installed Oracle Software/Grid Infrastructure on UNIX and Windows platforms
Patch oracle databases with the latest Patch Security Updates (PSUs)
Citizens Bank – Providence, RI March, 2013 – Oct, 2016
Senior Infrastructure Engineer
Troubleshoot and resolved complex issue for all supported services non-hosted environment.
Provided expertise on platform engineering, while overseeing the team's effort and meeting customer needs. Uses technical knowledge and industry experience to design, build and maintain technology solutions.
Developed software components and hardware for complex projects; aligns these with business strategies and objectives.
Provided expertise on best practices, standards, engineering approaches and complex technical resolutions for processes.
Placed emphasis on quality improvement efforts; ensures that deliverables are secure, scalable and reliable through estimation and correction.
Responded to Incident Management to identify root causes and strategic solutions to recurring problems.
Developed relationships and periodically meet with IT Operations, R&D, Enterprise Software and Business users to gain insight on requirements, needs and experience.
Ensured the highest levels of systems and infrastructure availability.
Took responsibility for the documentation and execution of large-scale projects, actively participating in all phases of the project. Identifies, assesses and manages risks to the success of the project.
Managed different databases through multiple product lifecycle environments, from development to mission-critical production systems.
Prepared system documentation.
Advised systems engineers on database coding issues.
Developed procedures to enhance reporting and query capabilities to improve efficiency and accuracy.
Implemented, refined, and evolving tools and processes to maintain 5 nines availability for 24 7 cloud-based SaaS solutions.
Investigating issues to provide a detailed analysis of your findings in a digestible format by email, instant message or voice.
Deployed and managed Mongo DB databases in Linux environment.
Provided guidance on service-oriented architectures, application frameworks, system integration methods, Enterprise Data Business and Technical Metadata Management.
Executed utility requirements such as reorganization, back-up and recovery.
Analyzed and resolved database system production problems.
Managed and Implemented Oracle Data Guard for Logical standby and Physical standby databases.
Configured and monitored daily backup processes.
Managed Database security using Oracle Internet Directory OID.
Planned and executed both data and data migration.
Created tickets, prioritized and escalated issues using Remedy Connector based on SLAs.
Reading Alert Log and User trace Files and Diagnosing the Problem.
Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
Provided first and second level software and hardware support to end-users and at client sites
Running complex queries to retrieve data from multiple tables within Oracle ensuring fast and secure access to business application.
Automated DBA task utilizing SQL and UNIX shell.
Analyzed user requirements and statistics, and participates in database design and performance evaluation reviews.
Reviewed and Applyed Database software patches.
Managed storage requirement for database-related components – capacity planning
Installed/re-installed Windows and Linux Server
Participated and supported Oracle Server installations both upgrades and standalone installations.
Built Dynamic SQL in stored procedures
Manage customer databases to ensure data integrity and accuracy
Provided Tier 3 customer support resolving database issues
Designed ETL processes for data migration of new acquisitions
Managed SQL Servers (Rackspace) and monitor databases for proper performance, Manage storage for applications, database security, and report incidents
Familly Dollar - Charlotte. NC Jan, 2011 – March 2013
Database Engineer
Managed different databases through multiple product lifecycle environments, from development to mission-critical production systems.
Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Applied data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Refined and automated regular processes, track issues, and document changes.
Assisted developers with complex query tuning and schema refinement.
Provided support for critical production systems.
Performed scheduled maintenance and support release deployment activities after hours if required.
Redesigned current SQL database tables, designing a new Oracle Database environment, and moving the data from SQL to Oracle.
Worked with key stakeholders to gather reports requirements.
Utilized SQL to create queries.
Interpreted data and analyzing results using statistical techniques and provide ongoing reports.
I was responsible for database monitoring and applying resolutions to database issues.
Worked with team members to standardize templates, report publishing, and report delivery.
Conducted SQL Server production database analysis on a regular basis.
Designed, installed, upgraded monitors, maintained, and conducted performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.
Developed data scripts, troubleshoot code and assist developers with performance tuning.
Provided customer assistance and support pertaining to database system queries and complaints.
Provided guidance on service oriented architectures, application frameworks, system integration methods, Enterprise Data Business and Technical Metadata Management.
Synthesized complex data sets into actionable insights and builds analytics stories that culminate in accurate business decisions.
Built Operational Data Stores (ODS), Data Marts.
Partnered with a cross-functional team of technical and analytical partners.
Worked on cutting edge data science and analytics problems to help solve real world challenges.
FEDEX – Duluth. GA Feb, 2010 – Jan, 2011
IT Systems Engineer
Implemented, managed, and maintained Windows-based infrastructure solutions, deployments, and upgrades. Troubleshoot technical issues across multiple data centers.
Installed, configured, administered, managed, and supported (including, but not limited to) Office 365 applications, on premise Active Directory and Azure cloud instances, Group Policy, DHCP, FTP, SMTP, and DNS.
Patched and managed VMware ESXi, Microsoft Server OS, backup and storage technologies.
Participated in a team on-call rotation for technical infrastructure escalation and resolution.
Configured and managed virtualization technologies including VMware ESXi 7.0, 6.x, etc.
Implemented and managed vulnerability scanning, patching, and remediation solutions within an enterprise system.
Responsible for system backups, restore, recovery, DR and high availability strategies for the cloud and on-premise environments.
Maintained system performance by performing system monitoring and analysis, and performance tuning; troubleshooting system hardware, software, networks, and operating system.
Troubleshoot hardware and software issues as they arise. Staying familiar with new versions of applications and technology used in the environment.
Assisted in the preparation of regularly scheduled reports.
Developed and maintained a filing system.
Organized and scheduling meetings and appointments.
Developed administrative staff by providing information, educational opportunities and experiential growth opportunities.
Contributed to team effort by accomplishing related results as needed.
Maintained computer and manual filing systems.
Conducted SQL Server production database analysis on a regular basis.
Performed troubleshooting for LAN problems for individual client basic software.
Provided customer assistance and support pertaining to database system queries and complaints.
Installed, administered and updated Oracle database tools and systems.
Implemented corrective plans of action for network performance issues, including utilization, availability and latency.
Evaluated latest technology innovations and adopted cost-effective, useful solutions.
Monitored use of data files and regulated access to protect secure information.
Established network specifications and analyzed workflow, access, information and security requirements.
Modified current databases to meet specific needs and goals established during initial evaluation and planning process.
Lend technical assistance to project team members and database administrators.
Performed
Contact this candidate