Sathiyaseelan Malesan - SQL DBA

SQL SERVER DBA

Sathiyaseelan Malesan

Email: admdcc@r.postjobfree.com Mobile: +971-********* LinkedIn: linkedin.com/in/sathiyaseelan-malesan-00160558 PROFILE SUMMARY

Microsoft Certified(70-764) in Administering SQL Database Infrastructure.

7 years of experience in SQL Database Administration.

Have hands of experience in Oracle Database Administration.

Have experience in high availability features like Log Shipping, Clustering, Database Mirroring and Always ON.

Experience in Performance Tuning and Optimization (PTO), profiling and using native monitoring and troubleshooting tools.

Expertise in DB Backups, Restoring, Disaster Recovery and Planning.

Having experience in BI like SSIS and SSRS.

PCI DSS audits for SQL Servers on quarterly basis.

Database trending and performance analysis and experience in providing the future infrastructure by capacity planning.

Experience working in a VMware ESX 4.1 - 5.1 environment.

Security and vulnerability analysis of SQL Databases.

Supporting most critical Core Banking Databases.

Applying SQL Server Cumulative Updates/Service Pack on quarterly basis.

Handling 14 TB of highly critical database.

Works in production environment and supports Oncall on rotational basis. TECHNICAL KNOWLEDGE

Server and Workstation : HP Proliant ML 370 G5 Server, HP Compaq DC Series Workstations.

Operating System : Windows Server 2000, 2003, 2008, 2008 R2, 2012 R2, 2016, Linux, AIX.

Monitoring Tool : HP BSM, OBM and SCOM.

SQL Databases : SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012,SQL Server 2014, SQL Server 2016, SQL Server 2017. Oracle Databases : Oracle 8i, 9i, 10g, 11g and 12c. Sathiyaseelan Malesan - SQL DBA

PROFESSIONAL EXPERIENCE

PRESENT PROJECT:

Company Name : ADCB, Abu Dhabi, UAE.

Designation : Senior Associate DBA.

Duration : May 2018 to till present.

Configuring and monitoring the High Availability features like SQL Clustering, Log Shipping, Mirroring, Replication and Always ON.

Implemented Always-ON (AAG) on SQL Server 2016 and 2017.

Works closely with software developers performing platform selections, database design, database architecture, SQL programming, consultation and technical guidance.

In-place upgrades and migrations from SQL 2005/2008 to SQL 2012/2016/2017.

Writing reliable and efficient code, queries, stored procedures, cursors, triggers and scripting on all platforms.

Recommends hardware configurations as they pertain to database performance and high availability.

Creates and maintains backup and recovery plans and high availability planning.

Supporting most critical Core Banking Databases.

Handling 14 TB of highly critical database.

Provides daily operational activities such as backups/restores, application connectivity troubleshooting and log monitoring.

Evaluate new features related to current and next available SQL Server versions.

Assist application team during stress tests and deployments to resolve deadlocks and performance glitch.

Applying Security updates and SQL Server Service Packs for SQL Cluster and Always ON.

Works with other Technology Team members i.e., Product Networking and Tech Support for any application development, network plans and trouble- shooting.

Participates in the On-Call production support on rotation basis.

Creating SOP and SMTD documents for the stability of the environment.

implementations and changes on the database servers.

Performing BCP activity on yearly once and DR activity on quarterly basis.

Ability to interpret and convey complex, difficult, or sensitive information.

Providing direction and mentor less experienced teammates.

Experience in Oracle User Creation Management..

Experience in Oracle Tablespace Creation Management.

Restoration using RMAN Backup in Oracle.

Monitoring DB using HP BSM tool.

Hands of experience in MySQL Databases.

Demonstrated initiative and the ability to implement change effectively and use of a corporate work ticketing system (e.g. BMC Remedy).

Doing Maintenance activities for critical databases on monthly basis. Sathiyaseelan Malesan - SQL DBA

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Managing close to 300 servers. Built cluster servers on SQL 2016 Policy based management

Security and vulnerability analysis of SQL Databases.

Database Assessment is being done for analysis of database configuration, patch status, and security settings.

Practices Operational Policy Enforcement.

Integration with existing reporting, work flow, and trouble-ticketing systems.

Centralized policy management so that a single policy can be applied across multiple servers.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

PCI DSS audits for SQL Servers on quarterly basis. PREVIOUS PROJECT - 2.1

Company Name : Wipro Limited, Chennai, India.

Designation : SQL DBA.

Project : TUI Airways, UK.

Duration : August 2016 to April 2018.

High availability SQL Server solutions including Log Shipping, Replication, Mirroring and SQL Server clustering

Experience in installing, configuring and upgrading SQL Server as well as supporting and troubleshooting applications deployed on that platform.

Monitoring the system availability and updating system documentation.

Performs SQL Server service pack upgrades on quarterly basis.

Database Mail is configured to send the mail from SQL Server to different recipients.

Created the customized database roles.

Ability to create, implement and review complex database structures.

Managed medium sized production database systems across multiple data centers - including MS SQL Servers 2012/2016 on Windows 2012/2016.

Solid understanding of database design and the relational model.

Strong knowledge of TSQL stored procedures, complex queries and indexing.

Experience with server-client computing and relational database environments PREVIOUS PROJECT - 2

Company Name :US Tech Solutions, Chennai, India.

Client : Wipro Limited.

Project : TUI Airways, UK.

Designation : Senior SQL DBA.

Duration : February 2016 to August 2016.

.

Sathiyaseelan Malesan - SQL DBA

Monitoring the system availability and updating system documentation.

Installed and configured SSIS and SSAS.

Migrated data from Microsoft Access 2000 file to SQL Server 2008 R2.

Worked with Business Analysts and Developers in identifying the requirements, designing and implementing database schema and application.

Created new database and tables using scripts.

Maintained User Databases and System Databases.

Implemented Trigger to maintain data integrity and consistency.

Experience in Oracle User Creation Management..

Experience in Oracle Tablespace Creation Management.

Restoration using RMAN Backup in Oracle.

Provided Security, consistency, efficiency and track state.

Analyzed clustered/non-clustered index allocation and included columns and optimization of query plans.

PREVIOUS PROJECT - 1

Client : Citibank N.A, Bangalore, India.

Designation : SQL DBA.

Project : NSE and BSE, Mumbai.

Duration : June 2013 to September 2015.

Installed SQL Server 2000, 2005 and 2008 R2.

Maintained regular backups and restored databases as needed.

Upgraded databases from SQL Server 2000/2005 to 2008 R2.

Handled SQL Queries like DDL, DML and DCL commands.

DR drill conducted on quarterly basis.

Configured Transaction Log Shipping in SQL Server 2005.

Configured Database Mirroring with synchronous mode.

Created maintenance plan in SQL Server 2008 R2.

Created Clustered and Non-Clustered Indexes.

Rebuild and Reorganize the indexes at regular intervals for better performance.

Created and scheduled jobs using SQL Server Agent.

Responsibilities included recovery, import/export and scheduling of tasks and monitoring their status.

Monitored the performance of the database using SQL Server Profiler and Execution plans.

Expertise in handling DBCC Commands.

GRADUATION

I had completed B.Tech Information Technology in Vel Multi Tech Dr.Rangarajan Dr.Sakunthala Engineering College at Chennai (India) in the year 2012. DECLARATION

I am hereby acknowledging that the details furnished by me are genuine to the best of my knowledge.

Place: Abu Dhabi, UAE.

Date:

Contact this candidate