Summary

• Over eight (8+) years of experienceas DBA in Installation, administration, upgrade, Migration, Design, Development, Troubleshooting, Implementation, and Maintenance of large MS SQL Server Databases and applications in a 24/7 environment
• Conceptual and hands on experience in upgrading and migrating SQL 2000 to SQL 2005/2008/2012 on clustered and non clustered servers.
• Extensive experience in setup SQL Failover Cluster, Log Shipping, Mirroring, Replication, Database Migration and consolidation of servers from one Data Center to another
• Proven in-depth experience in Capacity Planning, SQL Server Databases Performance Tuning & Optimization, environment setups, security.
• Expertise in database Backup/Recovery and Disaster Recovery procedures, applying required patches to SQL Server databases.
• Solid educational background, including Bachelor in Computer Science and MicrosoftCertified DBA

Key Skills

Microsoft Certified IT Professional (MCITP) in SQL Server 2005 and 2008
ITIL Certified, Information Technology Infrastructure Library
SSIS, SSRS, SSAS, Sharepoint, MySQL, MS Access, IIS

Professional Experience

Senior Database Administrator/Architecture
Confidential, April 2012 - Present

• Work with clients to interpret database aspects of project requirements to generate appropriate DB specific requirements, design and development
• Design high availability SQL Server 2012 and 2008R2 Failover cluster for Share Point 2012
• Install and Configure 2 nodes SQL Server 2012 Failover cluster
• Installed and Configured SQL Server 2008R2 Database Mirroring
• Set up Database Backup, Alerts, SQL Mail and Maintenance Jobs to monitor the database server
• Perform day-to-day Database Maintenance tasks -- Database Monitoring, Backups, Space, and Resource Utilization, responsible for performing Database refresh from production to UAT database.
• Perform database tuning, optimization and troubleshooting of database servers in Development, QA and Production environments
• Configured SQL Server Reporting (i.e. SSRS) Analysis (i.e. SSAS) services, SSIS and IIS

Senior Database Administrator/Architecture
Confidential, August 2011 - March 2012

• Worked with clients to interpret database aspects of project requirements to generate appropriate DB specific requirements, design and development
• Provided production support for SQL Server on 24/7 environment
• Designed high availability SQL Server Failover cluster and Database Mirroring architecture
• Installed and Configured 4 nodes SQL Server 2008 Failover cluster
• Installed and Configured 2 Nodes SQL Server 2008R2 Failover cluster for Share Point 2010
• Installed and Configured SQL Server 2008 Database Mirroring
• Configured SQL Server Reporting (i.e. SSRS) Analysis (i.e. SSAS) services, SSIS and IIS
• Set up Database Backup, Alerts, SQL Mail and Maintenance Jobs to monitor the database server
• Performed day-to-day Database Maintenance tasks -- Database Monitoring, Backups, Space, and Resource Utilization, responsible for performing Database refresh from production to UAT database.
• Performed database tuning, optimization and troubleshooting of database servers in Development, QA and Production environments
• Setup Database Monitoring, Alerts and SQL Mail to monitor the database server
• Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008
• Consolidated both Primary data center and DR database servers

Environment: SQL Server 2000/2005/2008/2008R2, Windows 2003/2008/2008R2, SSRS, SSIS

Senior Database Administrator/Consultant
Confidential, February 2011 - July 2011

• Provided production support for SQL Server on 24/7 environment
• Designed high availability database infrastructure
• Installed, configured and migrated SQL Server on clustered and stand alone servers
• Served as escalation point expert for the SQL Server database team
• Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008
• Performed database backups, database tuning and optimization and troubleshooting of database servers in Development, QA and Production environments
• Installed and configured 3 Nodes SQL Server 2008/2008R2 Failover cluster
• Installed and Configured SQL Server 2005/2008 Reporting and Analysis Services
• Performed day-to-day Database Maintenance tasks -- Database Monitoring, Backups, Space, and Resource Utilization, responsible for performing Database refresh from production to UAT database.

Environment: SQL Server 2005/2008/2008R2, Windows 2003/2008/2008R2, SSRS, SSIS, SSAS

Senior Database Analyst/Administrator
Confidential, March 2009 - January 2011

As a Senior DBA, I was responsible for design and maintenance of SQL Server Database environment at Hydro One. Performed data center relocation, database migration and maintenance and integration with vendor software on Windows platform.

• Provided production support for SQL Server on 24/7 environment
• Supported a large data center using 120 SQL Servers running on Windows2000/2003/2008
• Performed day-to-day Database Maintenance tasks -- Database Monitoring, Backups, Space, and Resource Utilization, responsible for performing Database refresh from Production to UAT database.
• Migrated database from SQL Server 2000 to SQL Server 2005 and 2008
• Configured and setup SQL Server 2008 fail over cluster for Hydroone.com, CRM and Share Point
• Designed high availability database infrastructure
• Worked with developers and vendors to install 3rd party software.
• Managed and maintained Data Warehouse and Data Mart applications and databases.
• Responsible for database security, backup, recovery, performance tuning for databases and applications, user administration, and capacity planning
• Installed, configured, secured SQL Server 2005/2008 Fail over cluster, database replication, mirroring reporting service and Analysis Server
• Troubleshoot database performance issues and tuned database objects. Set up traces and Profiler to troubleshoot performance issues. Analyzed deadlocks & diagnosed issues on the server.
• Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitored log files to proactively resolve issues.
• Planned, tested and performed major upgrade of SQL Server 6.5, 7, 2000 to SQL Server 2005 and SQL 2008

Environment: SQL Server 2005/2008/2008R2, Windows 2003/2008/2008R2, SSRS, SSIS

Senior Database Analyst/Administrator
Confidential, November 2008 - Feb 2009

• Provided production support for SQL Server on 24/7 environment
• Provided consulting solutions to various clients in database design, configured SQL Server 2005/2008 fail over cluster, setup database replication and database tuning
• Migrated database from SQL Server 2000 to SQL Server 2005
• Administer Microsoft SQL Server databases. Managed database instances, monitored server performance, and tune the database server and applications.
• Assisted a team of DBA's in migration of trading Service databases from SQL 2000 to SQL 2005.

Senior Database Administrator
Confidential, April 2008 - October 2008

As a Senior DBA, I was involved in DR center relocation and consolidation, configured log shipping and replication for DR databases.

• Provided production support for Moneris applications
• Supported large Data Warehouses of approximately 6 Terabytes.
• Performed day to day Database Maintenance tasks -- Database Monitoring, Backups, Space, and Resource Utilization, responsible for performing Database refresh from production to UAT database.
• Managed and maintained Database infrastructure (Database maintenance, backups, disaster recovery testing, security audits and database upgrades).
• Accomplished database migration of 1.5 TB of Fraud and OMS system from SQL Server 2000 to SQL Server 2005 server.
• Migrated database from SQL Server 2000 to SQL Server 2005
• Participated actively in the areas of business requirements gathering, technical design, and QA testing, alongside the team, to ensure best possible product quality and support
• Installed, configured, secured SQL Server 2005/2008 Fail over cluster, database replication, mirroring reporting service and Analysis Server
• Troubleshoot database performance issues and tuned database objects. Set up traces and Profiler to troubleshoot performance issues. Analyzed deadlocks & diagnosed issues on the server.
• Designed and implemented DB security, user management, performance.
• Supported a large data center using 50 SQL Servers running on Windows2000/2003

Environment: SQL Server 2000/2005/2008, Windows 2003/2008, SSRS, SSIS

Database Administrator
Confidential, April 2007 - March 2008

• Provided production support for Toyota applications
• Installed and Configured Four SQL Server 2005 Cluster servers
• Implemented and administrate database replication between SQL Server databases.
• Managed and maintained Data Warehouse and Data Mart applications and databases.
• Worked on an SQL Server consolidation and migration to SQL Server 2005 project
• Managed and was responsible for 56 SQL Server databases on 40 servers
• Monitored database performance and performed upgrades/improvements when required; analyzed the database architecture to ensure optimum efficiencies.
• Responsible for database security, backup, recovery, performance tuning for databases and applications, user administration, and capacity planning
• Developed and Implemented SQL Server 2005 Maintenance plans to keep the SQL Server databases running efficiently.
• Installed and Configured SQL Server Analysis and Reporting Services.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Administer the day-to-day operations of the system, making sure all processes run effectively; trained users and respond to user questions and issues
• Successfully resolved SQL Server problems in conformance with SLAs, which involved in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security etc

Environment: SQL Server 2005/2000, Management Studio, Query Analyzer, Profiler, Erwin, Windows 2003 Server, SQL Reporting Service

Database Administrator
Confidential, May 2006 - March 2007

• Provided production support for Narroflex applications
• Managed and Responsible for 22 SQL Server databases on 16 servers Created backup/recovery strategy, set up replication, and automate statistics. Backup and Recovery of Mission Critical Database
• Managed and maintained Data Warehouse and Data Mart applications and databases.
• Attended meeting with manager and developers for time lining projects, hardware selection, capacity planning, production cutovers and disaster recovery strategy.
• Worked with developers and users in standing up and moving codes and database through various stages of Development, Quality assurance, Operational Support, Customer Acceptance and Production environment.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Developed stored procedures, DTS/SSIS packages and transact-SQL code to accomplish varying tasks
• Performed database administration tasks such as performance monitoring using SQL Trace, SQL Profiler and system Performance Monitor.
• Installed and Configured SQL Server Analysis and Reporting Services. Implemented security using Roles, Privileges, Grants, and Views

Education

Bachelor of Computer Science
Internet Software Developer
Bachelor of Science (Computer Science)

References available upon request; travel acceptable and willing to relocate