Sr. Oracle DBA at Dedalus (2021-01 – Present)
I currently supporting my team in DBA on an as-needed basis for Egypt and South Africa client. Most recently, this has meant reviewing a new Oracle 11G,12c and 19c setups on servers using RAC with 12c administration management. From outside the day-to-day support, I can make objective recommendations and review current monitoring profiles.
- review of ADDM and AWR reports for performance tuning information.
- understanding end-user performance hot spots and digging through database internal views to understand where stored code problems exist and how to resolve them.
- reviewing new 19c grid monitoring profiles and adjusting as required
- review the Grid, ASM and Oracle OFA directory structures to ensure configuration is well laid out and logging and other output directories are captured in regular monitoring for gripes and possible errors.
- pro-active reviews of RMAN backups and review of backups policies
- My direct work involved upgrades, patching and other Oracle maintenance as well as regular development to test and production software deployments, 24x7 troubleshooting for live problems.
- I provide my support to Data Centre technical and DBA team under Egypt Project manager. I am in an amazing team. We managed many systems 24x7 for Oracle Corporation that included the 'bugs' and knowledge base databases used for overall technical support as well as providing 24x7 support for the Ministry of Health and Population-Egypt.
- assisting in Hardware specification as needed.
- Support as required for any database queries.
Sr. Oracle DBA, Team lead at DXC technologies (2016-01 – 2021-12)
Managed, coordinated, and defined the scope of daily activities for the transition projects for business support of the health care application across Gauteng and Limpopo province. In the Support lead role, introduced performance and efficiency changes to the 'HIS' system that increased the system availability and reduced the system failure by 90%
- Managed the overall infrastructure event program for the
- Participating in user and developer meetings for enhancements of the application.
- Conducting regular technical meetings for optimizing the performance of application by suggesting various SQL tuning options.
- Regular monitor of database for badly written adhoc queries
- running on the database using Spotlight for Oracle, SQL Lab Expert of Quest.
- We worked closely with systems and network administrators as well as various development teams and business leaders within the organization.
- Managed team of 4 personnel focused on implementing resolutions and updates.
- Trained junior members of IT team regarding Database/client and network security and troubleshooting of application issues.
- Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
Data Base Specialist at CSC technologies (2014-01 – 2016-12)
- Install and configure Oracle 11g RAC databases with ASM on V BLOCK servers.
- Database Backup/Recovery Policy and Disaster Recovery Result in business continuity
- Utilizing physical standby database server for daily database backups.
- Implementing Oracle 11g RAC with 2 nodes for a 1TB database. Setting up Test, QA and Production instances with 2 and 4 nodes (prod).
- Performing stress test and performance test in RAC environment. Performing Fault Injection Testing for RAC in pre-production RAC environment on servers.
- Installation and configuration WebLogic servers for application and Oracle 11g forms and reports.
- Designing and implementing security policies in database environment.
- Resolved On Call issues including Monitoring, Ticket resolution and Work/ Change requests.
- Regular monitor of database for badly written adhoc queries running on the database using Spotlight for Oracle, SQL Lab Expert of Quest.
Senior Database Administrator at iSOFT Health (2007-01 – 2014-12)
- Installation and Configuration Oracle 9i/10g of application in different areas like Testing, Training, QA and Production.
- Worked along with Linux admin and provide the complete file structures for Oracle files and Backups and Recovery.
- Server Maintenance Activities like modifying database storage structures, Space and User management.
- Worked in Oracle Replication issues and ongoing DBA Operations management with DB ranging in size of 20 GB to 80 GB
- Advanced Backup and Recovery using Oracles RMAN software; used offline/online for recovery in a production environment via shell scripting.
- Performance Tuning, Monitoring Statistics and Database sizing estimation.
- Participating in User, Developer, and Management meetings for enhancements of the application and suggesting the new technologies.
- Support for Application Team Performed periodic restore & recovery test using standby database backup.
- maintained custom changes for the new Oracle Financials applications.
- Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
- I also wrote and supported some key pieces of the SQL and PL/SQL code that monitored and collected statistics on our various environments as well as reports that we produced and provided to customers.
Database Administrator at FUTURE TECH (2006-01 – 2007-12)
- Installation, Creation, and support of Oracle 9i database environments test, training, and Production.
- SQL scripts to monitor and to get information on free space, Extents, Tablespaces, Tables, and Indexes
- Taking hot/cold backups and recovering the database during Crash/Emergencies. Performing Complete/Incomplete Recoveries
Oracle DBA Consultant at Ministry of Health (2005-01 – 2006-12)
I worked as a second DBA to their long-standing DBA contractor. I worked with their 9i databases that used Oracle Names server. We reviewed performance and assisted users in their database needs and troubleshooting.
- Maintaining Logical and Physical structure of the database.
- Implemented SQL scripts to monitor and to get information on free space, Extents, Table spaces, Tables, and Indexes
- Create and cloning the test Databases.
- Taking hot/cold backups and recovering the database during Crash/Emergencies. Performing Complete/Incomplete Recoveries.
