Experience

Palo Verde College
• Higher Education
• 1 - 100 Employee
• Operational Reporting Systems Manager/ SQL Server Database Administrator

  • Jul 2023 - Present


Aegis Mortgage

• Financial Services
• 1 - 100 Employee

• Oracle Database Administrator / SQL Server Database Administrator

  • Aug 2020 - Jul 2023

  Tools & Technologies: Oracle, Linux, Oracle Enterprise Manager, RMAN, UNIX, Perl I lead the implementation of Oracle ASM 12c software, partitioning disks in Linux and building a multitenant RAC database with two-node cluster and ASM storage. Configuring, integrating, maintaining, and upgrading all development, staging, and production databases, I manage user and space allocations and monitor performance. I also diagnose and resolve performance and capacity issues and use ETL to load and extract data from source systems 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. Show less



HEALTH AND HUMAN SERVICES AGENCY

• United States
• 1 - 100 Employee

• Oracle DBA / AWS Solution Architect & Business Analyst

  • Jul 2019 - Jul 2020

  Tools & Technologies: Tableau, R, STATA, Microsoft Excel, Python, CRM, Terraform, Lambda, Account Factory, Clout Endure, Docker, SNS, CloudWatch, MS Project I design, develop, and implement fault-tolerant, highly available infrastructures using Terraform following specifications for Cloud application deployment. Implementing IAM best practices and role-based access control, I ensure business continuity and effective disaster recovery. I also develop serverless architecture integrating SNS, CloudWatch, and other AWS services, and I facilitate stakeholder meetings from initial project charters through the planning and execution phases. Successfully managing a wide variety of projects for clients across diverse industries (education, publishing, real estate, law), I evaluate and upgrade preselected solutions and develop Project Execution Plans for proposed office campus expansions, new school builds, and housing community development with budgets ranging from $165M to $530M. • 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 managed and delivered two system enhancement projects within budget, reaching more than 60% of milestones. Show less



Paychex

• United States
• Human Resources Services
• 700 & Above Employee

• Oracle Database Administrator/AWS Cloud Solutions Architect

  • Aug 2017 - Jul 2019

  Tools & Technologies: Oracle Enterprise Manager (OEM), SQL, AWR, ADDM, Oracle 11g/10g, STATSPACK, SQL Track, TKPROF, Explain Plan, Golden Gate, Ansible, Artifactory, Docker, GitHub, Jenkins, Kubernetes, Maven, Sonar Qube. I managed and monitored database operations and application servers, loading data from flat files and organizing databases, schemas, and tables. Using import/export utilities, I cloned and migrated small-sized databases and moved data between 10g and 10g/11g environments. I conducted troubleshooting and performance tuning for Golden Gate, and I prepared weekly performance reports. I also created, maintained, and evolved AWS cloud infrastructure for running applications, managing continuous integration and deployment (CI/CD) methodology for server-based technologies. I 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. • Collaborated with architecture and engineering teams to design and implement scalable software services, ensuring best-in-class system security. • 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 Show less



Capital One

• Egypt
• Leasing Non-residential Real Estate
• 1 - 100 Employee

• Oracle Database Administrator

  • Jul 2015 - Jul 2017

  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 data base with 2 node cluster and instances using ASM storage. • Responsible for all backup, recovery, and upgrading of all the Oracle databases. • Worked on to take 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 CDB for HA Show less



LJ Power Generation

• South Africa
• Electric Power Generation
• 1 - 100 Employee

• Business Analyst

  • Jan 2013 - Jan 2015

  Tools & Technologies: Python, Tableau, SWOT analysis, Google Analytics, Brainstorming, MS Office: Word, Excel, PowerPoint, Visio, Jira, SQL, Trello Project, Microsoft Project I facilitated stakeholder meetings from project charter development through planning, execution, and monitoring, documenting project risks and lessons learned. I gathered and defined requirements from project stakeholders, developing work breakdown structures and milestones. Using Python to conduct market research, I identified 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. Show less