Allen Lloyd Francis

A LLEN L LOYD F RANCIS 13/7, Vyasar Nagar Colony, 1st Street, Vyasarpadi, Chennai – 600039 Email:--Mobile: -/- | Land Line: - A self-motivated and dynamic IT Professional, with Management qualification and having over 12 years of rich and professional experience, including over 6 months of International (Canada) experience, involved in Core Database Administration of MS SQL Server and now seek challenging opportunities to utilize acquired skills/experiences to drive Database Initiatives for comprehensive growth SQL S ERVER D ATABAS E A DMIN IS TRATO R / S U BJECT M ATTER E XP ERTIS E (SME) PROFILE HIGHLIGHTS Core Skills Database Administrate & Manage Support Services Delivery Project Delivery Coordination Team & People Management Virtualization Management Risk/Resource Management Review of SLA, SOW and SOP Always on High Availability & Clustering Knowledge on MSBI  A decisive and innovative Database Management Professional with a successful track record of Core Database Administration of MS SQL Server along with service support delivery of Oracle and UDB Database, performing the role of both BAU and Projects DBA, involving server installations, configuration, troubleshooting, migrating and upgrade and having experience in SOX Audit & implementation of best practice in Technology and Compliance  Special Mention includes  Last engaged with IBM India (P) Ltd., Chennai as Technical Service Specialist from Jan/2013 To Dec/2016, performing the role of Subject Matter Expert (SME) as Tower Lead and managed multiple databases like MS SQL Server, Oracle and UDB in 24X7 operation with on call support for leading Retail market giant  Extensive experience of Support Services Delivery (BAU) and Projects DBA, along with secure server (web/application/DB) installations, configuration, administration and support, including upgrade (around 40 Instances), right from initial infrastructure planning till delivery  Similar experience of establishing 6 Node Active/Passive clusters, with SQL Cluster Installation; Installation of Load Balancer features & SSRS CA Certificates; Development of Tools & Automation of activities to monitor servers/desktops for performance of CPU and Processor.  Strong analytical skills/experience in transforming of business needs to technical solution  Team Leader: Deft at tasking, delegation, monitoring, feedback of team performance as well as in skills like competence upgrade, conflict resolution, client coordination and mentoring  Team Player: Fast Learning curve along with analytical & problem solving skills at the same time having planning, communication, interpersonal skills and ability to adopt technical challenges/changes CAREER GRAPH IBM INDIA (P) LTD., CHENNAI Technical Service Specialist (Jan 2013 to Dec 2016) Accountabilities:  Last reported to the Technical Service Manager and performed the role of Tower/Technical Lead for 20 resources for various databases like MS SQL Server, Oracle and UDB DB2.  Resolved all Priority & Escalated Tickets and investigation on existing Database SQL 2005 instances/databases and prepared plan for migration to new clustered SQL 2012 environment. Page 1 of 4      Collaborating with the Architects, for projects related estimation on capacity planning/hardware and coordinated licensing for New MS SQL servers. Conducted performance tuning on long running queries & stored procedures as well as established reporting services, configuration and troubleshooting. Installed & supported High availablity & Disaster recovery of database along with design of SAN requirements for overall cluster configuration. Enforced ITIL Change management process for the Team to follow and zeroed many change failures, while conducted SOX audit and achieved issue free sign of from External audit team. Engaged in multiple engagements like SQL 2012 Cluster Installation on 6 node cluster, migration of database & post-migration support and configured Database Mirroring. Achievements:  Resolved an Issue on Database Mirroring Split brain situation in SQL 2008 due to certificates.  Configured Policy Based Management features to get information, if the environment is tweaked and  Supported resolution of many SQL Server Reporting Service issues, though being out-of-role support.  Installed certificates for financial application for added security.  Generated Automated reports pertaining to backup, disk space and critical error log for everyday check that resulted in less manual work.  Setup SQL 2014 Always on Feature on virtual cluster server as this approach is first of kind in IBM GAVS TECHNOLOGIES (P) LTD., CHENNAI Technical Leader (Oct 2010 to Apr 2011) Accountabilities:  Reported to the Technical Manager and led a team of 6 resources for all the MS SQL clients for support, including deployment and managing.  Resolved day to day operational issues as well as conducted performance tuning of long running queries, using Database Tuning advisor tool  Engaged in creating New SOP, SLA, SOW and SQL offerings documents, while mentored juniors and freshers on L1/L2 support issues, as the organization was relatively new in SQL Technologies. Achievements:  Created and build a new performance monitoring tool for monitoring all the servers CPU, Memory Usage, for Operation, Windows and SQL Team. TATA CONSULTANCY SERVICES LTD., CHENNAI Asst. Consultant (Aug 2009 to Apr 2010) Accountabilities:  Reported to the Manager and led a team of 20 resources o technologies like SQL, Oracle and UDB Database for 24X7 production-support services on call.  Supported 800 Instances of primary/secondary MS SQL Servers for Big Retail client, including implementations of database upgrade installation.  Performed as On-site coordinator with the responsibilities of performance & diligence of the entire team and scheduled support activities for database integrity.  Engaged in administered database security, scheduled backup monitoring, trouble shooting software issue and provided database support to other IS Teams.  Established the importance of DR site in case a natural disaster to implement DR sites for the client and conducted monthly drill for Disaster Recovery. Achievements:  Recovered lot of System Database corruption in a reasonable time without affecting the SLA.  Led and delivered a critical project, in absence of delivery manager, from initial knowledge transitions till steady state with 100% accuracy. NUEAGE TECHNOLOGIES CORPORATION, CALGARY, CANADA Resume of Allen Lloyd Francis Update: Jun 2017 Page 2 of 4 SQL Server DBA (Jul 2008 to Jan 2009) Accountabilities:  Reported to the Database Manager as individual contributor for database administration, analyzing existing database configuration, database load & performance to determine improvements in design and/or technology and thereafter provided database software support along with support on other technologies like Oracle, Mainframes and DB2 as Level 1 engineer COGNIZANT TECHNOLOGY SOLUTIONS (P) LTD., CHENNAI Sr. System Analyst (Sep 2006 to Mar 2008 ) Accountabilities:  Reported to the Asst. Manager and led a team of 4 resources, with the responsibilities of Installation, Configuration of SQL server & instances, deployment & trouble shooting of replication, patching of SQL Server Cluster/Standalones and resolution of day to day operational issues PREVIOUS ENGAGEMENTS Organization Satyam Computer Services Ltd., Hyderabad Netaccess India (P) Ltd., Chennai Carborundum Universal Ltd., Chennai Duration Oct 2004 to Sep 2006 Feb 2002 to Oct 2004 Jul 2000 to Jan 2002 Designation Sr. Software Engineer Customer Support Engineer System Management Executive QUALIFICATION Education:  M.B.A. (Systems), from Bharath Institute of Science and Technology, Chennai (2000) with First Class  B. Com., Loyola College, Chennai (1998) with First Class Accreditation  Microsoft Certified Technology Specialist (MCTS - SQL Server 2008)  Microsoft Certified Database Administrator (MCDBA - SQL Server 2000)  Microsoft Certified System Administrator (MCSA - Windows 2000 Server)  ITIL V3 (Foundation) Professional certified in ITSM  French Diploma (DELF A1) Level Certified  IELTS 2015 BAND 7 Certified  Training on SQL2012 Administration and Management with Always on Concepts  Attending Techtalk and webcast pertaining to SQL Architecture Internals  Attended Workshop on Capacity Planning for Windows & SQL clusters for Side by Side Migration Technical Skills  Virtualization: VMWare 8.0, Starwind  Operating System: WIN Server 2012/2008/2008R2/2003/2000, WIN XP/7  Database: MS SQL Server 2000/2005/2008/2008 R2/2012/2014  Backup Tools: SQL LightSpeed, Legatobackup  Ticketing Tools: HP Open View, BMC Remedy PERSONAL PARTICULARS Date of birth: 08-Dec-1977 Languages known: English, Tamil, Hindi and French Location Preference: Dubai/Abu Dhabi/Qatar/Bahrain/Singapore India and Overseas Nationality: Indian Passport Details: J- (valid till 14-Nov-2020) PROJECT DETAILS Resume of Allen Lloyd Francis Update: Jun 2017 Page 3 of 4 Project Client Duration Team Size Environment Details Role Responsibilities Project Client Duration Team Size Environment Details Role Responsibilities Project Organization Duration Team Size Environment Details Role Responsibilities Migration Banking Domain Client, Offshore India 18 Months 3 Windows Server 2012, SQL server 2012 and SQL Server Reporting Services Project for migration of all SQL 2000 and SQL 2005 Servers running with the client, along with application to SQL 2012 or SQL2014 as Microsoft announced Extended End Of Life for the former. Subject Matter Expertise (SME)  Conducted Pre Migration activities like running Best Practice Analyzer/Upgrade Advisor so as to capture road blocks prior to migration  Prior to migration noted the Configuration details & arranged for backups of all 40 Instances  Documentation of step-by-step migration actions  Installation of SQL cluster Instances for 6 Node active/passive cluster.  Performing Post migration Steps for databases and doing sanity check before releasing to stake holders  Converting all Database Mirroring into Always on availablity groups as best practice.  Installation of master key certificates and encryption for added security in Databases Upgrade of MSDN & TechNet Sites Microsoft, Offshore India 18 Months 6 Windows Server 2005, SQL Server 2005 and IIS 6.0 Project to upgrade older version of SQL 2000 along with the legacy application, running in MSDN & TechNet sites to SQL Serve 2005 as per Client decision. Team Member  Tested the application build & patches, by refreshing Dvelopment and UAT environment  Implemented database scripts/patches  Created CA Certificates for added security  IIS Installation & administration for sites Performance Monitoring Tool GAVS Technologies (P) Ltd., Chennai (Internal Product Offshore India) 6 Months 2 SQL Server 2008 and Visual Studio Dot Net Scope of this project was to develop & deploy an in-house tool to properly monitor servers Project Manager  Development of scripts to capture required parameters for dashboard.  Helping the application developer in design of tool.  Building a SQL server to make it as centralized repository for all servers. Resume of Allen Lloyd Francis Update: Jun 2017 Page 4 of 4