SUMMARY

• SQL DBA team leader offering over 9 years of experience worked in various roles seeking a position with new challenges and opportunities to build upon extensive knowledge and experience in MS SQL Server in the areas of service delivery
• Demonstrated abilities in handling project management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters.
• Provided general advice to Team members and handling escalated client issues, queries and complaints in an effective and timely manner.
• Monitor incident trends and anticipate potential problems for proactive resolution
• Manage DBA operations including staff recruitment, supervision, scheduling, development, evaluation and disciplinary actions.
• Involved in complete planning and knowledge transfer program for service and database consolidation between Newedge and Confidential . Setup a new team in SGGSC India for same department. The program gave me hands - on in to service catalog development, defining RASCI for Market DBA and other IS Groups within the perimeter in India-SGGSC. Also defined KPI’s for the DBA team with adherence to the SLA & OLA.
• Excellent working knowledge of the service delivery methods used in the Group and an in-depth understanding of service management techniques, including change management, incident management, Problem Management, Data Centre Operations and configuration management.
• Strong in database administration, production support, installation, configuration, upgrades, patches, Performance tuning, backup and recovery, DR setup, space management, database security and Auditing.
• Guarantee recoverability by managing the scheduling of system backups and database archive operations in conjunction with Data Center Operations. Ensure the correction of complex live issues with the minimum disruption to the business.
• Excellent experience in Installation and configuration of MS-SQL, Sybase 12.5,12.7, MySQL 5.6, 5.7 in UNIX/LINUX and Windows environment.
• Hands on experience as a MS-SQL/ Sybase database administrator and in full administrator cycle of a data warehouse, including requirements gathering, design, implementation & maintenance
• Proficient in database administration & operations (MS-SQL / Sybase/ MySQL) supporting a large and diverse application portfolio of 24×7 critical production systems, development, test & QA systems across multiple platforms
• Possess good communication, interpersonal, analytical / coordination skills with expertise in communicating all levels of the organisation

TECHNICAL SKILLS

Operating Systems: Windows XP / NT / / 2008/ 2012, PACCT, Citrix, VMware, UNIX and Linux

Languages: T-SQL, PowerShell, PL/SQL, C, Java and DOS

RDBMS: SQL Server / 2008 / R2 /2012 / Sybase ASE 12.5 / 15.5 / 15.7/ MySQL 5.6 / 5.7

Tools: Used: Autosys, IDERA, Remedy 6.00.01, BMC Patrol, SQL Profiler, PSSDAIG, PAL, DBArtisan.8.1.1, Precise i3, Service Now, System Centre Operations Manager (SCOM), Control-M 6.2.01 & Putty etc

PROFESSIONAL EXPERIENCE

Confidential

Lead DBA

Responsibilities:

• Involved in transition of application databases from NYL to TCS Infrastructure Service.
• Managing 1200+ SQL Instances on development, QA and production environments
• Involved in Oracle application script execution and responsible for DML changes.
• Interacting with Technical Account Managers to understand the requirements and recommending solutions for process improvement.
• End-to-End involvement in KT & Service Transition between Newyork Life Insurance to TCS Infrastructure Support.
• Perform RCA and Problem management. Work with Engineering and Operation team to optimize robust DBA Automation.
• Actively involved with application team for Legacy Management.
• Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers
• Repairing the corrupted objects & restoring the data from the known good backup
• Analyzing monthly Database growth and anticipating Disk space

Environment: Linux, UNIX, Windows, MSSQL, Oracle, Putty & ESP Scheduler etc.

Confidential, Jersey City, NJ

Lead MS SQL/MySQL/Sybase DBA

Responsibilities:

• Contributing as the Sr. Database Specialist by guiding the team and mentoring other DBAs in L1 & L2 capacity.
• Managing 2500+ SQL Instances on development, QA and production environments
• Hiring and setting up the offshore DBA team in India and training them on business specific process and environments of SG market division.
• Established, maintained, improved and published L1, L2, L3 KPI’s and metrics for offshore DBA and presenting them to Management.
• Provide inputs to our people mangers for streamlining team objectives and individual performance via KPI’s and metrics.
• Interacting with offshore Technical Account Managers to understand the requirements and recommending solutions for process improvement.
• End-to-End involvement in KT & Service Transition between Newedge and SocGen database from Singapore DBA.
• Perform RCA and Problem management. Work with Transversal Engineering team to optimize robust DBA Automation. Automate database installation for DBA which reduce manual intervention and saved 70% of time.
• Actively involved in Legacy Management.
• Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers
• Repairing the corrupted objects & restoring the data from the known good backup
• Worked on MS-SQL, Sybase and MySQL.
• Successfully completed database transition between Newedge and Confidential .
• Setup script to do Auditing on SQL Server 2005 SE and Completed Storage migration activity
• Setup script to check the active cluster node and preferred node if it’s running. Reduced the manual effort of daily check.
• Successfully completed database migration from Sybase to MS-SQL.
• Modified all maintenance jobs to use PowerShell.
• Sybase Server installation: Installed Sybase Server’s Version 15.5 / 15.7
• Accountable for software installation of MySQL-Server / Client-5.6. **
• Implementing database backups & refreshes for MySQL & Sybase - Manual
• Overseeing jobs management through crontab, alert monitoring and incident handling

Environment: Linux, UNIX, Windows, MSSQL, Sybase, MySQL, Putty, Autosys, Idera & Lite speed etc.

Confidential, Cincinnati, OH

MS SQL/ Sybase DBA

Responsibilities:

• Act as a Technical Mentor for junior DBAs in team. Involve them in project implementation.
• Managing 900+ SQL Instances on development, QA and production environments
• Have handled many Full-Delegation projects. Improved/ Optimized and streamlined process as part of full delegation transition.
• Perform RCA’s whenever a problem management is required.
• SPOC for clients for their Issues/Up-Coming projects etc.
• Handled Primary DBA roles and responsibility for multiple applications.
• Create and maintain all databases required for production usage.
• Perform capacity management and planning.
• Implementing Microsoft Windows Server Failover Clustering and setting up DR strategy for different clients.
• Differentiating in database backup, recovery / security; implementing strategies for database highly availability & scalability
• Handling cognition in replication & log shipping methodologies
• Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers
• Maintaining data integrity / data redundancy in the table & at the database level
• Write scripts to automate monitoring and alerting from SQL Server Databases.
• Scripting of database objects, performance tuning at database & user levels
• Expert in setting up the security in SQL Server.
• Executing replication (Transactional & Snapshot) for replicating data from production to test server
• Worked on MS-SQL and Sybase Databases.
• Set-up transversal data encryption and service broker on SQL Server.
• Managed transition for Sybase database for DBI client.
• Setup inventory for the DBA team which helps to keep all the information about Application, Server & Database.
• Involved with Technology Excellence Group (TEG) to minimize repetitive alerts, Fixing Database related issues.
• Worked for Project Transitioning, Offshore KT, Parallel Run & GO LIVE.

Environment: Linux, UNIX, Windows, MSSQL, Sybase, Putty, Remedy, PSSDAIG, BMC Patrol & SCOM

Confidential

DBA

Responsibilities:

• Installing, configuring, administering as well as securing our client’s production servers
• Managing 500+ SQL Instances on development, QA and production environments
• Setting up database backup, recovery / security; applied database highly availability & scalability
• Handling basic cognition in clustering, replication & log shipping methodologies
• Organizing device / drive backups while regulating weekly schedules
• Implementing data retrieval & ran scripting to reload database objects
• Coordinating in development of SQL Server Security Model & setting up the Database / SQL Server standards
• Upgrade of service packs in the server and reconfigured all the parameters
• Managing tuning of indexes & rebuilding in the case of index allocation errors
• Supervising the Jobs & scheduling done on daily, weekly / monthly basis for security and maintaining databases using by running update status
• Repairing the corrupted objects & restoring the data from the known good backup
• Accountable for daily complete backups of testing & production databases
• Replacing transaction logs & continuous monitoring of database growth; configuring maximum number of user connections & the permissions
• Applying data transfer method to transfer tables from one server to another & writing code / creating jobs to automate repetitive tasks
• Reporting the users with the means of alerts & various notification tools
• Worked on MS-SQL and Sybase Databases.
• Downgrading SQL server 2005 EE to SE to reduce Licensing cost.
• Upgrading SQL Server 2000 to SQL Server 2005 or SQL Server 2008.
• Job Modification from MKS tool kit to TSQL Script on all database servers.
• Build SQL server 2005 Cluster and in managed DR test.
• Migrating tables part of Heterogeneous replication from SQL to SYBASE.
• Configured Replication, log shipping & Mirroring
• Designed Database Security settings based on application / user request
• SQL Server Reporting, Integration & Analysis Services installation

Environment: Windows, MSSQL, Sybase, Putty, SCOM, DBArtisan.8.1.1, Precise i3, Service Now, Control-M 6.2.01