SUMMARY:

• A result - oriented professional with 10 years of experience in Database Operations, Transition Planning, Solution Development, Quality Assurance Project Management & Team Management
• Demonstrated abilities in handling project management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters.
• Involved in complete planning and knowledge transfer program for service and database consolidation between Newedge and Societe Generale. 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.
• Worked on MS-SQL 2012 installation on Amazon RDS Cloud and setup SSL for the server.
• 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 Cassandra, 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/Cassandra) 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 organization

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 ADMINISTRATOR

Environment: Linux, UNIX, Windows, MSSQL, Sybase, Putty & Autosys Scheduler etc.

Responsibilities:

• Contributing as Lead Administrator by guiding the team and mentoring other DBAs in L1 & L2 capacity.
• Managing 6500+ MSSQL & 1500+ Sybase databases on development, QA and production environments.
• Maximum database size maintained 4.5 TB and fixed table corruption for the same.
• Rebuilding and monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• Analyzing monthly Database growth and anticipating Disk space using BMC Patrol.
• Creating technical documentation for team to maintain the Production environment and upscale new joiners.
• Handling MIM and provide solution with timelines for management and help to get the RCA.

Confidential

Team Lead

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

Responsibilities:

• Provided strategic direction for the database team and functioned as the technical/project leader on projects.
• Involved in transition of application databases from NYL to TCS Infrastructure Service.
• Managed and administered 1200+ database in 105 instances. Initiated a project to consolidate servers and to remove old/unused databases. Reduced the number of databases to under 900 on 56 instances.
• Configured and supported replication and log shipping in both SQL 2008 R2 and 2012.
• Documented processes for installations, clustering, availability group setup, and patching.
• 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.
• Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers
• Rebuilding and monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition as part of Legacy Management.
• Analyzing monthly Database growth and anticipating Disk space

Confidential

Database Specialist

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

Responsibilities:

• Contributing as the Sr. Database Specialist by guiding the team and mentoring other DBAs in L1 & L2 capacity.
• Managing 2500+ databases 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 onsite 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. Reduce manual installation by 70% for DBA.
• 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, MySQL, Casandra and MongoDB.
• Dexterously involved in handling multiple technologies, for great initiative & enthusiasm and received Sport Award for same at Society Generally in Aug’14
• Successfully completed database transition between Newedge and Societe Generale and received Star of the Quarter at Society Generally in Jan’16.
• Successfully added new node for Cassandra Cluster.
• 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. **
• Overseeing jobs management through crontab, alert monitoring and incident handling
• Implementing Microsoft Windows Server Failover Clustering and SQL Server AlwaysOn Availability Groups
• Installing, configuring, administering as well as securing our client’s production servers
• Differentiating in database backup, recovery / security; implementing strategies for database highly availability & scalability
• Handling basic cognition in clustering, replication & log shipping methodologies
• Expert in setting up the security in SQL Server
• Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers
• Organizing device / drive backups while regulating weekly schedules
• Maintaining data integrity / data redundancy in the table & at the database level
• Scripting of database objects, performance tuning at database & user levels
• Implementing data retrieval & ran scripting to reload database objects
• Coordinating in development of SQL Server Security Model & setting up the Database / SQL Server standards
• Executing replication (Transactional & Snapshot) for replicating data from production to test server
• Examine the business ethics for the extensive use of indexes on the new servers
• Upgrade of service packs in the server and reconfigured all the parameters
• Managing tuning of indexes & rebuilding in the case of index allocation errors
• Setting the configuration parameters in accordance to the requirements
• 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
• Observing memory, CPU utilization, disk utilization, locks, deadlocks & runtime of queries
• Database creation: generating logical data models & translate into physical database structures that integrate with existing or proposed database structures and verifying if they meet the required parameters
• Creating tables, index, views, triggers, procedures, user groups, users & assign permissions based on requirement
• Database Security: creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups
• Monitoring of error logs regularly, of database space allocations, transaction log space allocations and backup / restore
• Little exposure on Replication Server alerts monitoring
• Handling software installation of ASE 12.5.*
• Involve in database & device creations
• Login management - creation, removal, assigning roles and mapping them with database users
• Performing database dump & load - both manually and through jobs
• Examine memory, CPU utilization, disk utilization, locks, deadlocks & runtime of queries
• Preparing tables, index, views, triggers, procedures, user groups, users & assign permissions based on requirement
• Database Security: creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups
• Supervising of error logs regularly, of database space allocations, transaction log space allocations and backup / restore
• Introducing on Replication Server alerts monitoring, incident handling and providing 24*7 support
• Accountable for software installation of MySQL-Server / Client-5.6. **
• Involve in database creations and file management
• Maintaining login & user management - creation, removal & assigning roles
• Implementing database backups & refreshes - Manual
• Overseeing jobs management through crontab, alert monitoring and incident handling
• Resolving database problems & issues relating to applications / systems and providing 24*7 support

Confidential

Senior Specialist

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

Responsibilities:

• Installing, configuring, administering as well as securing our client’s production servers
• Differentiating in database backup, recovery / security; implementing strategies for database highly availability & scalability
• Handling basic 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
• Scripting of database objects, performance tuning at database & user levels
• Implementing data retrieval & ran scripting to reload database objects
• Coordinating in development of SQL Server Security Model & setting up the Database / SQL Server standards
• Executing replication (Transactional & Snapshot) for replicating data from production to test server
• Examine the business ethics for the extensive use of indexes on the new servers
• Upgrade of service packs in the server and reconfigured all the parameters
• Managing tuning of indexes & rebuilding in the case of index allocation errors
• Setting the configuration parameters in accordance to the requirements
• 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
• Observing memory, CPU utilization, disk utilization, locks, deadlocks & runtime of queries
• Database creation: generating logical data models & translate into physical database structures that integrate with existing or proposed database structures and verifying if they meet the required parameters
• Creating tables, index, views, triggers, procedures, user groups, users & assign permissions based on requirement
• Database Security: creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups
• Monitoring of error logs regularly, of database space allocations, transaction log space allocations and backup / restore
• Little exposure on Replication Server alerts monitoring
• Handling software installation of ASE 12.5.*
• Involve in database & device creations
• Login management - creation, removal, assigning roles and mapping them with database users
• Performing database dump & load - both manually and through jobs
• Examine memory, CPU utilization, disk utilization, locks, deadlocks & runtime of queries
• Preparing tables, index, views, triggers, procedures, user groups, users & assign permissions based on requirement
• Database Security: creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups
• Supervising of error logs regularly, of database space allocations, transaction log space allocations and backup / restore
• Introducing on Replication Server alerts monitoring, incident handling and providing 24*7 support
• Recoded achievement in receiving HCL - Appreciation for taking responsibility & multi skilled in Dec’12
• Successfully implemented compliance policy & modified Global administration jobs in the project
• 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.

Confidential

DBA

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

Responsibilities:

• Implementing Microsoft Windows Server Failover Clustering and SQL Server AlwaysOn Availability Groups
• Installing, configuring, administering as well as securing our client’s production servers
• Differentiating in database backup, recovery / security; implementing strategies for database highly availability & scalability
• Handling basic cognition in clustering, replication & log shipping methodologies
• Expert in setting up the security in SQL Server
• Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers
• Organizing device / drive backups while regulating weekly schedules
• Maintaining data integrity / data redundancy in the table & at the database level
• Scripting of database objects, performance tuning at database & user levels
• Implementing data retrieval & ran scripting to reload database objects
• Coordinating in development of SQL Server Security Model & setting up the Database / SQL Server standards
• Executing replication (Transactional & Snapshot) for replicating data from production to test server
• Examine the business ethics for the extensive use of indexes on the new servers
• Upgrade of service packs in the server and reconfigured all the parameters
• Managing tuning of indexes & rebuilding in the case of index allocation errors
• Setting the configuration parameters in accordance to the requirements
• 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
• Observing memory, CPU utilization, disk utilization, locks, deadlocks & runtime of queries
• Database creation: generating logical data models & translate into physical database structures that integrate with existing or proposed database structures and verifying if they meet the required parameters
• Creating tables, index, views, triggers, procedures, user groups, users & assign permissions based on requirement
• Database Security: creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups
• Monitoring of error logs regularly, of database space allocations, transaction log space allocations and backup / restore
• Little exposure on Replication Server alerts monitoring
• Handling software installation of ASE 12.5.*
• Involve in database & device creations
• Login management - creation, removal, assigning roles and mapping them with database users
• Performing database dump & load - both manually and through jobs
• Examine memory, CPU utilization, disk utilization, locks, deadlocks & runtime of queries
• Preparing tables, index, views, triggers, procedures, user groups, users & assign permissions based on requirement
• Database Security: creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups
• Supervising of error logs regularly, of database space allocations, transaction log space allocations and backup / restore
• Introducing on Replication Server alerts monitoring, incident handling and providing 24*7 support
• 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.
• Designed Database Security settings based on application / user request
• SQL Server Reporting, Integration & Analysis Services installation
• Creating tables paces, rollback segments, user maintenance, database security imposition by creation & granting of roles / privileges, performance tuning, backups, tuning of SQL statements and support for oracle toolsets / utilities
• Interacting with users for system study, requirements gathering, analysis & testing of system and with team members to ensure smooth progress of project work
• Undertaking design / development, testing, debugging & troubleshooting of the application
• Managing database administration function involving:
• Creation / administration of all database objects, including tables, clusters, indexes, views, sequences, packages & procedures
• Database tuning & performance monitoring
• Resolution of database start up problems
• Conducting extensive analysis of the overall design, data modelling and program structure of RDBMS packages.
• Working with business analysts to develop functionality requirements for database objects
• Developing and enforcing database standards, guidelines, operational policies and procedures
• Working collaboratively with system administrators, NOC, operations support team, application developers
• Overseeing database operations of fast-paced complex distributed database environments involving security management, installations/upgrades/patches, performance tuning, backup and recovery
• Involve in providing post-implementation, maintenance & enhancement support with regard to the database applications
• Significantly involved in discussion with team member about implementing the execution plan and distributed the task among team member to achieve the project on time at Society Generally in 2014.
• Actively involved in writing script to automate some of the DBA implementation task which will reduce manual intervention
• Successfully implemented compliance policy & modified Global administration jobs in the project
• Bagged DBA of the Year at Nuware for contributing in enhancement of customer experience in
• Dexterously involved in handling multiple technologies, for great initiative & enthusiasm and received Sport Award for same at Society Generally in Aug’14
• Recoded achievement in receiving HCL - Appreciation for taking responsibility & multi skilled in Dec’12