PROFESSIONAL SUMMARY:

• More than 8 Years of IT experience in Analysis, Designing & Development, Implementation & Maintenance of Database, Database Administration and BI Applications using MS SQL Server 2014, 2012, 2008R2, 2008, 2005 and 2000 in Development and Production Environments.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of all versions of SQL Server i.e. 2000, 2005, 2008,2008R2 2012, 2014.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in Always - On Availability Groups (AAG) and HA/DR Troubleshooting.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics and Index Tuning Wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Performed Log Shipping and implemented Replication as High Availability techniques.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Experience in database design with T-SQL through conceptual Entity Relationship Diagrams and Erwin.
• Expertise in creating database objects such as Stored Procedures, Tables, Constraints, Indexes, Views, Indexed Views, and Triggers using SQL Server.
• Involved in Quality Assurance, bug fixing and testing. Prepared user manuals, presentations and trained user and operators.
• Hands on experience in creating end to end ETL strategies that will include data profiling as well as extracting transforming, conforming and loading data warehouses/ data marts for reporting purpose.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings) and securing packages secured packages with Encryption in conjunction with passwords.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS.
• Proficient in configuring the Report Server and Report manager to set up roles and security on the reports.
• Adept knowledge in creating calculated members and KPI's using basic MDX expressions.

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, South Carolina

SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server2000\2005\2008\2008R2\2012\2014\2016RC3 SQL servers.
• Created various Data marts and assisted in complete Life Cycle including Design, Development and Testing of an Application.
• Successfully migrated SSIS packages, stored procedures, SQL reports from SQLSERVER2005 to SQLSERVER2008 R2, 2012\2014 SQL servers.
• Exported and Imported data from text file and excel to SQL Server Database using Bulk copy insert and BCP utility.
• Performed DBCC utilities and fixed data corruption in application databases
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Fix the Cluster and Replication issues on SQL 2005/2008R2/2012 servers with in very strong SLA’s.
• Responsible for design, installation, configuration, security, and maintenance of highly available enterprise database systems.
• Established Linked Server Connections and remote procedure calls while maintaining performance of Queries.
• Implemented Agency Wide Reporting on SQL Server Health reports, automatic reports when any changes to Database Definition are made are directly emailed to the DBA’s.
• Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios.
• Troubleshoot and maintain database performance, including the proposal of short term fixes, long term solutions, and the regular scheduling of index maintenance and database integrity checks.
• Establish and maintain database policies and standards.
• Generate database schema definitions and modifications as required.
• Refresh data from one environment to another at the request of the application development staff.
• Develop, follow, and maintain in-house documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution
• Performed Administrative tasks in SQL Server using Power Shell.
• Good understanding of different RAID levels implementation.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Used cascaded parameters to generate a report from two different Data Sets. Developed queries for generating drill down reports in SSRS and created Ad Hoc reports through report builders.
• Upgraded hundreds of Complex DTS (SQL 2000) to SSIS Packages
• Created and deployed a number of SSIS packages to 2008, 2012, 2014 servers using all compatible versions of Visual Studio) and use these ETL’s to load data into Stage, ODS and Data Ware House systems.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Statistical mining SSAS, entity relationship diagram (ERD) database and used Erwin for physical and logical data modeling.

Environment: SQL Server 2000/2005/2008/2008 R2/2012/2014 Express edition, Power Shell, PL/SQL, Windows Enterprise Server 2012, Microsoft Visio, Microsoft Reporting Services

Confidential, Richmond, VA

SQL Server DBA

Responsibilities:

• Managing and administering around 150 SQL server instances which include2008/2008 R2/2012.
• Migration and up gradation of databases from old versions to SQL2008 R2 and SQL2012.
• Installed SQL server 2008 R2 through command Prompt considering the business policy.
• Used SCOM Monitoring tool for SQL.
• Configure Transactional and Snapshot replication on SQL 2008R2 Servers
• Performed database backups and restoration as needed.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Wizard (DTA)
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. Building / monitoring the indexes at regular intervals for better performance.
• Configuring DB file groups on SQL SERVER 2008 R2 to deliver better performance.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T- SQL.
• Auditing the tempdb database and shrinking databases.
• Working with the issues related to memory and space.
• Troubleshot performance issues, disk space issues and custom application issues.
• Extensive testing on the performance of the Stored Procedures.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2.
• Maintained a database for the reporting purposes like creating database and other SQL table objects.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Worked on SSIS packages to load the date from application database to reporting database.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Was providing support 24/7
• Maintained new server especially for SSIS packages and scheduling packages using Task scheduler and Automation.
• Designed and created reports using SSRS with drop down menu and linked reports.
• Created Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them, in the data field.
• Created ad-hoc reports using power pivot and performance point extracting data from heterogeneous sources.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, identifying and adding the report parameters.
• Developed, designed & implemented - Executive Dashboards (BI), Marketing Analytics, and Life cycle management - from customer acquisition to collections management, Mobile strategy, Digital Analytics using Micro Strategy Analytics.

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, WINOWS SERVER NT/2003/2008R2/2012, SSIS, SSRS, SSAS,T-SQL, Cluster, Snapshot, Stored Procedures, Power Shell, Perl scripting, shell scripting, ERWIN, Spot Light.

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Managing and administering SQL server instances which include 2000/2005/2008/2008 R2/2012.
• Implemented SQL Data Compression Using Sql server 2008 for Compressing Data and Log Files, Back up Level.
• Written and updated some deploy or application scripts in Perl for various build, testing, and system management purposes
• 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.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Configured and Maintained, Monitoring, Installation, patches, DBA tools and Clustering.
• Performed Loading & extracting of data to/from the servers, planning & executing database backup and recovery tasks.
• Migration and up gradation of databases to different version.
• Configured and Maintained, Monitoring, Installation, patches, DBA tools and Clustering.
• Optimized indexes with the use of Index Tuning Wizard and Rebuild indexes.
• Implemented Disaster Recovery (DR) Plan by maintaining Backups and performing the Restoring of the system and user databases.
• Have successfully engaged in various DR (Disaster Recover) efforts for my customers.
• Checked Performance Tuning, Indexing, Query Optimization.
• Implemented automated backup and database maintenance/cleanup jobs.
• Performed ETL to support data loads and transformations using DTS Packages and SSIS..
• Performing query plans and making sure each query is using appropriate indexes.
• Provided on - call 24/7 provide support.
• Implemented the agile process in the scrum methodology and integrated all the scrum processes with our TFS environment.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created SSAS cubes to facilitate the reporting of the business based on historical and current data.
• Created various complex cubes with usage based aggregations and set-count aggregations and used appropriate storage modes like MOLAP, HOLAP and ROLAP depending upon how important the data is and how frequently it needs to be fetched from the DW.
• Implemented Key Performance Indicator Objects, Actions, Hierarchies and Attribute Relationships for added functionality and better performance of SSAS Warehouse.

Environment: MSSQL Server 2008, 2005 and 2000, T-SQL, Perl scripting, shell scripting, Erwin, ASP.Net, DR (Disaster Recover), SSAS, SSIS (ETL), SSRS, Windows Server

Confidential, Dallas, Texas

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2008 and performed data migration from SQL Server 2005 to SQL Server 2008 through attach/detach and backup/restore method.
• Maintenance of Databases (DBCC, DB Re-Indexing).
• Managing Replication environment.
• Define and Monitor health check items for all Database Servers.
• Review and Deployment of changes to UAT and Production environments
• Setup Disaster Recovery solutions as per availability SLAs and participate in annual DR exercise.
• Continuous monitoring of SQL Server Performance.
• Involved in restore operations to refresh the data from production to test servers.
• Involved in creating backup strategy production, test and development servers.
• Document server and database policies and procedures.
• Creating policies and credentials
• Creating management plans for better backup and restore databases.
• Generated ad-hoc reports using MS-Access and Crystal Reports.
• 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.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Configured and Maintained, Monitoring, Installation, patches, DBA tools and Clustering.
• Performed Loading & extracting of data to/from the servers, planning & executing database backup and recovery tasks. Review and Deployment of changes to UAT and Production environments
• Setup Disaster Recovery solutions as per availability SLAs and participate in annual DR exercise.
• Maintain SQL Server Baselines.
• Continuous monitoring of SQL Server Performance.
• Manage enterprise-reporting (SSRS) Dashboard.
• Develop and Schedule SSIS and DTS packages
• Troubleshot databases and custom application issues
• Managed administrative work through automatic script, performing daily/weekly backups.
• Use the Resource Governor to manage SQL Server workload and system resource consumption.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.
• Involved in migration from sql server 2000 to sql server 2005.
• Logical and physical database design using Erwin Data Modeling Tool.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested backup strategies.
• Manage enterprise-reporting (SSRS) Dashboard.
• Created contained databases and user login to access contained databases.
• Develop and Schedule SSIS and DTS packages
• Managed administrative work through automatic script, performing daily/weekly backups.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.
• Tested the packages developed in DEV server to find out any bug and handled the errors encountered at the time of testing.
• Created Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them, in the data field.

Environment: MS SQL Server 2005, SQL Server 2008, Windows 2003 Advanced Server, Windows Server 2008, Microsoft Management Studio, Visual Studio 2005, Erwin, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Installed, configured and maintained MS SQL fail over clustering for critical production servers.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Excellent experience in configuring and maintaining all three types of replication like transactional, snapshot and merge replication.
• Configured Mirroring for better HA/DR of databases.
• Involved in writing T-SQL programming for implanting stored procedures and functions.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Performed validations and handled the errors.
• Performed data profiling using SSIS and streamlined the data according to formatting guidelines.
• Wrote T-SQL, created the stored procedures, triggers, and tables to meet the business and audit specifications.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Created documentation to install SQL Server, apply service pack, hot fix and clustering.
• Implemented enterprise backup solution by Installing and configuring Idera SQL Safe to backup SQL Server 2008/2005/2000, defined the backup/restore strategies to meet the SLA.
• Installed and configured Idera diagnostic manager to monitor and administer SQL Server 2008/2005/2000
• Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005 servers.
• Used SSRS to write complex formulas and query the database to generate different ad-hoc reports.
• Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.
• Implemented enterprise backup solution by Installing and configuring Idera SQL Safe to backup SQL Server 2008/2005/2000, defined the backup/restore strategies to meet the SLA.
• Installed and configured Idera diagnostic manager to monitor and administer SQL Server 2008/2005/2000 .
• Implemented DR by configuring, monitoring and defining control process for Log shipping by meeting the SLA, agreed upon with the business owners
• Designed staging database as intermediate stage for population recovery Data Mart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008R2 using SSIS.
• Filtered bad data from legacy system using Derived column, lookup, Fuzzy Lookup, Fuzzy Grouping and Conditional Split.
• Created Complex SSIS Packages implementing Master-child packages with properties like package configurations, SSIS loggings as well as custom loggings (using Event handlers).

Environment: SQL 2000, SQL Server 2005, WINDOWS 2000, 2003, SSRS, SSIS, SSAS, MS Access.