Summary

• SQL Server DBA with detail oriented,analytical and troubleshooting experience in different Microsoft products like SQL Server and Operating Systems.
• Depth knowledge and experience in data modeling including gathering and analyzing business requirement.
• Solid working experience in managing migrating, updating large databases in 24/7 data processing environment including backup/recovery, performance tuning, developing and managing reports using SQL Reporting Services SSRS , Monitoring, stored procedures, triggers, functions, constraints and views etc.

TECHNICAL SKILS

Technical Summary:

Database:

• Strong work experience and knowledge with SQL Server Database High availability using Clustering, Standby/Replication, Database Mirroring, and Log shipping
• Database Monitoring, Performance Tuning, Query Optimization, Backup/Recovery, Security Management
• SQL/T-SQL Programming
• Strong Database Administration experience with MS SQL Server 2000, 2005, 2008 , MS Access 2000 2003
• Performed databases upgrades from SQL Server 2000 t SQL Server 2005/2008 and SQL Server 2005 t SQL Server 2008 and als t SQL Server 2012
• Migration of Oracle and MySQL database t SQL Server 2005 and 2008
• Deployed large databases t development, test and production environment
• Preparing Change Management Requests CMRs for large data deployment and large data updates
• Preparing SQL Performance tuning baseline using the native tools like PerfMon, SQL Profiler, Dynamic Management Views

Web/Application Server Administration:

• Have solid knowledge and experiences administering Web Server IIS-Internet Information Services including installing, and configuring and administration
• Deployment of different applications t development, test and production environments

Operating Systems:

• Working experience on Operating Systems O/S include Windows Server 2008/2003/2000 Server, Windows 2000/XP/7 and MS-DOS.
• Working experience als includes installing, configuring, and administering the above operating systems

Networking:

• Designed and Managed network using HUB, ROUTER, and SWITCH
• Administration and management of user accounts in AD Active Directory in Windows 2000/2003/2008 Server

Professional Experiences:

1 Confidential

SQL Database Administrator

• Managed 12 regional sql server 2012 servers on Windows server 2008 operating systems
• Managed 204 share point databases on these servers
• Created backup maintenance plan for the above system and users databases and maintenance plan reports as well.
• Managed the backup process of different regions around 19 countries of Latin America t be restored t the Head quarter server on daily bases which are used for different reports purposes in the head office using the FTP or the Remote administration utility
• Managed and operated the Epicor Enterprise Resource Planning ERP application EPICOR 9.04 for inventory and finance applications. Created a databases backup, restore and disaster recovery policy. Used the ftp protocol t transfer files from remote servers. Prepare queries from these data t be used In the Crystal Reports
• Prepared SLA with the hosting company regarding the database backup and restore policies of the Epicor system
• Managed t prepare the SQL Server Performance tuning Baseline for the all servers in the 19 countries
• Installed SQL Servers 2008 R2 with SP2 upgrade on new servers and migrated different databases from SQL Server 2005
• Prepared SQL Server Performance baseline for different servers.
• Managed SSIS packages used t transfer different data.
• Managed SSRS reports.

1 Confidential

SQL Database Administrator

Responsibilities

Database administration

• Managing over 27 branch servers Databases Server Development, Test, and Production environments
• Managing different databases on these servers
• Database Programming:
• Extensive use of T-SQL programming using cte and cursors
• Writing T-SQL, Dynamic queries, Trigger, and Stored-Procedures
• Assisted Database Developers t optimize SQL queries, Stored Procedures etc
• Tools Used: Query Analyzer
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed, Deployed, and Managed Reports
• Managed Reports Security
• managed crystal reports
• Tools Used: Developed Reports using BIDS Business Development Studi , and Report Builder 3.0, 2.0
• Database High Availability:
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Transactional Replications
• Technology Used: Database Mirroring, Log Shipping, and Replication
• DTS/SSIS:
• Exported data from SQL Server t multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources t SQL Server
• Tools Used: Exp/Imp, SSIS, ODBC, DB Link, BCP

1 Confidential

SQL Database Administrator/DBA

Responsibilities:

• Managing over 34 Databases Server Development, Test, and Production
• Managing Application/Web Server IIS 5.0, 6.0,6.5, 7.0, 7.5
• Managed Development, Test, and Production databases
• Installed, Configured, and Managed SQL Server 2008, 2005 2000 in development, test, and production environment
• Database High Availability:
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Transactional Replications
• Technology Used: Database Mirroring, Log Shipping, and Replication
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed, Deployed, and Managed Reports
• Managed Reports Security
• managed crystal reports
• Tools Used: Developed Reports using BIDS Business Development Studi , and Report Builder 3.0, 2.0
• Database Upgraded development, testing and production environment :
• SQL Server 2000 t 2005/2008
• SQL Server 2005 t SQL Server 2008
• SQL Server 2008 t SQL Server 2012
• Database Migration in the development, testing and production environments
• MS Access 2003/2000/97 databases int MS SQL Server 2000, 2005, and 2008
• Oracle 10gR2 databases t SQL Server 2008
• My-SQL 4.1.0/5.0.1 databases t SQL Server 2005 and 2008
• Tools Used: SSMA SQL Server Migration Assistant for Oracle, My SQL, Access, and ODBC/DB Link
• Data Modeling:
• Worked on more than 10 data modeling projects and generated E-R Diagram
• Backward Forward Engineering with data modeling tools mentioned above
• Tools Used: ERWin, Quest Data Modeler, VISIO, SQL Server Data Diagram
• Patch Management:
• Applied SP Service Pack on SQL Server 2000, 2005, 2008 and Windows Server 2008, 2003, 2000
• Applied HOT Fixes on SQL Server 2000, 2005, 2008 and Windows Server 2008, 2003, 2000
• Database Monitoring/Performance Tuning:
• Strong and solid knowledge on database Monitoring and Performance tuning
• Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works
• Applied different maintenance plans for the automation of daily activities
• Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc
• Database Programming:
• Written T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers t optimize SQL queries, Stored Procedures etc
• Tools Used: Query Analyzer
• DTS/SSIS:
• Exported data from SQL Server t multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources t SQL Server
• Tools Used: Exp/Imp, DTS, SSIS, ODBC, DB Link, BCP
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Solid knowledge on Restoring the backups Databases full, differential, transaction
• Applying different backup technologies on databases t different medias such as Local Drive, Network Drive, File Server, TAPE Media
• Used DBCC t check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Strong working experience in creating, modifying tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Reviewing service related reports backups, maintenance plan etc...

2 Confidential

SQL Database Administrator/DBA

Responsibilities:

• Managed Development, Test, and Production databases
• Installed, Configured, and Managed SQL Server 2005 2000 in development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and stability
• Database High Availability:
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Transactional Replications
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed, Deployed, and Managed Reports
• Managed Crystal reports
• Managed Reports Security
• Tools Used: Developed Reports using BIDS Business Development Studi , and Report Builder 3.0, 2.0
• Database Upgraded development, testing and production environment :
• SQL Server 2000 t 2005/2008
• SQL Server 2005 t SQL Server 2008
• Database Migrated development, testing and production environment
• MS Access 2003/2000/97 databases int MS SQL Server 2000, 2005, and 2008
• Oracle 10gR2 databases t SQL Server 2008
• My-SQL 4.1.0/5.0.1 databases t SQL Server 2005 and 2008
• Tools Used: SSMA SQL Server Migration Assistant for Oracle, MySQL, Access, and ODBC/DB Link
• Patch Management:
• Applied SP Service Pack and HOT Fixes on SQL Server 2000, 2005
• Applied Patch on Windows Server 2008 and 2003 Enterprise Edition
• Database Monitoring/Performance Tuning:
• Strong on database Monitoring and Performance tuning
• Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works
• Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc
• Database Programming:
• Writing T-SQL, Trigger, and Stored-Procedures
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup

3 Confidential

Responsibilities

Studied the existing system and proposed the hardware such as server with its operating system and other interrelated devices necessary for the upgrade. Installed, maintained and troubleshoot various applications on the proposed servers.

Responsibilities

• Administered the IT department for the Ministry
• Supervised programmers hardware engineers in the department
• Studied different requirements for the Ministry and proposed the solution specially the human resource and logistic.
• Proposing the best high availability solution according t the business need of the Ministry and that was using the database mirroring
• Implementing maintenance plan and disaster recovery solution
• Managed the local area network for the department
• Made requirement study for the implementation WAN in different places of the Ministry and applying them.
• Follow up of the system performance using different stored procedures

Confidential

Junior programmer using the COBOL programming language on accounting application