Summary

Around * years of experience as SQL Server DBA (2014, 2012, 2008 R2, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) in different business domains.

Provided 24/7 on Call Support for Production Databases

Experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Failover Clustering & Database Mirroring in SQL Server.

Experience in Deploying and Consolidating Remote Instances.

Experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Failover) and Non-Clustered Environments.

Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (Lite Speed, Idera and Red Gate Tools).

In this SQL Server 2012 article I will describe what are policy based management facets and show you a list of them, later on I will give a link that will show you when I used it and how to use it. For the purpose of this article I will use SQL Server 2012.

Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.

Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Policy Based Management Facet is an object with a collection of properties (facet properties) that represent SQL Server object that you can manage.

The implementation of a facet is .Net code – for us it’s C#. In SQL Server 2008 users cannot create their own facets, although we designed the system with extensibility in mind.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

SQL SERVER DBA 2000 / 2005 / 2008 / 2012 SKILLS EXPERTISE :

• Backup & Recovery

• Database Security

• Database Designing and Query Optimization

• Data Transformation Services

• Manipulating Schemas, Tables, Indexes and Views

• Log Shipping

• Data Extraction Using DTS and SSIS

• T-SQL Programming

• Always On High Availability

• Failover Clustering

• Creating Packages, Jobs and sending Alerts using Database Mail

• Production Support for Database and Applications

• Implementing Snapshot, Merge and Transactional Replication

• Installation, Upgrade and configuration

• Performance Tuning

• Dynamic Management Views

• Tuning SQL Queries

• Database Mirroring.

• Database Migration and Upgrade.

• Core Database Administration.

Areas of Expertise:

Databases:

MS SQL Server 2012, 2008, MS SQL Server 2005

Programming:

Visual Basic 6, Visual Basic 5,ASP.net, C, C++ & SQL

DBA:

database administration of MS SQL Server 2012,2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools:

Backup Utility, SQL LiteSpeed, Visio

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Client: Bed bath and Beyond May 2015-Present

Location: Union, NJ

Role: SQL Server Dba

Description: Bed Bath & Beyond Inc. is an American-owned chain of domestic merchandise retail stores in the United States. The stores sell goods primarily for the bedroom and bathroom, as well as kitchen and dining room.. In order to properly represent the size increase in its retail stores, the company changed its name to Bed Bath & Beyond.

Responsibilities:

• Administrated and Managed SQL Server 2014/2008R2/2008/2005/2000 databases in Production, QA and development environments.

•Installed and configured 5-node Cluster Configuration (Active/passive) in SQL Server2012

• Administrated around 200 servers, 3000 databases with 8 Data Domains( DD).

• Have experience in enabling and disabling TDE encryptions.

• Deployed and Debugged SSIS packages using BIDs 2008 R2 and scheduled jobs for these packages

• Configured and Deployed SSRS reports, Troubleshooted these reports set up subscriptions.

• Implemented security policies for SSRS reports.

• Responsibilities include the Production support for the Database servers.

• Have experience installing, maintaining SQL server 2008 R2 Active/ Passive cluster

• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and mentored other technical staff.

• Implementation of AD groups as 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).

• Have experience in using Solar winds Database Performance Analyzers(DPA) tool

• Implemented and Maintained routine DBA tasks like script deployment, backup & restore, scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.

• Automated the backup and restore process for some critical databases and scheduled jobs for them.

• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.

•Maintain Notifications, Jobs, Job Steps and Schedules

•Monitor connections, locks and performance of SQL server

•Managing access control of operational and developmental application system databases

•Resolving issues through Performance Monitor and SQL Diagram

•Creating documentation for error resolving fixtures

•Consolidated the Servers from 500 servers to less than 50

•Came up with a High availability and disaster recovery solution

•Migrated and Installed SQL 2014 in production and non production environment

24/7 Production Support

•Implemented Change Control and Replication.

• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.

• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.

• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.

• Performed data partitioning for efficient management of database tables and indexes.

• Extensively working on performance issues like update statistics, Auto Stats.

• Involved in Change Data Capture process.

• Maintained Production and Test Database Environment in SQL server2012/2008R2/2008/2005. Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.

Environment:-SQL 2012,Talend,Tableau,SmartSheet,Box,Okta,MSVisual Studio,MS Access 2016,MS Access 2014,IBM Guardium Version 9,10

Client: UBS financial services Feb 2014-March 2015

Location:Weehawken,NJ

Role: MS SQL DBA/Developer

Description: A global financial services company, UBS provides investment banking, asset management, and wealth management services for private, corporate, and institutional clients worldwide. This project is to develop and publish tableau reports from a centralized data mart built to support wealth management team. Reports were built to serve portfolio managers, compliance and management teams.

Responsibilities:

• Database Administrator, Database Programming.

• Converting DTS packages into SQL Server 2005 Integration Services.

• Migrating SQL Server 2000 data bases into SQL Server 2005.

• To set up SQL Server configuration settings.

• Backups and Restoration of data/database using a Third Party Tool (SQL Lite Speed).

• Recovering the databases from backup in disasters

• 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

• Involved in trouble shooting and fine-tuning of databases for its performance.

• Monitored and modified Performance using execution plans and Index tuning.

• Rebuilding the indexes at regular intervals for better performance

• Managing the San backups.

• 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.

• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL Lite Speed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Client: General Atlantic November 2012-december 2013

Location: New York, NY

Role: SQL Server Production DBA

Description: General Atlantic is a global growth equity firm providing capital and strategic support for growth companies based in New York, New York.[1] Known simply as "GA," the firm was founded in 1980 as the captive investment team for Atlantic Philanthropies, a philanthropic organization founded by Charles F. Feeney, the billionaire co-founder of Duty Free Shoppers Ltd.

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.

• Performed business analysis, technical analysis, systems design, application software programming.

• Prepared DFD's & Entity Relationship (ER) diagrams.

• Monitored SQL server performance using SQL Profiler to find performance bottlenecks and deadlocks issues.

• Extensively operated on Data Partitioning and Snapshot Isolation in SQL Server 2005.

• Significantly worked on DBCC commands and Dynamic Management Objects.

• Worked on configuring SQL Server with minimum privileged access.

• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

• Created Linked Servers between SQL Server 2005 & Oracle 9. Also created DTS package for data transfer between the two environments.

• Employed Resource Governor to control and allocate CPU and memory resources depending on the priority of the applications.

• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler.

• Solving the Bugs Reflected by the Testing team.

• Rebuilding the indexes at regular intervals for better performance.

• Monitored and modified Performance using execution plans and Index tuning.

• Used Stored Procedures, DTS packages, BCP for updating Servers.

• Designed and implemented comprehensive Backup plan and disaster recovery strategies.

• Implemented and Scheduled Replication process for updating parallel servers.

• Automated messaging services on server failures, for task completion and success.

• Execute procedures to accomplish short-term business goals.

• Creating and maintaining various databases on production/development servers .

• Involved in migrating SQL Server Databases from Development to Production Server.

• Configured Log shipping from Production to Disaster Recovery server as part of the disasterrecovery plan.

• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.

• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.

• Identified, tested and resolved database performance issues to ensure data optimization.

• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.

• Implementation of system wide security policies and trouble shooting.

• Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.

• Deployed and scheduled SSIS package.

• Maintained security policies. Managed Logins and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures..

• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2008 with the use of the Query Analyzer and Database Engine Tuning Wizard.

• Established backup and recovery of MS SQL server 2008 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

• Used Visual Source Safe (VSS) for version control.

Environment: – ER Studio 8.0.3, Microsoft SQL 2008 Server, Microsoft SQL Management Studio, MicrosoftSQL 2008 Integration Services, Microsoft SQL 2008 Reporting Services,MS SQL Server 2008/2008R2, Windows 2003/2007, MS Access, Erwin.

Alere Health, Upper Saddle River, NJ July 2008 – August 2012

SQL Server DBA

Company Description:

Alere Health is a medical and surgical services organization. They deliver a wide range of services and solutions across a wide range of environment.

Project Description:

As a SQL DBA my responsibilities included upgrading to newer version of database, database maintenance, user management, security management, performance tuning, implementing high availability solutions, and 24x7 technical supports.

Responsibilities:

Monitoring the server for High availability of the servers.

Solving the request raised by user support.

Participate in implementation of new releases into production.

Facilitates application deployment and joint effort deployments.

Meet the SLA (Service Level Agreement) established.

Day-to-day administration of live SQL Servers.

Designed and implemented Security policy for SQL Servers.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

Automated messaging services on server failures, for task completion and success.

Execute procedures to accomplish short-term business goals.

Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.

Deploying monitoring tools like Site scope and spot light.

Table partitioning to improve I/O access.

Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

Using database level triggers code for database consistency, integrity and security.

Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

Environment: SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.

Permanent Adress: 715 Linden Avenue 203, Teaneck NJ 07666

BE computer science, 2008, Fairleigh Dickinson University (FDU).

Contact this candidate