SUMMARY

• SQL Server DBA with 10 Years of extensive experience in installation, configuration, implementation of SQL Server 2012/2008R2/2005/2000 on stand - alone and clustered instances.
• Extensive experience in designing and implementing High Availability (HA) and Disaster Recovery (DR) solutions like Clustering, log shipping, Replication, Mirroring and Always ON high availability Groups.
• Experience in Backup/ Restoration/ Recovery and Export/ Import of SQL Databases.
• Extensive experience in managing Very Large Databases (VDLB) > 4 terabyte (TB) in a high transaction OLTP environments.
• Extensive experience in SQL server upgrades from SQL /2008R2, SQL R2 and SQL 2008R2 to SQL 2012.
• Extensive experience in managing DBA resources and critical projects to meet/exceed Service Level Agreements (SLAs).
• Experienced as go to Person for SQL Server DBA for Query Optimization, Tracing, Tuning, Designing, Partitioning, Training Activities.
• Experience in Clustering, Encryption, Logical/Physical Standby, Debugging features of SQL Server.
• Experience in Optimizing T-SQL Queries, Creating and Removing Indexes, Updating the existing poor performance Queries.
• Experience in query optimization & performance tuning; SQL Profiler, Execution Plans, Performance Monitor (Perfmon), DMVs and DBCC Commands.
• Experience in T-SQL programming & SSIS to automate routing DBA tasks.
• Expert in usingBulk Copy Program(BCP), Data Transformation Services (DTS)packages andSSIS (integration services)with MS SQL Server 2000/2005.
• Experience in creating SSIS packages. Experience inDTS MigrationandMetadata Management:Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS(SQL Server Integration Services)for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools likeImport and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing and implementing SQL Server Reporting Services (SSRS) and creating SQL Server Reports.
• Experience in creating SQL objects like Tables, Stored Procedures, Views, Indexes, and writing ad-hoc queries for data analysis.
• Experience in designing and developing SSIS packages for automating DBA Tasks such as Database refresh, Database status Checks.
• Experience in creating Active Directory Users and Groups and managing SQL Server security with active directory groups.
• Experience leading offshore teams to deliver mission critical projects on time.
• Experience in capacity planning, SQL patch upgrades (Service packs and Cumulative updates) by coordinating with the application teams.
• Experience in configuration and installation of QUEST SQL server performance analyzer and SQL Optimizer and monitoring SQL server and database performance using QUEST.
• Extensive experience in change management process; Collaborating closely with developers, application owners and infrastructure staff in promoting development code to UAT for user acceptance testing and release in production for validation and user sign off.

TECHNICAL SKILLS

BACKUP AND MANAGEMENT TOOLS: VERITAS NETBACKUP, CommVault

MONITORING TOOLS: SCOM, Autosys

TICKETING TOOLS: Maximo, Service NOW, BMC Remedy

DATABASES: SQL Server 2012/2008R2/2005/2000

OLAPTOOLS: SQLServer Reporting Server2008/2005,SSIS (ETL)

THIRD PARTY TOOLS: Lite speed, Erwin,DB MotoQUEST Performance Analyzer, SQL Optimizer and Perfmon.

MS DEVELOPMENT TOOLS: SQL Query Analyzer, DTS, SQL Profiler, BIDS, DTABCP, SQL Server Management Studio, SSRS, Import/Export Wizard.

OPERATING SYSTEMS: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Professional.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. SQL Server Administrator

Environment: SQL Server 2012, 2008, 2005, 2000, T-SQL Programming, SSIS, DTS, SSRS, DMV.

Responsibilities:

• Installed SQL Server 2008R2/2012 cluster/standalone on Virtual servers in Production, UAT and development environments.
• Performed Database Upgrades from SQL Server R R2 and 2008R2 to 2012.
• Migrated of DTS packages to SSIS, and provided support to the development team in resolving the issues during migration.
• Configured and installed Quest performance analyzer\SQL Optimizer across the production and development environments.
• Created SSIS packages and SQL Agent jobs to automate data refreshes from production to UAT servers.
• Designed and Developed Clustering, Encryption features in SQL Server 2008 and 2012.
• Implemented both Symmetric and Asymmetric Encryption Keys for different Data Models in SQL Server Databases.
• Implemented both Physical and Logical Databases in SQL Server for Optimizations, Reporting’s and Data Guarding’s.
• Implemented Clustering features in SQL Server with Nodes and Functions.
• Implemented 4 Cluster Server Nodes for each division of Client.
• Worked on multiple projects simultaneously including DB upgrades, migrations, and server builds for new applications.
• Configured Log shipping to run the reports on secondary database.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
• Implemented and Managed Performance Tuning Tasks with Developers in Optimizing the Long Run Queries.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures, Indexes and Triggers.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor (Perfmon) to identify bottlenecks.
• Implemented System wide Security Policies & trouble shooting methodologies.
• Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database Mirroring, Log Shipping, High Availability Groups and Replication.
• Collaborated closely with application owners and developers on issues such as capacity planning, SQL Server upgrades (Service Pack, hotfix patch upgrade etc.) and weekly production releases.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Configured and managed SQL Server transactional replication and troubleshoot issues.
• Performed ad-hoc database backups and restores and fixed orphaned logins.
• Maintained security policies. Managed Logins and User: adding logins roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Assisted Developers in T-SQL Queries, Indexes, Performance Tuning and Optimizations.
• Tuning queries which are running slow using Profiler, Perfmon and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Tuning of the Stored Procedures\queries for better performance.
• Checked Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Prepared Documentation for theDisaster Recovery plan
• Designed Data Integrity jobs with Error Handling and email notifications.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Confidential, NJ

Sr. SQL Server Administrator

Environment: SQL Server 2008, 2005, 2000, T-SQL Programming, SSIS, DTS, SSRS, DMV.

Responsibilities:

• Installed SQL Server 2000, 2005 and 2008R2 across all tiers.
• Performed migration of SQL Server 2000 to SQL Server 2005 and .
• Developed and Performed Database Backups, Integrity Checks, Indexing Updates, and scheduling jobs.
• Troubleshooter and monitored SQL performance issues and Optimized the Long Running Queries.
• Developed SSIS packages to extract, transform and load data into the destination MS SQL database from Excel\Access\SQL databases. Also, created the T-SQL stored procedures/functions to process the data and populate them in to appropriate destination tables.
• Assist developers on database related issues and also T-SQL Programming Issues and Query Optimizations.
• Created Weekly, Monthly, Quarterly Database Cleanup tasks by analyzing the Poor Performance Queries, Locks and Indexes.
• Implemented new Alerts and Reports written using T-SQL and sent periodically.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution using log shipping, Replication, Mirroring and Always ON high availability Groups
• Monitored and trouble shoot Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction, also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Designed and Developed Clustering, Encryption, Physical and Logical features in SQL Server 2008.
• Developed Symmetric and Asymmetric Encryption Keys for different Data Models in SQL Server Databases.
• Implemented both Physical and Logical Databases in SQL Server for Optimizations, Reporting’s and Data Guarding’s.
• Implemented Clustering features in SQL Server with Nodes and Functions on Shared Disk and Mirrored Disks.
• Set up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, Perfmon, SQL Server Agent, and Database Engine Tuning Advisor.
• Applied patches and service packs to keep the database at current patch level.
• Monitored table, disk utilization, and database fragmentation on a periodic basis.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Experience in maintaining the database consistency with DBCC at regular intervals.

Confidential, NY

SQL Server Administrator

Environment: SQL Server 2005, 2000, T-SQL Programming, SSIS, DTS, SSRS, SSAS, DMV, VERITAS Net Backup.

Responsibilities:

• Performed Business Analysis, Technical Analysis, Systems Design, Application Software Programming on MS SQL Server 2000/2005 and T-SQL Programming
• Prepared Data Flow Diagram's & Entity Relationship(ER) diagrams for MS SQL Server Management Studio.
• Restructured the Stored Procedures, Designed and developed Queries and Packages using the T -SQL Programming.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Implemented Asymmetric Encryption Keys in SQL Server Databases.
• Implemented Logical Databases in SQL Server for Optimizations, Reporting’s and Data Guarding’s.
• Implemented Clustering features in SQL Server with Nodes and Functions.
• Unit Tested the SSIS packages with respect to its flow and performance issues.
• Created, Removed and rebuilt the indexes at regular intervals for better performance of Queries and Packages.
• Assisted the Development Team on T-SQL Programming and periodically cleaned up the data base with Dead Locks, Poor Performance Queries and Indexes.
• Trained Users and Development Teams on T-SQL Programming Methodologies and Code Frameworks.
• Monitored and modified Performance using execution plans and Index tuning.
• Managed the VERITAS net backups.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Completed documentation about the Database. Recovering the databases from backup in disasters.
• Exported or Imported data from other data sources like flat files using Import/Export through DTS, SSIS.
• Monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Confidential, TX

SQL Server Administrator

Environment: SQL Server 2005, 2000, T-SQL Programming, SSIS, DTS, SSRS, SSAS, DMV, VERITAS Net Backup, LiteSpeed Backup.

Responsibilities:

• Installed and configured more than 2GB RAM in SQL Server 2005.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Implemented Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Implemented SQL Server Analysis Services and OLAP Cubes
• Managed VERITAS net backups and Litespeed backups.
• Maintained the database consistency with DBCC at regular intervals.

Confidential

SQL Server Administrator

Environment: SQL Server 2005, 2000, T-SQL Programming, SSIS, DTS, SSRS, SSAS, DMV, VERITAS Net Backup.

Responsibilities:

• Responsible for installation, configuration, and maintenance of MS SQL Server on various environments.
• Responsible for Performance and tuning of SQL servers and application issues related to migration.
• Responsible for applications for performance, data integrity, validation issues and data Transfers between various servers using BCP.
• Wrote stored procedures, Triggers, Packages, Created Indexes, Tuned the Long Running Queries, Code Standards and Methodologies using T-SQL Programming.
• Responsible for routine Backups and Restoration of SQL Server Databases.
• Implemented Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures.
• Administered 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.
• Monitored MS SQL Server performance and managed the use of disk space, memory and connections.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Implemented the MS SQL Server Management Studio Package with SSIS, SSRS and SSAS.Wrote SSIS Packages for Data Import / Export and Reports using SSRS.
• Ran DBCC consistency checks, fixing data corruption on application databases.
• Monitored and tuned T-SQL scripts. Created upgrade scripts for Production database and supporting it.
• Audited stored procedures for optimization and improving performance.
• Designed database maintenance plans, profiler and execution plans for stored procedure development and indexes for optimizing performance.
• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Worked to establish connectivity between VB applications and MS SQL Server by usingODBC.

Confidential

SQL Server DBA

Environment: SQL Server 2000, T-SQL Programming, SSIS, DTS, SSRS, SSAS, DMV.

Responsibilities:

• Installation, configuration and upgrading of Microsoft SQL Server software and related products.
• Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning.
• Maintained of different application databases and tuned to avoid blockings and improve the performance.
• Import and Export data using DTS into SQL Server 2000
• Worked on Database upgrades and patches
• Retrieved data from SQL Server 2000 for various applications and creating stored procedures, Triggers, Indexes using T-SQL Programming.
• Responsible for space allocation, backup strategies, table maintenance.
• Implement and maintain database security (create and maintain users and roles, assign privileges).