SUMMARY

• MS SQL Server Administrator wif around 7 years of experience in teh IT industry, Challenging position in Server administration and technical maintenance wif teh state of teh art technology where my managerial, analytical, problem solving skills and application noledge can be put in for successful execution of projects.
• Senior MS SQL Server DBA wif Extensive noledge 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 migrating from 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 wif 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 wif 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 wif 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 ofSQLServer and related applications fromSQLServer.
• Deployed teh SSIS Packages to teh MSDB as well as File System depending on teh requirements.
• Created and Migrated DTS SSIS packages fromSQLserver 2000 2005 toSQLServer 2005 2008 respectively
• Good experience wif Report Manager, Report Builder, Report Security and Report Designer.
• Involved in migration ofSQLServer 2005 toSQLServer 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 teh constraints and documenting teh 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.
• Experience in Understanding structured data analysis, data models, data normalization.
• Implemented Transactional Replication between primary server read only server wif separate distributor server
• Configured teh Log shipping and created teh Standby server.
• Checked teh configuration and performance of teh existing databases including data file allocation, index, fill factor, fragmentation and teh 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

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, 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 teh Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned teh Complete Backing up of Database and restoring teh Database from Disaster Recovery.
• Planned and modified teh permission issues in teh 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 wif concern application team in fixing teh 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 teh backup schedule for production, test and development servers.
• Fine tuning teh Database Settings as well as teh Server Settings.
• Configured Mail Profile for sending automatic mails to teh respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining teh users, roles and granting privileges.
• Monitoring and scheduled jobs on production and staging environment.
• Experienced in troubleshooting production servers and fixed teh 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 wif application team at teh time database migration from SQL Server 2005 to SQL Server 2008.
• Interacted wif 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 teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS)
• Documented teh 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 teh 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 teh wizard utility in SQL Server 2008.
• Documented all teh steps and procedures for future references.
• Interacted wif concern application team in fixing teh 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 teh Execution Plan to improve teh optimization of teh 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 teh 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 teh 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 teh standard documents for Disaster recovery testing and implemented them.
• Experienced wif database sizing and capacity planning for production servers.
• Experienced wif creating logical and physical database design for development projects.
• Experienced wif improving SQL Server using windows performance monitor to improve teh server performance.
• Created teh DTS, SSIS packages to import teh 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 teh backup schedule for production, test and development servers.
• Worked wif developers to do teh database schema changes and database restore requests.
• Involved in restore operations to refresh teh data from production to test servers.
• Experienced in troubleshooting production servers and fixed teh 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 wif upgrade of databases from 2000 to 2005 in a Clustered environment.
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned teh Complete Backing up of Database and restoring teh Database from Disaster Recovery.
• Planned and modified teh permission issues in teh server.
• Designed a report on teh monitoring of SQL Server Performance. This report gives a detail report to teh management on teh Performance of teh server.
• Worked wif SQL Server Reporting Services (SSRS).
• Created Database Maintenance Planner for teh 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 teh MS SQL Server by creating user logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Involved in Performance Tuning on Production, QA and Staging servers of teh current project.
• Fine tuning teh Database Settings as well as teh Server Settings.
• Configured Mail Profile for sending automatic mails to teh respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining teh users, roles and granting privileges.
• Created teh backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for teh 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 teh application.
• Database and Transaction log backups & restoration, backup strategies, scheduling teh backups. Backing up system & user databases and restoring them. Did teh 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 teh system models using UML and ER Diagram.
• Performance tuning, and optimization of procedures and queries.
• Worked wif SQL server Profiler.
• Worked wif developers to do teh database schema changes and database restore requests.
• Creating, maintaining teh users, roles and granting privileges.
• Worked closely wif teh developers’ team and teh end users while teh system is being under development phase.
• Gave training sessions to teh end users for teh new product such as using teh product.
• Involved in writing queries and optimizing teh performance of teh queries.

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