Candidate Information Title Software Engineer Security Target Location US-OH-Columbus Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Software Engineer Columbus, OH Software Engineer Staff Dublin, OH Security Engineer Dublin, OH Software Engineer Information Systems Columbus, OH Software Engineer Spring Boot Columbus, OH Software Engineer Cloud Service Columbus, OH Senior Software Engineer Columbus, OH

Litha Kaladharan Pillai Cell: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLECareer 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 - PresentWorked 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 24x7Improved 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/2014Installing 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 statisticsSupporting major customers from USA, EMEA and SINGAPOREHandling 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/2016Microsoft Azure VMLitespeed for SQL ServerFoglight monitoring toolSolarwind for SQLPreciseIPCenter, IBM MaximoAWS: RDS, EC2, cloud monitoring, cloud berryEducational 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.Stephens College, Pathanapuram and scored 77% (1998-2000)I.C.S.E from St.Marys Residential School, Pathanapuram and scored 73% (1998)Certifications:MCP Certified: 70-462 (MC ID: 11192395)Project Details:Project #1:Client : McKessonRole : Systems AnalystTeam Size : 5Duration : Apr 2018 - PresentEnvironment : MS SQL Server 2008/2008R2/2012/2014/2016Responsibilities:Works with system architects and application team on migration/upgradesTroubleshooting performance issuesImplementing high availability strategies and backup strategiesDatabase performance/activity monitoring and maintaining security on databases accessWorking on Datamining as part of the Monthly Data refresh for various clients on Risk Manager Tool.Project #2:Client : DANARole : 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/2016Responsibilities:Escalation DBA and primary point of contact for 150 plus SQL instancesWorking with system architects and application team on migration/upgradesCoordinating the day to day activities with offshore teamTroubleshooting performance issuesUnderstanding business criticality and defining the high availability strategiesPlanning and implementing backup strategies considering the Recovery Point ObjectiveDatabase performance/activity monitoring using SQL native tools, Hobbit, SolarWind monitoring toolsRepresenting DBA team in DR activitiesMonitoring and maintaining security on databases access and database objectsDeploy massive SQL Server queries or changesConfiguring and troubleshooting Transactional Replication and Log ShippingTroubleshooting SSIS and SSRS issuesExperienced in Point-In time RecoveryPlanning Database MaintenancesInvolved in SQL Server build on Microsoft Azure VM.Project #3: GMRTClient : 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 LitespeedResponsibilities:Installation and Configuration of MS SQL 2000 /2005/2008/2008R2/2012.SQL Server Patching, Upgrades and Database migrationInstalling 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 BackupsMonitoring 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 OperationsClient : 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 LitespeedDescription: 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 tablesMonitor, 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 proceduresSecurity 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 : SkillsoftRole : Associate Technical Consultant.Team Size : 5Duration : 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 AdministrationInstalling and Configuring of MS SQL 2000 /2005.Installing Service Packs & Hot fixesSystem Performance monitoring and tuning.Server maintenance on Weekends like rebuild indexes and updates statistics to improve the Performance.Disaster Recovery ManagementDatabase Backup & restoration and automating them.Used SQL LiteSpeed for taking backups and restoresManaging securityCreating Server and Database users and assigning permissions.Maintaining Database security and auditing.Project #6: HCMClient : Canara BankRole : Associate Technical Consultant.Team Size : 5Duration : Oct 2007 to March 2008.Environment : Windows 2003, MS SQL Server 2000/2005.Description: The project has been implemented for Indias 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 AdministrationInstalling and Configuring of MS SQL 2000 /2005.Installing Service Packs & Hot fixesInstalling 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.