SUMMARY:

• 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:

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.

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.

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

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. 

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.

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

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