SUMMARY:

• I am a Microsoft Certified Solutions Associate (MCSA) and my areas of expertise include database administration, migration, upgrade, database development and data warehouse implementation with Microsoft SQL Server versions 2000, 2005, 2008 R2, 2012, 2014 and 2016. I have provided support for more than 600+ servers with 1000s of databases running across 100s of applications. I have several achievements under my belt that benefited my clients in terms of cost savings, process improvements and support excellence.
• I have over 25 years of full SDLC experience and more than 20 years of SQL Server DBA experience with Microsoft SQL Server and its related products. I have been exposed to various tools and technologies to monitor, tune performance, troubleshoot and resolve issues related to database and its applications.
• I have also worked as a developer for about 8 years before transitioning to database administration role.
• I am currently working as a Senior SQL Server DBA for Confidential, TX since Oct 2015. Prior to this engagement, I worked for Advance Knowledge Technologies, NJ for 2 years, and The City of New York for 3 years, Confidential, NY for 3 years and Confidential and Confidential for about 8 years as a Senior SQL Server Database Administrator. I have provided world wide support and worked on several initiatives and projects including Confidential, server migrations and upgrades for my clients.

TECHNICAL SKILLS:

SOFTWARE: Microsoft SQL Server 2016/2014/2012/2008 R 2/2005/2000/7.0/6.5/6.0 (Express, Developer, Standard and Enterprise Editions), Power Builder 6/5/4, Visual Basic 6.0, Oracle 7, SQL Litespeed, Spotlight Enterprise for SQL Server, RedGate Virtual Servers, Tivoli TSM for SQL Server, Veritas NetBackup and NetBackup Agent for SQL Server, IIS, ASP, VBScript, PCAnywhere 9.0, Terminal Server, Watcom SQL 4.0, BASIC, COBOL, Foxpro, Dbase IV and Clipper, ERWin METHODOLOGIES

OPERATING SYSTEM: Windows 2012/2008/2003/2000/ NT 4.0 /98/95, DOS, Novell NetWare

.PROFESSIONAL EXPERIENCE

Confidential, Southlake, TX

Senior Microsoft SQL Server Database Administrator

Responsibilities:

• Operational lead position with a team of 4 DBA’s supporting databases for several mission critical applications.
• Troubleshooting issues in a high pressure, high stress environment that impacts millions of subscribers and always goes to CNN and the Wall Street Journal when there are any 4G impacted subscribers; Communicate clearly and effectively with executive management while troubleshooting production outages on a live bridge during all hours of the day and night.
• Build a transparent support environment between vendor, VZW Engineering, VZW Operations and DBA Operations such that any and all items affecting the smooth running of the platform are managed, and to the extent possible, mitigated; running of Operation meetings to support project timelines and reactive/proactive database changes is paramount.
• Building and Implementing, administering, and maintaining SQL Server databases in the Commercial Data Systems (CDS) organization. Build and successfully integrates complex, multi - Terabyte OLTP and Data Warehousing databases with minimal supervision. Ensures optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring.
• Maintain database security and enterprise policy guidelines according to best practices. Recommend new and improved guidelines to ensure high availability and stability.
• Conducted benchmark tests to gauge hardware capacity and meet application capacity requirements. Document business and technical requirements. Create technically viable, cost-effective system designs and develops customer-focused implementation strategies and Mentors other DBAs in the group.
• Act as a leader of engineers in the work group. Train new team members. Lead multiple complex projects and high impact projects. Manage entire projects for network builds, modifying configurations, refining designs, and troubleshooting issues/analyzing problems. Involved in troubleshooting process, working with operations who contact data engineers for help. Responsible for planning, execution and completion of assigned projects. Typically manages multiple projects at one time. Manage both internal and external resources. Interface with all levels of management. Use independent judgment and discretion to make decisions in the best interest of the business. Ensures projects stay within budget. Utilize experience and knowledge/education to perform tasks. Provide advanced skills for analyzing and resolving complex problems.

Environment: MS-SQL Server 2016/ 2014/ 2012 / 2008, SSRS, SSIS, BCP, DTS, Bi-Directional SQL Server Replication, Nagios, Splunk, Windows 2003/ 2008/2012 Servers, SQL Sentry.

Confidential, Edison, NJ

Senior Microsoft SQL Server Database Administrator

Responsibilities:

• Install and configure SQL Server product and it’s components in production, non-production, stand-alone, VM, shared and cluster environment.
• Prepare documentation, checklist, templates and standard operating procedures as per industry standards and best practices.
• Setup database maintenance plan to perform full backups, differential backups and transaction log backups of all the databases to provide point-in-time recovery in the event of data loss or corruption. Configure jobs to send notification when the backup fails.
• Setup database maintenance plan to rebuild indexes and update statistics of all databases to proactively improve performance of databases. Perform integrity check of all the databases once a week to ensure there is no structural corruption.
• Configure and manage replication solutions like snapshot, transactional, and merge as per the business requirement. Configure jobs to send notification when the replication fails. Experience configuring replication in central publisher and multiple subscriber scenario, multiple publisher to central subscriber and multiple publisher to multiple subscriber scenarios.
• Resolved several replication performance problems and failures using replication monitor. Ensured that the replication runs with minimum latency by creating a tracer token periodically.
• 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, copies that can serve as a backup, copies that can be used for reporting purpose, copies with delayed update that can be used for recovering data that got corrupted in production.
• Proactively monitor and resolve SQL Server events like service down, agent down, backup failures, job failures, SSIS package failures, distributed query failures using linked servers, unplanned cluster failovers, replication failures, mirroring failures, log shipping job failures etc. insufficient disk space for database or log to grow, database or log full errors, tempdb errors etc.,
• Resolved several performance issues with long running queries and jobs and ensure that they run in acceptable time frame by checking the execution plan, creating necessary indexes and optimizing the code.
• Resolved many blockings and deadlocks using SQL Server Profiler and DBCC trace flags like 1204 and 1222. Used Blocked process report and blocked process threshold to capture blockings in an xml formant in SQL Profiler. Used deadlock graph event to troubleshoot and identify the processes and object involved in deadlock. Created indexes, changed isolation levels and deadlock priorities to resolve deadlock issues.
• Resolved several application timeout issues by monitoring and the tuning the queries and tables using Profiler and estimated execution plans.
• Proactively monitoring the index usage and physical statistics and recommend missing indexes to improve database performance.
• Worked with developers on a regular basis to help them design and develop optimized database and code. Review their code and advise them T-SQL best practices. Fulfill their day to day task like refreshing development databases from production, grant permissions to users, schedules jobs and SSIS packages, create linked servers, deploy SSRS reports, and migrate changes to production.

Environment: MS-SQL Server 2014/ 2012 / 2008 / 2005 / 2000, SSRS, SSIS, SSAS, BCP, DTS, Windows 2003/ 2008/2012 Servers, Quest Spotlight, Microsoft Cluster and SharePoint.

City Of New York, Confidential

Senior Microsoft SQL Server Database Administrator

Responsibilities:

• Use DMVs and custom scripts to tune performance of SQL Server queries.
• Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
• Use custom developed scripts to identify missing indexes.
• Evaluate query execution plans to identify expensive operators and tune them.
• Resolve Client/Server Connectivity issues.
• Resolve deadlocks and timeouts using Quest Spotlight, SQL Profiler and DBCC trace flags.
• Improve performance of long running jobs by optimizing the workflow and queries.
• Perform Database Integrity Checks using DBCC commands.
• Refresh test and UAT environment from production.
• Implement change management process to deploy changes to production.
• Provide support to developers and promptly complete their work requests.
• Migration Data from Excel, Flat files, Oracle, Informix and various other data sources to MS SQL Server by using BCP. DTS and SSIS packages.
• Provide support for ETL using SQL Server DTS and SSIS.
• Work with the development team on Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
• Extensively using tools like Quest Spotlight, SQL Profiler, Windows Performance Monitoring utility and performance counters for proactive monitoring and tuning MS SQL Server Performance,
• Hands-on working experience with analyzing query plans, using extended Stored Procedures and DMVs, managing indexes and locks, troubleshooting query performance and MS SQL server bottle necks including Network Traffic, Hardware usage and Blocking.
• Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security.
• Provided support for SQL Server Integration Services including installation, configuration, deployment of SSIS packages, dynamic package configuration using environment variables for portability between development and production environment and setting up logging within the package for troubleshooting, and setting up permissions for package development.

Environment: MS-SQL Server 2012 / 2008 / 2005 / 2000, SSRS, SSIS, SSAS, BCP, DTS, Windows 2003/ 2008 Servers, Quest Spotlight, Microsoft Cluster and SharePoint, NetBackup.

Confidential, NY, NY

Senior Microsoft SQL Server Database Administrator

Responsibilities:

• Installation, upgrade and configuration of MS SQL Server and databases in clustered and stand alone environments.
• Performance tuning using various SQL Server Commands, DTA (Database Tuning Advisor), Query Optimization plans, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Design and documentation of Logical and Physical data models.
• Provide expertise for using best RAID Technologies based on application requirement.
• Migration of Data from Excel, Flat files and various other data sources to MS SQL Server by using BCP and DTS utility.
• Extracting, Transforming and loading of data using SQL Server DTS and SSIS.
• Provide support using system stored procedures, tables and dynamic management views and T-SQL.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Work with the development team on Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
• Implementation of Replication Models using Snapshot, Merge and Transactional.
• Extensively using tools like SQL Profiler, Windows Performance Monitoring utility and performance counters for monitoring and Tuning MS SQL Server Performance,
• Extensively used third Party backup solutions like Redgate for MS SQL Server.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL server bottle necks including Network Traffic, Hardware usage and Blocking.
• Provided support for SQL Server Reporting Services (SSRS).
• Successfully implemented Log shipping for DR solutions in MS SQL Server 2000/2005.
• Environment: MS-SQL Server 2008/ 2005 / 2000 / 7.0 / 6.5, SSRS, SSIS, SSAS, BCP, DTS, Redgate, Windows 2003 Servers, Quest Spotlight, Microsoft Clusters, What’s UP and Altiris.

Confidential, Raritan NJ

Senior Microsoft SQL Server Database Administrator

Responsibilities:

• Provide SQL Server Database Administration, Database Modeling/Architecture, and Development Support for NCS and J&J group of companies.
• Test the installation and configuration of new versions and editions of SQL Server, service packs and hot fixes. Develop a standard installation checklist and IQ/OQs for such installations.
• Install and configure MS-SQL Server (all versions and editions) with service packs and security hot fixes on a dedicated / shared / cluster environment.
• Worked with the J&J approved vendors to install third-party SQL Server applications and ensure that it is installed and compliant with J&J policies.
• Install, configure and monitor database replication using snapshot, transactional or merge replication to provide database redundancy across multiple geographical locations.
• Develop geographic database failover solutions using Visual Basic, VB Script, SQL-DMO and T-SQL for business critical applications like Desktop Image Deployment, Citrix MetaFrame Farm, DiscoverNursing.com, SAP’s - Vertex, Paymetrics, Enterprise Crystal Report, Informatica and Web PORTALs.
• Create and manage database users, local and domain groups and implement SQL Server Security using Mixed Authentication or Windows Authentication.
• Maintain user accounts and passwords for privileged and non-privileged accounts and ensure that they are maintained according to the security policies.
• Assist J&J Worldwide Information Security Group to prepare SQL Server Configuration Guide according to J&J security policies.
• Monitor SQL Server down, SQL Server Agent down, Error log, Application and System logs, Job failures, Backup Failures, Database and Log growth, CPU Utilization, Memory Utilization and Disk
• Utilization using the SQL Server monitoring tool called MSSQLHelpDesk. This tool was developed in-house by me using SQL-DMO and T-SQL programming languages.
• Use SQL Server Profiler (Server and Client traces), Performance (System) Monitor, Index Tuning Wizard and Query Analyzer to monitor performance, capture performance data for testing and analysis, identify the root cause for performance bottlenecks, and recommend solution to mitigate problems.
• Capture SQL Server statistics and compare it with the base line performance values to evaluate SQL Server performance.
• Debug back-end stored procedures to identify performance issues.
• Participate in the root cause analysis meetings with vendors, developers and application owners and provide performance data and matrix for a given period of time.
• Capture capacity planning data over period of time and provide graphs and matrix to the application owners.
• Report SQL Server bugs and issues to Microsoft PSS Support.
• Work with Microsoft PSS Support to troubleshoot and debug SQL Server / Windows problems.
• Install and configure SQL LiteSpeed for SQL Server to backup SQL Server database or setup database maintenance plan to backup all the databases locally on the disk.
• Validate the backup by restoring the database on the test server. Perform DR exercise periodically for mission critical applications at a remote DR site managed by Sungard.
• Design and implement database backups and restore strategy on disks and tapes. Develop database disaster recovery checklists for each server.
• Worked with the Consolidation Analysis to perform site assessment and collect information pertaining to SQL Server installations at four sites.
• Recommend consolidation strategies to reduce the number of instance of SQL Server based on like applications and databases.
• Setup separate Shared SQL Server Environment for OLTP and Data warehousing applications and work with the site managers, system engineers, application owners, developers and users to migrate their databases, DTS/SSIS packages, OLAP cubes, Users and applications to the Shared Environment.
• Worked on several in-house projects as a back-end SQL Server Developer which involved writing several complex procedures, triggers, queries, packages and functions using SQL/TSQL.
• Worked with the end-users to collect user requirements and design Software Requirement Specification.
• Prepare Database Design and User interface document based on Software Requirement Specification.
• Worked with the front-end developers and designed back-end stored procedures, triggers, views, functions, SSIS and DTS packages and Cubes.
• Worked with the owners of different data sources to understand the data elements and develop the ETL process for data acquisition, data transformation and data presentation to build the data warehouse using DTS and SSIS.

Environment: MSSQLHelpDesk, MS-SQL Server 2005 / 2000 / 7.0 / 6.5, SSAS, SSRS, SSIS, DTS, BCP, Tivoli TSM for SQL Server, Veritas NetBackupAgent, SQL LiteSpeed, PCAnywhere, 9.0, Terminal Services, Windows 2000 / NT Servers / Workstations and ER/WIN, Microsoft Cluster on Win2K.

Confidential, Newark NJ

Microsoft SQL Server Database Administrator

Responsibilities:

• Install and configure MS-SQL Server 7.0.
• Install Client Utilities on the client machines.
• Create and Manage Confidential database.
• Create and Manage Users.
• Troubleshoot problems.
• Create and Monitor automated tasks.
• Design and develop database backup and recovery procedures.
• Support migration and cleanup of Meter Header and Meter Test data from Mainframe to Confidential database.

Environment: MS-SQL Server 7.0, COSMO / Confidential Application, Windows NT Server / Workstations and PCAnywhere 8.2.

Confidential

Project Leader / Microsoft SQL Server Database Administrator

Responsibilities:

• Relational database was designed and integrated simultaneously with each module. In all total six maintenance modules, twelve transaction modules and various reports were designed.
• Common operations in all modules like Add, Modify, Delete, View, Chaining from one module to another, Search, First Row, Next Row, Previous Row and Last Row where set on Right mouse button.
• Standard child window was created with a static datawindow and a report datawindow.
• Designed a pre-defined composite datawindow, which contained the organization’s name and addresses and other standard formatting required for all reports.
• Create database and tables thru ER/Win.
• Installation and configuration of SQL Server.
• Periodic back up of the databases and restore databases when required or at the time of recovery.
• Managed the databases, write stored procedures and triggers, setup users, designing database security, setup and manage tasks, alerts and operators.
• Setup SQL Mail and integrate it with the application, design and manage replication.
• Tuning the SQL Server for the optimal performance, and troubleshooting any SQL Server problems.

Environment: MS-SQL Server 6.5 Power Builder 5.0, ER/WIN 2.6, HP Pentium 133, HP NetServer E-45, Compaq Pentium 133, Toshiba Pentium Laptop, Win 95/NT

Confidential

Software Engineer

Responsibilities:

• Write Power Builder code and design the interface in Power Builder.
• Wrote stored procedures and functions to enhance the speed of the application.
• Created non-visual objects containing business rules in the form of functions and Visual User objects for datawindow, tabpage and treeview for re-usability.
• Extensive use of datastore was necessary to reduce visual overhead.
• Utilized message objects to communicate between modules.
• Composite, nested and N-up datawindow was used for reports.
• Error handling was performed with the help of error object; all common routines were defined as global functions.

Environment: Power Builder 4.0, Erwin 2.0 and Oracle Server 7, HP Pentium 133, Win 95/NT

Page 9 of 9