Database Administrator

Database administrator (DBA) with nearly 8 years of experience providing support and maintenance on database solutions in Microsoft SQL server environments. Proficient in assortment of technologies including PowerShell, Windows, Mysql, MongoDB and RedGate SQL Backup. Superior multitasking ability allowing troubleshooting problems, resolving issues and providing guidance while maintaining a professional demeanor.

Core Competencies:

Maintaining the Service Line agreements Performance Optimization of databases

Installation and Patching of SQL Server Creating and Monitoring Server Jobs

Setting up Clusters, replication, Mirroring and Log Shipping Automation daily tasks

Automating the Installation and patching Resolving Technical issues

Administering & Maintaining Microsoft SQL Servers Application Maintenance and Support

Education & Certifications

Bachelor of Technology (B Tech), Electronics and Communication, July 2003- July2007 (WES Credentials – 4 years Full Time Bachelor’s Degree)

Microsoft Certified Solutions Associate, SQL Server 2012, May 2015

Microsoft Certified Technology Specialist, SQL server 2005, August 2009

Experience

Senior Database Administrator

Cubic Health Inc.

October 2015 – Till date

Project: Database Development / Database Support

Cubic Health being an Analytics organization it requires new Database / Analysis solutions which are built by the DBA and development team. As a DBA it is required to create new database environments, Standardize the environments, create new security and capacity planning solutions. As a Developer it is required to create new data processing solutions that will be used for Analytics for clients.

Role, Responsibilities and Achievements:

Create new database servers from scratch including operating system, Network and Database setups.

Capacity Planning and management of database server environments.

Implementing Monitoring systems for Database and application servers.

Implementing standard backup and DR solutions.

Performance Tuning SQL server queries and SSIS packages used for database solutions.

Designing new database structures for applications.

Develop stored procedures for application use.

Create and maintain automated processes for Tableau reports deployment using PowerShell.

Database Administrator

SOCAN Group (Not-for-profit organization)

June 2015 – October 2015

Project: Database Support

The Database Support team provides support on all SQL Server and Oracle environments for all in house and external applications like Epicore ERP Management. The role also requires to support and maintain the internal databases of the Organization like HR related databases.

Role, Responsibilities and Achievements:

Responsible for providing day to day support on multi-terabyte database environments.

Perform SQL server and application migrations to newer versions.

Capacity planning for new database environments.

Setup new Clustered, Replicated and Mirrored environments and provide support on them.

Provide best practices information of all process related to database operations and security.

Enhance current backup and restore methodologies

Provide guidance to SQL developers on performance optimization of SQL scripts and procedures.

Provide best practices for all SQL Server related processes.

SQL server Database Administrator

Aristocrat Technologies

April 2014 – April 2015

Project: Online Gaming Platform

A small DBA team provided support on SQL server, MongoDB and Mysql databases used for running online slot games for different partners. The support would include integration of different database environments to send and receive data to each other.

Role, Responsibilities and Achievements:

Awarded for significant contribution for building new High Availability Clustered environments.

Automated SQL server database backup procedures for better error handling.

Capacity Planning for new environments

Providing continual improvement on existing environments

Responsible for management of security solutions and using tools like IBM InfoSphere Guardium and ApexSQL Audit for Audit Management.

Developed new Stored procedures for automated database maintenance

Provide guidance to SQL developers on performance optimization of SQL scripts and procedures.

Integrated Mongodb and SQL server environments to Report Mongodb data

Setup new Drupal based Content Management System on Mysql database.

Provide best practices information of all process related to database operations and security.

Database Administrator

Sun Life Financials

November 2010 – March 2014

Project: Infrastructure Database Administration

A Team of Database Administrators from India, US and Canada providing support on application databases on SQL server 2000,2005 and 2008 databases. The databases would be used for Insurance based applications and were managed under high security.

Role, Responsibilities and Achievements:

Automated SQL Server patching on multiple environments simultaneously using PowerShell.

Provided Infrastructure support on SQL Server environments including Installation, Standardization and decommissioning of database servers.

Worked on day to day Infrastructure maintenance of SQL Servers with large size databases (1 Terabyte plus databases).

Automated Installation and configuration of SQL server on multiple environments.

Contributed to Disaster Recovery solutions for Production Environments.

Test and approve new software (or new versions) before being used in server and user environments.

Provide best practices and Standard installation guidelines with documentation.

Work on Software upgrade projects to ensure the servers are up to date with the latest software versions.

Senior Software Engineer

NIIT Technologies

May 2010 – November 2010

Project: ING Investment Banking

A Team providing Database Administration and application support on Team Foundation Server repository for Project and SharePoint Management. The application is used for full life cycle management of .Net development for various applications of ING Bank.

Role, Responsibilities and Achievements:

Provided database maintenance on SQL server and application support on TFS 2007 and 2010 environments

Developed configuration methods for SharePoint site configuration using PowerShell.

Provided guidance and presentation to clients on use of TFS Projects for application development.

Software Engineer

Tech Mahindra (Mahindra Satyam, Satyam Computers)

August 2007 – May 2010

Project: Business Group IT Support, Microsoft Corporation

A team providing database and application support on internal databases of Microsoft Corporation used for development of new applications for clients. The database would be used for applications providing Full Life Cycle management.

Role, Responsibilities and Achievements:

Awarded Pat on Back award for providing resolution on maximum number of Support tickets in a month.

Provided end to end support on applications like Product Studio, VSS, Source Depot and Team Foundation Server.

Performing database backups, restores, integrity checks, optimizations, performance tuning, and database troubleshooting.

Contact this candidate