Santhosh M GA

647-***-**** ****, Darcel Ave,

acum1b@r.postjobfree.com Mississauga – ON L4T 2X4

SQL Server Database Administrator

OBJECTIVE

To obtain a position as a SQL Server Database Administrator where I can maximize my experience in monitoring and improving database performance and capacity, developing database strategies and implementing security measures to database.

HIGHLIGHTS OF QUALIFICATIONS

Over 5+ years of experience as MS-SQL Server Database Administrator in the creation and deployment of database solutions for diverse requirements with detailed knowledge on design, implementation and administration of databases that support enterprise-wide applications.

Acquainted working experience in handling highly available database and application infrastructure such as SQL Server AlwaysON, SQL clustering, Database Mirroring, network load-balancing, distributed file system for scalability and business continuity requirements.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Architected Windows Authentication, SQL Server Authentication, Windows Groups, SQL Logins, Database Roles, Schema, and Application Roles to manage SQL Server Security mechanism.

Developed and tested backup and restore strategy to cope up with the ever demanding increase in the database size and lessening the possibility of the company’s valuable data loss.

Developed migration plans for SQL Server databases into SQL Server 2012.

Strong experience in mentoring team members and writing documentation.

Adaptable to change and a quick learner possessing strong interpersonal skills with the ability to work with all levels within the organization.

Master degree in Database Professional from England. TECHNICAL SKILLS

Database SQL Server 2012/2008R2/2008/2005.

Systems Windows Server 2012/2008R2/2008/2003.

Language SQL, Powershell.

Tools SQL Profiler.

IT EXPERIENCE

L&T Construction, India Database Administrator, 2011-2016 Configuration, Installation and Maintenance:

Responsible for installation and configuration of SQL Server 2008/2008R2/2012 database on Windows 2003/2008/2012 servers.

Responsible to maintain the database systems that includes but not limited to ensuring successful backups, resolving system issues, monitor system availability, security, performance, capacity, updating system documentation, system and database recovery, etc. Security and Task Automation:

Liable for database security tasks such as creating and maintaining server logins, database users and assigning roles and privileges to users based on the authentication.

Working knowledge on SQL Server Agent including setting up complex workflows within single job, Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Santhosh M GA, 647-***-****, acum1b@r.postjobfree.com Backup and Restore:

Developed backup and recovery plan on different environments based on the data availability requirement and the potential impact of data loss on the business.

Restored databases across many servers based on the requirements such as testing data validation, legacy data movement, setting up fresh database server and various error/correction issues.

Server setup and Performance Tuning:

Accountable for arranging replacement/fresh application/database servers configured with websites and virtual directories under IIS on Windows OS with MS-SQL Server as backend solution.

Involved in data migrations across servers/within instances as a part of data cleansing, application merging and data archival.

Monitored and made recommendations for performance tuning on hosted databases. This involved database rebuild, archiving, index creation/removal/modification, file group modifications, adding scheduled jobs to re-index and update statistics in databases. High Availability/Disaster Recovery:

Working experience in handling highly available database and application infrastructure such as SQL Server AlwaysON, SQL Clustering, Database Mirroring, network load-balancing, distributed file system for business continuity requirements.

Setup and monitored database mirroring between principal database server and mirrored database server as a disaster recovery solutions.

Implemented Log shipping technology on the standby database server as a report database solution to the business needs.

SSRS, Change Management, Documentation:

Involved in bi-monthly change management, in which the application codes are tested before running on production servers with essential backup mechanisms.

Deployed RDL reports on report servers and managed shared data sources and permissions.

Prepared and constantly updated detailed audit documents on Disaster Recovery Procedure, Backup Strategy which proved very helpful for the team during internal auditing and identifying loopholes to be fixed.

Coordinated with cross-functional teams – infra structure, functional, technical, developers.

Provided 24x7 on-call support. Supported systems beyond regular hours/ weekends/ holidays. ACHIEVEMENTS

Consolidated production servers involving legacy data movement with improved functionality, security and cost efficiency.

Achieved minimal downtime during flood in the city by operating the production servers from Near Disaster Recovery Datacenter.

EDUCATION

Master of Science in Database Professional 2008. Sheffield Hallam University - England

Bachelor of Computer Science and Engineering 2004. Manonmanium Sundaranar University – India

Contact this candidate