SUMMARY

• Senior MS SQL Server DBA with 9 + years of strong professional experience in SQL Server 2016/ 2014/2012/2008 R2/2005 as Database Administrator and Developer.
• Highly experienced in installing, configuring and administering SQL Server 2016/ 2014/2012/2008 R2/2005/2000 on Standalone and VM Ware Servers (Windows Server 2012/2008/2003/2000 ).
• Upgraded and migrated several servers and databases from SQL Server 2005/2000 to SQL Server 2014/2012/2008 R2.
• Provided 24/7 On Call Support for Production servers.
• Extensive experience in Installation, Configuration and Administration of SQL Server in a Clustered and Non - Clustered environments.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Highly experienced in Configuring, Implementing and Maintaining Database Mirroring and Always ON.
• Good Knowledge in implementing in different Replication Models (Snapshot, Merge and Transactional) with different topologies.
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
• Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate).
• Highly experienced with Business Intelligence in MS SQL Server 2008R2/2012 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expertise in migrating servers using in place and side by side upgrade.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshooting performance issues.
• Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.
• Experienced in Extraction, Transformation and Loading (ETL) process using DTS, SSIS.
• Created Linked Servers for OLEDB Data Source and Native Data Sources.
• Experience in developing management reports using SSRS.
• Documented Disaster Recovery Plans and Participated in Disaster Recovery Drills.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Very good knowledge of PCI/SOX regulations and documenting audit procedures.
• Developed Dash Board Reports on COGNOS 8.4 report studio
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008/2012.
• Good knowledge with features of Sql server 2008 like Spatial, CDC, Resource Governor,Encryption and File Stream Data functionality.
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCCcommands and Dynamic Management Views.
• Strong in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Have experience in Power Shell Scripting.
• Good working knowledge in .Net Frameswork 2.0/3.0/3.5/4.0 , VB.Net,C#, ASP.Net, ADO.Net, XML and WebServices.
• Thorough Knowledge in using ticketing tools like Servicenow, Peregrine, ITSM.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities.
• Extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS

Platforms: Windows 2003 server/2008 server /2012/2016, PSI, VM Ware servers.

Databases: SQL SERVER 2000/2005/2008/2008 R 2/2012/2014/2016 , MS-Access

Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C#, VBScript, PowerShell

Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script

Tools: SQL Server Management Studio / Enterprise Manager, SSRS, SSAS, SSIS, Enterprise Manager, SSMS, Visual Studio 2005/2008, SharePoint 2007/2010/2013 , VERITAS, Quest LiteSpeed, Red Gate, Erwin, Tivoli, SCOM, ESM, RSAM, Guardium, Vizio, Microsoft Azure.

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

SQL Server DBA

Responsibilities:

• Actively participated in gathering of Requirement, Design and System Specifications.
• Administrated and Managed SQL Server 2016/ 2014/2012/2008 R2/2008/2005 databases in Production, Disaster recovery, UAT, PERF and Development environments.
• Upgraded/Migrated SQL Server 2008 databases to SQL Server 2014/2012 databases and mentored other technical staff.
• Configured and maintained SQL Server Always on Production databases.
• Worked on creating RBAC (Role Based Access Control) model for SQL server logins.
• Created DBA jobs to collect and monitor DB Servers using powershell.
• Created backup and DBAdmin reports using SSRS.
• Worked on SSIS and SSRS to generate the backup reports, failed jobs.
• Supported both OLTP and OLAP (SSAS) applications.
• Hands on experience on Backup and Restore Azure Services
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans.
• Checked servers for optimizations and implemented them.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Implemented Data masking\obfuscating techniques while migrating sensitive data from PROD server to lower environments.
• Used Policy Based Management. Created policies, facets and conditions.
• Used Resource Governor for limiting the resources like CPU, Memory to applications on shared Farm environments.
• Migrated SQL Server 2008 databases to Windows Azure SQL Database and updating the connection string.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing and Resource Governor
• Performed data partitioning for efficient management of database tables and indexes.
• Involved in Monitoring Performance of different production servers.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Fixed SQL Spotlight warnings and errors.
• Worked on user requests, Change requests through Servicenow.
• Used Servicenow for resolving incidents and providing RCAs.
• Worked on-call (24/7) rotation.

Environment: Windows Server 2012, Windows Server2008, SQL Server 2016/ 2014/2012/2008 R2, SSRS, SSIS, Internet Information Server 6, JavaScript, CSS, HTML, SharePoint, .Net Framework 3.5, C#, RSAM,ESM, Tivoli, SCOM, Guardium, EPV, Quest LITE Speed, Spotlight, ServiceNow.

Confidential - Columbus, OH

SQL Server DBA

Responsibilities:

• Experience with leveraging Hadoop systems components such as Hive and Pig, for data analysis, sqoop for data migration, Oozie for scheduling and HBase as a NoSQL data store.
• Supported and managed 2000+ MSSQL Server Instances running on Production, Disaster recovery, UAT, PERF and Development environments for client of their Business Units.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.
• Supported production servers in Fail over cluster environment.
• Worked on mortgage banking, involved in the Database design, build Stand alone and 2 Node clustered SQL 2008 R2 servers, migrated databases.
• Implemented and designed propriety data solutions by data correlation using NoSQL and SQL with the help of kafka.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Expertise in PL/SQL Development and Oracle Scheduling.
• Worked extensively on data maintenance like re-indexing, integritychecking, and database shrinking.
• Worked on databases over 6 TB size.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• MongoDB and other NoSQL systems, leveraging expertise on SQL, SSIS with the help of C# and Python.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query ExecutionPlans, Used SQL Profiler for optimizing the store procedure.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Created SSIS package to send a daily backup report of all the DB servers.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked on Tivoli\SCOM and Guardium alerts.
• Monitored and cleared incidents\tickets on Service now.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Environment: Windows Server 2003, Windows Server2008, SQL Server 2008/2005/2000 , SSRS, SSIS, Internet Information Server 6, JavaScript, CSS, HTML, BigData, Hadoop, Hive, Pig .Net Framework 2.0, VB.Net,kafka, C#, RSAM,ESM, Tivoli, SCOM, ServiceNow, Peregrine, Guardium, EPV, Quest LITE Speed, NoSQL, .

Confidential, Bridgewater, NJ

SQL Server DBA

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQLServer 2005/2008.
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Configuration of Oracle 11R2g RAC with ASM and Data Guard Environment.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Resolved incidents, change requests, User requests using peregrine and Servicenow.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Created Dash board reports using COGNOS report studio.
• Migrated schemas\tables from different database sources (Oracle) to SQL server.
• Performed Performance tuning for SQL Queries and the system.
• Created PL/SQL stored procedures to perform ETL operations.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS.
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005, Windows Enterprises 2003 servers, IIS Web server, Toad for SQL Server, LiteSpeed, JavaScript, CSS, HTML, Microsoft CRM, SSIS, SSRS, VERITAS NetBackup, ServiceNow,Peregrine,ERWIN,C#,VB.Net, ASP.Net., oracle 11g, TOAD for Oracle, TOAD Datapoint, SQL Developer.

Confidential

SQL DBA/Developer

Responsibilities:

• Upgraded the server from SQL 2000 TO SQL 2005.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.
• Created SSIS Packages to Extract, Transform and Load (ETL) consolidated data from different sources into Data Warehouse.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Performed Backup/Restore by using native and 3rd party tools like litespeed, VERITAS Net Backup.
• Created and scheduled back up using Maintenance Plan wizard.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Performed database consistency check as regular Interval.
• Assisted with development of Extract, Transform & Load (ETL) scripts to migrate from MS SQL Server DB schema.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Implemented and maintained SQLServer Agent Jobs, Monitor SQL Server Agent Job history.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.

Environment: SQL server 2005, SQL Server 2000 Enterprise Edition, MS Reporting Service 2000, Windows 2000/2003 Server, IIS 5.0,VERITAS NetBackup, SQL Profiler