SUMMARY

• 7+ years of experience in Database Administration and Development for very large and complex databases on SQL Server 2012, 2008 and SQL Server 2005/2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience with SQL 2012 ALWAYS ON and upgrades from SQL 2008
• Implemented the new SQL Server 2008 R2 mechanisms like DDL triggers, data compressions, backup compression, online indexing, security with principals and securable.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience in high availability SQL Server solutions, including Log Shipping, Replication, Mirroring and SQL Server Clustering.
• Expertise in database Backup, Recovery and Disaster recovery procedures (Logshipping, Mirroring, clustering, Replication and SRDF).
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer and also Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS).
• Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
• Expertise in planning and implementing MS SQL Server Security and database Permissions.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008.
• Experience in Data Migration from MS SQL server and from .
• Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive environment.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.24 X 7 Production Database on Call Support.
• Good interpersonal skills, committed team player with team driven skills.
• Good communication skills, written and verbal presentation skills.

TECHNICAL SKILLS

Databases & Services: SQL Server 2000/ 2005/2008/2012 , MS - ACCESS, SSIS, Reporting Services, Business Intelligence, Database Tuning Advisor, SQL Server 2000/7.0, T-SQL, MSDE, OLAP, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs,, ODBC, JDBC

Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services

Programming/Scripting: T-SQL Programming

Operating Systems: Windows XP/NT/ 2000/2003/2008 , Vista, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.

Protocols: TCP/IP, HTTP, FTP, SSH, TELNET

Virtualizations: VMware vSphere client, ESX 3.0, 4.0 and ESXi4.1.

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

SQL Server DBA

Responsibilities:

• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments usingSQLServer 2008/2012.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services. Installed necessary Service Packs for SQL server 2005.Installed SQL server2005,2008and2012on a test environment to be the future production environment. Upgraded legacy 2000 databases to SQL server2005/2008.
• Involved inDatabase Backupandrecovery.
• Implemented high availability on the various servers usingreplication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
• Optimized the performance of queries with modifications inT-SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) usingSSIS.
• Created variousSSISpackages based upon the requirement.
• Created various reports usingSSRS.
• Scripting theDatabase Consistency Checks(DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes andfine tuningStored Procedures).
• Data migration usingDTSservices across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed variousbackupcompression tools available and made the recommendations.
• Created necessary templates for various requirements gathering anddocumentation.

Environment: Windows 2000/2003, MS SQL Server 2005/2008/2012 , ETL, Oracle10g/11g, SSRS, DTS, SSIS, SQL Server Profiler,VB.Net, T-SQL, Erwin 4.0, Erwin 3.5.2, Database engine tuning Advisor, IIS.

Confidential, Jersey City, NJ

SR SQL DBA

Responsibilities:

• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
• Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping.
• Worked in Active/Passive and Active/Active cluster environment.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.
• Experience in Database Backup and Recovery procedures.
• Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Migration of databases from SQL server 2000 to SQL server 2005.
• Disaster recovery and Log shipping of SQL Servers meeting the Service level agreements for the various customers.
• Experience in implementing different types of Replication models like Transactional replication.
• Successfully planned and implemented SQL Server 2005 Database Mirroring.
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh.
• Providing 24x7 technical database supports for SQL Database systems.
• Experience in supporting and managing multiple Production, Staging & Development instances.
• Managed all Publisher, Distributor and Subscriber database environments for the replication.

Environment: MS SQL Server 2008/2005/2000 , Windows 2003/2000 Server Operating systems, IIS 6.0, .NET, T-SQL,SSIS, SSAS, XML.

Confidential, San Francisco, California

MS SQL Server DBA

Responsibilities:

• Performing SQL server daily health check and preparing a report based on it.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Participated in DR installation and trouble shooting(Mirroring, Logs hipping and High availability Cluster.
• Applying Service Packs and Security patches for the Servers as released.
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Managing backups on a daily basis and recovery (as per request).
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
• Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.
• Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Environment: SQL Server 2005, SQL Server 2008, Windows 2008, Windows 2003 EE, Cluster.

Confidential - Alpharetta, GA

MS SQL DBA

Responsibilities:

• Extensively involved in database mirroring, creating Back up Strategy. Resolving Dead locks and blocking issues.
• Extensively Involved in Designing (Logical and Physical) of Customer Database. Created & managed the Database Users, Login and Security.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database. Removed fragmentation from indexes.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL.
• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail
• Administrator tasks such as managing users, roles, and profiles.
• Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to SQL server.
• Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
• Experienced in performance tuning using Windows performance monitor and SQL profiler of SQL server.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP. Extracting, Transforming and loading of data using SSIS.
• Deployed and scheduled SSIS Package. Performed analysis and design of the application.
• Experience in with tools like Microsoft Reporting Services (SSRS). Created and deployed and scheduled report using SSRS.

Environment: SQL Server 2005/2000, (Query Analyzer, Enterprise Manager, SSIS packages, SQL Profiler), Clustering, MS Access, My SQL, MS Excel, MS Word, and Windows XP

Confidential

MS SQL Developer/ETL/SSIS/SSRS

Responsibilities:

• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Used DTS service for the data transformation from source to target database.
• Supported clustering and replication for servers.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Maintained cluster servers to provide high availability.
• Developed stored procedures, functions, views and triggers.
• Created DTS package to schedule the jobs for batch processing.
• Scheduled the DTS packages using the Data transformation services SQL2005.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2005, MS SQL Server 2000, Windows Server 2003, SSRS, SSIS, Transact-SQL, DTS

Confidential

MS SQL Developer

Responsibilities:

• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
• Designed application database on coded objects such as stored procedures and views.
• Utilized SQL scripts and complex queries to analyze and extract data.
• Supported business applications using T-SQL.
• Provided database coding support using SQL server environment.
• Tested the quality of application developers including data file for counterfeits.
• Normalized the status of new discovered processes and applications.
• Identified business needs and requirements including business securities.
• Modified existing applications to ensure data integrity and security.
• Performed disaster recovery plans for all data services.

Environment: MS SQL Server 2000, 2005, Windows Server 2003, 2000, SSIS, SSRS.