SUMMARY

• IT Professional with 9+ years of Administration Experience on MS SQL Server 2 R / 2000 systems in OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2012, 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Implemented SQL Server Always ON Feature in SQL Server 2012and also configured Always ON Availability Groups.
• Acquaintance in supporting Very Large databases (VLDB) up to 1.5TB and troubleshooting the problems in OLTP Environment.
• 24 X 7Production Database on Call Support.
• Implemented different types of High Availability & Disaster Recovery models like Clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Implemented & managed Active - Active and Active-Passive Clustering, Failover and Load Balance technologies.
• Implemented Mongo DB to store log file data and migrated data into the database and Participated in Architecture and Design sessions using Best Practices.
• Expertise in Side-by-Side Migrations of MS SQL SERVER 2000/20 /2008/2008 R 2/2012/2014.
• Worked in an environment with more than 1000 databases to handle.
• Experience in implementing various RAID 1, 5 and 10 technologies.
• Proficient in SQL Server 2008 features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Worked on Linux Cluster and supported Network team in installation.
• Implemented the SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs and Alerts, Database Tuning Advisor.
• Implemented PostGreSQL Enterprise DB 9.2.10 and migrated existing SQL databases. Automated DBA activities and upgraded existing databases.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Linked Servers, Database Maintenance Planning. Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Sound knowledge in writing complex SQL Queries, stored procedures, creating Indexes, Indexed views, file group modifications, User Defined Functions (UDF), Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and update statistics in databases.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach.
• Prowess in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
• Experience in developing and tuning SQL Server Integration Services (SSRS) packages and also Configuring and maintaining Report Manager and Report Server.
• Proficient in high level design of ETL, DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Aggregate, Data Conversion, Conditional Split, Bulk Insert Fuzzy Grouping, Fuzzy Lookup, OLEDB Command and Merge.
• Experience in creating deployment utility to Deploy SSIS Packages over Production and QA Systems.
• Expertise in using Temporary Tables, Table Variables, CTEs and Data Dictionary.
• Knowledge in Creating Report Subscription, Data Driven Subscription, Report Snapshots and caching, linked, cascaded and parameterized reports, complex drill down reports using SQL Server reporting services.
• Knowledge in designing, creating, processing ofCubesusingSSASand using MDX Queries.
• Knowledge in data warehouse modeling (designingStar Schema, snowflakeschemas with identifyingFacts and Dimensions).
• CreatedLinked ServersbetweenSQL Server & Oracle 9i and 10g. Also createdDTS packagefordata transfer between the two environments.
• Handled numerous Change Management requests on production servers.
• Flexible, Enthusiastic and project oriented team player withexcellent communication skills and analytical skills to develop creative solution for challenging client needs.
• Involved in all phases of the SDLC (Software Development Life Cycle).

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database, Administration of MS SQL Server 2008/2005/2000/ , Oracle, Sybase.

Programming Languages: Transact-SQL, SQL, C/C++, Java and Visual Basic

RDBMS: MSSQLServer 2000/ 2005/2008/2008 R2/2012/2014,MySQL, PostGreSQL 9.2.10,Oracle, MS Access.

Operating Systems: Windows 2000, Windows Server 2003/2008/2008 R2,2012, Windows XP, 7 Pro,Linux,Unix.

Database Tools: SSMS, SQL Server Business Intelligence Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Log Viewer, Database Tuning Advisor, and Upgrade Advisor.

ETL Tools: SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools: SSAS 2005/2008/2008 R2/2012

Web Server: IIS

Reporting Tools: SSRS 2005/2008/2012 , Crystal Reports, MS-Excel

Tools: Active X, IIS, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.x/7.x, Lite Speed, Spotlight, Fog light, Idera, Sharepoint.

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential, Harrisburg, PA

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008 R2/2012/2014 on Production, Development and Test Environments along with configuring the drives according to the standards and policies.
• Capacity planning of databases according to client requirements.
• Supported24 X 7 Production environments and solved many incident Tickets.
• Implemented MongoDB for Log file data and insert huge volume of data. Participated in Architecture and Design sessions using Best Practices.
• Set up Always on Availability Groups as a high availability for group of databases in SQL 2012 instance.
• By using the Availability Groups feature in SQL Server 2012 created DB Mirroring for specific Database.
• Used online indexing and online restoring in SQL server 2008R2 and 2012.
• Worked on very large and complex databases and in a highly transactional environment.
• Good hands on experience in applying hot fixes, service packs and repairing SQL Instances.
• Migrating databases from SQL Server R2 and SQL Server 2008R2 to 2012.
• Migrated databases from SQL Server 2005/2008R2 to SQL Server 2008 R2/2012 and Migrated SQL servers from physical to VMware virtual environment.
• Installation of SQL Server 2012/2008/05 and service packs on Windows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents.
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Good hands on experience in upgrading DTS packages to SSIS packages.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2/2012.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Optimized the query performance with modification inT-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2/2012.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used Lite Speed Backup with MS SQL SERVER 2008R2/2012.
• Supported Very Large databases (VLDB) up to 1.5TB and troubleshooting the problems in OLTP Environment.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers IN T-SQL.
• Refactored and fine-tuned the queries and stored procedures in T-SQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for Production Server database as part of the disaster recovery.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA Test environment for testing of new Deployments and Build.
• Worked closely with business and outside vendors to effectively plan, deploy and update database environment changes.
• Good hands on experience in Change Management, Incident and Problem management.

Environment: TSQL, MS SQL SERVER 2000/2005/2008 R2/2012/2014, SSRS, QUERY ANALYSER, VISUAL STUDIO 2008/2012, VB.NET, C#, WINOWS SERVER 2000/2003/2008 R2/2012, IIS.

SQL SERVER DBA

Confidential, Jersey City, NJ

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER /2008R2 on Windows 2003/2008R2.
• Migrated DTS 2000 PACAKGES to SSIS 2008R2 packages and maintained the archival data using Control flow task.
• Installed and administered two-node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition in SAN environment.
• Checking Database Health by usingDBCC Commands and DMVs.
• Maintained Transactional Replication on production servers. Implemented and configured Performance Data Collector.
• Supported Huge volume of databases.
• Configured the AWE and /3 GB switch for the 32 bit 2005 server.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented SQL server 2008 concepts like Data Partitioning, Snap shot Isolation.
• DB snapshot. DDL triggers, Try-Cache Blocks, Online indexing, DMV’s, DTA, SQL CMD and Dedicated Admin Connection, Common Table Expression (CTE).
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used Lite Speed backup with MS SQL SERVER 2005/2008R2.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers in T-SQL.
• Refactored and fine-tuned the queries and stored procedures in TSQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for Production server data base as part of the disaster recovery.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL SERVER 2000/2005/2008 R2, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005/2008, VB.NET, C#, WINOWS SERVER 2000/2003/2008 R2, IIS.

SQL SERVER DBA

Confidential, Phoenix, AR

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2008/05 and service packs on Windows Server Clustered environment. prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases including DTS to SSIS packages and mentored Jr. DBAs and other technical staff.
• Migration from Dev to QA to prod environments
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled upto 1.5 TB Size databases with clustered environment.
• Implemented new features in SQL server 2008 like Policy Based management, table Compression and backup compression, SQL server Auditing, Resource Governor and merge statement in TSQL.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Set up and Monitored transactional replication, Database mirroring on Production, QA and Dev serversand trouble shooting of errors.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modesfor various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyzed execution plans and generated suggestions for improvement.
• To set up SQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configured data partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Worked on Oracle Grid installation.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Handled numerous change management requests on production servers
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL server.
• Created and processed Cubes using SSAS
• Created, scheduled database maintenance planusing SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
• Monitored production environment
• Used Online Indexing and online Restoring in SQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Extensively used Repositories like Team Foundation Server (TFS)
• Supported24 X 7 Production environments.

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, OLAP cubes with SSAS, SSIS. Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server), Windows Server 2000/2005/2008 .

SQL Server 2005 DBA/Developer

Confidential, Warren, NJ

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and standalone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: TSQL, MS SQL SERVER 2000/2005,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2003,IIS,SSAS