PROFESSIONAL SUMMARY:

• Highly motivated with 10 years of Professional experience in the IT industry specializing in Microsoft SQL Server Database Administrator in Production, Development and Testing environments in Auto, Finance, retail, and Manufacturing domains. Proven ability to solve a wide variety of software and business issues. Excellent analytical, organizational, multi - tasking, planning and problem solving skills. Operate well independently or within a team.
• Expertise in Installation, upgrading, configuring, managing, monitoring databases SQL Server 2014/2012/2008 R2/05/00 on Windows 2008/03/00 servers built on Clustered VMware and Physical servers.
• Expert in Migration of SQL Server between different SQL Versions and Data Center Migration.
• Experience in Design, Platform Architect, Consolidation and Virtualization of new environments.
• Expert in Design and Implementation of High Availability/DR Solutions by using different techniques (AlwaysOn Availability Groups, Mirroring, Log Shipping, Clustering, Replication) across different Servers\Data Centers
• Experience in Designing/Implementing Database Backup Strategies.
• Experience in Performance Monitoring and Tuning Long Running Queries/CPU, MEMORY/DISK IO
• Experience in database performance tuning, Tuning Indexes, Table structures and query optimization, Execution Plan Analysis, data integrity and Table statistics, setting up SQL Profiler Traces, capturing events, Tuning Deadlocks, Blockings.
• Hands on Experience in Configuring appropriate Transactional Isolation Levels for appropriate Transaction Management and resolve resource contention issues on Production Databases
• Tested and applied latest service packs and hotfix for SQL Server on SQL Failover Clusters and Standalone database instances.
• Expertise in Performance Tuning Database Objects, Indexes, Partitions, and analyzing the Execution Plans with help of Dynamic Management Views (DMV’s) and automating tasks with help of Shell Scripts.
• Detecting Deadlocks, Blockings, stored procedure calls and Tuning Transaction Isolation Levels for Concurrent Execution of Critical application workloads.
• Partitioned large tables within Multiple Files and File groups by implementing various partitioning strategies (Partition schemes and Partition functions)
• Expert in Design Comprehensive Disaster Recovery solutions, Backup-Restore Strategies to Production Databases.
• Experience in developing drilldown reports and Drill through in SSRS
• Extensive experience in T-SQL: stored procedures, triggers, functions, tables, views, indexes and relational database models.
• Hands on experience with CDC, Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-catch blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Very good skillset as a developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Good Experience with SSIS Package Configurations, Logging, Package deployments using Manifest files, and scheduling package execution.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Good communication and written skills and can handle multiple projects simultaneously and 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Operating Systems: MS-DOS, WindowsServer

RDBMS/Databases: MSSQL Server 2000/2005/2008/2012/2014 ,Oracle 8i/9i, 10g

Data modeling and ETL Tools: SSIS, DTS

Reporting Tools: SSRS, MS Excel

Packages: MS Office, Visual Basic

Languages: C, SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, South Brunswick, NJ

SQL Server DBA

Responsibilities:

• Installed and maintained of SQL Server 2014, 2012 and 2008R2 on Test, Development and Production environments.
• Installed and administered two node Active/Active cluster on MS Windows Server 2008 R2 Enterprise database Servers.
• Involved in SQL Server 2008 R2 to SQL 2014 migrations and upgrades.
• Implemented normalization principles, logical and physical modeling, database design principles, tuned queries, stored procedures, and provided production support.
• Implemented logshipping, Replication as Disaster Solution and used Clustering for High Availability.
• Setting up proactive database monitoring using centralized tools asIdera Diagnostic Manager, Batch scripts, and jobs.
• Worked on performance monitoring and health checks for SQL Servers.
• Executed SQL Server Integration Services packages using SQL Server Agent Job for building high performance data integration.
• Partitioned large tables into multiple file groups and compressed data using Row and Page level compression and switched out yearly partitions on a scheduled basis.
• Created stored procedures and Functions accordingly the requirement.
• Implemented SQL scripts by using cursors, case statements and temp variables.
• Created SQL jobs for the backups on all the servers using a script.
• Configured managed Log shipping on more than 10 different servers.
• Used BMC Remedy to schedule database health notifications, Prod changes.
• Used third party sync back tool to transfer various (including backup) files among the servers in the environment.
• Created Reports through Reporting server (SSRS) accordingly the business requirement.
• Deploy the reports on the requested servers.
• Created SSIS Packages to load the data from various Databases and Files.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Performed daily tasks including backup and restore.
• Improved performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan.
• Checking Database Health by using DBCC Commands and DMV’s.

Environment: MSSQL Server 2014, 2012, 2008 R2, 2008, 2005, T-SQL, SSIS (ETL), SSRS, BMCRemedy, Synkback, Windows 2012 R2, 2008 R2 Server, C#, Sharepoint, TFS.

Confidential, Hopkins, MN

SQL Server DBA

Responsibilities:

• Managing and administering around 150 SQL server instances which include 2008/2008 R2/2012.
• Migration and up gradation of databases from old versions to SQL2008 R2 and SL2012.
• Installed SQL server 2008 R2through command Prompt considering the business policy.
• Used SCOM Monitoring tool for SQL.
• Performed database backups and restoration as needed.
• Created SQL jobs for the backups on all of the servers using a script.
• Configured managed Log shipping on more than 10 different servers.
• Involved in configuring availability groups in SQL 2012.
• Implemented maintained Always ON new concept in SQL 2012.
• Configured and managed the cluster environment.
• Considering the test cases while using the SCOM tool during SQL server installations.
• Created stored procedures and Functions accordingly the requirement.
• Implemented SQL scripts by using cursors, case statements and temp variables.
• Used inline- variable statements in the SQL queries.
• Compare the cost difference in between the old and new code for the stored procedures.
• Optimized stored procedures to get the performance.
• Used profiler to find the slow running queries to get the performance.
• Created SQL logins for windows authentication and SQL authentication.
• Created database users same as login as well as different when requested.
• Find and fixed Orphan users during the restoration of the database.
• Experience in data modeling physical data modeling and logical data modeling by using ERWIN tool
• Created SSIS new packages and modified existed packages.
• Upgraded few of the SSIS packages from SQL 2008 to SQL2012.
• Created Reports through Reporting server (SSRS) accordingly the business requirement.
• Deploy the reports on the servers where users can use.
• Created SQL jobs and assigned the SSIS packages to follow the schedules.
• Implemented installation documents for the future reference.
• Used BMC Remedy ticketing tool for Prod changes, creating database in shared environments.
• Involved using BESR backup tool in drives level.

Environment: MSSQL Server 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, SSIS (ETL), SSRS, BMCRemedy, Windows 2008 R2 Server.

Confidential, RI

SQL Server DBA,

Responsibilities:

• Managing and administering SQL Server instances which include 2000 to 2012.,
• Migration and upgradation of databases to different version.
• Implemented maintained Always on new concept in SQL 2012.
• Managing the database server’s security as per the MSB policy standards.
• Managing all aspects of physical SQL Server database administration which includes Security setup and enforcement,ID creation, installations, upgrades, patching, troubleshooting and tuning.
• Managed regularly scheduled backups and occasionally a database recovery.
• Implemented SQL Data Compression using Sql server 2008 for compressing data and log files, Back up level.
• Working with application development team in implementation of data definition changes and performance analysis of complex T-sql queries.
• Worked with the Table partitioning (Sql Server 2008) mechanism to allow the SQL server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Data Encryption, Table Compression, database Compression and Merge statements.
• Used Policy Based Administration feature (SQL Server 2008).
• Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Worked in Active passive cluster environment as a High availability solution.
• Recovered the system and User databases from suspect mode.
• Performing Backup/Restore to/from Legato server (tape) and Disk.
• Extensively used TSM, litespeed backups.
• Expert in configuring Tempdb.
• Tuning queries which are running slow using Profiler and Statistics IO by usingdifferent methods in terms of evaluating joins, indexes, updating statistics and code modifications.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Created complex stored procedures, Triggers, Cursors, Tables and other SQL Joins and statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking 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.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan.
• Managing Database spread across multiple servers in Production, Development, staging and testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks 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.
• Experience in Routine DBA jobs Backups and Restores.
• Travel off-site several times a year to perform a true disaster recovery test of the company’s most vital systems.
• Supports several application and support teams with numerous on-going projects to create or improve application environments.
• Practicing in 24x7 on call primary pager support.

Environment: MSSQL Server 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, Erwin, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, Windows 2008 R2 Server.

Confidential, DETROIT, MI

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2000 to SQL server 2005, 2008 and 2008 R2.
• Migrated Databases from SQL Server 2000 to SQL server 2005 and 2008.
• Worked in Active-Passive and Active-Active Cluster environment as a High availability solution.
• Created and maintained Database mirroring with automatic failover, Metro Mirroring (SAN Mirroring) and Resilient infrastructure as a High availability
• Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008).
• Worked with SCOM Monitoring
• Created Table Valued Parameters (SQL Server 2008) of a table value data type and be able to pass this variable into a stored procedure.
• Rendered Reports to Microsoft Word using SQL Server 2008.
• Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Used DTSXchange tool for migrating DTS packages to SSIS
• Worked in Active Passive and Active Cluster environment as a High availability solution.
• Performing Backup/Restore to/from Legato server (Tape) and Disk.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively used TSM backup.
• Expert in configuring Tempdb.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMV’s.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks 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.
• Good experience in data modeling and metadata services.

Environment: MSSQL Server 2008, 2005 and 2000, T-SQL, Erwin, ASP.Net, C#, SSAS, SSIS (ETL), SSRS, Windows 2003 Server. 

Confidential, IL

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2008/2005.
• Successfully installed and configured the new version of SQL 2008 in test and development environment.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Involved in analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Having experience on SAN and RAID levels and building SQL Server servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Resolved and tweaked memory pressures caused during product release.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented.
• Expertise and interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• To provide 24x7 production support for SQL Server databases on Clustered Servers.
• Experience in Query optimization, Client/Server Connectivity, Database consistency checks and Index Tuning Wizard.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Designed and Created databases, tables, views,store procedures and triggers.

Environment: SQL Server 2008, 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL Lite Speed, MSE, VSS and Password Updater, Erwin.

Confidential, Fort Lauderdale, FL

SQL Server DBA

Responsibilities:

• Installed and configured more than 2GB RAM in SQL Server 2005.
• Performed the migration of SQL Server 2000 to SQL Server 2005 and database administration.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting 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.
• 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 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.
• Participated in the entire phase of Software Development Life Cycle process
• 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).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Involved in creating and supporting in OLAP Cubes Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, MS SQL Server Reporting Services 2005 (SSRS), DDL, Erwin, SharePoint ASP.Net, ETL, C#.Net, CSS, Java Script, XML, HTML

Confidential

SQL Developer/DBA

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Designed Database objects including tables, procedures, views and database triggers on SQL Server Database.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created many complex Stored Procedures and used them in Crystal Reports.
• Create SQL logins in windows and SQL authentication mode as well as users as per the request.
• Implemented back up strategy and automated the process for full, diff and log backups in timely fashion.

Environment: SQL Server 2000, Microsoft Visual Basic 6.0 and Windows 2000, DDL, ETL