SUMMARY:

• Over 11+ years of experience working as an SQL DBA in production and non - production environment using various Microsoft Technologies
• Working experience in SQL Server Database Administrator for very large and complex databases in SQLServer 2012 , SQL Server 2008 R2, 2008.
• Installing SQL Server and adding features to an existing SQL Server with DQS (Data Quality Services), MDS (Master Data Services) and Data tools, Configuring SSAS, SSIS and SSRS.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Creating and Databases and protecting them by taking different kinds of Backups such as Full, Differential, and Transactional log backups and restoring them if needed.
• Creating Logins and Users providing appropriate roles and permissions to servers & DB’s.
• Administering SQL Server High Availability features like Log-shipping, Mirroring and Replication and troubleshooting accordingly.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Working experience and knowledge in Windows Power Shell and Batch Scripting.
• Having hands on experience in DR processes including Log shipping and Database Mirroring. Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2. Also created DTS package for data transfer between the two environments.
• Experience in CMMI level 3 process and Business Intelligence Reporting tolls like SSRS, SSIS, SSAS, SAP Business Object 4.0.
• Experience in SQL Server DTS and SSIS package design, constructing and deployment ETL expertise in using tools like SSIS. Experience in extracting, transforming and loading (ETL) data from Excel, Flat File, XML, Oracle to MSSQL Server by SSIS services, Talend .
• Knowledge in T- SQL writing stored procedures, triggers and functions.
• Strong background in Data warehouse concepts- ETL Data modeling and Reporting. Built, designed and tested various level OLAP and OLTP reporting systems. Strong skill in interfacing Business Object with Database like SQL server 2008
• Working knowledge in Reporting Services (SSRS) and Integration Services (SSIS).
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems .

TECHNICAL SKILLS:

Platforms: Windows Server 2008/2003/2000, Windows 7/8/8.1/Vista/XP/98, Android, iOS

Languages: C, C++, T-SQL, FORTRAN

Tools: MSSQL 2012/ 2008-R 2/2008/2005/2000, Oracle Developer, MySQL, SSIS, SSRS, Talend, ETL, BI, FogLight, Erwin, Visio, Microsoft Office Suite, ACCESS, AccPac,LAW, Lotus Note and Microsoft Exchange Server

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2012/2014 successfully on windows 2012 and 2008 R2 servers.
• Migrated SQL Server 2005 and 2008 to 2012 and 2014. Also, created detailed documentation of steps taken during the migration process.
• Managed SQL Server user logins, database users, roles and its permissions to new environment.
• Ran code developed by developers on production servers and helped troubleshoot any errors that occur.
• Conducted consistency checks on the database and analyzed the fragmentation on the indexes.
• Created SQL Server Agent Jobs to automate tasks such as to run Index Maintenance, Index Defrag, Rebuild, Update Statistics and capturing deadlocks using trace flags.
• Configured and managed Linked Servers for data transfer between SQL Server and Oracle databases.
• Monitored that backup have been made and successfully saved to a secure location and monitor disk space to ensure SQL Servers do not run out of disk space.
• Used Powershell to perform administrative duties by accessing databases and instances of SQL Server without using SQL Server Configuration Manager(SSCM) and SQL Server Management Studio(SSMS).
• Deployed SSIS packages as per requirement to load data from different sources also used in transferring jobs, logins and SQL Server objects.
• Did performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and Windows Performance monitor.
• Installed Active-Passive Clustered nodes and performed fail-over from one node to another upon request.
• Deployed MS SQL Server databases to be used in web applications in Microsoft Azure Web Sites.

Environment: Windows 2003/2008/2008 R2, SQL Server 2005/2008/2008 R2/2012/2014, Oracle 11g/12c, Replication, Clustering, AlwaysOn.

Confidential

Lead Database Administrator/ SQL Server

Responsibilities:

• Installed and maintained MS SQL Server 2008 on Windows 2008 Server.
• Worked on s etting Up the AlwaysOn Availability Group in SQL Server 2012/2014 Failover Cluster. Installed Windows Failover Clustering (WCF) as well in windows 2012.
• Worked on creating three node failover cluster in SQL server 2012 and two node failover cluster in SQL Server 2014.
• Installation and configuration of SQL Server 2005, 2008,2012 and 2014 databases
• Upgraded SQL Server 2008 to SQL 2012 server for high volume processing databases and support third Party application Right-angle upgraded version(S14.1).
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyser to Administer SQL Server.
• Configuring, tuning and optimizing SQL Server 20 08/2012/2014 using tools like SQL Profiler, performance counters, DBTA, DMV’s.
• Administrator tasks like managing users, roles and permissions.
• Involved in complete database design including conceptual, logical and physical models.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases.
• Automating sql server Admin tasks using Powershell.
• Modelling and architecture of the SQL Server 20 08/2012/2014 database.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed to speed up backup operations.
• Created Complex reports using SS Reporting services.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support

Environment: Windows 2 008 R2, MS SQL Server 2005/2008 R2 /2012, SSRS, DTS, SSIS, BCP, SQL Server Profiler, VB.NET, T-SQ L, IIS 6.0/7.0, Right-angle(S10/S11.6/S12/S14), Database tuning Advisor(DBTA), Activity Monitor, Trace Flags, Job Activity Monitor, DMV, SQL Query Stress

Confidential, MD

Sr. SQL Server DBA

Responsibilities:

• Installed/Configured and upgraded PROD/COB/UAT/DEV environments from SQL Server 2005/2008 R2 to 2012.
• Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring and Log Shipping to provide multiple copies of production data that can be used for disaster recoveries.
• Set up Log shipping between Primary Server (PROD) & Secondary Server (COB).
• Worked on Cob tests during weekends to test COB environment by business users.
• Work closely with infrastructure and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
• Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment
• Extensively worked on auditing entire environment by building SQLMonitoring database to capture everything single thing in the prod environment.
• Deploying new code base release to UAT and Production Environments.
• Used PowerShell for SQL server automation tasks.
• Successfully implemented a project to set up process of automated log shipping without primary server by just using backups.
• Provide expertise for using best RAID Technologies based on application requirement.
• Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
• Extensively used Service Now tool for any changes in the environment and also incidents.
• Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks or network latency.
• Used SSIS to move auditing files from SQL server to Unix server.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential, MD

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2012/2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
• Responsible for overall database environment and maintain operational uptime of 99.9%.
• Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
• Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism.
• Designing, Implementing and administering the transactional replication from Primary database server to the 6 search pool servers.
• Use Power Shell to configure user accounts and give necessary privileges for SQL logins.
• Setup SQL Mail and integrate it with the application, design and manage replication.
• Install and configure SQL LiteSpeed for SQL Server to backup SQL Server database or setup database maintenance plan to back up all the databases locally on the disk.
• Creating Virtual Machines in VMware vCenter and maintain virtual Machine and performance.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects
• Monitoring the servers using Idera third party software and backups using SQL Litespeed.
• Ticketing systems like Resolve for Change Request, Sales Force, BMC Remedy etc.,
• Deployed SSIS packages and worked on Reporting services.
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Provided 24/7 on-call support on rotation basis for production database.

Environment: MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential, VA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005 and 2008R2 in production and development environment.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008 Enterprise Edition on SAN environment
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005/2008.
• Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Expertise in designing databases and capacity planning.
• Create Powershell scripts to automate tasks such as creating/disabling logins or exchange accounts
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
• Creating documentation for error resolving fixtures.
• Worked with Jira ticketing system software to solve issues.

Environment: Microsoft Windows Server 2008/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 and apply service packs, hot fix and clustering installation.
• Database Administrator, Database Programming.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Created and implemented Powershell scripts to push nightly backups from AWS hosted.
• Deploying new code base release to UAT and Production Environments.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Worked with change management and change control procedure.
• Converting DTS packages into SQL Server 2005 Integration Services
• Solved issues related to server performance and disk space.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Support Development team in deploying and testing the application.

Environment: Microsoft Windows Server 2000/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005.

Confidential

Jr.SQL Server DBA

Responsibilities:

• Implemented database mirroring as a part of disaster recovery plan.
• Created Clustered Indexes and Non-clustered Indexes to increase the performance of a database.
• Used DBCC commands to check the physical and logical consistency of the databases and to rebuild indexes.
• Managing and scheduling daily jobs relating to data transfers, backup, and recovery.
• Involved in troubleshooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler.
• Managed the use of disk space, memory and connections.
• Implemented transactional replication and involved in the maintenance of the replication.
• Implemented Backup and restore strategies in SQL Server 2005,2008R2
• Involved in Data Migration from SQL 2000 to SQL 2005.