PROFESSIONAL SUMMARY:

• Over 12+ years of professional experience as Database Administrator in Multiple Technologies Primarily SQL Server (MS SQL DBA).
• In - depth experience in all aspects of Database Administration and Database Development (SQL and T-SQL) and automation scripting (PowerShell).
• Experience in administration, troubleshooting and maintenance of production, development & UAT server databases.
• Proficient in meeting tight deadlines and adopting new technologies.
• A self -motivated, responsible team player working effectively with management, developers and users.
• Good exposure with Infrastructure Process (ITIL) management. Core Responsibilities
• Extensive experience in MS SQL Server Database Administration including planning, installation, deployment/implementation, configuration.
• Handled & resolved escalated incidents, fire-calls from level-2 engineer to fulfill the SLA commitments.
• Implemented and provided consultation for customers on new project requirements.
• Expertise in SQL Server databases Backups/Restore, High availability features.
• Migrated Databases on different versions of SQL Server.
• Migrated Databases, Jobs, DTS packages, Logins from 2000 servers to 2005,2008,2008 R2,2012 and 2014.
• Experience in planning and implementing Security Standards for MS SQL Server on Windows NT 2000/2003/2008/2008 R2, 2012 and 2014.
• Experience in Installation of various SQL Server versions.
• Experience in using Native Tools for Performance Monitoring.
• Implemented Replication of MS SQL Server Databases, successfully configured transactional replication and Merge replication on Production databases.
• Implemented Log Shipping of MS SQL Server Databases on MS SQL Server 2000/2005/2008/2008 R2 versions.
• Extensive Experience in configuring Database Mirroring on SQL Server 2005, 2008 R2 and 2012 versions.
• Experience in setting up Always on Feature from SQL Server 2012.
• In Depth experience in Troubleshooting Database Performance Issues.
• Experience in third party tools such as LightSpeed, Red gate, Performance Analysis Log tool etc.
• Experience in Extraction Transformations and Loading tools like Data Transformation Services (DTS).
• Deployment and trouble shooting of SSIS Packages upon user’s request.
• Database refreshes upon the application user’s request.
• Experience on planning and performing the DR tests of various environments.
• Experience on designing Database Backup and recovery of databases as per client requirement.
• Configuring SQL Server reporting services and Deploying the reports and Managing security of SSRS as required.
• Basic Knowledge on Oracle Database concepts.
• Experience in efficient use of Dynamic Management Views and functions and Experience in guiding the developers to make efficient use options and features available in SQL Server.
• Experience in managing the SQL Server using the policy based management option available from 2008 version.
• Configuring resource governor for trouble shooting purposes in case of any performance issues.
• Extensive experience in SQL & T - SQL Programming, Power Shell Scripting, Query Optimization, Performance tuning and has good knowledge of Database Design, Data Models, program logic and test case preparation in multiple domains like Infrastructure Solution, Travel and Transportation Solution, Health Care, CRM, Institute Management, Accounts and Banking.

TECHNICAL SKILLS:

Operating Systems: Windows 2000, 2003, XP, 2008,2008 R2, 2012

RDBMS: Microsoft SQL Server 2000/2005/2008/2012/2014, SQL Azure, Oracle 9i, MS Access

Languages: SQL, T-SQL and PowerShell

Tools: Universal Service Desk, Remedy, Veritas Net backup, SQL LightSpeed, Citrix, Tivoli Storage Media, PAL tool, SQL Profiler, System Monitor, SQL Management Studio, SQL Enterprise Manager, SQL Query Analyzer, Webstore

PROFESSIONAL EXPERIENCE:

Confidential

• Database Consultant
• Senior Database Administrator
• Database Administrator
• Database Administrator
• SQL Server Developer/DBA
• SQL Server Developer/DBA

Responsibilities:

• Refreshing the Databases as per the Development requirements
• Writing SQL and Power shell scripts to automate proactive monitoring and preparing different types application reports on request.
• Migration and Configuration of the SQL Server databases.
• Configuring and troubleshooting issues related to Log Shipping Mirroring, Replication and Always-On availability group.
• Plan and Execution of Disaster Recovery plan for SQL Server environment.
• Trouble shooting performance issues and automating day to day DBA activities.
• Database Capacity planning and consolidation for SQL Server environment
• Documentation of installation and procedural documents.
• Performing failovers on Cluster setup boxes as per the requirement.
• Proactive Monitoring of database critical parameters for Database Servers
• Supported DEV teams during build preparation, deployment process, with their queries and concerns related to pre-production and production environment

Confidential

Responsibilities:

• Managing Confidential ’s most critical Financial databases on SQL Server 2008 R2 Three node cluster.
• Single point of contact for the customer, communicating with client directly for any issues and concerns
• Assist team members and others in related queries and concerns.
• Installing and configuring the SQL Server Cluster/Standalone Instance and Databases as per the Customer requirement
• Configuring and Installing Pro-active Automated Alert Monitoring scripts
• Creating and managing the users, roles and privileges as per the application requirement
• Refreshing Azure and On-premise Schemas, tables and full database
• Troubleshooting Performance issues, Database level issues, Backup and Recovery problems and Fragmentations/defragmentation related problems
• Analyzing schemas and tables and collecting system level statistics and reorganizing the all the tables and rebuilding the corresponding indexes
• Contacting customer to update the status of handling issues and service requests at every stage of resolution
• Organizing team meetings (Daily Service Review) and SRTs (Service Restoration Team meet) for discussing and explaining about the issues/problems persisting on the environment and to get the proper resolution with the help of senior resources in the team
• Documenting each activity taken place in the environment such as a New installation, a change, configuration etc.,
• Suggesting the Customer for feasible configuration of related tools as per existing application and Operating system environment

Confidential

Responsibilities:

• As part of operations support, responsible for maintenance of SQL Servers which are hosted on in PROD, QA, ST and DEV environments.
• Monitoring the servers and responding to MOM alerts received and resolving them.
• Monitoring and troubleshooting replication as part of daily activities and configuring the replication if required.
• Backing up of all the databases along with the verification.
• Creation of user database, users and assigning roles to the users.
• Restoration of the databases.
• Applying SQL Server patches and service packs.
• Monitoring and optimizing the performance of the Database.
• Performing database Refresh activities on lower environments.
• Checking Alert log & monitoring growth of the Table spaces.
• Maintenance of Database security.
• Supported DEV teams during build preparation and deployment process

Confidential

Responsibilities:

• Provide DBA support to the Production, Pre-Production and Development Servers.
• Monitoring the growth of the Database to ensure the smooth running of daily activities.
• Maintaining data exchange batch jobs
• Taking full / differential database backups of all system and production databases.
• Controlling and monitoring user access to the Database.
• Executing the Database Consistency Checks ( Confidential ) at regular intervals using Schedules.
• Establish and maintain appropriate backup & recovery strategies.
• Maintain the standby server by restoring the backup.
• Check the Windows Event Viewer for error messages.
• Check for adequate disk space for growing database files and log files.
• Check SQL Server jobs (look for failures) and the SQL Server logs for error messages.
• Coordinating with software development team in view of database design & changes required in functional modules
• Evaluate possible approaches to increasing application and server performance, based on the knowledge obtained from daily operational activities.
• Assist team members and others in database related queries and concerns.
• Troubleshooting the application and database issues
• Responsible for DB changes code management and preparation of build deployment script

Confidential

Responsibilities:

• DBA support for Production and Pre-Production Servers and performed daily administration, monitoring of SQL Servers
• Monitoring the growth of the Database to ensure the smooth running of daily activities.
• Controlling and monitoring user access to the Database.
• Check the Windows Event Viewer for error messages.
• Check for adequate disk space for growing database files and log files.
• Check SQL Server jobs (look for failures) and the SQL Server logs for error messages.
• Played a key role in design & implementation of Replication & Disaster recovery solution of Database.
• Involved in Query optimization (stored procedures, views).
• Managed functions pertaining to refreshing of developer’s databases and assisted developers to write queries.
• Upload the information from different platforms into SQL databases using DTS
• Database & client software valuation/installation/migration/patch installation & troubleshooting
• Provided technical support on SQL tuning and indexes design to developers, resolved database problems on a daily basis.
• Worked with the application developers on database issues, including index design, data manipulation, SQL tuning, and using views or procedures for data security.
• Executing the Database Consistency Checks ( Confidential ) at regular intervals using Schedules.
• Configure and monitor database backups with maintenance plans.
• Restore Database in case of crash/ emergencies
• Monitor databases performance and manage database locks/ processes etc.

Confidential

Responsibilities:

• As a team member, I worked on the administrative tasks of SQL Server and infrastructure up gradation for improvisation of existing SQL server database design and performance and reengineering of front end applications for co-operative banks. We give utmost priority to SQL Server Availability and performed daily administration, monitoring of SQL Servers.
• Maintaining the production Database Server that is common to 4 branches.
• Monitoring the growth of the Database to ensure the smooth running of daily activities.
• Taking full/differential database backups of all preproduction and production databases.
• Controlling and monitoring user access to the Database.
• Executing the Database Consistency Checks ( Confidential ) at regular intervals using Schedules.
• Establish and maintain appropriate backup & recovery strategies.
• Maintain the standby server by restoring the backup.
• Check the Windows Event Viewer for error messages.
• Check for adequate disk space for growing database files and log files.
• Check SQL Server jobs (look for failures) and the SQL Server logs for error messages.
• Coordinating with software development team in view of database design & changes required in functional modules
• Evaluate possible approaches to increasing application and server performance, based on the knowledge obtained from daily operational activities.