Database Support Supervisor
ELM
مجموع سنوات الخبرة :27 years, 1 أشهر
Database Management Supervisor - Operation department
Leading team of 12 DBAs, mixed SQL and Oracle in a very fast and dynamic diversity expanding environment, with mission critical databases affecting everyday life of KSA residents.
Application Architectural validation and review to achieve highest performance, at budgeted cost.
Lead the team to provide 24/7 support for mission critical databases.
Re-architecting and design for production components for performance enhancement and scaling
Lead team to achieve database uptime of 99.98%, through stabilizing the production environment, maintenance, and ongoing performance enhancement.
Assessment of the logical database design, database code review and analysis.
Responsible for the database physical design, partitioning, scaling, and capacity analysis.
Redesign process/policies for the Database team to adhere with best practices to achieve quality and performance.
Architecting and design the database monitoring, and alerting across the production database environment.
Saved 8.3 Million SR of database licensing, through consolidation and choosing the right database edition through true up and by developing code for reconciliation of a production project that was leaking payments.
Business process analysis and verification of code implemented results across integrated system, is performing same as the SRS document.
Leading the oracle team for two success Exadata implantations to production, performance tuning, and operational daily maintenance tasks.
Ownership of change management, ticketing, service requests related to database.
Owner of implementation process for DB activities of new projects.
Ownership of service delivery process to database team.
Responsible to assess and review codes through change management.
Responsible for assessment, design and architecture, for all the proposals with proposal team.
Engage in the application architecture to fix performance issues affecting the database performance.
Lead the team to document operational tasks, and routines.
Planning of the expansion of the database team, according to services, technology, administration and operational tasks.
Lead the DB team for daily operational tasks, requests, tickets, achieving best resolution time across the operation team.
Participating in the stress test scenarios to stress the database, Analysis and performance tuning after stress test
Work closely with infrastructure team, application team to mitigate performance and design issues.
Direct, motivate, and develop team, maximizing their individual contribution, their professional growth, and their ability to function effectively with their colleagues as a team.
Design, Architecting, and maintaining VLDBs of whole sum 50TB+ with appropriate driving maintenance jobs.
Work closely with SAN teams, System teams, to achieve top notch performance.
Work closely with Dev teams to aspire and train to write better TSQL code.
SQL Windows Clustering design and implementation, and maintenance for 25 SQL Clusters.
Planning data plans for using on the SAN (VMAX, Clarion, …etc) as expansion and as I/O.
Participate in the Remote Disaster Recovery major Architecting plan.
DataMart, and Datawarhousing solutions design and implementations.
SQL Techs Replication, SSIS, SSRS, SSAS.
Design Alert and intelligent notification scheme.
Design and implement sophisticated monitoring scheme.
Enhancing Query performance using different methodologies to keep our audience dazzled about SQL possibilities to drive performance for the DB environment serving 150 +Applications, serving 300.000 Users
Management of the Developer teams, and coaching the support teams, Manage Incidents, Problems, Plans and directing the operations of the Software and Systems.
Architecting and leading the development of complex Educational ERP system, HR/Attendance system with gates and access control, Billing system of Students, Advising System, Asset Management System, Library/POS across many others
Design/Architect/Administer and Lead MIU Database(s) /servers serving the needs, and managing every aspect of the Database operations since version 2000 till 2008 for over 8 years serving 15000 students and 1200 staff members.
Architecting and leading the development technical perspective mailing, exchange server management and account management, with integration with Google apps integration/web services
Analyze business needs by interviewing representatives from all departments to understand the needs, and introduce business solutions/proposals based on IT.
Control Change Request Process for the Database, Database Architecture, design replication, maintenance plans and delivering high level administration for the database engine, and software design
Architecting MIU Portal Model, and leading the developers’ team to achieve the Portal known as Student Services Online, and working close to management to analyze the students’ needs.
Managing the Implementation of new Technologies and prototyping systems before deploying.
Design the DRP (data recovery plan) and administer coaching and training of various IT staff to execute.
Providing employee development, coaching, mentoring, and team building.
Leading the project of switching from Oracle DB to SQL server
Designing, and lead the administration of MIU network which swaps over 40 Servers and 1000+ terminals, this network runs the follows (Oracle DB Server/Application Server, MSSQL 2005/2008, MS Exchange, WSUS, SMS2k3, IIS5/6/7, ISA, FTP, Exchange 2007, VERITAS, MYSQL, Apache, Linux, MYSQL)
Designing, Implementing and Administering the small-sized (40 pc + 2 Domain controllers) secured computer network (windows2k), swapped over Cairo, Hurghada ( 1 DC) and Sharm El Sheikh, with 512 KB SDSL as the base connection between the three branches through VPN.
Maintaining the mail service - SMTP, POP3 using Kerio Mail Server
Securing the Network using ISA2000, and monitoring the network usage / thread
Responsible for the budget of the IT Department and decision of buying and adapting new trends and software/hardware, was able to lower the costs of most aspects of the IT Department and the supplies that is needed.
Backup, failsafe planning using Microsoft backup / tape device
Upgrading the IT sector to adapt new technologies
Doing website designing and implementation
Developing VB 6 solution for the Tourism Department
Developing Faxing solution and email service solution.
• Lead or solo engineer for client installations of Microsoft Networks (NT4 - Windows 2000) including Windows Active Directory and Group Policy Objects troubleshooting and configuration.
• Lead or solo engineer for designing/implementing networks for clients using switches/routers/hubs and UTP, for building full TCP/IP network.
• Troubleshooting via telephone and on-site support for a wide range of client terminal services environments.
• Troubleshooting and maintenance of small office networks based on Microsoft technology
• Instructing some tracks of Microsoft products and graphics
• System Admin at Abu El Enin Factory for Textiles, also Graphic designing
• Integrating computers and building small LAN solutions
• Customer served like (El Demerdash Hospital, Railroad Agency, Pico International, Mobil - Maady, Alpha Checmical Egypt - Amon Pharma)
• Companies worked at Unitek Egypt - Shehab Co-ltd
Complete training in the PMI certification curriculum 2010 Member of Project Management Institute 2010
• Oracle PL/SQL • Oracle Forms 10g • Oracle Reports 10g
B.Sc. Electrical Engineering , Ain Shams University 2002 • Final Year Grade : Very Good • Graduation project : Planning of new developed area with Excellent Grade
Completed certification Tracks of MCSE as following during 2001/2002 • Microsoft Windows 2000 Professional • Microsoft Windows 2000 Server • Microsoft Windows 2000 Active directory • Microsoft Windows 2000 Infra Structure • Microsoft Windows 2000 Active directory Design