SUMMARY

• SQL Server Database Administrator with 15+ years of experience and proven track record of designing, administering and supporting database systems.
• Expertise experience in Installation, Configuration, and Management of SQL Server 201 |2012|2008 database servers on multi node multisite SQL clusters.
• Experienced with Implementing and Maintaining IT solutions for a large inventory of SQL Servers using technologies such as Log Shipping | Database Clustering | Mirroring | Always On HADR.
• Expertise Experience in Provisioning and Configuring Servers and Databases in AWS
• AWS EC2 and RDS.
• Perform all database management responsibilities in Microsoft Azure for production and non - production workloads Good knowledge & experience on Cloud Computing like Azure.
• Expertise experience in Performance Tuning using Execution plan | Query Store| Wait Stats| Extended Events| Data Collector | Resource Governor| DMV’s |DMF’s |PSS diag.
• Implemented new SQL Server 2019 mechanisms like data compressions | online indexing | Contained Databases | security principals | AAG | Partitioning (Horizontal).
• Experience in encryption strategies such as Transparent Data Encryption (TDE).
• Experience with BCP and Bulk Insert.
• SQL Server Virtualization & Consolidation on VMware and Hyper-V environments.
• Solid IT infrastructure foundation and skilled in automation, scripting such as PowerShell, security and database development.
• Experience with Very Large Databases (VLDB’s) ranging from 1 terabyte to 10+ terabytes with 15000 plus transactions an hour.
• SQL Server Hardening & Best Practice Implementation as recommended by Microsoft.
• More than 15 + years of experience in administration of Windows | including Windows Failover clustering, Active Directory, DNS and DHCP.
• Vast experience with Monitoring tools like), System Center Operations Manager (SCOM), Idera, SQL Spotlight, LogicMonitor and SQL Sentry Plan Explorer.
• Experience in Web server (IIS 7.0 |6.0 | 5.0) installation/configuration, troubleshooting IIS issues. Experience in Troubleshooting ASP and.net applications hosted on IIS.
• Experience with Storage Area Networks (SAN: CX300 | CX310 |CX340).
• Experience with on-call problem resolution and triage in SQL Server environments.
• Experience in planning, designing, and documentation of disaster recovery plan.
• Experience in working with geographically dispersed team and teams such as Infrastructure, Storage, Networking, Development and QA.
• Certified Microsoft SQL Server DBA

TECHNICAL SKILLS

Relational Databases: SQL Server 2019/2017/2016/2014/2012/2008/2005/2000/7.0/6.5 , AWS, SQL, Sybase, MySQL.

Operating System: Windows 2016/2012/20 bit & 32 bit)

Database Administration Tools: SQL Server Management Studio, Enterprise Manager, SQL Profiler, Control - M, Microsoft Visual Studio, Business Intelligence Development Studio.

Query/Reporting: SQL Query Analyzer, MS SQL Reporting Services 2016/2012/2008/2005/2000 , and Crystal Reports.

Database Monitoring Tools: Logic Monitor, Idera, Redgate, Spotlight on SQL Server, Cacti, NT Performance monitor, SQL Profiler, and SQL Sentry Plan explorer

Database Maintenance Tools: CA.

Data Model Tool: ERWIN, Visio

Web Server: IIS 5.0/6.0/7.0

Programming Languages: T-SQL, PowerShell

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Database Administrator

Responsibilities:

• Responsible for installation and configuration of SQL server 2016/ 2017 database on VMs and EC2 Windows servers 2012R2/2016
• Responsible for providing 24x7 critical Production Support to all 120 plus Production, Development and Clustered servers.
• Installed, Configured and Maintained high available solutions such as Always-on, Database Mirroring, Replication, and Log Shipping.
• Worked extensively on configuring and troubleshooting Always-on on SQL 2017/2016/2014/2012.
• Responsible for OLTP Design (logical/physical), development, implementation, and maintenance phases.
• Responsible for OLTP Code and design review. Ensure database security, integrity and performance.
• Designed and implemented backup and recovery strategy.
• Use of Query Store feature for monitoring performance of database systems.
• Experience in Horizontal and Vertical Partitioning of tables to achieve better Performance and scalability
• Worked with developers to tune the SQL queries using SQL Profiler.
• Provided 7 x 24 Production support for the database and application issues.
• Coordinated patch management of windows OS and clusters. Tested and applied latest service packs and cumulative Hotfix which addressed specific issues for SQL 2017/2016/2014/2012/2008 and Windows 2016/2012.
• Performance tuning - Identify SQL bottleneck queries and tune the queries for optimal performance using DMV’s, DMF’s, xtended events.
• Resolved locking conflicts/blocking and resource utilization. Worked with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics. Resolve complex database administration problems.

Environment: SQL 2019/2016/2014/2012/2008 , Windows 2012/2008, T-SQL, Always-On, SSIS, SSRS, Database Mirroring, Log Shipping, Windows Failover clustering, AWS RDS and EC2, SCOM 2007/2012, Idera.

Confidential

Senior SQL Server DBA

Responsibilities:

• Production support, Performance Tuning, BCP/DR, Dev Support.
• Production database support to Confidential applications.
• Documented the OS and database /application matrix, documented the OS and SQL Server hardware and software specifications.
• Configured Always ON availability groups for critical database applications. Trouble shoot Always ON failover issues. Put in place solution to proactively avoid Always ON performance issues.
• Performance tuning and deadlock analysis.
• Development support and BCP (Business continuity) using database mirroring and log shipping.
• Managed DDL and DML changes through the SDLC
• Providing design, development, and testing support to assigned brokerage application teams.
• Managed on-call problem resolution and triage for the production SQL Server database environment.
• Installing SQL Server products; manage patching and compliance issues.
• Analyzing performance issues and providing recommendations based on testing results or problems being experienced in production.
• Maintaining SQL Replication between source and target SQL Server databases.
• Leading the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
• Consulting with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
• Handling and leading various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development.
• Partitioning SQL Server Production and Development tables based on retention rules defined by business.
• Refreshing pre-production environment with production data. Scrambling sensitive data fields.

Environment: SQL Server 2014/2016/2017 , Windows 2012/2012R2, SSIS, SSRS, SQL Profiler, SQL Server Trace, T-SQL, Perfmon, Mirroring, Log Shipping, Transactional/Merge Replication, Spotlight.

Confidential

SQL Server DBA

Responsibilities:

• Worked as “Database Administrator” maintaining 35 Production systems (Intranet and internet) responsible for Support, on call 24/7, database maintenance and system maintenance.
• Federal Program Improvement Plan (PIP) Applications Operations and Support.
• Disaster Recovery Planning, testing and implementation for Level 1 applications.
• Data Center migration project: Was part of a team responsible for migration of 24+ servers.
• Installation of SQL 2008/2012 on a clustered (Active/Passive, Active/Active/Passive) and non-clustered environment.
• Technical lead in setting up and maintaining SQL Server log shipping, and Mirroring across geographically dispersed SQL clusters. Experience with setting up replication between homogenous and heterogeneous subscribers such as SQL and DB2.
• Implemented data encryption on PII information on the database level and the object level.
• Implemented the NIST guidelines for server security and hardened the servers.

Environment: SQL Server 2005/2008/2012/2014 Enterprise edition, SQL Server 2014 standard, Windows Server 2008/2008R2 Enterprise edition, Windows MSCS Clustered Environment, VMware, Enterprise Architect 7.5.8, JIRA, SQL Server Profiler.

Confidential

Database Manager

Responsibilities:

• Job duties included managing the database team.
• Lead the day-to-day operations for the SQL Server and Oracle database teams.
• Databases and system uptime 24/7.
• Resource allocation.
• Responsible for timely reports for senior management which enables them to make informed and accurate IT decisions.
• Optimize the use of the databases across the organization by staying current on upcoming enhancements to functionality and guiding team in the optimal use of the existing functionality.
• Coordinate seamless cooperation with Network, applications and Infrastructure teams.
• Responsible for optimal database performance expectations of users and management.
• Plan and execute proactive measures to achieve stability and availability of the database systems.
• Lead the development of processes and procedures to improve efficiencies of the team.

Confidential

Senior SQL Server DBA

Responsibilities:

• Installation of SQL 2005/2008/2008 r2 on a clustered (Active/Passive, Active/Active/Passive) and non-clustered environment.
• Implemented and maintaining SQL Server log shipping, and Mirroring across geographically dispersed SQL clusters.
• Upgrade experience from SQL20005to SQL2008R2.
• Monitoring, controlling and implementing changes in the production environment.
• Experience in applying Service Packs at database level.
• Monitor Databases in error logs, lock escalation, dead lock, resource utilization by sessions & package caching, buffer pool hit-ratios.
• Involved in Physical designing and development of the application.
• Monitoring the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of Indexes and taking remedial steps. Configured RAID1 (Mirroring) for OS & Transaction logs. Configured RAID5 for Data files.
• Creation and Maintenance of database, table spaces, users, tables, indexes, stored procedures, roles, profiles, partitions and other schema objects.
• Database loading, Migrating and maintaining data using various utilities DTS, EXPORT, IMPORT and ATTACH/DETTACH Data Migration tools.
• Architected online and tape backup strategy for mission critical applications.
• Performed advanced DBA functions: Physical DB design, linked server definition and security, Day-to-day DBA monitoring and business needs analysis.
• Devised a refresh strategy where in the non- production environment databases is automatically refreshed with production data every day.
• Define enterprise-level standards (coding, architectural, migration), platform and tool selection.
• Performance Tuning using Execution plan, Profiler, and Performance Monitor.
• Created Users and Roles and performed Database Auditing and Security.
• Involved in Migration of Database using Migration Utility. Scheduling of operation and outages.

Environment: SQL Server 2005/2008/2008 R2, Windows 2008/r2, SSIS, DTS, DB2, Replication, Log Shipping, Windows clustering, Redgate.

Confidential

Senior SQL Server DBA

Responsibilities:

• Planning and Implementation of migration from SQL Server 2000 to SQL Server 2005.
• Analysis and Design of disaster recovery and high availability.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS ETL packages.
• Implemented ER modeling for OLTP and OLAP.
• Have configured and deployed SSIS packages on servers.
• Extensive experience in creating stored procedures, triggers and cursors.
• Implemented SQL Server Security baselines recommended by Microsoft and SQL Server security best practices and guidelines by DISA for SQL Server 2000 and SQL Server 2005.
• Created SQL Auditing, and enabled SQL Auditing on SQL Server.
• Created customized Database Audit specifications.
• Installing and Configuring of SQL Server 2005 Database in clustered environment, Database Mirroring & Log Shipping for high availability solutions.
• Implementation of system wide security policies and trouble shooting.
• Installed and configured SQL Server 2008 on development servers. Designed and Implemented performance benchmark for SQL Server 2008
• Analysis of Tables, Stored Procedures, Views, Defaults, Triggers, Indexes and suggested corrective measures.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and daily monitoring of SQL Server databases.
• Monitored the performance using sql profiler and windows performance monitor tool.

Environment: Windows Server Bit enterprise edition, Two node Active-Passive Clustered SQL Server, SQL Server 2005/2008 Enterprise 64 bit, SQL Server 2000 Enterprise.

Confidential

Senior SQL Server DBA

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Implemented in logical and physical design of data warehouse.
• Wrote SQL scripts for creating daily backups of OLAP databases. Created scheduled jobs to monitor the database and data warehouse backup jobs, monitor the disk space.
• Have successfully performed disaster recovery mockup drills each year during the project to simulate recovery of all our production SQL Server installations in an event of disaster.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Migrated Databases from Sybase to SQL Server 2000. Mission critical 24/7 production applications were hosted on SQL Server Enterprise edition, Windows Advanced Server 2003. Active/Passive Cluster Server configuration.

Environment: SQL Server 7.0/2000/2005 , Erwin 4.0, SQL Server Enterprise Manager, SQL Server profiler, SQL Query Analyzer, Sybase11.5/12.5ASE, Windows NT 4.0/2000. Hummingbird DOCS OPEN/DM5, REMEDY