SQL Database Administrator Resume

SUMMARY:

12+ years of total experience in Production and Database Support.
Worked on databases 2000/2005/2008/2012/2014/2016 versions of MS - SQL servers, 12.x, 15.x, 16 of Sybase ASE, 12.5, 15.x versions of SAP Replication server.
Successfully handled projects on Installations, patching, upgrades, migration and scripting
Demonstrated team and relationship management skills coupled with proven communication skills.
Experienced in working on ticketing tools such as Service Now and WebTop, scheduling tools such as Autosys and Control M.
Experienced in following ITIL standards, change management and problem management processes.

TECHNICAL SKILLS:

Operating System: Sun Solaris 8, 9, Linux 6.2, 7.1, AIX 5.3, Windows 2000,2005,2008,2012,2014, Windows NT

Databases: MS-SQL 2000,2005,2008R2,2012,2014,2016, Sybase 12.5 - 15.x, Sybase Replication Server 12.5,15.x, SAP HANA SPS 11

GUI: Sybase Central, DBartisan, SQL Server Management Studio, Query Analyzer, RapidSql, SAP HANA Studio, SAP Control Center

Languages: Shell Scripting, AWK Programming, TSQL.

Tools: & Utilities: Service Now, Tivoli Remedy Software, ISQL, BMC Patrol, Autosys, Clear Case, Webtop, SSIS, SSRS

PROFESSIONAL EXPERIENCE:

SQL Database Administrator

Confidential

Responsibilities:

Confidential

SQL Database Administrator

Responsibilities:

SQL DBA Lead

Confidential

Responsibilities:

Experience in setting up new heterogeneous replication environment using SAP Replication server
Defined and implemented Best Practices, SLA’s for teh project team in HPE.
Handled complex issues faced by clients in database and resolve it in timely manner.
Developed scripts to automate teh critical Database monitoring and health check tasks.
Provide permanent fix for a Business Impacting problem.
Suggest client new improvements and adoption of new features in database.
Liaise with product vendor to identify and resolve any product bugs.
Point of Contact for all database related issues faced by client.
Define database architecture for new application as and when required by clients
Develop scripts to automate teh critical monitoring and health check tasks.
Provide permanent fix for a Business Impacting problem.
Suggest client new improvements and adoption of new features.
Liaise with product vendor to identify and resolve any product bugs.
Define database architecture and data flow mapping for new application as and when required by clients
Perform Problem Management for each Critical Incident to find a permanent fix.

SQL DBA

Confidential

Responsibilities:

Providing database support for trading and finance applications.
Understanding teh requirements for teh applications and installing new T-SQL, ASE and MSSQL servers as per teh required standards.
Designing & building databases to store information, Estimating and applying new server configurations and monitoring performance of teh database.
Setup replication, Mirroring of databases, perform database maintenance, apply updates and patches
Managed multiple database upgradation and dataserver migration activities.
Perform in-depth analysis on performance issues and suggest improvements for increasing teh query/server performance.
Perform Recovery such as Point in Time, Partial or Up to teh Minute Recovery of teh databases to a specific point of time during failures.
Take part in weekend activities such as DR tests, SAN Pool move, Migration and cutover activities etc.
When performance issues arise, determine teh most TEMPeffective way to increase performance including hardware purchases, server configuration changes, or index/query change.
Write scripts to automate recursive DBA tasks.

Support DBA

Confidential

Responsibilities:

Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012 environments.
Successfully worked on project 50K to reduce teh number of webtop alerts for teh team from more than 1,00,000 alerts /month to less than 50,000 alerts / month.
Planned and successfully executed project to reduce teh number of index failures during weekends due to database space issues.
Analyzed and ensured all database servers are backed up in a way that meets teh business’s Recovery Point Objectives (RPO).
Investigate, find root cause for a critical production problem and provide a detailed analysis and resolution for teh issue.
Setup, Monitor and fix any issues during Index Rebuild, reorg, DBCC and update stats
Experienced in using SQL Server Profiler and SQL Server Agent.

Confidential

SQL DBA

Responsibilities:

Successfully worked on project 50K to reduce teh number of webtop alerts for teh team from more than 1,00,000 alerts /month to less than 50,000 alerts / month.
Successfully worked on integrating Lehman servers into barcap environment by making them complaint with Barclay’s server standards.
Planned and successfully executed project to reduce teh number of index failures during weekends due to database space issues.
Analyzed and ensured all database servers are backed up in a way that meets teh business’s Recovery Point Objectives (RPO).
Investigate, find root cause for a critical production problem and provide a detailed analysis and resolution for teh issue.
Setup, Monitor and fix any issues during Index Rebuild, reorg, DBCC and update stats

Confidential

Senior Technical Specialist - DBA

Responsibilities:

Backup/Restore databases as and when needed and define Backup strategy for teh servers.
Creating and managing login accounts, Granting roles and permissions to users.
Managing and monitoring teh use of disk space, memory and connections.
Writing scripts for data loading, migration, processing etc.
Liaise with Microsoft technical support by raising cases to resolve product related bugs.
Find queries causing deadlocks and suggest application to fix frequently occurring deadlocks.
Resolve user database/tempdb log full issues and identify teh filling process.