SUMMARY:

• Experienced DBA/Manager with high availability (HA) multi - instance installations, Failover Clustered Active/Active Instances (FCIs), AlwaysOn Database Availability Groups (DAGs), server and database performance tuning, mirroring, log shipping, reporting services (SSRS)
• Administer SQL Server instances, databases, performance monitor and enhancements
• Diagnose and resolve problems in response to customer reported incidents and proactive monitoring for potential problems for SQL server instances and databases
• Analysis and planning for anticipated changes in data capacity requirements
• Review project requirements with focus on business objectives, application, data, performance
• Coordination of active projects, maintenance, hardware and software updates
• Implement high availability solutions using active/active clustering, database availability groups, mirroring, log shipping and transactional replication
• Performance tools, Performance Monitor(Perfmon), SQL Server Profiler, Database Tuning Advisor, MS-SQL best practice analyzer (BPA), SolarWinds. Dynamic Management Views(DMVs)
• Implement SQL Server maintenance jobs for database / transaction log backups, index defragmentation / rebuild, statistics update, database integrity checks
• ITSM aligned services focused on line(s) of business services and support
• Experienced in problem solving skills and ability to work under pressure

TECHNICAL SKILLS:

SQL: MS-SQL Server 2017 / 2016/ 2014 / 2012 / 2008 R2 / 2005 Enterprise, Azure SQL Database, SQL Profiler (SSDT), Database Tuning Advisor, Activity Monitor, Performance Monitor (Perfmon), Data Collector, Extended Events Manager, MS-SQL Best Practice Analyzer, SSIS (Visual Studio), SSRS, T-SQL, SQLCMD, SQLIO, SolarWinds

Operating Systems: Window Server 2012/2008, Windows 10/7, PowerShell, RedHat Linux

Software: Lite Speed, Backup Exec, CommVault, SolarWinds, MS-Office, MS-Visio, Remedy, Service Center

PROFESSIONAL EXPERIENCE:

Confidential, Garden City, NY

SQL Server DBA

Responsibilities:

• Provided production support for all SQL servers versions 2017/2016/2014/2012/2008 R2
• Migrated SQL Servers 2008R2 to SQL Server 2014/2012, Reporting Services(SSRS), SQL Server logins, database permissions, linked servers, alerts, SQL jobs, Database mail.
• Migrated SSRS databases from SQL Server 2008R2 to SQL Server 2014/2012.
• Migrated On-Premise databases to Azure SQL Server using SSIS.
• Implemented maintenance jobs for database integrity checks, index reorganize / rebuilds, statistics update, nightly backups of user databases and transaction logs.
• Implemented server alerts for job completion and failures, critical server / database related alerts.
• Review of SQL / Windows server logs, maintenance jobs, database and log growth events.
• Performance optimization using DMVs for wait stats, query execution plans analysis.
• Utilized performance monitoring tools, SQL server Profiler, Database Tuning Advisor(DTA), Performance Monitor(Perfmon).
• Implemented database high availability / disaster recovery solutions using log shipping, mirroring, server clustering, database availability groups (DAGs) and transactional replication.
• Implemented SQL Server Alerts for server/database critical errors across all servers.
• Developed and deployed SSIS Packages using Visual Studio. Created dataflow tasks utilizing ADO.net, OLEDB connections.

Confidential, Weehawken, NJ

SQL Server DBA

Responsibilities:

• Migrated SQL databases from SQL 2008/2005 to SQL 2012 production servers.
• Deployed SQL Server 2012 Always on Cluster and Database Availability Groups.
• Patched SQL servers 2012/2008 running in AlwaysOn Database Availability Groups.
• Backup and restore of databases using CommVault and native backup utilities.
• Decommissioned migrated SQL server clusters and databases.
• Provided operational support for production support services.
• Reported on daily task status for database and instance migration for datacenter move.
• Utilized T-SQL scripts to monitor index usage / fragmentation and statistics update.
• Implemented high availability using Log shipping, database mirroring, SQL server clustering.

Confidential, NY

SQL Server DBA

Responsibilities:

• Deployed MS-SQL 2012 active/active cluster supporting production applications.
• Created design document and procedure to replace SAN storage LUNs on production cluster for SQL server 2012 active/active and AlwaysOn instances.
• Worked with Windows and SQL server PowerShell using SMO, sqlcmd and sqlps.
• Created database maintenance jobs for database backups, TLogs, Index defragmentation rebuilds and statistics updates, database integrity checks, job history maintenance.
• Analyzed SQL server logs, SQL server agent jobs, resolved issues for blocking, deadlocks, high CPU, Memory and I/O utilization.
• Performed performance analysis using dynamic management views(DMVs), Perfmon, SQL Profiler, SQL Query Analyzer and database tuning advisor.
• Configured linked servers to run queries against oracle databases.
• Configured SQL Server Reporting Services. Performed SSRS migrations between instances.

Confidential, NYC, NY

SQL Server DBA

Responsibilities:

• Support of production SQL servers, administration, project implementation, helpdesk.
• Worked with windows admin group to setup windows active passive SQL Cluster.
• Performed routine maintenance, including backup & recovery for SQL server 2008 R2/ SQL 2005 servers, database security administration, SQL server instance availability.
• Created maintenance plans for database backups, index reorganize / rebuilds, statistics updates, database integrity checks.
• Implemented database log shipping and database mirroring for mission critical databases.
• Deployed scripts on production server using batches as per client request.
• Installed and configured SQL Server additional components for SSIS(integration services), SSRS(reporting services), SSAS(analysis services)
• Daily monitoring of SQL Server jobs failures, errors, space usage, database and log growth.

Confidential, NY, NY

SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2005 instances, applied latest service packs, hot fixes.
• Implemented SQL Server 2005 cluster hardware, implemented SQL Server database replication, mirroring, log shipping for high availability.
• Created maintenance plans for database/log backups, index reorganize / rebuild, statistics update, database integrity checks.
• Used SQL Profiler and performance monitor to trace database performance issues.
• Setup and configured SSRS (reporting services) for business.
• Installed database mirroring in high performance (synchronous mode) to avoid downtime.
• Configured and monitored snapshot, transactional and merge replication.
• Supported SQL Server production & pre-production release roll-outs.

Confidential, NY

SQL Server DBA

Responsibilities:

• Upgraded SQL 2000 servers to SQL 2005 servers, applied service packs and hot fixes.
• Daily monitoring of SQL Server jobs failures, error logs, space usage, and security.
• Configured log shipping and mirroring between production and DR servers.
• Created SQL database / transactional backup strategy for production and dev environments.
• Improved database performance using SQL Profiler, database tuning analyzer, execution plans and I/O performance monitor counters.
• Created maintenance plans for database/log backups, integrity checks, index rebuild, index fragmentation and statistics update.