SUMMARY

• 9 Yrs of SQL Server DBA experience in IT, Commercial, Banking, Health and Finance environments
• Experience in an operational environment providing support involving coordination with release management and change management.
• Experience with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL2014 installation, administration and management of multiple instances/servers in highly transactional environments
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• OLTP Design development, implementation, and maintenance phases
• Experience in Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2008 as well as DTS Xchange tool for migrating DTS packages to SSIS packages
• Worked with IT staff on various projects like Server upgrades, Data center migrations etc
• Expert in Disaster Recovery Planning with Log shipping, replication etc and High Availability solutions like DB Mirroring, Clustering and Always on High Availability groups etc
• Involved in a few very large Data Center migrations as the Senior DBA for DB2 andSQL Serverinventories - and developed an approach suited to minimizing risks
• Worked with Developers for query optimizations, performance tuning, package deployments, code changes etc.
• Proficient with database backup/restore, recovery procedures, index maintenance, production security standards, change requests etc
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, SSMS, BI studio, SQL Profiler, Database Tuning Advisor, DMVs
• Extensive experience with data modeling, Dimensional modeling, logical and physical database design.
• Excellent T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Replication - Snapshot, Merge and Transactional.
• Extensively worked and had good knowledge on Integration and Reporting Services and good experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Experience in using different Transformation tools like DTS packages, BCP, and BULKINSERT, SSIS.
• Configured always on High availability groups for reporting purpose.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2000/2005/2008 /2014 , Analysis Server 2000/2005/2008 , Ms Access 2000/2005/2008 .

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade advisor, Replication, DTS xChange MS Visio, DB artisan, SQL reporting, SSIS,MAP Tool, Red Gate SQL Compare, Red Gate SQL Backup, Apex, SQL Enlight, SQL Sentry, Solar Winds, Idera Diagnostic Manager, ERWIN, ER/Studio, SQLIO.

Programming Languages: SQL, TSQL, XML, PL/SQL.

Web Tools: MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 2000/2003/2003 R3/2008R2/2012/XP/NT 4.0, Unix, MS-DOS.

Utility Tools: MS Office, MS Project, ClearQuest, Visual Source Safe 6.0, Rational ClearCase, Tivoli, Magic, TSRM.

PROFESSIONAL EXPERIENCE

SQL DBA/Developer

Confidential, White Plains, NY

Responsibilities:

• Involved in installing and configuring of SQL server 2014 on standalone and clustered environments.
• Consolidation and migration of databases to new hardware and platforms
• Migrated SQL server 2008/2005 on Win2003 to SQL Server 2014 in Microsoft Windows Server 2012 Enterprise Edition.
• Build a centralized solution to monitor all SQL servers
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Automated Code deployments SQL scripts, SSIS packages and SSRS rdls from Subversion.
• Troubleshoot and tune queries using native SQL server tools
• Implement HA/DR features like Always on Log Shipping and SQL Replication for business critical applications
• Expert in designing database and Storage Capacity Planning.
• Implementing high availability with AlwaysOn Availability Groups and failover clustering
• OLTP Code and design review Ensure database security, integrity, and performance
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Planning, analysis and migrate databases to SQL 2014
• Provided 7 x 24 Production support for the database and application issues.
• Build 5 Node active passive cluster to use resources more effectively
• Work on effective solutions to bring data from M/F to SQL server
• Hands on experience in red gate data compare, schema compare and data generator
• Task lead for migration of data from three sources two SQL databases and a pro flat file database to two new SQL databases.
• Involved in data modeling, designing and building relational databases using Erwin tool.
• Implemented database mirroring between primary server and a standby server.
• Running DBCC consistency checks, and fixing data corruption in user databases

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012 servers, Active Directory, SSIS, SQL Upgrade Advisor, Solar Winds, VMware3.5, Diagnostic Manager, Microsoft Reporting Services, Power shell, Microsoft SQL Server Integration Services(SSIS), PAL, DMV’s, Octopus.

Sr. SQL DBA/Developer

Confidential, King of Prussia, PA

Responsibilities:

• Involved in installing and configuring of SQL server 2008 and 2008R2 on standalone and clustered environments.
• Installed SQL 2008 standard edition with SP1 for testing present application and migrating test databases to test any upgrade issues.
• Disk swap on existing clusters
• Build 5 Node active passive cluster to use resources more effectively
• Work on effective solutions to bring data from M/F to SQL server
• Hands on experience in red gate data compare, schema compare and data generator
• Task lead for migration of data from three sources two SQL databases and a pro flat file database to two new SQL databases.
• Installed Idera diagnostic manager to monitor all PROD servers
• Involved in data modeling, designing and building relational databases using Erwin tool.
• Implemented database mirroring between primary server and a standby server.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space and implemented an e-mail notification solution to be notified when a threshold or error is encountered.
• Involved in resolving dead lock issues and performance issues.
• Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
• Disk configuration to implement availability and reliability, which usually transfers into Redundant Array of Inexpensive Disks (RAID) and Storage Area Network (SAN)
• Experience in installing and configuring clustering to provide high availability and scalability.
• Optimized queries and stored procedures for better performance
• Used SQL assistant for writing advance SQL queries, and used xSQL data compare to compare databases and tables for sync between dev, test and production.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Identifying the bottlenecks and troubleshooting it for optimal performance.
• Responsible for MS SQL Server 2008, configuration, tuning and provide support to all production and development servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured transactional replication between primary server and three read only servers, with separate distributor server and experience in troubleshooting replication problems.
• Extracted, transformed, and loaded data (ETL) by Writing SQL queries, running queries, exporting data, importing and scrubbing data with Excel or Access
• Successfully migrated SQL 2000 DTS packages to SSIS using DTS xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Running index tuning wizard and rebuilding indexes for faster query response.
• Created the logical and physical data modeling using Erwin tool.
• Maintain operators, categories, alerts, notifications, jobs, job steps and schedules. Monitor connections, locks and performance of SQL server.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL accounts).
• Created documentation to install SQL server, apply service pack, hot fix and clustering installation.
• Worked with various tasks of SSIS like transform data task, execute SQL task, and active script task etc.
• Expertise in security issues such as creation and granting permissions on various objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Scheduling SSIS packages, Fuzzy Look-up for cleaning bad data, validating data using SSIS wizard

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003 servers, Active Directory, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services,VMware3.5, Diagnostic Manager, Microsoft Reporting Services, UNIX, Power shell, Microsoft SQL Server Integration Services(SSIS), Litespeed

SQL DBA

Confidential, Richmond, VA

Responsibilities:

• Installation and configuration of SQL server 2008 and 2008R2 on standalone and clustered environments.
• Configured SQL server clustering, log shipping, mirroring and replication.
• Implemented active\passive and active\active clustering and installed SQL 2008R2 for production application support.
• Worked on datacenter migration from VA to St. Louis.
• Using upgrade advisor analyzed and resolved all the issues encountered in migrating from SQL Server 2000 to SQL Server 2008.
• Using DTS xchange tool to convert DTS packages to SQL Server 2008 SSIS packages.
• Implementing database standards and naming convention for the database objects.
• Converting and deploying of existing DTS packages to integration service (SSIS) packages over the development, testing and production environments.
• Using Microsoft business intelligence development studio for creating ETL packages and reports. Creation of SSIS packages to extract, transform and load into the campaign database
• Ensured constraints and writing triggers to apply business rules. Performance tuning, backing up and restoring user databases.
• Involved in designing and implementation of data warehousing solution which includes Building an OLAP database, creating data source.
• Configured and maintained transactional for different environments and also setup the jobs to capture the latency instead of using tracer tokens
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS
• Managed databases on multiple disks using RAID technology.
• Developed T-SQL stored procedures/functions to process data and populate them in the appropriate destination tables.
• Setup change data capture on replicated tables
• Create MDW database to monitor all the instances of SQL server
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Configured and maintained transactional and merge replication for different environments.
• Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
• Expertise in monitoring and troubleshooting SQL server performance issues.
• Worked on various tools like SQL LiteSpeed for backups.
• Tuning of slow running queries or inefficient queries for optimal performance using SQL profiler and managing indexes and statistics.
• Monitoring the database server's health and tuning accordingly.
• Provided 24 x 7 production supports for the database and application issues.

Environment: MS SQL Server 2008, 2005, 2000, BPA, Performance Dashboard, T-SQL, SSIS, SSRS, DTSxChage tool, TSM,TSRM and Windows 2008/2003/2000 Servers.

SQL Server DBA

Confidential, Webster, MA

Responsibilities:

• Involved in installing and configuring of SQL Server 2005.
• Installed SQL 2008 standard edition with SP1 for testing present application and migrating test databases to test any upgrade issues.
• Involved in Data modeling, designing and building relational databases using Erwin tool.
• Implemented Database Mirroring between primary server and a standby server.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space and implemented an e-mail notification solution to be notified when a threshold or error is encountered.
• Involved in resolving dead lock issues and performance issues.
• Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
• Experience in installing and configuring clustering to provide high availability and scalability.
• Optimized queries and Stored Procedures for better performance
• Used SQL Assistant for writing advance SQL queries, and used xSQL data compare to compare databases and tables for sync between dev, test and production.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Identifying the bottlenecks and troubleshooting it for optimal performance.
• Responsible for MS SQL Server 2008, configuration, tuning and provide support to all Production and development servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Used performance monitoring tool fog light for to check the health of the databases and instances.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Successfully Migrated SQL 2000 DTS packages to SSIS using DTS Xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Created the logical and physical data modeling using Erwin tool.
• Generated SQL scripts using windows power shell to generate table creation scripts and backing up the database with a windows powershell script
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003 servers, Active Directory, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, Diagnostic Manager, Microsoft Reporting Services, UNIX, Power shell, Microsoft SQL Server Integration Services(SSIS), Litespeed

SQL DBA

Confidential, Madison, WI

Responsibilities:

• Responsible for MS SQL server 2005, configuration, tuning and provide 24 X 7 dedicated support to all production, development and clustered servers.
• Involved in data migration from SQL 2005 to SQL 2008.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Prepared technical specifications for the development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Resolved the SQL server 2005 upgrade hurdles and successfully migrated SQL 2000 DTS packages to SSIS using upgrade advisor and package migration wizard.
• For complex packages like password protected packages, packages created using SQL native client used DTS Xchange tool.
• Worked as project lead on the actual tools and custom code upgrade/conversions as well as lead on actual deployment team.
• Developed advanced queries, triggers, views, and indexes using T-SQL
• Installation of replication server, configuration and monitoring the replication, implemented transactional replication writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production
• Created logical and physical data modeling for development database using ERWIN tool.
• Wrote and integrated stored procedures to generate the reports.
• Specialized in designing clusteringenvironments (active/passive and active/active) to further increase scalability and stability of business critical systems.
• Wrote complex stored procedure, queries, triggers, functions, user-defined functions and cursors for application.
• Created different types of reports such as drill-down, summary, form, OLAP and sub reports, and formatting those using SSRS 2005.
• Experience in creating parameterized reports and linked reports with thorough knowledge of report serving architecture. (table, chart and matrix report)
• Additionally, designed and implemented a disaster recovery system.
• Running index tuning wizard and rebuilding indexes for faster query response.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL accounts).
• Prepared estimates for database, table size growth.
• Setting up, configuring and troubleshooting Log shipping for databases on disaster recovery (DR) servers.
• Expertise in security issues such as creation and granting permissions on various objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Monitoring the event logs and server error logs for troubleshooting.

Environment: Windows 2003 Server, SQL 2005 / 2008 Enterprise Edition, Oracle 10g,SSRS, SSAS, SSIS, Performance Point Sever 2007,T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Jr.SQL DBA

Confidential

Responsibilities:

• Involved in installing and configuring of SQL Server 2000 and 2005, both in unattended and remote installations.
• Involved in data modeling, designing and building relational databases.
• Transferred data from Oracle to SQL server using SSIS.
• Implemented database mirroring.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins with permissions in SQL server 2005 as per the developer’s request.
• Created linked servers between SQL server 2000/2005 and Oracle servers in the environment.
• Involved in migrating the backup jobs from SQL server to Lite Speed
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Involved in resolving dead lock issues and performance issues.
• Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Identifying the bottlenecks and troubleshooting it for optimal performance.
• Responsible for MS SQL Server 2000, configuration, tuning and provide 24 X 7 dedicated support to all production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured transactional replication between primary server and three read only servers, with separate distributor server and experience in troubleshooting replication problems.
• Resolved the SQL server 2005 upgrade hurdles and successfully migrated SQL 2000 DTS packages to SSIS using upgrade advisor and package migration wizard.
• For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL accounts).
• Prepared estimates for database, table size growth.
• Created documentation to install SQL server, apply service pack, hot fix and clustering installation.
• Expertise in security issues such as creation and granting permissions on various objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Wrote and integrated stored procedures to generate the reports.

Environment: Microsoft SQL Server 2005, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SSRS, Crystal Report v9.0, VB.Net, Windows XP, Office 2003.