SUMMARY

• Over 7+ years of experience in database administration, modeling, analysis, implementation, performance monitoring and tuning using SQL Servers 2012/2008R 2/2008/2005.
• Experience in Installing, Configuring, Managing and Troubleshooting SQL Server 2012/2008R 2/2008/2005.
• Experience in upgrading SQL Server to new versions and applying service packs and hot fixes and unattended Installation.
• Experience in Migration from SQL Server 2005 to SQL Server 2008
• Good understanding of Normalization /De - normalization and the database design methodology.
• Installed new Instances, created databases, tables, Indexes, Stored Procedures, and Views for the developers.
• Performed database and instance security activates creating user login with appropriate role, granting login privileges, monitoring the user accounts, created groups and granted database application roles to users for groups.
• Experience scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance Planning.
• Experience in implementing different types of Replication Models like Transactional and Snapshot.
• Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined functions.
• Proficient with SQL Server Disaster Recovery, Backup/Restore.
• Experience in implementing SQL Server Security and Database Permissions.
• Well experienced in scheduling SQL Server Jobs, Maintenance plans and executing them.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Solid experience and outstanding knowledge of high availability SQL Server solutions including Mirroring, Log shipping, Replication.
• Knowledge and experience in dealing with Constraints, Querying, Joins, Keys, Indexes.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization and Database Consistency Checks using DBCC Utilities
• DMVs and DMFs also using (DET) to get recommendation what query need to work on.
• Knowledge of using (SSIS) in the development (ETL) Extract Transform Load
• Well experienced in performing root cause analysis and using SQL Profiler for troubleshooting.
• Knowledge in deploying multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Knowledge in SQL Server Clustering, Non-Clustering, heap and balance Tree.
• Experienced in implementing efficient Disaster prevention and Recovery Strategies and High availability like
• Database Backup and Restore, Database Snapshot, transactional, Replication, Log shipping, and Clustering (Active/Passive).

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Vista/7/8/8.1

Database Tools: Profiler, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

Web Technologies: HTML, CSS, JavaScript

GUI Tools: Visual Studio 2005/2008

Languages: C++, C#, .Net, ASP.Net, VB.Net

Databases: SQL Server 2012/2008R 2/2008/2005/2000, Microsoft VS 2010/2012/2013

OLAP Tools: SQL Server Reporting Server 2008/2005, SSIS (as ETL)

Third Party Tools: Spotlight and Redgate

PROFESSIONAL EXPERIENCE

Confidential, North Kansas City, Missouri

SQL SERVER DBA

Environment: Windows 2003/2007/2008, MS SQL Server 2012/2008/2005, SQL Server reporting services, T-SQL, SQL Query Analyzer, replication, monitoring.

Responsibilities:

• Installed SQL Server 2005/2008R2/2012 Servers on windows 2003/7/8/8.1 Platform.
• Monitoring the Schedule job, Backup, SQL Server database and Replication.
• Managing database backup and recovery Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Experienced in trouble shooting, performance tuning, query tuning, index tuning using DBCC command, Wizards and SQL Profiler.
• Set database access privileges for different users and user groups.
• Perform optimization of SQL queries.
• Maintenance of clustered and non-clustered indexes. Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Developed DTS, SSIS Packages to transform data from excel file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Developed standards for SQL Server maintenance / updates.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database.
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert and E-mail notification setting.
• Maintained Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.

Confidential, Minneapolis, MN

SQL Server DBA

Environment: Windows 2003/2008, SQL 2000/2005, T-SQL, Replication, SSIS, SSRS, Database Mirroring, Lite Speed, BMC (Ticketing).

Responsibilities:

• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Implemented new SQL Server 2005 concepts like Data partitioning, Snapshot isolation.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Rebuilding indexes at regular intervals for better performance.
• Expertise in SQL server Reporting Services (SSRS).
• Scheduled package execution in SSIS.
• Installing packages on multiple servers in SSIS.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
• Created extensive reports using SSRS (Tabular, Matrix).
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Monitored & modified Performance using execution plans and Index tuning.
• Used log shipping for synchronization of databases.
• Worked in Active passive cluster environment.
• Prepared Documentation for the Disaster Recovery plan.
• Wrote and debugged Stored Procedures, (DDL) triggers, functions as per client requirements and (DML).
• Extensively worked on troubleshooting and fine-tuning of databases for its performance.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations.
• Worked on call 24/7 Support on weekly basis.

Confidential, Bedminster, NJ

Senior SQL DBA

Environment: MS SQL Server 2008/2005Windows 2000/2003/2008 Server Operating systems, SSIS and SSRS.

Responsibilities:

• As a Production and development DBA managed 63+ SQL Servers with size ranging 20 GB to 1 Terabyte in a 24x7 Production environment.
• Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Successfully Upgraded most of the MS SQL Server from SQL 2000/2005 to MS SQL Server 2008
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers on VIRTUAL Servers, applied service packs and security fix for all servers.
• Extensively used VMware for Virtual environment.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Managed SQL Servers in Clustered environments.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
• Did extensive Database design and Modeling using ERWIN.
• Created the DTS, SSIS packages to import the data from MS Access SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Confidential, New York City, NY

SQL Server DBA

Environment: Windows Server 2005, MS SQL Server 2008 Enterprise Edition, SQL Profiler, SSIS, and SSRS.

Responsibilities:

• Responsible for the Installation, daily monitoring, maintenance of SQL Server 2005 installations in both the production and development Environments and also upgrades to SQL server 2005.
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate parameters
• Participated in the migration of the databases and managed the location of database files, log files and their sizes.
• Migrated and validated users and logins in the new environment.
• Granted roles and permissions to SQL server users.
• Developed, implemented, and maintained procedures for ensuring the security and integrity of SQL Server 2005 and the corresponding databases.
• Created tables, Views, Indexes, Functions and advanced queries for databases by using SSMS.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Automated and enhanced daily administrative tasks including space management, database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic backups with backup devices, Database maintenance Plans and Recovery.
• Configured and maintained transactional, snapshot and merge replications.
• Performed Log shipping to a standby server to safeguard valuable data.
• Performed Database Mirroring in SQL Server 2005.
• Modified and optimized complex queries for data retrieval.
• Involved in converting DTS Packages to SSIS Packages.
• Managed the production and development databases for performance tuning, capacity planning and database security configuration.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
• Performed Root cause analysis to track down problems and used SQL profiler for troubleshooting.
• Generated different reports using SSRS. Manage more than 20 databases running on different Windows platform.

Confidential

SQL Server DBA/Developer

Environment: MS SQL Server 7.0/2000/2005, Windows 2000/200, Create and maintain databases after logical and physical database design.

Responsibilities:

• Installed SQL Server 2005, 2000 Servers, multi instances and service packs for existing 7.0/2000 servers.
• Managing database backup and recovery create database objects including tables, triggers, views, stored procedures and indexes.
• Experienced in troubleshooting, performance tuning, index tuning using DBCC command, Wizards and SQL Profiler.
• Set database access privileges for different users and user groups. Perform optimization of SQL queries.
• Maintenance of clustered and non-clustered indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Developed SSIS and SSRS Packages to transform data from excel file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Developed standards for SQL Server maintenance / updates.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database.
• Job, Scheduling, batch, alert and E-mail notification setting using maintenance plan.
• Maintained Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.