SUMMARY

• 8 years of experience in SQL Server Database Administration in Production, Test and Development environments, with MS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000 systems along with experience in Business Intelligence development, Data Modeling and Analytics in different fields like Finance, Insurance, Transportation and Healthcare.
• Expert knowledge of SQL Server Architecture both 32-bit and 64-bit systems in Cluster and Stand alone Server environments in terms of Installation and Configuration.
• High level understanding of RDBMS concepts as well as Data Modeling and Azure SQL concepts.
• Sufficient hands-on experience in HA DR High Availability Disaster Recovery techniques like Log Shipping , Mirroring High safety High performance , Replication Snapshot Transactional and Clustering Active - Passive and Active- Active .
• Experience working with data-tier application DAC for Migration.
• Experience in Migrating SQL Server 2000 to 2005/2008/2008R2/2012/2014.
• Experience working with Team Foundation Server TFS , Visual Source Safe and Clear Case for Data Archival.
• Good at recent SQL Server features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE ..
• Well experienced in analyzing Performance, Query optimization and tuning.
• Good experience in creating objects such as Databases, Tables, Stored Procedures, Triggers, Cursors, Constraints, Indexes, Full-text Indexes, Views, Indexed Views, T-SQL Merge Command
• Experience in Index Maintenance Index tuning, Rebuild Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity.
• Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Troubleshooting performance issues and fine-tuning Performance Tuning queries and stored procedures, also experience in Perfmon counters.
• Good knowledge about Database Recovery models.
• Having good experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer.
• Experience in automation of administrative tasks like creating maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
• Experience in Error handling through TRY-CATCH statement and Common Table Expressions.
• Experience working with Azure SQL Database Import and Export Service.
• Experience in deploying SQL Databases in CLOUD AZURE AMAZON .
• Experience working with SQL Server 2014 and Active Directory.
• Expertise in implementing Business logic by using T-SQL DDL, DML , stored procedures, triggers and User Defined Functions UDF .
• Experience in using DMVs, DMFs, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built Global Variables for instant analysis.
• Involved in package migration from DTS to SSIS 2005
• Extensive experience in planning and controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Experience in performing database regular Backups Full/Differential/Transaction Log Backups into Disk and Restoring on requirement.
• Experience in handling the Isolation Levels and Concurrency Effects.
• Hands on experience in Log shipping database Cutover DR DRILL to Data Recovery Servers and routing the Application from Data Recovery Servers and testing the Application connectivity.
• Experience in configuring Registered Servers, Linked Servers and Multi Server Administration.
• Involved in SQL server default port number changing to nonstandard port number, created Server aliases as part of SQL Server hardening.
• Involved in Clustering at both Windows and SQL Server levels and maintenance.
• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL LiteSpeed, for performance Foglight and for alerting Idera.
• Auditing of database for user transactions, login and database action and removing orphan users.
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Experience in Data Extraction, Transforming and Loading ETL using For Each Loop in SQL Server Integration Services.
• Experience in building SSIS packages .dtsx involving ETL process, extracting data from various flat file, Excel files, legacy systems and loading to SQL server.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points package restart ability features , break points and error logging procedures.
• Experience in creating Analysis services databases, data sources, data source views, named calculations, named queries, dimensions, cubes, calculations
• Responsible for SSIS package deployment and execution, SSAS cubes deployment, SSRS reports publishing, report generation and availability.
• Experience in using different control flow tasks like FTP, Bulk Insert Task and data flow tasks like merge, merge join, look up, data conversion, derived column, conditional split
• Experience in Analysis Services SSAS OLAP Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing.
• Experience in creating tabular, list, matrix reports templates of Tablix data region and writing queries to perform drill down operations in SSRS.
• Experience with parameterized reports and custom reporting using SSRS
• Created SSRS projects and reports in BIDS, sort, drill down data and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Provided support for 24x7 availability of database services.
• Experience in creating reports and dashboards using MS Excel VBA Visual Basic Application and Tableau.
• Experience in statistical softwares like SAS and R to implement statistical data analytical concepts like predictive analytics, outlier detection
• Zeal in self-learning latest versions of SQL Server and upcoming technologies from Microsoft.
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

Sr. SQL Server DBA

Torchmark is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments.

Responsibilities:

• Installed Service packs and Builds
• Setting up and Troubleshooting Replication.
• Worked with SQL Server 2008 in place and side by side upgrade from SQL server 2005
• Worked on Project for setting up DB mirroring and troubleshooting
• Successfully implemented the Capacity planning for different servers.
• Experience working with data-tier application DAC for Migration.
• Experience working with Azure SQL Database Import and Export Service.
• Experience in deploying SQL Databases in AZURE.
• Provided cloud computing services in IaaS and various other cloud services
• Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Experience working with SQL Database Migration Wizard SQLAzureMW and Azure SQL Database Preview v12.
• Setting up and troubleshooting DB mirroring projects.
• Worked on setting up active-active Clusters.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Performed database regular Backups Full/Differential/Transaction Log Backups into Disk and restoring on requirement.
• Performed daily tasks including Backup and Restore.
• Monitoring the database consistency with DBCC at regular intervals.
• Used third party tools like LiteSpeed, Fog Light and DB comparer.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Upgraded SQL server from SQL 2000/2005/2008 to 2008R2/2012/2014 using Inplace and side by side migration techniques.
• Troubleshooting performance issues and fine-tuning Performance Tuning queries and stored procedures.
• Performed BCP failover exercises for Log Shipping and Mirroring.
• Resolving performance issues using DMVs Dynamic Management Views .
• Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery.
• Developed Automated Backup jobs and DBCC scripts for databases and transaction logs.
• Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, Error logs and making recommendations for performance improvement in hosted databases which involved Index creation, Index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
• Used native tools like Data Base Tuning Advisor, Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Usage of DBCC Utilities to maintain the consistency and integrity of each database in the server.
• Creation of useful indexes as part of Performance Tuning.
• To perform source-to-target mapping and building database schema in an SQL 2012 environment including creating scripts and procedures for production migration.
• Involved in Data Modeling using ERWIN.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2008R2/2008/2005 using Microsoft Business Intelligence Development Studio.
• Experience in implementing and maintaining Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
• Preparation of status reports.
• Designed and developed SSIS packages using different Control flow tasks, Transformations and Dataflow tasks.
• Developed and deployed OLAP cubes for reporting purposes using SSAS.
• Used ETL packages to move logins and jobs from one server to another server.
• Created Dashboard reports to analyze the quarterly and yearly performance.
• Performed Query Optimization to increase the performance by tuning SQL queries using Profiler and Execution Plans
• Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks SAN /Network Attached Storage NAS , RAID levels.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Provided support for 24x7 availability of database Services and ensure to meet the SLA.

Environment:

SQL Server 2005, 2008 and 2008 R2, 2012, 2014 T-SQL, Access, Windows 2003 2005 and 2008 Servers, SharePoint, Business Intelligence Development Studio SSIS, SSRS, SSAS, Performance Monitor, Clustering, SQL Agent, SQL Profiler, SQL Guard, Database Tuning Advisor, Team Foundation Server

Confidential

SQL Server DBA

Responsibilities:

• Deployed database objects from development/testing environment to production environment.
• Developed and deployed OLAP cubes for reporting purpose using SSAS.
• Created, deployed and managed reports using SQL Server Reporting Services SSRS .
• Configured and deployed SSIS packages from test to production environments.
• Created, scheduled database maintenance plan using SSIS maintenance plan task.
• 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.
• Responsible for monitoring and making recommendations for performance improvement in
• Prepared, maintained and modified SQL Safe installation and configuration documents.
• Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Planning, Gathering the pre-deployment information and Deployment of the third party IDERA tool SQL Diagnostic Manager SQLDM .
• Prepared, maintained and modified SQL Diagnostic Manager SQLDM installation and configuration documents.
• Conducted unit tests of reports.
• Managed Security using Roles for various users in Development.
• Troubleshooting performance issues and fine-tuning Performance Tuning queries and stored procedures.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2008R2/2008/2005 using Microsoft Business Intelligence Development Studio.
• Handles datasets using complex queries and stored procedures.
• Handled numerous change management requests in Development.
• Involved in Unit testing and debugging.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Migrated SQL Server 2005 databases to SQL Server 2008 databases including DTS to SSIS packages.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Implemented and maintained Database mirroring as a Disaster Recovery soultion.
• Performed database regular backups Full/Differential/Transaction Log Backups .
• Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Worked on Conceptual, Logical, Physical data modeling and Performance Analysis.
• Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 64 bit on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Migrated databases from SQL Server 2000 to SQL Server 2008 and 2008 R2.
• SQL Server 2008 R2/2008/2005 Database Administration.
• Managed and Administrated the SQL Server 2012/2008R2/2008/2005 systems in Production and Development environments.
• Reviewed stored procedures developed by the developers and given recommendations for code modifications in production.
• Managed Security using SQL Logins, Roles and Security Modes for various users.

Environment:

SQL Server 2005, 2008 and 2008 R2, 2012, T-SQL, Access, Windows 2003 2005 Servers, SharePoint, Business Intelligence Development Studio SSIS, SSRS, SSAS, .NET., Performance Monitor, Clustering, SQL Agent, SQL Profiler, Database Tuning Advisor, Team Foundation Server

Confidential

SQL Server DBA

Responsibilities:

Involved in creating, structuring, formatting using report designer.

• Used c .net asp web pages to show the deployed reports as required by the user.
• Created tabular reports, list reports, parameterized reports, ad-hoc reports, drill down reports according to business requirements in time restricted environment.
• Created measures, measure groups, dimensions and multi-dimensional cubes
• Build an analysis services database on already existing data warehouse solution
• Loaded fact and dimension tables as part of modified data warehouse solution.
• Modified star schema and identified the requirement of snow flake schema in the design.
• Used SQL Profiler to optimize Stored Procedures.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.
• Created database objects like Procedures, Functions, Triggers, Indexes.
• Involved in business analysis and technical design sessions with business and technical staff to develop dimensional models, requirements document, and ETL specifications.
• Deployed SSIS packages with minimal changes using XML config file.
• Used several SSIS control flow and data flow transformations as part of ETL.
• Extensively used Merge command as alternative to small SSIS packages in dimension and fact load
• Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files
• Created SSIS Packages to migrate the data from Oracle databases, XML, text files, Excel files.
• Created linked server with oracle to import data to SQL Server.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Used ETL packages to move logins and jobs from one server to another server.
• Monitored the event logs and server logs for troubleshooting and problem solving.
• Involved in Moving System databases.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle servers.
• Migrated databases from SQL Server 2005 to SQL Server 2008/2008R2 databases.
• Configured Database Mirroring with high performance and high availability mode.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Installed and configured SQL Server 2008/2008R2 on both cluster and stand-alone environment.
• Installed SQL Server Service Packs to keep the SQL Server up to date.
• Maintained DB Security by creating logins, users, roles and permissions for the business people.
• Responsible for activities daily routine backup restore, refreshing databases as per requirements.
• Scheduled and created Maintenance plans on databases and also created automated jobs.
• Implemented SAN replication and performed test failover.
• Configured SQL Server 2005 four Node Cluster Active-Active in virtual environment using VM Ware Workstation for testing.
• Configured SQL Server 2008 multi Node Cluster Active-Active and Active passive .
• Upgraded SQL Server 2005 to SQL Server 2008/2008R2 in windows server 2008 64bit.
• Migrated and maintained data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools.
• Maintaining both Development and Test servers in sync with Production server by doing Database Refreshes.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail.
• Implemented different types of replications Transactional, Snapshot and merge replications.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Responsible for SSIS, SSAS, SSRS package executions and availability.
• Provided support for 24x7 availability of database Services and ensure to meet the SLA.

Environment: MS SQL Server 2000/2005/2008/2008R2 64 bit, Enterprise, Windows server 2003/2008 64 bit, Business Intelligence Development Studio SSIS, SSRS, SSAS, Performance Monitor, Clustering, SQL Agent, SQL Profiler, SQL Guard, Database Tuning Advisor, Commvault, Powershell, T- SQL.

Confidential

SQL Server DBA

Responsibilities:

• Designed and implemented stored procedures and triggers for automating tasks.
• Query Optimization with SQL Profiler for better performance.
• Assist the Development staff with the testing and implementation of the application
• Troubleshooting performance issues and fine-tuning Performance Tuning queries and stored procedures
• Created multiple reports with drop down menu option having complex groupings within the report
• Worked on Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters
• Involved in extracting data from multiple data sources, perform multiple complex transformations and land data into SQL Server Tables.
• Used ETL tool SSIS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Successfully migrated data from multiple environments into SQL Server 2008 using BCP, Bulk Insert and SSIS Packages.
• Defined and processed the Fact table Dimensions using SSIS.
• Implemented SSIS packages for the exchange of data between different data sources.
• Defining/creating and handling Data Sources, shared data sources and Parameterized Reports in SSRS 2005
• Involved in SQL Server Hardening.
• Managed and Administrated the SQL Server 2008/2005/2000 production and Development Servers.
• Developed logical design and physical design.
• Handled production/Development servers with more than 2 TB of database size with complex structures.
• Upgraded the SQL Server 2005 to SQL Server 2008.
• 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.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Expertise in setting up and troubleshooting Database mirroring.
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Developed SSIS packages, stored procedures, functions, triggers.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS
• Involved in all phases of database modeling
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.

Environment: SQL Server 2008/2005, T-SQL, Excel, Advanced Windows 2000 Server, Visual Source Safe 6.0 Version Control Management , TFS Team Foundation Server , VS 2003/2005, SSIS, SSRS, T-SQL, SQL Profiler.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Maintaining the Database consistency using DBCC commands at regular intervals.
• Trouble shooting Problems by using SQL server profiler.
• Monitor production Server Activity.
• Responsible for General Database Administration, Query Performance tuning.
• Transfer data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert.
• Extensively used SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules. Developed stored procedures, functions and various packages.
• Installed configured SQL Server 2000 on Windows 2003.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures, Triggers and maintaining referential integrity.
• Taking Database full Backup, Transaction log backup differential backup as per backup strategy daily routine.
• Modified the existing stored procedures, views and triggers in the part of performance tuning.
• Monitoring of database size, disk space in all Production, Model Development the environments.
• Transforming Excel reports into VBA dashboards related to quarterly financials and loan deductibles.
• Used Windows Performance monitor to monitor CPU Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Creating and monitoring all maintenance jobs backups, integrity, and optimization on all databases.
• Handle development and production support, document reviews, test plans, integration of the system.
• Document all process and Data Flow involved in the database for future reference.

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL, Excel, Crystal reports , Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT