Sql Resume
Cairo-, EgypT
EMPLOYMENT OBJECTIVE
A position as a product or project manager, IT manager, DB Manager that will allow me to apply my managerial and technical skills and experience in production of leading-edge information solutions.
Summary
Decisive, action-oriented and result-focused professional offering over 12 years of experience in Information Technology with over 4 years of "hands-on" IT management and project management skills experience. Proven technical background includes DBA, high availability systems architecture, database & data warehouse implementation, administration, tuning, and infrastructure, software development software architecture, software development, object-oriented analysis and design, requirements analysis, and data modeling.
Areas of Expertise
- Conduct System Analysis, Solution Design, Lead Development and Implementation of various Applications and the subsequent transition to ERP and Web Enabled Application
- Manage of many diverse types of people including DBAs, Programmers, Engineers, Technicians, Able to motivate technical people by understanding their needs.
- Create and maintain entity relationship diagrams, meta data repository and comprehensive system documentation, including everything from environment configuration information through standards, policies and procedures.
- Experienced in all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, Logical Data and Index Partitioning, Modify & create Indexes, Optimize Indexes, monitoring error logs, jobs etc.
- Create, administer & maintain SQL Server Databases (Production, Development, Test and Staging) for various team groups, and ensured the Availability of the Database Server in a 24X7 Environment.
- Configure and maintain Report Manager and Report Server for SSRS, develop reports using SQL Server Reporting Services and utilizing complex SQL.
- Handle IT budget and procurement of IT stuff, and coordinated with vendors.
- Design business compatible procedures/process to govern the change requests, and the development process, according to the PMI model, Capable for finding ways to improve business processes and speed up time.
- Database replication, mirroring, log shipment techniques for remote database standup, and Clustering SQL server Active passive over several nodes.
- Extensive experience with IIS with webserver administration and windows administration, active directory design and architecture.
- Ability to work independently and organize workload with minimal direct supervision.
- Experienced in designing/implementing networks infrastructures.
- Expertise in designing Disaster recovery plans and business continuity strategy.
- Lowering the cost for achieving best performance by taking the right decision for the technologies adopted to achieve best results in accordance to business needs.
- Developing and maintaining complex applications to deliver data-driven content to Web users.
- Deliver training for junior DBA, and mentoring for the Development team to asset them in writing better code, and better SQL techniques.
Development / Software Skills
SQL Serve 2000,2005,2008, SSRS, SSIS,DMV,TSQL,BCP,DTS,Crystal Reports, C# ,ASP.NET, VB6,VBS, VBA,ASP, HTML, Ajax,UML,Oracle Form Builder, Report Builder, SQL*Plus,PL/SQL, TFS 2007, 2010, Microsoft Project/task management tools,Visio, Enterprise Architect, RedGate tools, Agile Model, MS Great Plans(dynamics)/Integration
OPERATING SYSTEMS, COMMUNICATIONS PROTOCOLS & STANDARDS SKILLS
MS Windows servers (NT4, 2000, 2003,2008),Active Directory, TCP/IP, DNS, DHCP, SMTP, POP3, IMAP, LDAP, FTP, HTTP, SSL, ISA 2004,2006, IIS 5,6,7, Exchange 2003, 2007, Google Apps, fair Linux Administration, Apache Server, Iptables, SAN, NAS, RAID, Vsphere, NetApp, VMware, VERITAS, SCOM,SCCM
Professional Experience
May 2004 Confidential Cairo- Egypt
Database Head /System Analyst / Technical Manager
- 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 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
- 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, Linux, MYSQL)
- Designing and implementing the Network security, Firewall, Antivirus and performance analysis, documentation and reports
2002- 2004 Confidential Cairo - Egypt
System Admin - Manager
- Designing, Implementing and Administering the small-sized (40 pc + 2 Domain controllers) secured computer network (windows2k) , swapped over Cairo, Hurghada ( 1 DC) and Confidential, 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.
2001 - 2002 Confidential. Cairo- Egypt
System Engineer - Maintenance Dept. Manager
- 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.
1996 - 2001 Cairo - Egypt
Various contract and permanent positions
- Troubleshooting and maintenance of small office networks based on Microsoft technology
- Instructing some tracks of Microsoft products and graphics
- System Admin and Graphic designer at Abu El Enin Factory for Textiles,
- 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
Education
- Complete training in the PMI certification curriculum 2010
Member of Project Management Institute 2010
Official Studied Curriculum by Oracle:
- Oracle PL/SQL
- Oracle Forms 10g
- Oracle Reports 10g
Official Studied Curriculum by Microsoft
- Programming using C#
- Core Web Application Technologies with Microsoft Visual Studio 2005
- Advanced Web Application Technologies with Microsoft Visual Studio 2005
- Core Data Access with Microsoft Visual Studio 2005
- Advanced Data Access with Microsoft Visual Studio 2005
- Software Analysis and Design
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
B.Sc. Electrical Engineering.
- Final Year Grade : Very Good
- Graduation project : Planning of new developed area with Excellent Grade
BIO Data
- Date of birth : 1977
- Marital Status: Married
- Military Status : Exempted