SUMMARY

• MS SQL Server Administrator with around 7 years of experience in the IT industry, Challenging position in Server administration and technical maintenance with the state of the art technology where my managerial, analytical, problem solving skills and application knowledge can be put in for successful execution of projects.
• Senior MS SQL Server DBA with Extensive knowledge in Managing SQL Server environment
• Around 7 years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2012, 2008 R2, 2005, 2000 and 7.0 in Production, Development & Replication Environments.
• Extensive experience in installation, configuration, and maintenance of MS SQL Server 2012/2008 R 2/2005/2000/ 7.0
• Proficient experience in Upgrading and migratingfrom SQL server 2000/2005/2008 to SQL server 2008 R2/SQL 2012
• Expert working in Virtual Environment using VMWARE for SQL Server.
• Experienced in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities and AlwayOn high Availability of MS SQL Server 2012/2008 R2/2005 to provide robust database solutions.
• Expert in Active/Passive and Active/Active Clustering, Expert in implementing log shipping and Expert in implementing database mirroring.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
• Experience in Managing Security of SQL Server 2000/05/08 by creating Database Users, Roles and assigning proper permissions according to business requirements
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services(SSIS),Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
• Experience with Reporting Services (SSRS) and Analysis Services (SSAS).
• Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions.
• Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
• Proficient in troubleshooting database issues.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
• Team player with Good communication, interpersonal and business analysis skills.

TECHNICAL SKILLS

Operating Systems: Windows 2008 server, Windows 2003 Server, Windows 2000 Advance and Professional Servers and Windows NT 4.0.

RDBMS: SQLServer2012/2008R 2/2008/2005/2000 , MS Access., DB2

SQLServer Tools: SSMS, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer,SQLProfiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan, BIDS

Database Tools: Profiler, Query analyzer, SSRS, SSIS, SSAS.

Languages: C, T-SQL

Third Party Tools: Erwin, Visio, Quest Litespeed, DB Artisan. Visual Source safe4.0/6.0, Spotlight

Web technologies: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0), MOSS2007

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr. SQL Server DBA

Responsibilities:

• Managed 200+ Production, Dev, UAT, QA and SIT SQL Servers in Virtual and Physical Environments.
• Designed new databases architecture according to Business requirements like logical design and physical design.
• Actively involved in Migration of SQL Server and related applications from SQL Server.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements.
• Created and Migrated DTS SSIS packages from SQL server to SQL Server respectively
• Good experience with Report Manager, Report Builder, Report Security and Report Designer.
• Involved in migration of SQL Server 2005 to SQL Server 2008.
• Extensively involved in Database Mirroring inSQL2008.
• Extensively Involved in Log Shipping inSQL2005.
• Involved in semiannual Disaster Recovery Testing drills.
• Extensively worked on Capacity Planning.
• Maintaining both DEVELOPMENT and PRODUCTION servers in sync.
• Creation and Deployment of Ad-hoc and Drill-Down Reports to satisfy business and managerial needs.
• Creating databases, designing the constraints and documenting the requirements
• Creating Back up Strategies, and scheduling them for execution.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Analysis coding and design of different forms(JSP,HTML,JavaBeans,Struts)
• Worked as a member of J2EE and weblogic installation and support team.
• Prepared JUnit test cases.
• Perform peer document review and code review.
• Experience in Understanding structured data analysis, data models, data normalization.
• Implemented Transactional Replication between primary server read only server with separate distributor server
• Configured the Log shipping and created the Standby server.
• Checked the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance.
• Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize
• Involved in Query optimization and overallSQLserver Performance improvement
• Involved in numerous overnight implementations and upgrades.
• MonitoredSQLLogs to ensure success of schedules, jobs, and backups.
• Worked on Command prompt utility like SQLCMD, ISQL, OSQL, and BCP.
• Extensively worked on Performance tuning of stored procedure.
• Involved in Monitoring Performance of different production servers
• Subscribe SQL server Azure cloud services
• Create database on SQL Azure
• Create manage SQL server Azure database
• Setting up connection strings and connecting SQL server Azure database from locally installed SQL sever management studio for developers.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, SQL server Azure,Windows Server 2008 R2, 2008, 2003.

Confidential, Pennsylvania, PA

Sr. SQL Server DBA / Developer

Responsibilities:

• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Planned and modified the permission issues in the server.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Interacted with concern application team in fixing the problems when ever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Installing packages on multiple servers in SSIS.
• Experience in Database tuning and development to support high transaction ERP applications.
• Performance tuning, and optimization of procedures and queries.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS ( Tabular, Matrix )
• Created the backup schedule for production, test and development servers.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining the users, roles and granting privileges.
• Monitoring and scheduled jobs on production and staging environment.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.

Confidential, Boston, MA

Sr. SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Interacted with Developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC (Testing) machines.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
• Involved in troubleshooting all the performance issues for different database applications.
• Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Documented all the steps and procedures for future references.
• Interacted with concern application team in fixing the problems when ever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Provided 24 x 7 Production support for the database and application issues.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.

Confidential, Atlanta, GA

MS SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Implemented Failover clustering for Active/Active and Active/Passive for HA
• Managed SQL Server Clusters in a SAN environment
• Implemented Database Mirroring on SQL Server 2008 environments for DR/HA .
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to 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
• 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 the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• 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.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.

Confidential

SQL Server DBA

Responsibilities:

• Upgraded most of SQL Server 2000 to SQL Server 2005.
• Involved with upgrade of databases from in a Clustered environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Planned and modified the permission issues in the server.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server Reporting Services (SSRS).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining the users, roles and granting privileges.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Performed analysis and design of the application.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
• Backing up system & user databases and restoring them. Did the database administrative job of Security, Backup/recovery, ODBC connections etc.
• Involved in Monitoring Performance of different production servers. Implemented Database mirroring for disaster recovery.

Environment: MS SQL Server 2005/2000, SSIS, SSRS, SSAS, Windows Server 2003, 2000.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
• Involved in creating tables, views, indexes, cursors and stored procedures.
• Involved in creating data models and designing logical and physical models of database.
• Upgraded SQL server 2000 to SQL Server 2005 on standalone and clustered environments and applied service pack.
• Involved in designing the system models using UML and ER Diagram.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Worked with developers to do the database schema changes and database restore requests.
• Creating, maintaining the users, roles and granting privileges.
• Worked closely with the developers’ team and the end users while the system is being under development phase.
• Gave training sessions to the end users for the new product such as using the product.
• Involved in writing queries and optimizing the performance of the queries.

Environment: MS SQL Server 2005/2000, Waterfall, Windows Server 2000.