Software Engineer Security

Litha Kaladharan Pillai Cell: +1-515-***-****

Email: *****.*@*****.***

Career Objective:

To achieve a challenging position as an MS SQL Server Database Administrator in a result-oriented company, where my acquired skills and education will be utilized towards continued growth and advancement.

Experience Summary:

Working as Systems Analyst for “UST Global” (US) since Apr 2018 - Present

Worked as Systems Analyst for “UST Global” (India) since Dec 2014 to Jan 2018.

Worked as a Senior Software Engineer for “Bank of America Solutions India pvt Ltd.” from July 2010 to Dec 2014.

Worked as an Associate Consultant for “Citagus Software Pvt Ltd “, Bangalore from Oct 2007 to Jun 2009.

Roles and Responsibilities:

Maintained over 2000 production MS SQL Server 2000/2005/2008/2012/2014 and SQL Cluster Servers in worldwide with 24x7

Improved and maintained the high availability of 24x7 production servers with disaster recovery management which includes Database Snapshots, Backups, Standby servers (Log shipping), Replication and clustering.

Good experience on Setting up and Troubleshooting of Log shipping, DB mirroring and Replication for MS SQL Server 2005/2008/2012/2014

Installing and Configuring SQL Litespeed, a third-party tool for SQL server backup and recovery.

Creating and monitoring jobs for automating daily tasks like backups, checking database integrity and consistency, rebuilding index, updating statistics

Supporting major customers from USA, EMEA and SINGAPORE

Handling user requests like point in time restores, Database restore requests from tape Backups.

Creation and Maintenance of Databases, Assigning Roles and managing user permissions.

Maintaining SLA and implementing Production changes and attending change management calls and Problem management calls.

Involved in SQL Server build on Microsoft Azure VM.

Sound knowledge on building and administering MSSQL databases on AWS RDS & EC2 instances.

Backup & Restore from S3 bucket using cloud berry.

Cloudwatch monitoring and performance tuning.

Tools:

MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016

Microsoft Azure VM

Litespeed for SQL Server

Foglight monitoring tool

Solarwind for SQL

Precise

IPCenter, IBM Maximo

AWS: RDS, EC2, cloud monitoring, cloud berry

Educational Qualifications:

Master of Technology in Computer Science from Dr.MGR Educational and Research Institute, Chennai and scored 84.7 % (2005-2007)

Bachelor of Engineering in Information Technology from Avinashilingam Institute for Home Science and Higher Education for Women (Faculty of Engineering) Deemed University, Coimbatore and scored 79.54% (2000-2004)

Pre-Degree from St.Stephen’s College, Pathanapuram and scored 77% (1998-2000)

I.C.S.E from St.Mary’s Residential School, Pathanapuram and scored 73% (1998)

Certifications:

MCP Certified: 70-462 (MC ID: 11192395)

Project Details:

Project #1:

Client : McKesson

Role : Systems Analyst

Team Size : 5

Duration : Apr 2018 - Present

Environment : MS SQL Server 2008/2008R2/2012/2014/2016

Responsibilities:

Works with system architects and application team on migration/upgrades

Troubleshooting performance issues

Implementing high availability strategies and backup strategies

Database performance/activity monitoring and maintaining security on databases access

Working on Datamining as part of the Monthly Data refresh for various clients on Risk Manager Tool.

Project #2:

Client : DANA

Role : Systems Analyst (SQL DBA)

Team Size : 8.

Duration : Dec 2014 to Jan 2018.

Environment : Windows 2003, MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016

Responsibilities:

Escalation DBA and primary point of contact for 150 plus SQL instances

Working with system architects and application team on migration/upgrades

Coordinating the day to day activities with offshore team

Troubleshooting performance issues

Understanding business criticality and defining the high availability strategies

Planning and implementing backup strategies considering the Recovery Point Objective

Database performance/activity monitoring using SQL native tools, Hobbit, SolarWind monitoring tools

Representing DBA team in DR activities

Monitoring and maintaining security on databases access and database objects

Deploy massive SQL Server queries or changes

Configuring and troubleshooting Transactional Replication and Log Shipping

Troubleshooting SSIS and SSRS issues

Experienced in Point-In time Recovery

Planning Database Maintenances

Involved in SQL Server build on Microsoft Azure VM.

Project #3: GMRT

Client : Bank of America & Merrill Lynch (Global)

Role : Sr. Software Engineer (SQL DBA)

Team Size : 20.

Duration : July 2010 to December 2014.

Environment : Windows 2003, MS SQL Server 2000/2005/2008/2008R2/2012 SQL Litespeed

Responsibilities:

Installation and Configuration of MS SQL 2000 /2005/2008/2008R2/2012.

SQL Server Patching, Upgrades and Database migration

Installing and Configuring SQL Litespeed, a third-party tool for SQL server backup and recovery.

Supporting major customers from USA, EMEA and SINGAPORE, Brazil, Mexico.

Monitoring Production server with Foglight tool along with Maximo and IPCenter ticketing tools.

Troubleshooting Log shipping, Database Mirroring, Replication, SQL clustering issues.

Handling user requests like point in time restores, Database restore requests from tape Backups

Monitoring Backup jobs and DBCC jobs using Autosys tool.

Doing regular server health checks before starting the business hours.

Server maintenance on Weekends like rebuild indexes and updates statistics to improve the Performance.

Maintaining SLA and implementing Production changes and attending change management calls and Problem management calls.

Involved in disaster recovery tests for production servers.

On call support (16 * 7)

Security Implementation: Administering MSSQL Server by creating user logins with appropriate roles, dropping unwanted logins/roles.

Project #4: L3 Operations

Client : Bank of America & Merrill Lynch (Global)

Role : Sr. Software Engineer (SQL DBA)

Team Size : 24.

Duration : July 2010 to December 2014.

Environment : Windows 2003, MS SQL Server 2000/2005/2008, SQL Litespeed

Description: The L3 Database team provides Level 3 database support to production environments in USA. The Database group is chartered with the role of providing on call support for MSSQL, Oracle & Sybase database management systems (DBMS). This project is into providing L3 on call Sql server production support for 1000 plus production servers.

Responsibilities:

Monitor and troubleshooting SQL Jobs.

Worked on the space requirement of data, checking the data & log file growth.

Monitor and managing event viewer.

Documentation of day to day problems and solutions.

Working on the alerts generated from various production servers. The basic alerts would be Disk capacity Full, Log Full, Blocking, Deadlock, Server Down, Database suspect, SQL job failures, Logshipping out of sync, Memory Alerts Etc.

Monitor and troubleshoot SQL Performance using Perfmon, Profiler, and system tables

Monitor, analyze and troubleshoot SQL server concurrency issues like blocking and deadlocks using system tables and DMVs. Provide feedback on code improvements to app teams whereever applicable.

Design and Troubleshoot SQL Server high availability using Log Shipping, Database Mirroring, Replication and Clusters.

Keep the knowledge base updated with new troubleshooting information and procedures

Security Implementation: Administering MSSQL Server by creating user logins with appropriate roles, dropping unwanted logins/roles.

Deliver knowledge sharing sessions and Triages across teams.

Project #5: Order Fulfillment Renovation System.

Client : Skillsoft

Role : Associate Technical Consultant.

Team Size : 5

Duration : Apr 2008 to Jun 2009.

Environment : Windows 2003, MS SQL Server 2000/2005.

Description: The project is mainly specified for the renovation of existing projects like Quick Contract Creation (QCC) project etc for the company Skillsoft. It is a multi-phased project.

Responsibilities:

Database Administration

Installing and Configuring of MS SQL 2000 /2005.

Installing Service Packs & Hot fixes

System Performance monitoring and tuning.

Server maintenance on Weekends like rebuild indexes and updates statistics to improve the Performance.

Disaster Recovery Management

Database Backup & restoration and automating them.

Used SQL LiteSpeed for taking backups and restores

Managing security

Creating Server and Database users and assigning permissions.

Maintaining Database security and auditing.

Project #6: HCM

Client : Canara Bank

Role : Associate Technical Consultant.

Team Size : 5

Duration : Oct 2007 to March 2008.

Environment : Windows 2003, MS SQL Server 2000/2005.

Description: The project has been implemented for India’s one of the biggest public sector bank. Bank has 45000 employees working in its various branches (4000), regional offices (71) and Circle Offices (26) in. The Bank provides a wide array of alternative delivery channels that include over 1900 ATMs- covering 680 centers, 1157 branches providing Internet and Mobile Banking (IMB) services and 1833 branches offering 'Anywhere Banking' services. Under advanced payment and settlement system, 1693 branches of the Bank offer Real Time Gross Settlement (RTGS) and National Electronic Funds Transfer (NEFT).

Responsibilities:

Database Administration

Installing and Configuring of MS SQL 2000 /2005.

Installing Service Packs & Hot fixes

Installing MS SQL 2005 Reporting services.

System Performance monitoring and tuning.

Performing database maintenance tasks like DBCC.

Data Migration and conversion using Data Transformation Services and BCP.

Contact this candidate