SUMMARY:

• Extensive experience developing and working with diverse collection of applications and Around 6 years of professional experience as Microsoft SQL server database administration and developer.
• Extensive experience in maintaining Very large databases (VLDB) and highly trans active production SQLServer 2017/2016/2014/2012/2008 R 2/2008/2005/2000 /7.0 env.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active - Active and Active Passive) and Database Mirroring
• Handful of Experience on SQL server 2016new features likeAlways Encrypted, Stretch Database, Query Store .
• Experience in Migrating from SQL server 2000 to 2005 and 2000/ R2and 2008/2008R2 to 2014,2016by using side-by-side upgrade process anddocumented the Upgrade Process.
• Extensively worked on Backup compression and data compression in SQL Server 2008.
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMwareEnvironment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, DQS (Data Quality Services), MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS).
• Expertise on physical storage SAN configuration on different RAID levels.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Hands on experience with administering large databases, managed databases of size above4 terabytes, database design, normalization and database application development using varied development tools.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical table partitioning.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting sql server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Explicitly used third party tools like Litespeed, OPSview, Fog light and Red gate, Solarwinds, Tivoli Storage Manager (TSM).
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Checking the threshold values and baselines and monitoring in perfmon and SCOM.
• Rebuilding indexes with different fill factors and updating statistics.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008R2/2008/2005,2000/7.0, Oracle, MYSQL

Languages: T-SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual studio2005/2003

Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, Microsoft Office Suite

Tools: Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM

Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008 R2, Windows 95/98/XP/Vista/7.

Others: Microsoft office, Microsoft Project.

PROFESSIONAL EXPERIENCE:

Confidential, Maryland Heights, MO

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2017(LINUX POC), 2016, 2014, 2012 and 2008R2 on Test, Development and Production Environments.
• Managed and Administered SQL server databases on Microsoft Azure Platforms(IAAS,PAAS).
• Administered and maintained production/Development servers with more than 4+ TB OCC (OnCommand Connection), PROS(Parts Pricing) databaseswith complex structures.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012,2014,2016.
• Implemented Database Mirroring to provide high availability for Navistar’s Engine Tracking application.
• Created the Navistar Prowatch User Group to share knowledge between the plants on the working of the software used to record employees entering and leaving the plant via turnstiles.
• Migrated Navistar’s CorpTax, License Management, Special Parts Pricing applications from SQL Server 2008 to SQL Server 2014.
• Implemented Engine Shop Floor Application Databases migration from SQL Server 2005 to SQL Server 2014.
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Upgraded/Migrated SQL Server 2000/2005/2008 R2 databases into SQL server 2008R /2016.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Extensively worked on Control-M backup, IBM tools, CMDB.
• Did Performance Tuning of the Stored Procedures.
• Worked with SQL Server 2008,2012,2014,2016 inplace and side by side upgrade from SQL server 2005
• Hands on experience in trouble shooting database issues.
• Created documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2014 and from SQL server server.
• Performed daily tasks including backup and restore by using SQL Server 2012, 2014 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008/2012 and Flat files.
• Responsible for monitoring and making recommendations for performance improvement in 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

Environment: SQL Server 2016/2014/2008 r2/2008/2005,2000 SQL Server Enterprise Manager, Query Analyzer, Transact-SQL (T-SQL), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MS Access, MS Visual Studio, Bulk Copy Program (BCP), Microsoft Office, MS Visio 2003/2007/2010, C.

Confidential, Oceanside, CA

Sr.SQL Server DBA

Responsibilities:

• Administrated and Managed SQLServer 2012/2008R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000/2005/2008 R2 databases into SQL server 2008R2/2012 and mentored other technical staff.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like SQL SENTRY Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Created a SSIS replication package from production to 12 pool servers.
• Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008/2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• 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
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Generated multi parameterized reports in MS SSRS 2008/2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008/2012 based reports.
• Worked on TFS for project handling.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL, .Net framework, XML, MS Visual, TFS

Confidential

Sr.SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2012 and 2008R2 on Test, Development and Production Environments.
• Worked with SQL Server 2008 inplace and side by side upgrade from SQL server 2005.
• Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection.
• Worked in Active passive cluster environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Successfully implemented the Capacity planning for different servers.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Performed data partitioning for efficient management of database tables and indexes.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Rebuilding the indexes at regular intervals for better performance.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Monitored and modified Performance using execution plans and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performance testing on stored procedures, indexes, and triggers.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in applying Service Packs at database and OS Level.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Checking Database Health by using DBCC Commands and DMVS
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations
• Expertise in SQL server Reporting Services(SSRS)

Environment: SQL Server 2012/2008R2/08/05/00,Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, Redgate, MS Visio, Microsoft SQL server Visual Studio 2005/2008/2010, MS Business Intelligence Development Studio 2008, FogLite.

Confidential

Jr SQL DBA

Responsibilities:

• SQL Server 2008 R2/2008/2005 Database Administration.
• Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008 R2.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Experience working with CRM Application issues.
• Installed and configured Microsoft SQL two node Clustering (Active/Passive).
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Deployed multi-campus backup environment based on EMC Data domain storage.
• Installed and configured Storage Area Networks(SAN) in a heterogeneous environment.
• Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Successfully implemented the Capacity planning for different servers.
• Experienced in configuring Powershell environment for SQL support.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Try- Catch statement, Common Table Expression(CTE).
• Worked in Active/passive and Active/Active cluster environment and Installed and Configured more than 50 Clustered SQL Instances
• Worked on Project for setting up DB mirroring and troubleshooting.
• Worked on setting up Transactional Replication (push and pull) and Merge Replication and troubleshooting along with Slip stream installations and TDE.
• Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.
• Implementation of SQL failover cluster and setting up backup jobs and Checking Control Jobs.
• Creating and Maintaining Database Maintenance Plans and Worked in migrating database to different collations
• Implementing and Maintaining Server Level Auditing for auditing of Logins, Creating and Dropping Objects.
• Checking the performance issues on servers as per request by using profiler, perfmon, DBCC and DMVs.
• Monitoring servers by checking Error Logs, Windows Logs, Creating Logins and Roles with appropriate permissions.
• Worked in Configurations of IIS (Internet Information Service) in ISP environment with access to SQL DBs
• Installed and Configured SSRS and Deploying SSIS packages.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes using Data Tuning Advisor.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008/2005, Windows 2003 Server, IIS 6.0, XML, MS Business Intelligence Development Studio, DB compare.