SUMMARY:

• 12 years of experience in Design, Development, Implementation & Administration of Client - Server Applications & Database systems using MSSQL 7.0/ 2000/20 R 2/2012/2 .
• 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.
• Know of administering SQL Server on AWS and Azure.
• 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:

TSQL:, C, Java, XML, VBScript, JavaScript, Visual Basic

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

EXPERIENCE SUMMARY:

Confidential, Denver, CO

Sr SQL Server DBA

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

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

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/20 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, Wichita, KS

Sr SQL Server DBA

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 Sybase, Onyx and 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/ DMV’s and 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

SQL Server DBA

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