SUMMARY

• 10 years of technical experience as a Senior MS SQL DBA, Database management team Lead, Database design, production and development support DBA.
• Extensive experience in MSSQL Server administration, replication, log shipping, Mirroring, AlwaysOn, performance tuning and Clustering.
• Hired & lead the database administrators team here in US enterprise environment & setup, hired & manage offshore team in India.
• Excellent experience in creating & maintaining SQL Server 2014/ 2012/ 2008 R 2/ 2005/ 2000/ 7.0/ 6.5, Optimization, Backups, restore, performance tuning, data partitioning, Security & disaster recovery.
• Excellent time and task management skills.
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication, presentation, problem solving & conflict resolution skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012 R2, 2008 R2, 2005, 2000, 7.0 and 6.5, Oracle10g and 11g, Access, PostgreSQL and GreenPlum

Operating Systems: Windows 2012 R2, 2012, 2008, 2008 R2, 2003, 2000 Windows workstation, NT 4.0 servers, Windows 95/98/XP, Windows 3.11, Millennium, 2000/XP/95/98, MS DOS, Novell Netware, Linux & UNIX

Applications: MS Office, Adobe (Reader, Photoshop, Flash cs3), Foxit Reader, SQL Mail and Outlook Express

Tools: Cluster Administrator, AlawaysOn Availability Groups, Erwin, Mirroring, Amazon EC2 machines, Big Data, In - Memory optimized tables, Cloud, Amazon RDS, Columnstore Index, Buffer Pool extensions, NetIQ, Performance Monitor, Dataware house, STAR & Snow Flag Schema, Profiler, SQL Query Analyzer & TSQL, SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, Orangeburg, NY

Sr. Project Support MS SQL DBA

Responsibilities:

• Responsible to provide 24 X 7 mission critical support to 110 Production and development farms including cluster, Standalone, Virtual (VM) and Cloud (Amazon AWS) servers
• Successfully upgraded and migrated multiple SQL 2008 /R2 to 2012 and 2014.
• Consolidated multiple SQL machine into shared SQL 2014 box running on EMC VNX5700 machine.
• Installed multiple standalone, Virtual (VM) and clustered instances.
• Setup and configured HADR/ Always On
• Tested and Applied latest service packs and cumulative Hotfix.
• Configured and maintain transactional, merge, peer to peer and snapshot replications.
• Installed, configured and maintained Log shipping to create Standby Server.
• Experienced in DTS, SSIS, SSRS and SSAS.
• Performed quarterly DR drill across datacenters
• Experienced with Amazon RDS for MSSQL Databases.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Created the backup and restore strategy for production, development and test environments.
• Created maintenance plan for database consistency and optimization.
• Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk and memory devices
• Involved in tuning the database & server performance. Worked with Profiler to trace & tune the database.
• Responsible for stored procedure optimization, Performance tuning of databases.
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Experience with SQL Server disaster recovery procedures and created the guidelines for them
• Experienced in leading DBA team, Off shore team, assign tasks and interact with the different groups to manage the servers.
• Documented server and database policies and procedures.
• Involved in Change Management, Problem management activities using ServiceNow and Remedy tool before implementing database changes in production and development activities.
• Determined hardware and software requirements for variety of SQL Server version
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Experienced in database sizing and capacity planning for new and existing projects.
• Experienced in setting up the database data center for different departments.
• Excellent team player and worked on call rotation

Confidential, Manhattan, NY

Lead Project MS SQL DBA

Responsibilities:

• Worked as a Production and Project support DBA provided 24*7 Production Support for 200 servers out of which 87 servers are production servers.
• Maintained 45 mission critical applications.
• Upgraded and migrated multiple SQL server in Datacenters
• Successfully Upgraded SQL 2005 to SQL 2008 /R2 and SQL 2012.
• Installed multiple SQL Server 2012/ 2008 R2/ 2005 R2 in standalone and clustered configuration. Planned, configured, tested and implemented failover cluster.
• Tested and Applied latest service packs and cumulative Hotfix.
• Configured and maintain a Microsoft SQL server2005/2008 R2 fail over clusters.
• Consolidated 10 SQL server machines into single SQL cluster environment
• Configured and maintain snapshot, transactional, merge replications.
• Installed, configured and maintained Log shipping to create Standby Server.
• Setup & configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created the backup and restore strategy for production, development and test environments.
• Created maintenance plan for database consistency and optimization.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2008 to MSSQL 2012.
• Responsible for securing SQL server environment
• Installed and configured DTS, SSIS, SSRS and SSAS.
• Created custom Performance Analysis reports in SQL 2008 for future hardware and software load/analysis.
• Experienced in Database Mail, NETIQ Monitoring and Alerts.
• Configured Linked server for application team to run adhoc queries.
• Created DDL triggers for auditing any DDL change in SQL 2008
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Experienced with ticketing system using Service Now tool.
• Experience in hardware and software requirements for different SQL Server version and editions
• Well-versed with different RAID level for database server technology.
• Installed and configured IIS web server 6.0 and 7.0
• Act as a point-of-contact to troubleshoot application, web server and server issues
• Provides application support (administration, configuration, and monitoring) for both off the shelf and home grown applications in a 24/7 highly critical web-based environment.

Confidential, Manhattan, NY

Lead. MS SQL DBA

Responsibilities:

• Administered over 600 databases on 90 SQL Servers instances in production and pre-production environments (SQL Server 2000,2005 and 2008)
• Install and configured sql 2005 and 2008, applied latest service packs and hot fixes
• Facilitated SQL Server 2005 cluster and SQL Server replicating server
• Performed routine maintenance, including backup & recovery in sql server 2000 and 2005
• Created and maintained jobs and maintenance plans
• Responsible for Database tuning, creation & design
• Upgraded from sql 2000 to sql 2005 and sql 2005 to sql 2008
• Consolidated 10 sql 2005 server machines into single sql 2005 cluster environment
• Facilitated SQL server 2005 and sql 2008 server migration in Datacenters
• Performed analysis on tables, indexes and code in order to optimize query performance
• Maintained data models & designs using Erwin and sql diagrams
• Used SQL Profiler and performance monitor to trace database performance
• Use table partitioning to improve system performance over all
• Configured SQL 2005 cluster for mission critical application to provide 24*7 up environment
• Setup and configured SSRS (reporting services) for business
• Installed and configured SSAS (analysis service) for data warehousing
• Setup, configured and monitored log shipping for critical databases
• Installed database mirroring in high performance mode to avoid downtime
• Setup policies in sql 2008 using different conditions, targets and facet. configured and monitored snapshot, transactional and merge replication
• Supported SQL Server production & pre-production release roll-outs
• Administer sql server security using sql and windows authentication and setup different proxy account to grant certain permission.
• Configured Linked server for application team to run adhoc queries
• Design & development of preprod/integ/development DB refreshes with Production data
• Transformation and Uploading the information from different platforms into SQL Server databases using DTS, BCP, BULKINSERT and SSIS (integration service) packages
• Plan & Manage auditing on critical info for SOX purpose.

Confidential, Jersey City, NJ

Sr. MS SQL DBA

Responsibilities:

• Responsible for MS SQL Server 2000 & SQL Server 2005, Service pack & hot fix installation, configuration, tuning & make the systems available ASAP and provide 24 X 7 dedicated support to all Production.
• Upgraded SQL 2000 servers to SQL 2005 servers.
• Install and configured sql 2005, applied service packs and hot fixes
• Configured 2 log shipping from production system to stand by servers in SQL 2005.
• Configured the transactional replication between the production servers.
• Experienced with MS SQL Fail over clustering, Involved in planning, installation & configuration of 2 active/ passive cluster environments.
• Configured and maintain transactional, snapshot and merge replications.
• Created the logical and Physical database design for development projects.
• Created the backup strategy for production and test environments.
• Involved in disaster recovery procedures for production servers.
• Created DTS packages for import and export the data in and out of SQL Servers.
• Configured log shipping to create a stand by server for production server.
• Experienced with increasing database performance using SQL Profiler, index tuning wizards, execution plans and performance monitor counters.
• Upgraded the SQL Server 7.0 to SQL Server 2000.
• Created maintenance plan for database consistency and optimization.
• Installed SQL Analysis services and extracted the data from Oracle and access database and build the cubes for reporting purpose.
• Experienced with performance tuning of stored procedures and SQL Scripts.
• Involved in securing SQL Server in all aspects of the security features.
• Worked on capacity planning for production servers for future growth.
• Created the maintenance plan for optimization and integrity check for all SQL Servers.
• Involved in backups, DBCC, updating index statistics, monitoring database and disk space, security, and scheduled tasks.
• Maintained the SQL Servers up and running during the production servers all the time.
• Involved in day to day monitoring of SQL Server jobs failures, error logs, space usage, & security.
• Created the documentation for database policies and procedures.
• Built a custom SQL Server database for BizTalk server 2000 to house transaction data along with an ASP intranet site for retrieval of the data.

Confidential, Manhattan, NY

Sr. MS SQL DBA

Responsibilities:

• Responsible for provide 24 X 7 dedicated production support to all 400 Production, development and clustered servers.
• Maintained 80 mission critical applications.
• Upgraded SQL 2000 to SQL 2005.
• Installed and configured SQL 2005 on WINDOWS 2000 and 2003 systems.
• Installed and configured 2 Node Active / Passive cluster to provide high availability to mission critical application.
• Configured and maintain transactional, snapshot and merge replications.
• Configured and maintain a Microsoft SQL server2000/2005 fail over clusters.
• Involved in Data Extraction and Loading using DTS, Integration services and Import and Export Utility.
• Created Logical and Physical data modeling for development databases using SQL Diagrams and Erwin Tool.
• Installed, configured and maintained Log shipping to create DR and reporting Server.
• Created maintenance plan for database consistency and optimization.
• Document server and database policies and procedures.
• Involved in Change Management, Problem management activities using Service center Client before implementing database changes in production and development activities.
• Created the backup and restore strategy to production, development and test environments.
• Involved in Disaster recovery and created the documentation.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Determined hardware and software requirements for SQL Server version 2000 and 2005. Determined the SQL 2005 installation options. Tested the Installation of SQL 2005 Server.
• Configured SQL Server Management Studio to work with the SQL Server 2000 and 2005. Configured Dynamic Configuration in SQL Server 2000 and SQL server 2005.
• Worked on Client/Server tools like SQL Server Enterprise Manager, Management Studio and Query Analyzer to administer SQL Servers.
• Evaluated data storage considerations to store databases and transaction logs. Created the database using SQL Server Enterprise Manager, Management Studio, Database Wizard and Transact SQL Statements. Specified size and automatic growth options.
• Developed Integration services package for data transformation and to implement business logic.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Estimated space requirements for a database.
• Worked on Clustering, DTS, Import and Export utility, BCP Utility and replication tool for transferring data. Planned and setup replication.

Confidential, NJ

Lead MS SQL DBA

Responsibilities:

• 24 * 7 mission critical production support of 77 production servers. Installed, configured
• Configured and maintain snapshot and transactional replications for production servers. Created the DTS Packages to do Import and Export operations to MS SQL Servers.
• Improved in SQL Server performance tuning by using SQL Profiler, Performance Monitor, SQL Query Analyzer and Index tuning wizards.
• Monitor 2-node Cluster environment & applied SPs.
• Involved in creating backup strategy for cluster, production, test & development servers.
• Experienced with restoring the user & system databases.
• Involved in disaster recovery procedures. Created maintenance plan for database consistency and optimization. Involved in implementing security features for MS SQL Servers, such as creating and granting permissions on various Objects, assigning permission to user(s), role(s) and column level permission.
• Document server and database policies and procedures.
• Involved in database tuning, sizing projects and projected the database growth.
• Setup Log shipping for Reporting Servers hence, distributed load on Production servers.
• Created linked server from SQL to oracle.
• Worked closely with Network team to Backup Oracle databases
• Installed and configured IIS 6.0 for application team.
• Start and stop IIS services and sites.
• Enable dynamic content services, such as Active Server Pages and ASP.NET
• Created Web site configurations, and install and use File Transfer Protocol (FTP) services.
• Creating virtual directories.

Confidential, MD

MS SQL DBA

Responsibilities:

• Responsible for 24*7 critical production support, total 120 servers out of which 80 servers are production servers. Installed SQL Server 2000 on Windows 2000 advanced servers, applied service packs and security fix.
• Installed, configured and maintained 2 fail over clusters in production environment.
• Configured and maintained transactional and merge replication for 3 environments. Configured Log shipping server to create stand by environment.
• Worked with developers to tune the queries, run scripts and move the database from production to development servers.
• Configured the database maintenance plans for database optimization. Responsible to improve the Server performance and SQL server optimization. Configured SQL Security features and maintained the user administration.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning. Upgraded SQL 2000 servers to SQL 2005 servers.
• Configured 2 log shipping from production system to stand by servers in SQL 2005.
• Configured the transactional replication between the production server environments in SQL 2005.
• Installed SQL Clustering for production environment and configured logshipping for DR.
• Responsible for Capacity planning, sizing, monitoring Disk I/O, Server Rebuild & migration.
• Created Standard Operating Procedures (SOP) for SQL Server install, upgrade, apply patch and SQL clustering.
• Created the documentation for database policies and procedures.
• Experienced with documenting the SQL Server installation and maintenance activities.
• Involved in securing SQL Server in all aspects of the security features.
• Worked on capacity planning for production servers for future growth.
• Created the maintenance plan for optimization and integrity check for all SQL Servers.
• Involved in backups, DBCC, updating index statistics, monitoring database and disk space, security, and scheduled tasks.
• Maintained the SQL Servers up and running during the production servers all the time.
• Involved in day to day monitoring of SQL Server jobs failures, error logs, space usage, & security.
• Created the documentation for database policies and procedures