PROFESSIONAL SUMMARY:

• 9+years of experience in Implementation, Administration and Support of MS SQL Server in Development, Test, UAT and Production Environments.
• Installation and configuration of SQL server with Health Care, Manufacturing and IT sectors.
• Specific hands on experience include administering large and complex Databases, Database Design.
• Entity relationship diagram (ERD) development / normalization and physical database schema design.
• Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.
• Experienced with Change Data Capture (CDC) for insert, update and delete in SQL tables.
• Implemented ServiceNow and customized. Migrated data from ITSM to ServiceNow.
• Created custom - tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version. Experienced in Migrating data between servers (Oracle, MYSQL, Staging, Data warehouse).
• Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
• Experienced in Encryption of Databases on Master DB level, Table level and column level using self-signed certificates and TDE keys for securing the top priority data.
• Implemented Active / Active Clustering and Active Passive Clustering as a disaster recovery solution.
• Implemented AlwaysOn Availability Group on Multiple instances on SQL Server
• Experience in supporting Very Large databases 4TB and troubleshooting the problems.
• Experience with new concepts like Data Auditing, and Policy based management system.
• Experience with concepts like data partitioning, online indexing, DDL triggers, DMV, DMF
• Experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity, and experience in migrating SQL Server 2005/2008/R2 to SQL Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Experienced with Third party tool and applications like Red gate, SQL promt, SQL Monitor, Delphix.
• Experience in configure server and client network protocols like SQL Server and SQL Extensions in SQL 2005 using configuration manager.
• Exquisite skills in database Backup, Restoration, Recovery, Replication, Linked Servers, Database Maintenance Planning.
• Dexterity in implementing different types of High Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping, Database mirroring and clustering.
• Experienced in managing SharePoint Servers as Admin.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience in monitoring database performance using SQL Profiler, and the DB’s percent log space for all database servers using SCOM and Windows Performance counters.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in writing Stored Procedures, User Defined Functions, Cursors, Triggers and Schema.
• Experience in Data Modeling (logical modeling and physical modeling) using Erwin.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
• Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/2005/2008 R2/2012/2014, Oracle 8i/9i/10g/12c, MS Access

Tools:, Utilities SSIS, DTS, SSRS, SQL Server Enterprise Manager, Profiler, SQL Navigator BCP, Query Analyzer, SQL Server Manager, SSMS, Apex log, IDERA, ITSM, ASSURENET, Concur, KRONOS, LOFTWARE, Red gate SQL Compare tool, Database Tuning Advisor, Desk Board, Erwin 7.x, Visual Basic 6.0 & 9.0, ODBC, Excel VBA, ADO, ADO.NET, PL/SQL, TOAD, Visual

Programming: T-SQL, PL/SQL, C#.net, ASP.net, VB.net, VB Script, HTML, Java Script, Unix Shell.

Ticketing system: ITSM, Service Now, JIRA, Remedy.

Operating: Windows NT/2000/2003, Windows 9x, HP-UX 10.x, 11.x, AIX 5.3, Solaris 9/10.

Other Tools: MS Office suite 2000/2003, MS Visio, .Net frame work 1.1/2.0/3.0/3.5/4.0.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. SQL Server Lead DBA

Responsibilities:

• Plan, design, and implement application database code objects, such as ITSM, CONCUR, AssureNET, KRONOS, and LOFTWARE. Worked as a lead in AMS team, prepared root cause analysis reports for P1 incidents.
• Migrated DTS packages to SSIS Packages and upgraded SSIS packages from SQL 2005/2008 R2 to SQL Server 2012.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change management issues.
• Resolved issues on Concur Travel and expenses configuration issues configured Audit rules and Cognos reports.
• Migrated Data to AWS Severs along with SQL server upgradation to AWS for about 30 Instances.
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability.
• Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.
• Implemented Transactional and Snapshot Replication in SQL 2008 R2.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
• Implemented AlwayOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Created Master keys and certificates for implementing Data encryption on secured data.
• Looped cells, variables and created macros using Excel VBA.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Proposed Kronos upgrade project to Client including SQL server upgrade.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Provide database coding to support business applications using T-SQL.
• Experienced with Clustering setup and Active Directory in Windows 2010.
• Develop new processes to facilitate import and normalization, including data file for counter parties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, AWS, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential, LA County, CA

SQL Server Lead DBA

Responsibilities:

• Processed Daily Data Migration through SSIS jobs by collecting data from different servers.
• Converted Oracle server databases to SQL Databases using SSMA to reduce maintenance cost.
• Maintaining the azure portal in creating the databases and archiving the logs and data in SQL Azure.
• Participated in Maintenance activities of SQL Azure and Amazon Web Services (AWS). Writing stored procedures, functions and complex T-SQL queries in SQL AZURE Cloud and AWS.
• Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Implemented Encryption of data on stand-alone instances and AOAG instances using Master Keys, TDE and Certificates.
• Performed Backup compression using third party tool Delphix.
• Performed database maintenance tasks using Third part tool Idera and SQL Monitor.
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability. Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Upgraded/Migrated SQL Server 2008/2005 databases to SQL Server databases and mentored Jr. DBAs and other technical staff.
• Created builds in Team foundation Servers (TFS) for deploying Master scripts in UAT ad Production environments.
• Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Captured changes from logs into CDC change tables by enabling CDC stored procedures.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment.
• Implemented AlwayOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Configured and implemented SAVIOM project management, after testing Change Point and NetSuite Project management and Resource Management.
• Responsible for creating and maintaining API interfaces between applications and databases.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Upgraded SQL servers from 2005 and 2008 versions to SQL 2014 and 2016.
• Provide database coding to support business applications using PL SQL, T-SQL.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
• Created reports using SSRS and deployed on to SharePoint Servers.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2012 Enterprise Edition, SSMA, MS-SQL Server / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, AWS, SSIS, SSRS, PL SQL, T-SQL Visual Studio 2012, 2013, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2010

Confidential, Freehold, NJ

SQL Server Lead DBA

Responsibilities:

• Involved in updating existing databases of SQL server Managed database security policy login using Windows and SQL server authentication mode.
• Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Design and develop SSIS packages, store procedures, configuration files, and tables, views, and functions implement best practices to maintain optimal performance.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the data warehouse.
• Generated reports by using SSRS and provided them on web server Report manager.
• Worked with importing flat files and XML files, Share Point, fetched data from other data source like MS Access, DB2, MySQL, Oracle and ETL to the database. Created UNIX shell script to move file across the servers and automation of daily tasks.
• Migrated data from MySQL DB to SQL DB using SSIS.
• Checked database upgrade advisor for compatibility check for databases before updates.
• Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases, increased physical memory, and enabled text indexes.
• Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. export / import and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from the developers and non - technical staff member using views.
• Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Identified long running queries using Desk Board report. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved in Tabular Data warehouse operations for SSAS 2012 and 2008 OLAP databases.
• Involved in performing Audits and recovery operations of SSAS objects. Created reports to generate them through Email for the administrative using MDX Queries.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Studio 2010,Sybase, MYSQL, Toad, Indexes, LogShiping, .Net Framework 3.5, snapshot, Replication, MS Office suite 2010.

Confidential, Raritan, NJ

SQL DBA

Responsibilities:

• Involved in beginning of the project, updated existing database from Oracle Servers to SQL server Managed database security policy login using Windows and SQL server authentication mode.
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change issues.
• Resolved issues on Concur Travel and expenses configuration issues configured Audit rules and Cognos reports.
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Involved in the Service Now implementation project.
• Configured and scheduled Kronos accrual jobs. Given support to End users for Vacation and accrual issues.
• Created job codes for roles in Kronos for all level of employees.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import / export data feeds to / from OLAP data warehouse and claim system.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the OLAP data warehouse.
• Installed, configured, operated and troubleshot Web SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
• Generated reports by using SSRS and provided them on web server Report manager.
• Worked with importing flat files and XML files, Share Point, fetched data from other data source like PL SQL, MySQL, and ETL (Extract, Transform and Load) to the database.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases like increased physical memory, and enabled text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Configured database log shipping and mirroring to maintain, prevent from the disaster recovery and managed ASCO’s standards. Configured and managed primary- standby nodes for High availability of database for users and manage organization standards.
• Identified long running queries using Desk Board report. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
• Worked with importing flat files and XML files, fetched data from other data source like MS Access, DB2, Mysql, Oracle and ETL (Extract, Transform and Load) to the database using SSIS. Created UNIX shell script to move file across the servers and automation of daily tasks.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, Sybase, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Basics, Visual Studio 2008, Indexes, Cluster, .Net Framework 3.5, snapshot, Replication, MS Office suite 2011, Cognos 10.

Confidential, Brookfield, WI

SQL Server Developer,DBA

Responsibilities:

• Involved in new databases design and creation using Rational Rose.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Worked on creation and improving the stored procedures and triggers performance.
• Implementation of Microsoft Office SharePoint Server Beta for corporate intranet, document management, collaboration.
• Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
• Responsible for Query Performance tuning and Optimization.
• Created views, SQL joins DTS packages and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Generated T-SQL code for creating cursor and handling the data validations.
• Created SQL server Analysis Projects using MS SQL Server
• ETL packages are created to extract, transform and load data to data ware house using SSIS.
• Using SSIS the data is transferred to and from flat files, MS Excel, MS Access and SQL Server 2005. .
• Implemented the calculations to aggregate physical measures using management studio.
• Involved in creation of Multi - Dimensional Cubes and Relational Cubes.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.
• Developed and maintained MS Access database.
• Supported development of a speciation control documents for an MS Access Project Management Database.

Environment: MS Office suite 2000, MS-SQL Server Management Studio 2000/2005, T-SQL, DTS, Replication, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access, Erwin, SQL Query Analyzer.

Confidential, Grand Rapids, MI

SQL Server DBA

Responsibilities:

• Involved in beginning of the project, updated existing database from SQL server instances to SQL server Managed database security policy login using Windows and SQL server authentication mode.
• Design primary-standby databases (Manual log shipping to the same servers) setup for existing applications running in SQL server Standard Edition and Enterprise Edition.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Installed, configured, operated and troubleshot Windows SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
• Involved in Design of Data warehouse using Kimball and Star Schema and created Fact tables and dimension table.
• Created cubes and configured and deployed cubes using SSAS.
• Created XML files by using SSIS Package Configuration.
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
• Moved SQL server objects among test, QA and Production environment. Took full, differential and Transactional backup of databases often and moved them to external tape storages.
• Used DDL to define indexes (keys), specifies links between tables, and imposes constraints between tables.
• Delivered SharePoint training to users and administrators.
• Worked with internal and external clients for import and normalization of third-party data.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Created Logical & Physical Database modeling for in house development application. Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using the concept of OLE DB.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• OLAP Created, altered, maintained system roles and permissions to users on various database objects.
• Responsible for creation of new database objects like stored procedures, tables, view, triggers, function according business logics. Inserted XML file parameter in to the database tables using services.
• Used Rational Rose/MS Office Suite for creating use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.
• Worked with IBM Rational Clear Case and Rational Clear Quest to automate and enforce the development processes and aid with configuration management.
• Audited database user’s audits using SQL profiler and costumed stored procedures/packages.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Developing various simple to complex reports using different Reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports and Business Objects.
• Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources and ETL related operations. Partitioned large tables1.2 million rows tables using range partition.
• Providing high availability SQL Server solutions, including Log shipping, Mirroring, Snapshot and Replication.
• Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Developed complex reports and provided to business people for further analysis. Responsible for make changes in application according to business logic.
• Faced, resolved connectivity issues and ODBC with front end application languages ASP.net, VB.net and C#.net. Responsible for connectivity issues to the database, IIS 6.0 and VERITAS Cluster software among servers.
• Involved in Staging Partitions and Usage Based Optimization ( UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved in Tabular Data warehouse operations for SSAS 2008 OLAP databases.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.

Environment: Windows NT/2008, MS SQL Server Management Studio 2008 R2, T-SQL, DTS, SSIS, SSRS, SSAS, TFS, Replication, Oracle 9i, Rational Rose, Informatica 8.6, PL/SQL, SQL*Plus, SQL*Loader, Shell scripts, .NET Framework 4.0, VB.NET, C#.net, Visual Basic 7.0, Visual Studio 2008, ERwin 4.0.5, ODBC, AIX 5.3