Profile

• Microsoft SQL Server DBA with over 8 Years of experience in Database Administration, Technology Operations and technical skill set for handling very large scale, high availability database systems built on Microsoft technologies like Production Servers related to Financial, Health Care, and Insurance.
• Experience Summary
• Over 8 years of professional experience as SQL Server Senior DBA/Developer and Production Servers Maintenance related to Financial, Health Care, and Insurance.
• Implemented Database Mirroring on 2008/2008R2/2012 and Setting Always On Availability Groups on SQL Server 2012 and Clustering 2005/2008/2008R2/2012 on windows 2008/2008R2/2012 as High Availability Techniques.
• Extensively worked on Active-Active and Active-Passive Clustered Environment with 24 CPU consolidated environment of SQL Server Versions 2014/2012/2008R2/ 2008/2005/2000.
• Implementing Transactional and Snapshot Replication and Performed Log Shipping as Disaster Recovery Solutions.
• Installation and Upgrading of SQL Server 2014/2012/2008R2/2008/2005/2000 and on Windows Clustered Environment.
• Migrating SQL Server 2000 Databases into SQL Server 2005/2008/2012 by In-Place Upgrade Process and as well as Side-By-Side Upgrade Process.
• Extensively worked SSIS Implementations, configuring and deploying SSIS packages and troubleshooting SSIS jobs, SSRS reports deployments.
• Experience with other 2012/2008/2005 new concepts like DMV'S, DMF'S, and Performance dash board.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text Indexing, and Database Application Development using varied development tools, Availability groups, SSIS, SSIS Catalogs deployment, SSRS, and SSAS.
• Extensively worked on DTS in SQL Server, SQL Server Integration Services SSIS , Reporting Services SSRS ,Performance Tuning Application Design, Hot, Warm and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.
• Good at Data availability solutions like Online Restore, Online Index Operation, Database Snapshot, and Fast Recovery.
• Extensively worked on 32 bit, x64 bit and i64Clustered and Standalone Server environments.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, User defined Data Types and Functions.
• OLAP experience like Analysis Services, Reporting Services and Integration Services.
• Gathering data requirements, design and Fine-Tuning of Databases as per the requirement of clients. Complete Administration of Microsoft SQL Server Databases is my Primary Responsibility.
• Closely worked with development team to assist them in various problems solving and Troubleshooting SSIS Packages, SSRS reports, Web-Based Applications, which calls various Database objects like Stored Procedures, Functions, and Triggers.
• Managed and maintained hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Excellent in the use of the import and SQL Loader utilities to load data and performing exports as supplemental to daily hot, cold and RMAN backups to be used for database restore and recovery.
• Migrated DTS packages into SSIS packages using Upgrade Advisor Tool and SSIS wizard, BI tools.
• Good knowledge to configure LUNS of RAID 0, RAID 0 1 and RAID 5, RAID Groups and Storage Groups as per the size and Performance requirements and installation of .net frame work 3.0, IIS 6.0/7.0.
• Extensively worked on IIS 6.0 /7.0 and .net frame work installations on windows server 2012/2008R2 and compliance issues.
• Extensively worked on setting up MS DTC and Local policies on windows servers.
• Good Experience in SQL Server 2008 Concepts like Backup Compression, Data Compression, Lock Escalation and New Data Types like Spatial Data Types, File Stream Data Types, Date/time and Filter Indexes.
• Strong time Management Skills and Excellent Team player.
• Ability to adapt quickly to Changing Environments.
• Provided 24 X 7 Production Database On-Call Support.

Technical Proficiency

Project Domain Application Development, Systems Integration and Database, Administration of MS SQL Server 2008/2005/2000 and Oracle. Data Modeling Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin4.x. ETL Tools MS SSIS and DTS, PL/SQL, TSQL, SQL Server bulk insert and BCP utilities Tools Active X, IIS, SSIS, SSRS,SSAS, DTS, LiteSpeed, Spotlight, Visual Studio 2003/2005, Team Foundation Server TFS , Visio 2003, Office Visio 2007, Enterprise manager, Query Analyzer, Perfmon counters, SQL Profiler and SQL LOADER, sale force, Idera. Business Intelligence SSRS SQL Server Reporting Services Databases SQL Server 2014/2012/2008R2/2008/2005/2000/7.0, MSSQL, MS Access. Languages T-SQL, PL/SQL Markup Languages: HTML, XML Packages Microsoft Office 2010/2008/2003/2000/XP Operating Systems Windows NT/2000/XP/2003,2008/2008R2 Unix

Career Progression

Confidential

Sr.SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2014/2012/2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
• Involved in Implementing 2012,2008R2 active-passive clustering on Windows 2008R2 Operating system with consolidated environment of multiple SQL server instances in Sql 2012 and 2008R2.
• Involved and set up of SQL Server 2012/2008R2 Mirroring on production servers.
• Involved and set up of SQL Server 2012 availability groups.
• Involved and set up of SQL Server 2012 SSIS Catalog.
• Involved in Migration of the Server SQL Server 2005 to 2012, SQL Server 2008R2 to 2012 and DTS to SSIS, and involved in SAN Migration for the SQL Server 2012 and 2008R2 Servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Implemented Transactional Replication and Performed Log Shipping as Disaster Recovery Solutions.
• Involved developing and implementing jobs for SQL server, and involved in various production releases for all the groups.
• Extensively worked SSIS Implementations, configuring and deploying SSIS packages and troubleshooting SSIS jobs, SSRS reports deployments.
• Involved deploying of Cubes, SSIS packages and report for different groups.
• Configured the RAID levels for data files, log files and tempdb at server level.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Extensively worked on IIS 6.0 /7.0 and .net frame work installations on windows server 2012/2008R2 and compliance issues.
• Extensively worked on setting up MS DTC and Local policies on windows servers.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Worked on key performance indicators for customizable metrics. To set up SQL Server configuration settings.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring the servers using spot light third party Quest software.
• Maintaining the database consistency with DBCC at regular intervals

Environment: SQL Server 2014/2012/2008R2/2008/2005, Windows Sever 2012, Windows 2008R2, Windows NT, SQL Idera, Sql backup5, SQL secure, ETL, SSIS, SSRS, SSAS, PowerShell, C ., VB, VBA, ASP.NET, MS Excel and MS Access, Oracle , SSAS, System Monitor / Performance Monitor, HP BAC

Confidential

SQL server DBA

Responsibilities:

• Involved as an MS SQL Server 2014/2012/2008R2/2008/2005/2000 and responsible for installation, configuration, tuning and provided 24 X 7 dedicated support to all Production servers.
• Migrated Sybase 12 servers to Sql server 2005/2008/2008 R2.
• Migrated two servers with more than 60 databases from SQL Server 2005 to SQL Server 2008 R2.
• Implemented SQL Server Replication for Production Database as Fail-Over or Standby servers.
• Implemented SQL Server Mirroring and Log Shipping as Disaster Recovery Techniques.
• Implemented Transparent Data Encryption TDE to encrypt sensitive data.
• Developed new database maintenance plans which involves Create statistics, Update statistics, rebuilding the Indexes, Database Integrity checks for all the newly built.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL.
• Performed performance monitoring, reviewing Windows and SQL event logs and system logs.
• Involved database performance issues, database capacity issues, replication and other production related data issues.
• Set up Log Shipping, MSSQL Mail, SMTP
• Created SSIS packages to clean and load data to data warehouse and provided 24 X 7 dedicated support.
• Migrated DTS Packages to SSIS using Upgrade Advisor Wizard.
• Created package to transfer data between OLTP and OLAP databases.
• Creating Sql Server Jobs to run SSIS packages.
• Used Event Handlers to handle errors and enabled logging along with email notification.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Developed stored procedures, advanced queries, trigger, views and indexes by using T-SQL.
• Extensively involved in Developing and Enhancing of Custom Queries extracting data from Source System and wrote required enhancements on Existing SSIS Packages.
• Responsible to assign permission to user s , role s , and object. Support column level permission and Administrate security for server's logins Windows and SQL Accounts .
• Respond to Workflows assigned to me and fix any database issues promptly Update and work on projects that I have been assigned to as a resource from the Database Management team.
• Extensively worked on setting up IIS 6.0 and .net frame work installations on windows server 2012/2008R2 and compliance issues.
• Extensively worked on setting up MS DTC and Local policies on windows servers.

Environment: MSSQL Server 2008R2/2008/2005/2000,SSIS, SSRS T-SQL, Data Transformation Services DTS , Win 2008/2003/2000, Unix, Linux, Win XP/NT, MS SQL Reporting Services, TFS, SharePoint, Visual Studio.

Confidential

Sr.SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
• Involved in Implementing 2008,2008R2 active-passive clustering on Windows 2008R2 Operating system with consolidated environment of multiple SQL server instances in Sql 2008 and 2005.
• Involved and set up of Sql Server 2008 Mirroring on production servers.
• Involved in Migration of the Server SQL Server 2000 to 2005, SQL Server 2005 to 2008 and DTS to SSIS , and involved in SAN Migration for the Sql server 2000 and 2008 Servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Implemented Transactional Replication and Performed Log Shipping as Disaster Recovery Solutions.
• Involved developing and implementing jobs for SQL server, and involved in various production releases for all the groups
• Involved deploying of Cubes, SSIS packages and report for different groups.
• Configured the RAID levels for data files, log files and tempdb at server level.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers..
• Extensively worked on compliance issues.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Worked on key performance indicators for customizable metrics. To set up SQL Server configuration settings.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring the servers using spot light third party Quest software.
• Maintaining the database consistency with DBCC at regular intervals
• Extensively worked on IIS 6.0 /7.0 and .net frame work installations on windows server 2012/2008R2 and compliance issues.
• Extensively worked on setting up MS DTC and Local policies on windows servers.

Environment: SQL Server 2008R2/2008/2005, Windows 2000, Windows NT, SQL SAFE, Sql backup5, SQL secure, ETL, SSIS, SSRS, C ., VB, VBA, ASP.NET, MS Excel and MS Access, Oracle , SSAS, System Monitor / Performance Monitor, HP BAC

Confidential

SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
• Involved in Implementing 2008,2008R2 active-passive clustering on Windows 2008R2 Operating system with consolidated environment of multiple SQL server instances in SQL 2008 and 2005.
• Involved and set up of SQL Server 2008 Mirroring on production servers.
• Involved in Migration of the Server SQL Server 2000 to 2005, SQL Server 2005 to 2008 and DTS to SSIS , and involved in SAN Migration for the SQL server 2000 and 2008 Servers.
• Handled up to 2 TB Size databases with clustered environment.
• Involved in installing and configuring latest version of SQLSAFE in SQL Server 2008 Active-Passive Clustered servers.
• Maintained servers with multiple instance of SQL Server 2000, 2005 and 2008 with 24 CPU having 100 GB Memory.
• Implemented Transactional Replication and Performed Log Shipping as Disaster Recovery Solutions.
• Involved developing and implementing jobs for SQL server, and involved in various production releases for all the groups in Met Life.
• Involved deploying of Cubes, SSIS packages and report for different groups.
• Configured the RAID levels for data files, log files and tempdb at server level.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Involved in development of complex mappings and also in tuning of mappings for better performance.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Expert in using and implementing DMV's, DMF's, data partitioning, DDL triggers and Online indexing.
• Extensively worked on 32 bit, x64 bit and i64clustered and standalone server environments
• Responsible for transferring packages using SSIS and transferring SQl Server Objects from QA to Production Using SSIS Packages.
• Deployed Reports on Report Server.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Trouble shooting various SQL Server 2008, 2005 and 2000 Database connectivity issues from the web applications.
• Planned the Complete backing up of Database and Restoring the Database from Disaster Recovery by using SQL SAFE.
• 24 X 7 Production Database on Call Support

Environment: SQL Server 2008R2/2008/2005, Windows 2000, Windows NT, lit speed, SQL SAFE, Sql backup5, SQL secure, ETL, SSIS, SSRS, C ., VB, VBA, ASP.NET, MS Excel and MS Access, Oracle , SSAS, System Monitor / Performance Monitor.

Confidential

SQL server DBA

Responsibilities:

• Expertise and Interest include Administration, Database Design, Performance Analysis on production Databases.
• Installed and configured SQL Server 2008 on new Servers and Installed SQL Server 2000 and 2005 service packs.
• Installing Windows and SQL Server security patches, Windows regular updates.
• Involved in Migration of the Server SQL Server 2000 to 2005, SQL Server 2005 to 2008 and DTS to SSIS ETL .
• Involved in development of complex mappings and also in tuning of mappings for better performance.
• Performed daily loads and verification of loaded data.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Expert in using and implementing DMV's, DMF's , data partitioning, DDL triggers, Mirroring and Online indexing.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL and PL/SQL.
• Extensively worked on 32 bit, x64 bit and i64clustered and standalone server environments
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns eliminated redundant and inconsistent data and normalized tables.
• Extensively used ETL and SSIS tool to load data from Excel spreadsheets, flat files, and xml files into the target SQL Server database.
• Involved in ETL process under development, testing and production support environments.
• Responsible for transferring packages using SSIS ETL , and transferring SQL Server Objects from QA to Production Using SSIS Packages.
• Created and modified Stored Procedures and Functions to generate reports.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Used log shipping for synchronization of database.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Trouble shooting various SQL Server 2000 and 2005 Database connectivity issues from the web applications.
• Designed and Developed FTP task to transfer files from one server to another server.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2005/2000, SSIS, SSRS, Replication, Active / Passive Clusters, C ., VB, VBA, ASP.NET, Windows 2003, PL SQL.

Confidential

SQL server DBA

Responsibilities:

• Installation of SQL Server 2005 on Widows Active-Passive Clustered environment.
• Managed and administrated the SQL Server 2005 and 2000 servers.
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Design, Migrated, Deployed and monitored DTS packages into SSIS packages and maintain Database Maintenance Plans on daily Basis.
• Transferred SQL Server Objects from QA to Production Using SSIS Packages.
• Handled up to 2 TB Size databases with clustered and replication environment
• Extensively worked on Dynamic Management Views DMV's and Dynamic Management Functions DMF's .
• Created and Deployed Cubes Using SSAS and Good experience in data modeling and metadata services.
• Configured Reporting Server Using Reporting Services Configuration Tool. And created and Deployed Reports using SQL Server Reporting Services.
• Designed and Developed FTP task to transfer files from one server to another server.
• Designed a Report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Fine Tuning of database objects and server and worked with SQL server Profiler to generate traces.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
• Planned and modified the permission issues in the server and Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Maintaining SQL Script for creation of Database Objects using VSS Visual Source Safe .
• Used DTS Packages to move logins and jobs from one server to another server.
• Used log shipping for Synchronization of Database.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Extensive testing on the Performance of the Stored Procedures.
• Assisted based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

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

Confidential

SQL Server DBA

Responsibilities:

• Database Administrator/Database Programming/Product specialist.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Extensively worked on compliance issues.
• Wrote the packages using DTS in SQL2000
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Worked on key performance indicators for customizable metrics. To set up SQL Server configuration settings.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring the servers using spot light third party Quest software.
• Maintaining the database consistency with DBCC at regular intervals

Environment: SQL Server 2008/2005, Windows 2000, Windows NT, lit speed, Sql backup5, SQL secure, ETL, SSIS, SSRS, C ., VB, VBA, ASP.NET, MS Excel and MS Access, Oracle , SSAS, System Monitor / Performance Monitor, TFS.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Performance tuning of the SQL 2000 servers in order to reduce I/O and Memory contentions.
• Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams. Troubleshoot SQL Server performance issues for internal and external customers.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup recovery and performance monitoring.
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Monitoring the servers using spot light third party Quest software.
• Extracting the fixed length format files from DB2 databases.
• Export or Import data from other data sources like flat files using Import/Export of DTS
• Recovering the databases from backup in disasters
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• DBA support for a development team customizing and testing new releases of client-server applications and analyze various aspects of Stored Procedures and performed tuned as needed to increase productivity and reusability of code.
• Written Tested and Documented Program code and implemented programs.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.

Environment: SQL Server 2005/2000, SSIS, SSRS, Replication, Active / Passive Clusters, C ., VB, VBA, ASP.NET, Windows 2003

Confidential

SQL Server DBA/Developer

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Writing Stored User Defined Data Types, Procedures, Triggers and Functions.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and Disaster Recovery strategies. Implemented and Scheduled Replication process for updating our parallel servers.
• BCP, Bulk Copy, Select into are used to move data
• Using the Lite Speed to take backups.
• Monitoring/troubleshooting the existing DTS packages.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters.
• Maintaining the database consistency with DBCC at regular intervals.
• Using log shipping for synchronization of database.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 7.0, 2000, Ms-Access, Visual Basic, and Windows NT Clients.