SUMMARY:

• 12 years of experience in Design, Development, Implementation & Administration of Client - Server Applications & Database systems using MSSQL 7.0/ 2000/2005/2008 /2008 R 2/2012/2014/2016 /2017 .
• Worked with 2 Fortune 50 ranked companies for around 6 years.
• Worked for top auto insurer and top bank in assets.
• Collaborated extensively with higher management as well as junior team members.
• Expert skills on SQL Server Installation, Configuration, Performance Monitoring, Query Optimization, Indexing, Security Administration and Replication
• Experience in Data modeling and Database Design using SQL Diagrams, MS Visio and Erwin.
• Experience in Database Programming using T-SQL in writing Stored Procedures, Triggers, DTS/SSIS packages
• Developing comprehensive Database Backup strategies (Full, Differential and Tran logs) and successfully Implementing Various Recovery/Restore methodologies
• Responsible for automation of maintenance jobs, Day-to-day maintenance activities like running DBCC checks, Transaction Logs, file growths etc.
• Experience in Architecting the system from conception to inception of SQL Server.
• Involved in VLDB Configuration by DB Striping, placement of Indexes across different drives, RAID levels.
• Experience in meeting all service level agreements and maintain 99.999 application uptime.
• Worked across development/Test/Production environments.
• Involved in Data migrations and data conversions involving as large as 100million rows using Bulk Insert, BCP, DTS, SSIS utilities
• Worked extensively on complex T-SQL Store Procedures, Triggers, Functions, subqueries for different SQL development activities.
• Worked on SQL Server BI stack using SSIS, SSRS on SQL Server 2008/2008R 2/2012/2014.
• Exposure to multiple Database systems like MS SQL, Oracle, MS Access
• Experienced in scripting technologies like T-SQL and PowerShell.
• Administer & Support mission critical databases and provide 24*7 Production support
• Involved in Server & DB Monitoring and tuning efforts using various tools like Perfmon, SQL Server Profiler, Index Tuning Wizard(ITW), SPOTLIGHT, Log Explorer
• Strong knowledge working on Windows 2003/ 2008/2012/2012 R2/2016 Servers.
• Install, deploy, Administer and Support Web Applications on IIS Webservers, Reporting Services
• Worked on PowerShell to automate SQL Server Administrative Tasks.
• Experience working with TDE encryption in SQL Server.
• Extensive experience Optimizing Store Procedures for different DB activities. in Implementation of High availability solutions using Log shipping, SQL Server failover Cluster, Replication, Mirroring, Always ON for DR/Standby servers
• Have strong background in Computers & Mathematics; Excellent analytical, organizational, problem solving, logical analysis, interpersonal and communication skills; good team spirit, ability to learn new technical skills quickly and effectively; hard working and highly determined.

TECHNICAL SKILLS:

Programming Languages: T-SQL, C, Java, XML, VBScript, JavaScript

Web Technologies: HTML, XML, JSP, JavaScript, Adobe Photoshop, Fireworks

Database: MS SQL 7.0/ 2000/2005/2008 R2/2012/2014 Oracle, MS Access

SQL Services: SSRS, SSIS, DTS, Log Shipping, Clustering, Replication

Tools: SQL Lite Speed, DB Artisan, ER/Studio, Rapid SQL, REDGATE, SPOTLIGHT, DBDIFF, Visual Studio 2010, 2013,2015,2017, IDERA Tools, TDP/TSM Netbackup

Application Server: IIS, Reporting Service

Designing Tools: UML, Database design with Visio, SQL Diagrams, Erwin Data Modeling, OLAP, OLTP

Version Control: Visual Source Safe, PVCS, VS TFS

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr SQL Server DBA with BI

Responsibilities:

• Database Administration using MSSQL 2000/ 2005/2008/2008 R 2/2012/2014/2016
• Primary DBA for most important databases used for general health administration of the organization.
• Involved in capacity planning activities of the Production Servers so that there is no need for auto growth and ad-hoc space addition.
• Proposed the OLA Re-index and backup solutions to the organization which saved lot of hours for re-index processing and system was used more for business-critical operations.
• Implemented free solution for organization which send the team alert whenever the system reboots with timestamp info.
• Deployed T-SQL code to Production, QA, Development boxes using appropriate change record with SOX and HIPAA compliance.
• Worked on Day to tickets to using ServiceNow using all the principles of ITIL.
• Helped the project kick start by proposing and implementing all the details involved in DEV box step for proof of concept/Development and QA.
• Helped the organization migrate many business-critical databases with minimal downtime from SQL 2005/2008/2008 R2/2012 to SQL 2014/2016.
• Worked with the development team to performance tune the T-SQL queries so that a very important job duration was changed to 9.30hrs to 7 Hrs.
• Deployed different BI stack (SSIS / SSRS / SSAS) to Development/Test/ Production Servers.
• Proposed a comprehensive solution to the organization were most of the access process can be automated and all steps can be audited which can later be used for SOX.
• Proposed and implemented the latest solutions for SQL 2016 using Column Store, Memory-optimized tables, Query Store which optimized/improved the applications.
• Worked extensively on Availability Groups setup/troubleshooting on SQL Server 2014/2016
• Implementation all the SQL features like Mirroring/Replication/Log Shipping on SQL Server 2008/2008R 2/2012/2014/2016 .
• Implemented/Troubleshooted all the Clustering features like Active/Passive and Active/Active Clusters.
• Performed all other regular SQL Server Database Administration tasks.

Environment: MS SQL Server 2008/2008R 2/2012/2014/2016, XML, VMWARE; Windows 2008/2012/2012 R2/2016, T-SQL, SSIS, SSRS, SSAS.

Confidential, Grand Rapids, MI

Sr SQL Server DBA with BI

Responsibilities:

• Design, Development, Implementation & Administration of Client-Server Applications & Database systems using MSSQL 2000/ 2005/2008/2008 R 2/2012/2014/2016
• Manage SQL Server database servers through multiple product lifecycle environments, from development to mission-critical production systems.
• Installs, configures, maintains and upgrades database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, backups, security, etc.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekend.
• Helped write complex T-SQL code to automate some SSIS(ETL) activities.
• Runs schema and data comparisons.
• Prepares deployment and rollback scripts.
• Experienced in writing T-SQL code for DDL/DML/DCL activities for Store Procedures, Trigger, Functions, SSIS(ETL), SSRS.
• Perform scheduled maintenance and support release deployment activities after hours.
• Monitor SQL Server Alerts, configuration via monitoring tools such as SolarWinds DPA (Database Performance Analyzer), Red Gate SQL Monitor.
• Written end to end PowerShell Scripting to automate databases refreshes from one environment to another
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Extensive experience in Optimizing Store Procedure for pulling student record information.
• Document the company’s database environment.
• Worked extensively on complex Always ON install, maintain and troubleshoot.
• Extensive experience on read-only Always ON routing.
• Managed complex Replication environment paired with SQL Server Always ON.
• Used PowerShell to automate basic daily SQL Server admin activities.

Environment: MSSQL SQL Server 2008/2008R 2/2012/2014/2016, HTML, JavaScript, XML, VMWARE; Windows 2008/2012/2012 R2/2016, T-SQL, SSIS, SSRS.

Confidential, Bloomington, IL

Sr SQL Server DBA with BI

Responsibilities:

• Used HP Service Manager to resolve Tickets on a day to day basis.
• Involved in Change Management Task, Recovery Tasks and requests
• Installation& Configuration of SQL Server 7.0/ 2000/2005/2008 /2008 R 2/2012/2014/2016 . server on test and production environments
• Worked on SQL Server systems both on physical as well as VMWARE infrastructure.
• Creation and configuration of SQL Databases including striping VLDB’s (8TB) across multiple files and file groups (Data files, Log files, Index files, TEMP DB)
• Security Administration (adding logins, DB users, granting permissions thru roles, managing Schemas) on the SQL Server
• Worked on multiple projects involving data cleansing and data discrepancies remediation.
• Worked on complex T-SQL Code using Store Procedures, Functions, Triggers to create business logic based on web application requirement.
• Written extensive ETL T-SQL code to cleanse, aggregate data according to quarterly, yearly.
• Involved in Change Management Task, Recovery Tasks and requests
• Optimized code for Store Procedures which were used to pull the claims details for the customer.
• Reduced the time taken for Store Procedures from 3 min to few seconds using temp tables instead of direct merges on tables.
• Extensive use of Scripting tools like T-SQL and PowerShell to automate all the common DBA/Developer activities for ETL/SSIS/SSRS packages.
• Written PowerShell scripts to perform automated patching of SQL Server instances.
• Extensively involved in creating schema using Erwin Data Modelling tool.
• Worked on ER Studio Data modelling tool for designing schema, create and update DB objects in SQL Server.
• Deployed some of the test environments into AWS EC2 platform.
• Working on processes to move historical data into data warehouse and very old data into archival systems.
• Designed SQL BI applications using SSIS.
• Experience in both OLTP and OLAP-Data warehouse systems.
• Sound knowledge on Installation, configuration and development of SSIS, SSRS.
• Worked on creating dashboards and various reports using SQL Server 2012 Reporting services to display different business critical data for policies.
• Created packages for data aggregation, cleansing, loading using SSIS(ETL).
• Worked on backend databased for Salesforce/SharePoint/Lync.
• Reverse engineering schema for both OLTP - OLAP and made changes according to business requirement.
• Creation & Migration of various DB Objects like Tables, Primary Keys, Foreign Keys, Indexes, Stored Procedures, functions across multiple environments
• Implementation of Backup and Recovery methodologies involving Full and Tran log backups across Production, UAT and Development servers
• Programmed stored procedures and created DTS packages using MS SQL Server to perform data cleansing and to replicate data to the remote database server.
• Involved in creating Linked Servers across between SQL Servers and across other heterogeneous data sources like Oracle, MS-Access, ADSI (Active Directory services)
• Monitored Transaction Logs and DB Growth and attending space issues
• Resolved Blockings and Proactively monitored Deadlocks and resolve them by setting up trace flags - T1204,1205, -T1222 as startup parameters
• Investigated Defragmentation & Perf tuning using DBCC ShowContig, REINDEX, INDEX DEFRAG, and Update Statistics.
• Day to day Perf tuning activities for Hardware, Server, Database and QUERY Optimization techniques.
• Documented Bug fixes, new technologies, Installation procedures.
• Working with various Development/User team to resolve and test all ongoing/new issues
• Interacting with Windows OS, SAN, Security and Monitoring areas to setup procedures for SQL Server 2005/2008/2012 installation, storage, backup and recovery and security.
• Implemented migration of SQL Server 2000/2005 to SQL Server 2008/2008R 2/2012/2014/2016 .
• Involved in 24*7 Production support
• Installation of Service packs, hotfixes and rollout to all environments methodically
• Involved in Installation, maintenance and troubleshooting of different SQL Server Replication implementations.
• Worked on PowerShell scripts for various SQL Server related tasks.
• Installation, Maintenance, Troubleshooting, Upgrade of Log shipping, SQL Server failover Cluster(Active-Active/Active-Passive), Replication, Mirroring, Always ON for DR/Standby.

Environment: MSSQL SQL Server 2008/2008R 2/2012/2014/2016, HTML, JavaScript, XML, VMWARE; Windows 2003/ 2008/2012/2012 R2/2016, MS IIS 5.0, T-SQL, XML

Confidential

Sr SQL Server DBA with BI

Responsibilities:

• Evaluate all the legacy systems and Design new system involving capacity planning, Servers Hardware level requirements, storage requirements
• Design new databases combining all Legacy systems like Confidential hierarchical Mumps database.
• Identifying Sever Configurations and SAN space and Installation, configuration and maintenance of the new systems across all environments (Development, Test & Production)
• Involved in Logical/Physical/datadictionary modeling using Erwin and other data modelling tools like ER/Studio.
• Design tables, implement relationships (Primary/Foreign Key) & forward engineer across all the environments based on application requirements
• Created DB objects like Indexes, Stored procedures & triggers using T-SQL and maintain them for Loan business logic.
• Designed SQL Server security architecture using Logins, Roles, Schema etc.
• Worked with data migration and wrote the SSIS(ETL) packages to migrate all the data from Legacy systems to SQL Server.
• Involved in programming stored procedures and created DTS packages using MS SQL Server to perform data cleansing and to replicate data to the remote database server
• Created Linked Servers across Other SQL Servers and MS Access and uploaded data using the Link servers
• Used Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Extensive ETL experience in exporting and importing Data to and from Oracle, IBM DB2, Mainframe using SSIS/DTS.
• Set up Transactional Replication between servers and troubleshoot the issues
• Monitor database growth activities & Troubleshoot Transaction Log Issues
• Performance Tuning/Query tuning using Fog light/ DMF’s. Worked with Query tuning, execution plans, trace flags and SQL Profiler
• Scheduled weekly Re index & other Database Maintenance Jobs to check database consistencies
• Installation of Service packs, hotfixes and rollout to all environments
• Supported the OLAP databases.
• Involved in Code reviews and Change Control methodologies
• Collaborated on 24*7 production support during on call rotation.

Environment: MSSQL SQL Server 2008/20050, MS CRM 4.0, T-SQL, .NET Framework3.5, Erwin 6.0, IIS, HTML, XML, SQL Lite speed, DB Artisan, SSIS, SSRS. Fog light, Virtualization, JavaScript, Windows Server 2008

Confidential, HOUSTON, TX

Sr SQL Server DBA with BI

Responsibilities:

• Installation & configuration of SQL Server 2000/2005/2008 on DEV, Test and Production Servers
• Teamed with various IT and engineering teams regarding the get the best possible Hardware, software requirements of the Servers and data centers
• Resolved day to day tickets, covering all the areas on SQL Server (Installation, Security Administration, Space Issues, and Backup Recovery).
• Worked extensively on complex Store Procedures, Triggers, Functions, Views and other T-SQL.
• Support the databases both in Clustered/Non-clustered Environments.
• Dealt with VLDB databases as big as 4 TB.
• Involved in migration of SQL 2000 to SQL 2005, SQL 2005 to SQL 2008/2008R2
• Implemented DR for Production instances in form or Replication, DB Mirroring, Log Shipping
• Performed migration of the DTS packages to the SSIS packages.
• Collaborated with the developers in Performance tuning and query optimization several mission critical T-SQL coding.
• Supported replication on many mission critical application databases.
• Managed challenging work shift environment
• Set-up and troubleshooting heavily on Clustered Environments, Active-Passive, and Active-Active.
• Written SSIS packages for the production data migrations and ETLs to transfer huge chunks of data.
• Developed medium to complex reports using SSRS using SQL Server 2008 to display business critical KPIs.

Environment: MSSQL SQL Server 2000/2005/2008 , T-SQL, Tivoli, VSS, Erwin 6.0, IIS, HTML, XML, SQL Lite speed, DB Artisan, JavaScript, Windows Server 2008

Confidential

SQL Server DBA/Developer/BI Trainee

Responsibilities:

• Follow all the principles of SDLC, AGILE and SCRUM in project development as needed.
• Evaluate all the features of SQL Server and suggest best possible direction for the client.
• Set up & Configure database servers for multiple environments (Development, Test & Production)
• Design tables, implement relationships (Primary/Foreign Key) & forward engineer across all the environments based on application requirements
• Involved in Creation of DB objects like Indexes, Stored procedures & triggers using T-SQL and maintain them
• Created Logins, users & roles and involved in Daily User Maintenance
• Involved in programming stored procedures and created DTS packages using MS SQL Server to perform data cleansing and to replicate data to the remote database server
• Created Linked Servers across Other SQL Servers and MS Access and uploaded data using the Link servers
• Created Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Set up Transactional Replication between servers and troubleshoot the issues
• Monitor database growth activities & Troubleshoot Transaction Log Issues
• Scheduled weekly Re index & other Database Maintenance Jobs to check database consistencies
• Designed and developed the Database prototype of a web-based Report Request tracking system that used for tracking report requests submitted by Virtual Lab client to the offshore data management team.
• Maintaining four corporate web sites. Tasks include server migration, troubleshooting web application Connectivity issues, monitoring availability and performance, and support deployment of new enhancements

Environment: MSSQL 7.0/ 2000/2005/2008, T-SQL, VB Script, ActiveX, DB Artisan, DBDiff, IIS, HTML, JavaScript, HTML, Windows 2000 Advanced Server, Compaq ProLiant 6000/7000, Terminal Services