PRINCE SADEK
Lead Database Engineer
O’Fallon,MO
Summary
Dynamic Lead Database Engineer with 10+ years of experience in building data intensive applications, devoted to maintaining reliable computer systems for uninterrupted workflows. tackling challenging architectural and scalability problems, collecting and sorting data in the Financial Services, Transportation, Government sector and Media Distribution Data warehouse fields
Overview
14
14
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Lead Database Engineer
Mastercard
St Louis, MO
11.2018 - Current
- Solid experience in Oracle (11g/12c/19c ) tuning with extensive experience as a Database Administrator in medium to larger organizations
- Highly proficient in SQL with a solid understanding of database concepts (e.g
- Entity relationship modelling, Object-relational mapping)
- Thorough understanding and significant experience of database backup and recovery, performance monitoring and tuning, data manipulation and migration and advanced replication technologies
- Strong technical knowledge of database architecture, data storage and management principles, with experience using related technologies
- Experience with High Availability architectures, Data recovery RAC environments
- Experience in implementation & support of NoSQL technology (including Cassandra, Postgres, and Mongo)
- Exposure and good experience within the financial services/payments industry environment AR,AP,GL,PO modules(e.g
- Banking, Credit Card Scheme)
- Experience with web technologies and automations (ISG, Cloud, Azure, AWS) and UNIX shell scripting (bash, ksh, and sh)
- Hands on experience with Exadata administration and support
- Strong communication skills both written and verbal coupled with strong problem solving
- Exposure and practice with any or all the following: Remedy, ITIL, Agile, Scrum, and Kanban, Workplace
- Provide project and day to day operational support for Oracle 19c RAC databases running Oracle Applications 11i & R12.1 and R12.2.9 , Database Migrations, and associated tools
- Work with all areas of Oracle Technical Services (OTS), Oracle Support, Divisional IT personnel and other third parties as required
- Database and Application Cloning multiple platforms, patch analysis and deployment
- ADOP cycle expert in performance and tuning
- Communicate to stakeholders via standard methods (e.g
- Orally, email, ticket system), resolve incidents and problems
- Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production
- Follow standard PCI , SOX , auditing related standards
- Develop or refine technical procedures, scripts and associated documentation
- Lead in disaster recovery preparation, planning and testing
- Upgraded Application R12.1.3 to R12.2.9 within 70 hours downtime, on multi-node application infrastructure bare metal
- Patch Management for Oracle and Oracle E-Business Databases CDB and PDB
- Oracle Enterprise Manager (OEM), Weblogic , OHS, OPMN tuning experience
- Strong administrative experience of Oracle Applications and Databases, Apache, Oracle Application Server.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Designed and implemented effective database solutions and models to store and retrieve data.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
Senior Database Administrator
Emerson
St. Louis, MO
06.2015 - 11.2018
- Provide projects and day to day operational support for Oracle RAC databases running Oracle Applications 11i & R12 , Database Migrations, and associated tools
- Work with all areas of Oracle Technical Services (OTS), Oracle Support, Divisional IT personnel and other third parties as required
- Database and Application Cloning multiple platforms, patch analysis and deployment
- Monitoring and problem resolution and database Tuning
- Communicate to stakeholders via standard methods (e.g
- Orally, email, ticket system), resolve incidents and problems
- Communication of same to stakeholders
- Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production
- Develop or refine technical procedures, scripts and associated documentation
- Lead and Assist in disaster recovery preparation, planning and testing
- Oracle Applications R12.2 & R12 and 11i full support and new implementations
- Database Migrations between Heterogeneous Platforms (Big Endian to Little Endian)
- Essential DBA skills including backup/recovery and performance tuning
- Oracle Enterprise Manager (OEM), Data Integration and Oracle Applications
- OBIEE 11g experience and support across multiple projects and business units.
- Strong administrative experience on Oracle application and database
- Set up and controlled user access levels across databases to protect important data.
- Conducted tests to identify issues and make necessary modifications.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Coordinated with project management on database development timelines.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Defined hardware requirements and planning storage capacity to manage systems and infrastructure.
- Led projects and analyzed data to identify opportunities for improvement.
- Completed paperwork, recognizing discrepancies and promptly addressing for resolution.
Oracle Application Database Administrator
Metra Rails
Chicago, IL
04.2014 - 05.2015
- Managed Oracle application production databases on multiple platform such as Linux and Windows
- Installing, configuring and upgrade Oracle software 11g / 12c
- Performed backups and recovery on database management system using RMAN, export and import tools.
- Maintain maximum availability of the databases and response times through monitoring OEM12c
- Extensive experience with Oracle PSU apply in RAC and Non-RAC database environment
- Monitor database performance and space utilization – investigate and resolve reported issues as well as recommend upgrades and security updates.
- Participate in on-call rotation within the Database team in support of clients 24X7 environment US and offshore teams.
- Maintain and troubleshoot Data Guard replication to ensure failover in the event of a disaster, tools includes Golden Gate
- Perform SQL tuning and recommendations as deemed necessary to ensure customer SLAs are met
- Experience with some of the following: WebLogic Suite, SOA Suite, Cloud Management Pack, Storage support Dell EMC
- Experience with Comm Vault Data Storage Software application Management
- Lead Database team in upgrading Middle tier Application environment from i11.5.10 to R12.1.3
- Lead Database team in upgrading our Application Database RAC environment from 11.2.0.1 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2
- Strong knowledge of Oracle E-Business Suite applications architecture, configuration and troubleshooting
- Review 3rd party applications for technical concerns and provide input on application architecture CommVault Support, Linux Support
- Installed 2-8 node Oracle 10/11g & 11gR2 RAC clusters on Red Hat Linux AS 5x/6x using ASM on Dell Power Vault SCSI NAS and other NAS/SAN systems to support internal production and test environments
- Providing reports on database performance variation and solution
- Documentation and review of Standard Operating Procedure (SOP).
- Proposed database changes to ease monitoring and administrative effort.
- Provided resources and skill sets to support DBA functions for applications.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
Oracle Application Database Administrator
AST Corporation
Naperville, IL
04.2013 - 03.2014
- Lead the production database team to support development, validation, and implementation.
- Proactively adjusted schedule of work, priorities, and staff’s assignments based on work load to ensure efficient operations
- Managed Oracle production databases on multiple platform such as Linux and Windows
- Administered and maintained multiple large Oracle OLTP Databases on Different Linux OS and Windows server platforms with data growth up to 4TB in size
- Extensive experience with Oracle Data Guard Replication on Oracle 10g & 11g and 12c environment
- Responsible for standards and design of physical data storage, maintenance, access, and security administration
- Experience in Oracle Enterprise Manager Grid Control implementation and management
- Extensive experience in Oracle upgrade from version10g to version 11g and upgrades to database version12c
- Extensive experience with Oracle database PSU patch installation in RAC and Non-RAC DB environment
- Extensive experience with Oracle database migration and database schema refresh with oracle data pump utility
- Experience with database cloning tools used RMAN utility and regular cold backup methods
- Participate in on-call rotation with database team support in 24X7 environments
- Experience with Oracle Golden Gate management
- Administer daily changes between dev, test, staging and Production Databases while working closely with developers and end users on given projects and systems
- Created and configured Oracle ASM to manage database storage with load balancing
- Help developers in troubleshooting performance issues.
- Proposed database changes to ease monitoring and administrative effort.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Implemented BI solution framework for business intelligence projects.
- Conducted tests to identify issues and make necessary modifications.
- Implemented security measures to protect vital business data.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Assistant Department Manager
Menards
Schaumburg, IL
10.2012 - 03.2013
- Recruits, interviews, and hires team members, conducts performance appraisals, takes discipline action, motivates and training new team members
- Ensures maintenance of equipment, facility, and grounds through the use of a preventative maintenance program
- Ensures complete and timely execution of corporate & local marketing programs
- Provides world class Customer Service by surprising and delighting our customers every day
- Assists Store Manager in managing the store including establishing priorities, following up to, and supervising store associates.
- Arranged sales incentives with store management and vendor representatives to reward deserving team members for exceeding expectations.
- Achieved financial objectives by preparing annual budgets, scheduling expenditures, analyzing variances and initiating corrective actions.
- Worked actively with management team to create daily and weekly sales plans based on weekly sales trends.
- Partnered with merchandising team to plan and execute floor moves, merchandise placement and overall sales set-up.
- Motivated associates to consistently deliver effective selling behaviors through coaching and recognition.
Assistant Logistics Manager
Abu Dhabi Media
Dubai, UAE
02.2008 - 09.2012
- Lead projects in the completion of 80+ medium- to large-scale implementations, managing project from business requirements analysis to solutions delivery and support
- Strong knowledge of Oracle Application architecture, configuration and troubleshooting
- Providing reports for database performance variation and solution
- Participate on-call rotation with database team to support clients in 24X7 environment
- Installing, configuring and upgrading Oracle database from 10g to 11g
- Managed a $1.2 million data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications
- Contributed in analyzing and increase 15% revenue growth in 2010 by standardizing content from disparate databases, enabling sales and support staff to quickly respond to customer requests
- Created Web-enabled, group-scheduling system for a large Media entity, allowing users to view and print their needs for current and future analysis
- Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions, and creating user-friendly training materials
- Developed and tested storage strategies and disaster-recovery plan for large distribution company's operational database, delivering solution that guaranteed recovery performance and high availability
- Completing business requirements analysis including the evaluation of systems specifications for client ahead of deadline
- Exceeded monthly goals by successfully handling more than 130 clients daily
- Created high-quality Flash designs, banner ads, icons, animations and logos tools used Photoshop
- Collaborated on client engagement strategy to drive entry into risk-driven project methodology, improving accuracy of project definition, sizing estimates, and yearly resource budget planning
- Improved client relationships and project predictability through shared business and technical perspectives, agreed project roles, risk assessment, transparent business-aligned development efforts
- Interacted with 50+ affiliate stations in UK and Middle East, ensuring reliable and high-speed delivery to Government, Residential, Large and Small-business customers
- Provided required weekly, monthly and quarterly reports listing sales figures and client track records
- Researched and rapidly resolved client conflicts to prevent loss of key accounts
- Established client payment plan program to monitor payment compliance and progress, reducing uncontrolled payment by 20%
- Assigned personnel to various projects and directs their activities, reviews and evaluates their work and prepares performance reports
- Supervised, scheduled and coordinated projects
- Provided Data Modeling support for the development projects
- Directed shipping and receiving of wide range of products daily.
- Conducted research to address shipping errors and packaging mistakes.
- Handled day-to-day shipping and receiving overseeing more than 1000 packages per day delivered to different location.
Education
Bachelor of Science - Computer Science
Modern Academy in Maadi
Cairo 10.2001 - 06.2006
Skills
Oracle Applications 1159, 11510, R1206, R1211/3, R1228Support, HRMS, Oracle Database Support, Golden GateData Warehousing Administration, OBIEE, WebLogic, SOA, OID, SSOOracle 19c,12c, 11gR2, 10g, 9i, 8iSQL Server2010, Mongo, CloudSolaris, Red Hat Linux 5/6/7, Windows NT/2000/2008/2018 R2EDM: Enterprise Domain ModelEAM: Enterprise Application MigrationAIM: Application Implementation MethodologySQL Developer, Toad, RAC, SQL Plus, RMAN, Shell , Patching ,Backup , Tape ManagementEnglish, ArabicFlash, Dream Waver, HTML , Java , T-SQL , SQL
Technology leadership work streams
Advanced analytics
Systems inquiry proficiency
Risk analysis
Teamwork and Collaboration
Certification
Oracle12c 11g DBA OCA, OCP, Data Warehousing
Timeline
Lead Database Engineer
Mastercard
11.2018 - Current
Senior Database Administrator
Emerson
06.2015 - 11.2018
Oracle Application Database Administrator
Metra Rails
04.2014 - 05.2015
Oracle Application Database Administrator
AST Corporation
04.2013 - 03.2014
Assistant Department Manager
Menards
10.2012 - 03.2013
Assistant Logistics Manager
Abu Dhabi Media
02.2008 - 09.2012
Bachelor of Science - Computer Science
Modern Academy in Maadi
10.2001 - 06.2006