PROFESSIONAL SUMMARY:

• 7+ years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server2016/2014/2012/2008 R2 / 2008 / 2005 / 2000in Development, Test and Production Environments.
• Experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading SQL Server 2014/2012/2008/2008R2/2005/2000 on Clustered and Standby Environments.
• Expertise in Upgrading SQL Server to new versions, applying service packs and hot - fixes, and unattended Installation.
• Experience in Migrating from SQL server 2000 to 2005 and 2000/2005 to 2008R2 and 2000/2005/2008/2008R2 to 2012 by using In-Place upgrade process and as well as side-by-side upgrade process and documented the Upgrade Process.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005/2008/2008R2/2012/2014 versions.
• Experience on Database Mirroring and Log shipping with Network Authentication.
• Experience on SQL Server Replication that is Snapshot, Transactional & Merge.
• Experience in implementing and Monitoringdifferent types High Availability and Disaster Recovery scenarios like Always on, Replication, log shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev environments.
• Experience usingSQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in supporting Very Large Database (VLDB) more than 8TB and troubleshooting problems.
• Experience in designing data warehouse and building interfaces for SAP Business Objects.
• Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and LiteSpeed to/from Disk /Legato server (Tape).
• Very good experience on working with SCOM Monitoring.
• Extensively used tools like SSMS, SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries and also good experience in data (table) partitioning.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing.
• Strong SQL Server Developer Skills including writing Transact-SQL Queries, stored procedures, user defined functions, views and Good understanding of Normalization /De-normalization, Database design and modeling (logical and physical).
• Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool.
• Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Created linked servers between SQL Server 2000 & Oracle 9i, 10g & 11g and Teradata and DB2.
• Expertise usingBusiness Intelligenceand development tools likeSSIS, SSRS and SSAS to manage data warehouse environment.
• 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.
• Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Programming Languages: C, C++, SQL, TSQL, VB.NET, ASP.NET.

RDBMS: MS-SQL Server 2005/2008/2008R2/2012/2014/2016, Oracle 11g

BI Tools: SSIS, SSAS, SSRS 2005/2008/2008R2/2012, DTS.

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer.

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003/2008/2008R2/2012.

Data Modeling Tools: Erwin, RedGate, LiteSpeed, Idera.

PROFESSIONAL EXPERIENCE:

Confidential, CT

SQL Server DBA

Responsibilities:

• Installation and managingSQL Server 2016, 2014, 2012, 2008R2, 2008 on different environments.
• Experience in creating, managingSQL Server AZURE Databases and setting up Connection Strings and connecting SQL Server AZURE Databases from locally installed SQL Server Management Studio(SSMS) for Developers
• Responsible for integrating data into a centralizeddatabase with dynamic designanduser friendly web application, to keep trackof Direct Bill Payments andCommissions from various Clients across the nation.
• Worked on designing and implementing Always On for database environment to make sure we have 99.99% uptime and24/7 High availability of as part of the DR implementation.
• Involved in Data center Migration project for moving databasesacross the location which includes around 500 serverswith SQL Server 2008 to SQL Server 2012, 2014, & 2016.
• Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment.
• UpgradedtoSQL Server 2012and guiding the development and application team to fully utilize SQL Server 2012 enhancements.
• Implemented backup strategy for the new data center environment.
• Planning and Implementation of Data archiving strategies usingOPTIMfor the data life cycle management and data retention procedures.
• Dailysupport, troubleshooting, monitoring, optimizationandtuningof SQL server environments across entire system.
• Involved inChange Control Managementis the discipline of systematically identifying and controllingchangerequeststo a project from both internal and external sources.
• Working withServiceNow Tickets(Any changes on Production, staging and development environment need to Create ServiceNow Tickets).
• CreatedMerge Replicationbetween different data centers. Resolved issues; designed and managed database security.
• Installed and managed SSIS, SSAS and SSRS services on different environments.
• Developed SSRS reports for the internal reporting dashboard.
• Managed SSAS cubes and supported full, incremental load process.
• HandledPerformance Tuningand Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• CreatedDatabase DiagramusingErwin Data Modeler,Data Dictionary Document,Database Installation and Configuration Document and Merge Replication Setup Document.
• Experience in integrating different database environments like Sybase SQL Server, Oracle SQL Server etc.
• Worked onDTS Package,DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Experience inDesigning Data Martand Data Warehouse using Star Schema and Snowflake Schemaand OLAP Technology Analysis Services and Cognos using SQL Server 2008.
• PerformedCapacityPlanning,data modelingandLogical/Physicaldatabase Design.

Environment: SQL Server 2005/2008/2008R2/2012/2014/2016,T-SQL, SSIS, SSAS, SSRS, Query Analyzer, SQL Profiler, Performance Monitor,Remedy, Lite Speed, Data Compression,SAN, PowerShell, Active Directory, Windows 2012/2008R2/2008/2003/NT/XP

Confidential, Mounds View, MN

SQL Server DBA

Responsibilities:

• SQL Server 2008/2008R2/2012/2014/2016 Database Development and Administration.
• Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008/2008R2/2005 on standby environments.
• Installed latest service packs, applied hot fixes and cumulative updates.
• Migrated servers from 2005 to 2012 and 2008 to 2012 with In-place and Side-by-Side Processes.
• SQL Server Patching on 2005, 2008, 2008R2, 2012, 2014.
• Applied Patches and Service packs to update different versions of MS SQL Server in Clustered and standalone environments.
• Created linked servers between SQL Server 2005 and 2008, 2008R2 and 2012.
• Administering SQL Server High Availability features like Log shipping, Database Mirroring and Always On.
• Worked onActive/Passive clusters to manage cluster resources and troubleshoot errors.
• Used log shipping, Always on Availability Groups and Mirroring for synchronization of databases and worked with Transactional Replication to achieve load balancing.
• Ensure backup and recoverability of all enterprise SQL server databases using Native SQL and Symantec Netbackup.
• Daily routine Developer/DBA tasks like handling user’s permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production servers and handling maintenance jobs.
• Implemented the TDE (Transparent Data Encryption) in all the production servers to secure the customer credit card or payment details and also in order to follow the PCI standards.
• Installed, Configured, managed security for SSIS, SSAS, and SSRS (2008 R2, 2012 &2014).
• Creating SSIS packages to load data across different servers.
• Re-Designed Siemens model cubes (SSAS) by partitioning the cubes yearly and then monthly.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Involved in integration/system testing and backup/restore testing for all components.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Experience with Team Foundation Server and BI Documenter tool.
• UsedTFSfor source control and managing development via tasks/bugs.
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines.
• On Call 24X7 support, request queue, daily maintenance and application support.

Environment:SQL Server 2005/2008/2008R2/2012/2014/2016,Visual Studio 2008/2010,BIDS, T-SQL, SSIS, SSAS, SSRS, Red Gate SQL Compare, Lite Speed, Performance Analysis (PA), HP Quality Center, Crystal Reports, TFS, MS-Excel, XML, Windows 2012/2008R2/2008/2003/NT/XP.

Confidential, MN

SQL Server DBA

Responsibilities:

• Managed and Administrated SQL SERVER 2005/2008/2008R2/2012/2014 highly transitive Production Environment and Active passive clustered environment.
• Migrated databases from SQL Server 2005 to 2008R2 and 2008 to 2012 documented the process with Pre-Migration and Post-Migration steps.
• Handling Memory configurations for SQL Server 2008R2 and 2008 on Windows 2008.
• Implemented the SQL Server 2008/2008R2 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, CTE,DDL triggers, TRY-CATCH blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Solid experience in configuring and managing of high availability SQL Server solutions including Always on, Log shipping, Database Mirroring and SQL Server Failover Clustering.
• Installed, Configured, managed security for SSIS, SSAS, and SSRS (2008 R2).
• Created, Configured, deployed SSIS packages across environments.
• Created SSIS packages to process SSAS cubes in parallel & in sequence also.
• Partitioned SSAS cubes based on date keys.
• MigratedDTS packages to SSIS packages and Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Installed & Configured Report Server, Report manager.
• Maintained, Deployed SSRS RDL files cross environments. Managed security using shared data sources for reports.
• Encrypted database files using transparent data encryption.
• Monitored and modified performance using execution plans and Index tuning.
• Expert in sizing and utilizing the Temp database in an efficient way.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Extensively used repositories like Team Foundation Server (TFS), Visual source safe and clear case for Data Archival.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Hands on experience in trouble shooting database issues, Update statistics, database integrity check and Backup operations.
• Worked on call 24/7 support on weekly basis.

Environment: SQL Server 2014/2012/2008R2/2008/2005, T-SQL, Windows 2012/2008/2003 64-bit, BugZilla, DTS, SSIS, SSRS, SSAS, RedGate, Profiler, Share point,Oracle 10g,TFS,LiteSpeed.

Confidential, PA

SQL Server DBA/ Developer

Responsibilities:

• Installation and configuration/Maintenance of SQL Server 2012/2008R2/2008/2005 in all environments.
• Configured different High Availability strategies like SQL server 2012 always-on availability groups,Log shipping, clustering (Active/passive).
• Configured and maintained Transactional Replication for reporting and fixed replication issues on the servers.
• Applying SQL server packs and hotfixes (cumulative updates) on SQL servers as per the requirement.
• Implement side by side migration of databases from SQL server 2008R2 to 2012.
• Worked and involved on database pre-deployment and deployment DBA activities on production servers.
• Monitoring all the SQL server alerts like disk space issues and SQL job failures and fixing the issues.
• Configured Report Serverusing report configuration manager in SQL server 2008R2 and involved in deploying,delivering of reports using SSRS and troubleshoot for any errors occurs in execution.
• Involved in monitoring performance of different production servers using native SQL tools and windows tools like performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Database Security maintenance & creating Linked servers.
• Built SSIS packages to import data from different sources and transform in the format required and load.
• Deployed & migrated solution files for SSAS across environments and managed cube security using custom roles.
• Installed & Configured report server and report manager.
• Deployed SSRS RDL files cross environments. Managed security using shared data sources for reports.
• Updating the SQL accounts & service account passwords prior to expiry on all the servers as per the audit requirement.
• Used Remedy ticketing tool in Resolving database related incidents and requests, resolving incidents within defined SLA's and respond to database related alerts escalations.
• Worked on call 24/7 Support on weekly basis.

Environment:SQL Server 2005/2008/2008R2/2012,T-SQL, SSIS, SSAS, SSRS, SAN and Red Gate, Lite Speed, MS clustering, Crystal Reports, MS-Excel, XML, Replication, Windows 2008R2/2008/2003/NT/XP.

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Installed, configured and applied Service Packs for SQL Server 2012/2008R2/2008/2005.
• Migrating SQL Server 2000 to 2005 and 2000/2005 to 2008.
• Implemented database mirroring, Transactional Replication on MS sql server 2005.
• Installed and maintained 2-Node (Active-Passive) Clustering as a High availability solution.
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data migration tools.
• Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Dropped and recreated the indexes on tables for performance improvements.
• Created indexes to speed the execution of data retrieval queries and stored procedures.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Scheduled the backups for Databases and Transaction log, performed restoration operations and utilized compressed backups.
• Worked on Fail over Clustering for SQL Server databases for mission critical applications.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Designed new job process, new database maintenance plans, DTS packages.
• Resolved blocking and deadlocks issues with the databases / servers on a real-time basis.
• Used SQL Profiler to monitor the server performance, debugging T-SQL and slow running queries.
• Monitored, tuned and analyzed database performance and allocated server resources to achieve optimum database performance.
• Maintained user account administration for Different domains.

Confidential

SQL Server DBA

Responsibilities:

• Administrated the SQL Server 2000/2005/2008 servers and production, pre-production, non-production databases, Front end Application support and Performance Analysis/tuning.
• Extensively worked on snapshot and merge replication.
• Extensively worked on Log Shipping and Database Mirroring for 2000 and 2005 production servers and SQL server 2005 security Audit.
• Used DMVs, DMFs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes for query/stored procedures tuning.
• Created Documentation, schema designing, ER Diagrams using Erwin and MS Visio and involved in architecture.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Managed Security using SQL Logins, Roles and Authentication Modes for various categories of users.
• Involved in configuring table/data partitioning on huge tables for better performance.
• Troubleshooting and resolved application issues, database performance and deadlocking issues.
• Reviewed and approved stored procedures developed by the developers and data modification SQL script for production.
• Resolved database space issues by sizing Table spaces, data files, and log files.