SQL Server Application DBA Resume

SUMMARY

19+ years of RDBMS administration experience in Sybase ASE, Sybase Replication Server, Sybase IQ and SQL Server.
Have worked for various financial clients including Citco Fund Services, Bear Stearns, JPMC, Citibank, Confidential and Confidential .
Expert in Sybase and SQL Server Database Administration, Support, System Analysis, Design, Development.
In depth experience in installation, migration, upgradation and patching.
Primary DBA roles including trouble shooting, Performance tuning and migration.
Application DBA roles for critical application releases and query tuning.
Successfully managed DBA Team of 5 members and have proven leadership skills
Excellent experience with clustering, High Availability, Log shipping, Mirroring, Always On.
Have expertise in Production support ( 24x7 ), database recovery and backup, DBCC, Reorg, Performance Tuning related issues.
Excellent knowledge of job automation using Autosys and cron schedulers.
Good knowledge of C, bash, korn and Perl scripting.
Excellent operating systems knowledge in Windows, Linux, AIX, Sun Solaris, SCO UNIX
Knowledge of various ticketing tools including Remedy, Peregrine, Service Now.
Have received awards for Process streamlining, alert reduction and automation.

TECHNICAL SKILLS

RDBMS: Sybase ASE 12.5 / 15.x, Sybase Replication 12.4 / 15.x, Sybase IQ MS SQL Server 2008 R2, SQL Server 2012, 2014, 2016

Operating Systems: Windows, Linux, AIX, Sun Solaris

Monitoring Tools: BMC Patrol, Foglight, SQL Sentry.

Ticketing Tools: Remedy, Peregrine, Service Now

Scripting: K, C and bash shells, PowerShell

Misc. Others: Knowledge of Oracle 9i, Languages C/C++, VB 6.0, Reporting Tool - SQR, Crystal Reports 9

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Application DBA

Responsibilities:

Interact with different Scrum Teams on end to end support for Application Releases and Production Rollouts.
Participate in Performance calls and suggested performance enhancements options like index suggestion, table participation, deadlock avoidance on case to case basis.
Perform SQL Sentry monitoring and Report Top SQL queries impacting performance.
In the short span of time, I was able to partially automate the daily script code drop process which reduced the manual intervention by 30%.

Environment: Bitbucket, Sourcetree, Confluence, SQL Server 2016, SQL Sentry, PowerShell

Confidential

Sybase & SQL Server Application and Operations DBA

Responsibilities:

Participated in Application Releases and developed scripts to improve the process.
Developed various reports related to Peak Season Readiness, DB Response, Identity thresholds, which was used exhaustively by OPS DBA team.
Participated in Data center migrations, automated email for the checkout reports.
Worked proactively on various long pending issues related to spinlock contention, parallel backups, foglight monitoring, slowness of depersonalization script, etc.

Environment: SQL Server 2016, Sybase ASE 15.x, Sybase Replication 15.x, Windows, Linux, Foglight monitoring tool, PowerShell.

Confidential

Primary DBA

Responsibilities:

I worked as Primary DBA for 120+ servers and 11 applications altogether.
Performed successful migrations from Sybase ASE 15.0.3/12.5 to 15.7 on Linux / cloud platform for various estate critical Applications.
As PDBA, I took part in various COB tests and dry runs, which includes NAM and EMEA servers.
Worked proactively on various long pending issues related to recurring alerts, replication, autosys job fixed, etc. efficiently.
Performed normal BAU activities like - Capacity Management, FortiDb audit violations, troubleshooting weekend maintenance jobs for issues, Autosys job fixes.
Pushed cloud technology, merger server services and decommissioning of old server as a cost saving measure
Coordinated various critical application meetings with clear-cut and innovative ideas.
Received several appreciations from client for prompt responses and successful migrations.
Pioneered RPC CIS technology to Citi Sybase servers.
Provided critical support for Application for their release as part of App DBA.
Proactive participation for all P1/P2 issues for SQL/Sybase environments.

Environment: Sybase ASE 15.x, Sybase Replication 15.x, Sybase IQ, Linux, Autosys, BMC Patrol, Korn, C and Perl shell scripting.

Confidential

Senior Sybase and MSSQL DBA

Responsibilities:

Handle all major escalations during US hrs as part of L3 Team.
Actively participate in incident calls, co-ordinate with SAP for critical solution
Configuration, Management, Troubleshooting Log Shipping, Mirroring, Replication for SQL Server.
Sybase ASE 15.7 upgrades and Migration to Linux
Troubleshooting for daily production support issues
Fixing weekend maintenance issues related to dbcc, Update Stat, Reorg, server start failures
Fine tuning database configurations for SQL servers
User deployment in Production Servers as part of change management.
Performance Tuning using Profiler trace, tuning advisor.

Environment: MS SQL Server 2008 R2 / 2012, Sybase ASE 15.x, Sybase Replication 15.7.1, Windows, Linux