SUMMARY:

• IT Experience of 8 years in Data Base Administration DBA of Micro Soft SQL Servers 2012, 2008R2, 2005, 2000 in Development, QA/Test, Production and Disaster Recovery Environments.
• Excellent with Business Applications for various Domains viz., Finance, Sales Insurance.
• Good Experience with Database Design of physical models use Data Dictionary Software packages to maintain security, data integrity and eliminate data redundancy/ corrupted data.
• Good Experience with Capacity Planning and Optimum Configuration.
• Significant Expertise with Installation, Configuration, Upgrade/ Side-by-Side Installation of MS SQL Server 2000, 2005, SQL Server 2008 2008R2 and SQL Server 2012 including Hot Fixes, Service Packs.
• Strong in Database Backup, Restore in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery Scheduling the Backup jobs.
• Rich Experience with Migration of Historical Databases from SQL Server 2000 to 2008R2, Control-Z Progress DB to SQL server 2008R2 and Oracle DB to SQL server 2008R2.Also Migration/Upgrade of Databases from SQL server 2000 to SQL Server 2008R2 and SQL Server 2008R2 to SQL Server 2012.
• Excellent with Security Permissions at SQL Server Level, Database Level Windows Level.
• Proficient in Performance Monitoring Tuning using Performance monitoring tool PERFMON ,Running of Traces using SQL Profiler tool for workloads, and Tuning of Indexes Clustered/Non Clustered using Database Engine Tuning Advisor DTA , Query Optimization using Query Execution Plans Index Scan/Index Seek .
• Good at working with Application Development teams for improving the Performance of SQL Server databases optimum storage.
• Executed 3rd Party Tools like SQL Data Compare, DBArtisan for Data Bases Comparison.
• Good experience with Scheduling of Jobs using SQL server Agent, Maintenance plans.
• Significant Expertise with implementation of High Availability Options minimized the Downtime of the Server/System in line with SLAs.
• Thorough Understanding of Table Normalization, Relational Database Management Systems RDBMS , Implementation of SQL server Databases Troubleshooting.
• Strong Experience with Development T-SQL of Databases, Tables, Views, Stored Procedures, Functions, Indexes Clustered / Non-clustered , Joins, Triggers etc.
• Proficient in Implementation of High Availability options like Log Shipping, Mirroring,
• Fail over Clustering Active/Passive , Replication Snapshot / Transactional / Merge / Peer to Peer Replication .
• Good Experience in Building of Data Warehousing using Microsoft SQL Server 2000/ 2005/ 2008/ 2008 R2, 2012 databases and ETL Tool of SSIS Integration Services.
• Rich Experience with Import Data Export Data , SSIS Integration Services 2000 / 2005/2008R2 / SSDT 2012 -ETL tool, SSAS Services 2005/2008R2 , SSRS Services 2005/2008R2 .
• Very Good Experience in Production Support 24/7 Environment for SQL server Database/ logical disk Free space monitoring, attending to Tickets/RFCs resolving the Issues/incidents Day to Day activities of SQL server DBA.
• Flexible, enthusiastic and project oriented Team player with solid leadership skills to develop creative solution for challenging client needs.
• Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause, organized and highly motivated.

TECHNICAL SKILLS:

DETAILS OF PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Installed configured SQL Server 2008 R2 and SQL Server 2012.
• Refreshing the Databases done the Backup Restore
• Long Running Transactions checked Program name, host name , deadlocks if any and fixed the issue
• Open Transactions checked Blocking, deadlocks and fixed the issue
• High CPU Utilization Performance Monitoring Tuning checked the Processor time and any checked unwanted processes and fixed the issue
• High Memory Utilization done the Performance Monitoring Tuning PERFMON , checked the pages/sec, collected workloads by running the SQL Profiler Trace, and analyzed the long running Queries using Database Engine Tuning Advisor-DTA for the Recommendations on improvements on Clustered and Non-clustered indexes on the tables .
• Log Files of more than 80 Size Initiated/scheduled the Tran.Log Backup jobs
• Log Files more than 10GB Initiated/scheduled the Tran.Log Backup jobs
• Low Disk Space on SQL Server Disk Mount Points fixed as per above
• Checked Data files Log File Sizes for any Free Space availability, Shrink the Files, if there is free space. If there is no free space, then advised Windows Infrastructure group to increase the disk space
• Low Disk Space on SQL Drives Checked any Backup files staying in the Backup folder for more than 3 days. Removed the unwanted Backup files for creating more space on the Drive.
• Checked the Alert Notifications Daily alerts and done the Troubleshooting on SQL Server Databases for the following Alerts:
• Checked the Central Reports on SQL Servers daily and raised the Tickets Incident Console and taken the approvals for attending to the Incidents like High Memory / High CPU Utilization, Refreshing the Databases, initiation of Tr.Log Backups, Migration of Databases including Logins, Grant Permissions to new users, Removal of unwanted Logins, Running of Scripts, Starting Stopping of MS SQL Servers, SQL server Agents etc. Closed the Incidents after finishing the Incidents with approvals.
• Attended to CRQs Change Requests raised by others / self for any change required to the SQL server Databases, create new Databases, Alter old Databases , Alter Scripts/ constraints and attended to that during the Maintenance Window and completed the CRQ and obtained the approvals and closed the CRQ.

• Worked with System Administrators/ SQL Developers for Database Design of physical models used Data Dictionary Software packages to maintain security, data integrity and eliminate data redundancy and recovered corrupted data.

• Worked with Application Development team for improving the Performance optimum storage.
• Developed New SQL Inventory for 300 SQL servers, Status of Databases, application, business unit, decommissioned.
• Monitored the Performance of SQL Server 2005, 2008R2, 2012 using Performance monitoring tool PERFMON , collected work loads T-SQL Queries using SQL Profiler Trace, Tuned the Indexes using Database Engine Tuning Advisor and advised the Development Teams on the Recommendations of DTA.
• Implemented Installation configuration of Fail over Cluster Active/Passive , Log Shipping, Mirroring, Replication Snapshot, Transactional Merge, Peer to Peer .
• Done the Migration of DTS 2000 packages into SSIS 2008R2 and migration from SSIS 2008R2 packages to SSIS 2012 Integration Services Packages. I have migrated validated SSIS 2008R2 packages and SSIS 2012 Packages on both Dev Prod .
• Reporting Services are executed using SSRS for the Monthly, weekly , daily Reports.
• Generated Historical Reports using SSAS cubes-Analysis Services.
• Technical Documentation is prepared as per the Company's Policies.

Environment: SQL Server 2008R2, SQL server 2012, Oracle, Windows 2003XP, Windows 2008 R2, PL/SQL, T-SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed configured SQL Server 2008 R2 and SQL Server 2012. Upgrade also is done from SQL server 2000 databases to SQL server 2008R2 databases.
• Backup, Restore operations are done in Full, Simple Recovery Modes, and Restored Databases with Point in Time Recovery.

• Worked with System Administrators/ SQL Developers for Database Design of physical models used Data Dictionary Software packages to maintain security, data integrity and eliminate data redundancy and recovered corrupted data.

• Worked with Application Development team for improving the Performance optimum storage.
• Monitored the Performance of SQL Server 2008 R2 databases using Performance monitoring tool PERFMON ,ran Traces using SQL Profiler, Query Optimization is done index seek/index scan , Tuned the Indexes using Database Engine Tuning Advisor.
• Installed configured Fail over Cluster active to passive instance-I and added Second Instance.
• Implemented the Log Shipping and database Mirroring.
• Implemented Replication Snapshot/Transactional/Merge/Peer-Peer .
• Built several SSIS Packages, Extracted data from multiple Data Sources like SQL server 2000, Excel-Flat Files, MS Access Cleansed/transformed data using control flow task/data flow task elements and loaded on to SQL server Databases by configuring the Connections and Deployment of Packages.
• Analysis Services-SSAS are executed and Historical Summary Reports are generated.
• Reporting Services are executed using SSRS for the Monthly, weekly Reports.
• I worked for the SQL Data Base Migration Upgrade Project for Migration of SQL server 2000 Databases 20nos. of total size: 1000GB into SQL server 2008R2 and migration of Databases from SQL server 2008R2 to SQL server 2012. Deployed the Backups of these Databases to Prod Servers, Restored them upgraded the DB Compatibility levels.
• I have generated T-SQL Scripts for SQL server 2008R2 2012 Databases, Tables, Views, USPs, UDFs, Triggers for SQL server 2008R2 SQL server 2012.Upgraded the Databases to Prod Servers of SQL 2008R2 and SQL2012. Validated the migrated Databases of SQL 2008R2/2012 for Tables Row Counts , Stored Procedures, UDFS, Views, Triggers.
• I have done the Migration of 50 nos. of DTS 2000 packages into SSIS 2008R2 and migration from SSIS 2008R2 packages to SSDT 2012 Integration Services Packages. I have migrated validated 50 nos.of SSIS 2008R2 packages and also SSDT 2012 Packages. I have deployed these 50 Packages on to Prod Servers SSIS 2008R2 SSDT 2012 upgraded and Validated them.
• Obtained Client Sign-Off on all the above upgraded Databases SSIS/SSDT pkgs.
• Preparation of Technical Documentation for the Migration Project.

Environment: SQL server 2000, SQL Server 2008R2, SQL Server 2012, Windows 2000, Windows 2008 R2, Windows 2012, T-SQL, Microsoft C 2010

Confidential

SQL Server DBA

Responsibilities:

• Installed configured SQL Server 2008 R2 and SQL Server 2012.
• Raised Change Requests for Hot Fixes on SQL server 2008R2 and Upgrades.
• Attended to the Alarm Messages / Tickets for different Issues and fixed the issues on a day to day basis. Closed the Tickets after fixing the issues.
• Data Base Monitoring includes checking of the Free Disk Spaces on 29 SQL Servers and raising the Service Tickets for adding the Disk space to the required Drives Backup/Data/Log . Checked the growth of Databases on a daily basis use shrink files method/ reset initial size of data/log.
• Day to Day Activities of SQL Server DBA. Running the Scripts T-SQL on the Prod server.
• Backup, Restore operations are done in Full Recovery Mode, and Restoring Databases with Point in Time Recovery. Snapshots of Databases are taken for TIVOLI Upgrade 7.5 Project.
• Deployed/Tested lot of SSIS Packages .dtsx for web services Project and TIVOLI upgrade project on DEV, QA and PROD and tested them and scheduled the jobs.
• Scheduled the SSIS Jobs thru SQL Server Agent. Fixed the issues of failed jobs.
• Development of Maintenance plans and scheduling the Backups, Rebuild of Indexes, Cleanups, Update Stats.

• Worked with System Administrators/ SQL Developers for Database Design of physical models used Data Dictionary Software packages to maintain security, data integrity and eliminate data redundancy and recovered corrupted data.

• Worked with Application Development team for improving the Performance optimum storage.
• Monitored the Performance of SQL Server 2008 R2 databases which are migrated using Performance monitoring tool PERFMON ,ran Traces using SQL Profiler, Query Optimization is done table scan , Tuned the Indexes using Database Engine Tuning Advisor.
• Involved in Installation configuration Fail over Cluster, Log Shipping and database Mirroring, Replication.
• Reporting Services are executed using SSRS for the Monthly, weekly Reports.
• Technical Documentation is prepared as per the Company's Policies.

Environment: SQL Server 2008R2, SQL server 2012, Oracle, Windows 2003XP, Windows 2008 R2, PL/SQL, T-SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed configured SQL server 2005/2008R2 on Standalone servers.
• Backup, Restore operations are done in Full, Bulk Logged, Simple Recovery Modes, and Restoring Databases with Point in Time Recovery on Dev/Prod Servers of SQL server 2000/2005/2008r2 .
• Restored SQL server 2000 DBs into SQL server 2008R2 Databases.
• Scheduled the Jobs thru SQL Server Agent. Developed Maintenance Plans on Prod Servers.

• Worked with System Administrators/ SQL Developers for Database Design of physical models used Data Dictionary Software packages to maintain security, data integrity and eliminate data redundancy and recovered corrupted data.

• Worked with Application Development team for improving the Performance optimum storage.
• SQL server Migration Assistant SSMA tool is installed configured for using it for migration of Oracle 9i DB into SQL server 2008R2 DB 1632 tables are migrated Details of Migration given below.
• Monitored the Performance of SQL Server 2008 R2 databases which are migrated using Performance monitoring tool PERFMON ,ran Traces using SQL Profiler, Query Optimization is done table scan , Tuned the Indexes using Database Engine Tuning Advisor.
• Installed configured Fail over Cluster active to passive instance-I and added Second Instance.
• Implemented the Log Shipping and database Mirroring.
• Implemented Replication Snapshot/Transactional/Merge .
• Built several SSIS Packages, Extracted data from multiple Data Sources like Oracle, DB2, Excel-Flat Files, MS Access, Tera data, Cleansed/transformed data using control flow task/data flow task elements and loaded on to SQL server Databases.
• Analysis Services-SSAS are executed and Historical Summary Reports are generated.
• Reporting Services are executed using SSRS for the Monthly, weekly Reports.
• Technical Documentation is prepared as per the Company's Policies.
• Coordinated with Offshore Teams for implementing the Infrastructure of the Migration Project.

Migration of Control Z Progress DB / SQL server 2000 Historical Databases into SQL Server 2008R2:

• Downloaded the CSV Text Files of Control-Z / Progress DB from shared Web Site.
• Created the Database and created T-SQL Scripts Structure for 424 tables on SQL server 2008 R2.
• Uploaded the 424 CSV Text files into C: my documents folder in the Non Prod. Server.
• Used Bulk Insert command for appending the data more than 200,000 Rows in each file,max.124Million Rows to the 424 SQL tables already created on SQL Server 2008R2.Biggest file bulk inserted has 124million rows.
• Resolved the Data Issues / Error Messages in the CSV Text files while bulk inserting the data into SQL tables. Converted the Data types in line with the Data Dictionary.
• Indexing is done. Monitored the Performance using SQL Profiler. Ran the Traces and checked on the Slow running SPs.
• Prepared Change Document for changes made for data types: Control Z DB Vs SQL Server 2008R2.
• Taken the Backup copy of 2 Historical Databases viz., SQL server 2000 and restored them in SQL Server 2008R2 on Prod Server, as data types are same.
• Validated the SQL tables by checking the row Count, Column count and first 10 last 10 Records, Summation of Price Column of each Table of the 3 Historical Databases.
• Attended the Toll Gate Meetings and convinced the Board on the Migration Validation of the Tables of SQL server 2008R2.
• Received Approvals from Compliancy Audit Team for the 3 Historical Databases.
• Migrated all the above 3 Databases to Prod Server.

Migration of Historical Database Oracle 9i into SQL Server 2008R2:

• SQL server Migration Assistant SSMA tool is installed configured for using it for migration of Oracle DB into SQL server 2008R2 DB 1632 tables are migrated .

• Worked on the migration of Oracle 9i database to SQL Server 2008R2 by creating Tables Bulk inserting/appending the Rows into the SQL Tables.
• Also, installed configured SSMA SQL server Migration Assistant Software Tool for fast conversion of Oracle Databases into SQL server 2008R2 Database/1632 Tables.
• There are some Issues while running SSMA s/w like Data types of Oracle are different from SQL Server 2008.The data types are mapped for each table synchronized the metadata using SSMA and then migrated data Rows from Oracle Table to SQL server 2008R2 table.
• Converted the Data types in line with the Data Dictionary.
• Indexing is done. Monitored the Performance using SQL Profiler. Ran the Traces and Query Optimization is done.
• Prepared Change Document for changes made for data types: Oracle 9i Vs SQL Server 2008R2.
• Validated the SQL tables by checking the row Count, Column count and first 10 last 10 Records, Summation of Price Column of each Table of the above Historical Databases.

Environment: SQL Server 2008R2, Oracle, Windows 2003-XP, Windows 2008 ,.NET, T-SQL, PL/SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL server 2005 2008, 2008R2 on stand alone and clustered servers.
• Monitored the Performance of SQL Server using PERFMON, ranTraces using SQL Profiler, used Query Execution Plan Table scan / Statistics . Identified the slow running queries and tuned the long running queries/SPs. Database Engine Tuning Advisor is used and tuned the indexes of the Tables to make more efficient.
• Installed configured Fail over Cluster instance-I and added Second Instance.
• Implemented the Log Shipping and database Mirroring.
• Implemented Replication Snapshot/Transactional/Merge .
• Analysis Services-SSAS Cubes are built and Historical Summary Reports are generated.
• Reporting Services are performed using SSRS for different Requirements of the Client.
• Involved in building of Data Warehousing with Microsoft SQL Server 2005/2008/2008r2 using SSIS ETL built Data models using Erwin based on Star Schema/Snow Flake Schema.
• Created Tables, Joins, Indexes, Stored Procedures in DWH. Implemented Star Schemas as a Set of Dimensional Fact Tables in the DWH/Cubes SSAS .
• Built several SSIS Packages, Extracted data from multiple Data Sources like Oracle, DB2, Excel-Flat Files, MS Access, Teradata, Cleansed//transformed data using control flow task/data flow task elements and loaded on to SQL server Databases.
• Technical Documentation is prepared based on the Standards Company's Policies.

Environment: SQL Server 2005/2008/2008R2, Oracle, Windows 2003, Windows 2008, T-SQL, PL/SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL server 2005 on the servers according to the requirements.
• Performed Upgrade of SQL server 2005 to SQL Server 2008.
• Implemented Audit policy in the system registry for SQL Server 2005
• Performed Full backup and restored on the SQL 2005.

• Upgraded DTS packages to SSIS packages.

• Implemented database mirroring.
• Implemented Fail over Clustering for Instance I and added Instance-II Active/Passive .
• Implemented Log Shipping and Replication Snapshot/Transactional/Merge .
• Performed the Full backup restore operations in Full Recovery mode.
• Supported on call on rotational basis and supported the data bases 24 7.
• Monitored the Performance of SQL Server using PERFMON, ranTraces using SQL Profiler, used Query Execution Plan Table scan / Statistics . Identified the slow running queries and tuned the long running queries/SPs. Database Engine Tuning Advisor is used and tuned the indexes of the Tables.
• Integration Services, Analysis Services Reporting Services are performed using SSIS, SSAS SSRS for different Requirements of the Client.
• Developed several SSIS Packages, Extracted data from multiple Data Sources like Oracle, DB2, Excel-Flat Files, MS Access, Teradata, Cleansed, transformed data using control flow task/data flow task elements and loaded on to SQL server Databases.
• Technical Documentation is prepared based on the Standards Company's Policies.

Environment: SQL Server 2005/ 2000, Oracle, Windows 2003/2000, T-SQL, PL/SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL server 2005 based on the Requirements.
• Performed Back-up, Restoration of Databases in Full Recovery Bulk-Logged modes.
• Implemented the Security Permissions/Logins utilizing the SQL 2005.
• Monitored the Performance of SQL Server using PERFMON, ranTraces using SQL Profiler, used Query Execution Plan Table scan / Statistics . Identified the slow running queries and tuned the long running queries/SPs. Database Engine Tuning Advisor is used and tuned the indexes of the Tables.
• Implemented Log Shipping and Replication Snapshot/Transactional/Merge .
• Increased the space in existing data files.
• Resolved blocking issues in databases.
• Troubleshot the slow running queries and applications.
• Created indexes, updated index statistics and rebuild indexes.
• Created SSIS packages to transfer the data from development to testing and production.
• Reporting Services/Analysis Services are performed using SSRS/SSAS.
• Created maintenance plans for user and system databases.
• Implemented database mail and created operator and assign the operator to jobs.
• Transferred logins jobs SQL server 2000 to SQL server 2005.
• Implemented database mirroring on SQL server 2005.
• Supported on call 24 7 on rotational basis
• Built several SSIS Packages, Extracted data from multiple Data Sources like Oracle, DB2, Excel-Flat Files, MS Access, Teradata and Cleansed//transformed data using control flow task/data flow task elements and loaded on to SQL server Databases by configuring the Connections and Deployment of Packages.

Environment: SQL Server 2000/2005, Oracle, Windows 2003 Server, T-SQL, PL/SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL server 2005 on new servers and configured SQL server 2005 as per the requirement.
• Installed SQL server 2005 service packs and hot fixes on the new servers.

• Performed the full backups and transactional log backups on the source server.
• Monitored the Performance of SQL Server using PERFMON, ranTraces using SQL Profiler, used Query Execution Plan Table scan / Statistics . Identified the slow running queries and tuned the long running queries/SPs. Database Engine Tuning Advisor is used and tuned the indexes of the Tables to make more efficient.
• Copied the backup files from source server restored the backup files on the destination server.
• Transferred the Logins from source server to destination servers.
• Upgraded the DTS packages to SSIS packages.
• Installed and configured the application software on application servers.
• Created maintenance plans for system and user databases assigned operator to the jobs.
• Implemented database mirroring.
• Implemented Log Shipping and Replication Snapshot/Transactional/Merge .

• Handled pager on rotational basis for 24/7 production support.
• Reporting Services/Analysis Services are performed using SSRS/SSAS as and when required by the Company.

Environment: SQL Server 2000/2005, windows 2003, T-SQL, PL/SQL

Confidential

SQL Server DBA

Responsibilities:

• Installed configured SQL server 2000 / 2005 according to the Requirements.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Monitored the Performance of SQL Server using PERFMON, ranTraces using SQL Profiler, used Query Execution Plan Table scan / Statistics . Identified the slow running queries and tuned the long running queries/SPs. Database Engine Tuning Advisor is used and tuned the indexes of the Tables to make more efficient. Point in time recovery plans.
• Implemented the SQL login Security for developers and app user ids.
• Maintaining Stand by servers and implementing Log shipping.
• Performance tuning in Database level using reports/queries and operating system level.
• Performed Database Backups Restoration, Backup Strategies and Scheduling Backups.
• Performed Troubleshooting for the problems involved with stored procedures, triggers and problems related to the privileges.
• Changed SQL directories owner to the Administrator account.
• Implemented audit policy in the system registry for SQL Server 2000/2005.
• Performed Full backup and restored on the SQL 2000/2005.
• Supported on call on rotational basis and supported the data bases 24 7.

Environment: T-SQL, PL/SQL, SQL Server 2000/7.0, SQL Server 2005, Windows 2000/2003

Confidential

SQL server DBA

Responsibilities:

• Developed T-SQL for Tables, Views, User Defined Functions, Indexes, User Stored Procedures, Joins, Triggers tested transferred to Production.
• Installed and Configured SQL Server 2000/2005
• Performed database backups and restored database.
• Backup and Restore databases. Create and maintain customized standby server.
• Manage database and transaction log files, auto shrink log files using scheduled script.
• Set up Jobs for Database Consistency Check.
• Install, uninstall and upgrade SQL servers and service packs.

Environment: SQL Server 2000/2005, T-SQL, Excel, Windows 2000/2003 Server.