SUMMARY:

• IT Professional with 12+ years of experience as Production SQL Server DBA, consultant, and Architect in a number of DBMS accounts and mission critical projects. Proven ability to provide on - demand support to Microsoft SQL Server 2016, 2014, 2012, 2008, (+R2), 2005, 2000, 7.0 & 6.5 version database servers for maximum performance.
• Self-motivated, quick learner, strong analytical and problem-solving skills. Capable of working under pressure and mission critical environment; Effective communication & people management skill in geographically separated virtual team & offshore work management.
• A good team player who can be flexible and work individually.
• Extensive experience of installation, configuration, maintenance, and daily administration for very large and complex databases in SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Installed different versions of SQL Server on different environments and applied Service Packs.
• Solid hands-on skills in migration/upgrading of SQL Server 2005 to 2016 and applying Service Packs, extensive experiences in migrating and new installations of SQL Server on Hyper-V & VMWARE environments
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Experience in using DMV & dynamic management functions for finding out long running queries
• Firm experience of SQL Server High Availability and Disaster Recovery including SQL Server and Windows clustering, Database Mirroring and Log Shipping Transactional Replication.
• Expert in BI tool administration like SSIS, SSRS and SSAS.
• Implemented the new SQL Server mechanisms like data compressions, online indexing, Contained Databases, security principals and AlwaysOn.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experienced in working on different environments like Production, DR, Development and Test.
• Experience in setting up High Availability techniques like Log Shipping, Database Mirroring, Failover Clustering, Replication and AlwaysOn as per business requirement.
• Installed Failover Clustering on multiple nodes on Active-Passive, Active-Active environments.
• Expertise in handling migrations across different servers and managing Data Center Migrations along with managing security, logins, jobs and maintenance plans.
• Created jobs, alerts, operators and notifications by automating alerts using the Database Mail and SQL Server Agent.
• Expertise in server Capacity Planning, Sizing, Hardening, performance reports & Best Practice Implementation. Monitoring space and growth on databases and plan for capacity in advance to estimate upcoming space issues.
• Experience in creating ETL and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format) by using multiple transformations.
• Experience using Business Intelligence Development Studio (BIDS) to create and run SSIS
• Troubleshooting issues and delivering Root Cause Analysis, Workarounds & Solutions for all technical problems with compliance to defined ITIL Processes on Problem & Incident Management

TECHNICAL SKILLS:

Database: SQL Server 2016\2014\2012\2008R2\2008\2005\2000, Oracle10g/9i/8i/7.x, MYSQL

Languages: SQL, T - SQL, PL/SQL, Shell, Python

Operating Systems: Windows Server 2012/2008/2003/ XP, Unix, Linux, NIX HP-UX, IBM-AIX, RHEL6, Solaris 9, 10

SQL Server Skills: Upgrading\Patching SQL Server, Database Migrations, Disaster Recovery, High Availability, Log shipping, Failover Clustering, Database Mirroring, Replication, Always On High Availability, Database Design and Security, Performance Monitoring and Tuning, Backup and Restore, Partitioning, Indexing

SQL Server Tools: SQL Server Management Studio, Query Analyzer, Business Intelligence Development Studio, SQL Profiler, SQL Server Configuration Manager, Database Engine Tuning Advisor, Error Reporting, Activity Monitor

BI Tools: SSIS, SSRS, SSAS

Other Tools: MS Office, Erwin, Toad, MS Visio, BMC Remedy, VMWare, VXVM.0, Veritas Cluster Service 4.1, Lotus Notes, Idera, Litespeed, NFS, RAID, Nagios, Service Now, Net cool, Hqmonet, ControlView, ProcMon, HP Service Manager, ServiceNow, Foglight.

Web Server: Apache http, Tomcat, ISS

Hardware: HP (PROLIANT DL380G7,DL360 G5), V440, Dell Power edge(710 & 910), IBM blade servers

VMware: VMware ESX Server -3.x, GSX, Virtual Center, VMware WorkStation (5.x, 6.x), Hyper-V

PROFESSIONAL EXPERIENCE:

Database Admin Consultant

Confidential

Responsibilities:

• Responsible in identifying transition SQL servers with in Markit environment unique to the account.
• Responsible for transition activities includes making sure the backup for all databases are in place.
• Worked with backup team to ensure Tape/Disk backup.
• Responsible to get inventory all SQL servers supported.
• Responsible for working with monitoring team and setting up Foglight monitoring of all supported SQL servers.
• Responsible for documenting the environment.
• Involved in proactive activities that keep the customer environment healthy and the activities that support ITIL process.
• Involved in Disaster Recovery exercise

Sr. SQL Server DBA

Confidential, New York, NY

Responsibilities:

• Responsible for Database support, troubleshooting, planning and migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Project involved guidance and adherence to standardized procedures for planned data center consolidation for in-house corporate and third party applications based on SQL 2000 in upgrade project to SQL 2008R2\2012\2014
• Monitoring of database size and disk space in Production, Staging and Development environments.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database migration.
• Performed installations of SQL Server 2008R2 and 2012 on Windows Server 2008R2\2012 and patch servers accordingly.
• Engage in Disaster Recovery strategic planning and implement Backups on SQL Server.
• Rebuilding and monitoring indexes at regular intervals for better performance.
• Proactively monitor the database systems to ensure minimum downtime.
• Extensively worked on SQL Server Integration Services and SQL Server Reporting Services.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions (RTO and RPO).
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Responsible for assigning proper user access to databases and determining the adequate security for each user.
• Configured Database Mirroring and Log Shipping and troubleshooting with connectivity, security and firewall issues.
• Experience in implementing different types of Replication Models like Snapshot, merge and Transactional.
• Configured Replication Server, worked on replication server.
• Involved in Monitoring and troubleshooting replication issues.
• Configured Database mail, linked servers, Maintenance plans and SQL Server Jobs.
• Executed Change management scripts on weekly basis.
• 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.
• Checking Database Consistency/health by using DBCC commands at regular intervals.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Technical Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 2007, ASP.NET, C#.NET, XML, Windows 2003

Sr. SQL Server DBA

Confidential, New Jersey

Responsibilities:

• Gather and analyze client requirements and planning stages of SDLC and documenting project and coding specifications and plan deliverables.
• Installation and Configuration of MS SQL server 2012, 2008 R2, 2008 and 2005 on Windows Cluster server and standalone server.
• Upgrade SQL server with version (side by side and in place upgrade).
• Log-shipping configuration, Monitoring and Troubleshooting.
• Database FULL backup, DIFFERENTIAL backup, TRANSACTION-LOG backup file& file group backup and copy only backup strategy under disaster recovery plan.
• Database Restore, attached, detached and bring the database single user mode, offline mode.
• Recovery of database in suspect mode.
• Monitoring the database growth, disk space availability, CPU&Memory utilization and SQL server services status
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Experience in implementing different types of Replication Models like Snapshot, merge and Transactional.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Setting up Full and T-log backups for all databases as a DR procedure for recovering the databases from backup in disasters and implementing Point-In-Time Recovery solutions.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Maintaining database consistency with DBCC at regular intervals.
• Planning migrations and moving databases and logins in different environments.
• Implementing suitable performance tuning and query optimization techniques.
• Providing 24*7 on call support.

SQL Server DBA

Confidential, New Jersey

Responsibilities:

• Responsible for all database architecture including planning and design of Relational Data Warehouse.
• Documented project design and coding specifications.
• Installed SQL Server 2005 and applied SPs.
• Implemented application database code objects like tables, views, joins, stored procedures, triggers, functions, temp tables and table variables for application databases.
• Managed the migration from\to SQL Server 2000\2005.
• Transferred databases, jobs, logins and objects from Old to New Servers.
• Involved in performance tuning and code optimization.
• Handled Logical Data and Index partitioning for large tables.
• Implemented Capacity planning and Load balancing techniques.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Scheduled full backup nightly jobs and hourly transaction Log Backups as part of DR Procedures.
• Implemented Log shipping and Replication for high availability.
• Monitored SQL server performance using SQL Profiler to find performance and deadlocks.
• Scheduled jobs, alerts, logs and notifications with SQL agent.
• Managed security by defining roles and rights.
• Maintained database consistency with DBCC at regular intervals.
• Managed Internal SharePoint Site for Reports, Tracking Defects and High priority Issues.
• Implemented frequent database refreshes on Dev\QA environments.
• Implemented Database partitioning for large tables.
• Provided 24x7 on-call support for production systems.echnical

Environment: SQL Server 2005\2000, Windows Server 2003, .NET Framework