SUMMARY:

• 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,2012,2014), MS Access 2000 & 2003
• Performed databases upgrades from SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 t SQL Server 2008 and also to SQL Server 2012 and to SQL Server 2014
• Working in VMWare virtualization supporting virtual Windows 2012 servers where SQL Server 2012 databases are managed
• Migration of Oracle and MySQL database to SQL Server 2005 and 2008
• Deployed large databases to 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
• Management and operations of TFS(Team Foundation Server)
• Experiences administering Web Server (IIS-Internet Information Services) including installing, and configuring and administration
• Deployment of different applications to development, test and production environments
• Working experience on Operating Systems (O/S) include Windows Server 2012/ 2008/2003/2000 Server, Windows 2000/XP/7 and MS-DOS.
• Working experience also includes installing, configuring, and administering the above operating systems
• Designed and Managed network using HUB, ROUTER, and SWITCH
• Administration and management of user accounts in AD (Active Directory) in Windows 2000/2003/2008/2012 Server
• Participated on the application of SAN storage for redundancy, high availability and scalability business requirement for PAHO

TECHNICAL SKILLS:

Database: SQL Server 2014/2012/2008/2005/2000, MS Access 2010, 2003 & 2000, MySQL (4.0.3,5.0.1),Database Migration: MySQL (4.0.3, 5.0.1), MS Access

SQL Tools: Query Analyzer, Profiler, Database Mail, SQL Agent

ETL Tools: SSIS/DTS, BCP,FTP

Reporting: SSRS (SQL Server Reporting Services/Server)

Data Modeling: Quest Data Modeler

Programming: SQL, T-SQL, Store Procedures, Trigger

Operating System: Windows Server 2012/2008/2003/2000, Windows XP/NT4.0, MS-DOS, VMware

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE:

Confidential

SQL Database Administrator

• Managed 12 regional SQL server 2012 servers on Windows server 2008 operating systems
• Managed around 300 SQL Server 2012 share point databases on Windows 2012 servers
• Installed SQL Server 2014 with SP1(Patches) /SP2 on a new Windows 2012 server and migrated databases from SQL Server 2008 R2 server, Sql server 2005 server
• 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) to be restored to 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
• Knowhow of policy based management system for the control and automation of different SQL tasks
• Managed and operated the Epicor Enterprise Resource Planning (ERP) application (EPICOR 9.04) for inventory and finance applications in PAHO with PALTEX. Created a databases backup, restore and disaster recovery policy. Used the ftp protocol to transfer files from remote servers. Prepare queries from these data to be used In the Crystal Reports
• Prepared SLA with the hosting company regarding the database backup and restore policies of the Epicor system
• Managed to prepare the SQL Server Performance tuning Baseline for the all servers in the 19 countries
• Participated on the implementation of SAN storage for redundancy, high availability and scalability business requirement for PAHO, especially applying redundancy of local data backups in the SQL Server data in the VMware hosts.
• Installed SQL Servers 2008 R2 with SP2 upgrade on new servers and migrated different databases from SQL Server 2005
• Participated on a SQL 2014 Upgrading project which involved the inventory processes of all SQL servers existing in the organization by using MAP tool kit ;applied the SQL Server 2014 Upgrade Advisor for any data type and compatibility issues to be dealt with. The project involved around 25 SQL Servers of different versions (SQL Server 2005, SQL Server 2008, SQL Server 2008 R2) to be upgraded to SQL Server 2014.
• As part of the project work, I configured new SQL Server 2014 (for the Test and production environments) for the preparation of the upgrade process.
• Transferred DTS packages to SSIS packages before migrating to SQL Server 2014.
• Good and practical experience on the design and creation of databases for PAHO, especially with the health department.
• Using the SSIS feature of SQL Server 2014, transferred Health data from different sources (Excel and large fixed width text files, access files) to SQL Server Databases.
• Deployed the SSIS packages in SQL Server 2014 using the Integration Services Catalog for the transfer of different types of health related data files from Latin America countries (Like Brazil, Colombia etc.) to Centralized ware house and apply different SSIS task for transforming them to SQL Server database tables.
• Good experience on the implementation of SSRS for different DW data.
• Automation of the SQL Server database using the PowerShell script
• Prepared SQL Server Performance baseline for different servers.

SQL Database Administrator

• Managing over 27 branch servers Databases Server (Development, Test, and Production environments)
• Managing different databases on these servers
• Extensive use of T-SQL programming using CTE and cursors
• Writing T-SQL, Dynamic queries, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries, Stored Procedures
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed, Deployed, and Managed Reports
• Managed Reports Security managed crystal reports
• 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

Network system

• Deputy Manager of the department store
• Managed the sales and inventory system designed on SQL Server 2000.
• Installed the Local Are for the whole department Network
• Managed the Windows and SQL Users and logins.
• Managed the Data by following the disk space for the data and log files