Krishan Fernando

Professionally Certified Database Administrator specializing in performance tuning to provide the high efficiency and cost reductions to the organizations. Carries over 20 years of experience in Information Technology sector including 17+ years’ experience as a database administrator. Worked on concurrent projects and successfully delivered according to the schedule and budget with minimum resources. Proven track record of Incident resolutions within SLA to meet all critical benchmarks.
Performance Tuning: Consistently tuned complex production databases to the optimal performance for different application domains and able to obtain more than 30% overall performance improvements.
High availability & Disaster Recovery: Designed, developed and managed high availability solutions for the different projects to overcome the unplanned outages and to ensure database integrity using Always-On, Windows Failover cluster, Oracle RAC, Data guard and VERITAS.
Project & Vendor Management: Proven record of successfully leading and on time delivery all phases of IT projects, effectively communicating with the respective teams & vendors, aligning business goals with technology solutions to produce high-quality deliverables that meet or exceed the expectation.
 

Crédit Agricole Corporation (Singapore) – August 2021 – Present
Crédit Agricole CIB is the corporate and investment banking arm of Crédit Agricole Group, it offers clients a range of products and services in capital markets activities, investment banking, structured finance, commercial banking and international trade. 
Lead Database Administrator
⦁ Provided Level 3/Level 2 database administration support for over 2,000 SQL Server instances globally.
⦁ Led the successful migration of more than 300 obsolete database instances to SQL Server 2019/2022 as the DBA Lead.
⦁ Implemented a standardized DBA Operation model across database instances in Italy, Germany, Nordex, and Spain.
⦁ Served as the London Platform Owner, effectively managing all UK SQL Server database instances while driving continuous improvements.

Mitsubishi UFJ Financial Group (Singapore) – September 2019 – August 2021
Mitsubishi UFJ Financial Group is a leading global financial services group and one of the largest banking institutions in Japan. It is the world’s second largest bank holding company and the fifth largest bank by total assets. 
Senior Database Administrator
⦁ Managed over 200 SQL Server databases for the Asian Systems Office, covering Singapore, India, Australia, Philippines, Vietnam, and Taipei, ensuring 24/7 database administration support for critical production environments.
⦁ Successfully migrated medium to large-scale "end-of-life" production databases to SQL Server 2019 Always On clusters, achieving this with minimal incidents.
⦁ Automated the patch upgrade process using PowerShell, enhancing accuracy and reducing manual effort.
⦁ Proposed and implemented a standardized "Always On" deployment model for SQL Server database infrastructure, improving operational efficiency.

UniCredit Bank (Singapore) – April 2018 – August 2019
UniCredit is an Italian global banking and financial services company. Its network spans 50 markets in 17 countries, with more than 8,500 branches and over 147,000 employees.
Database Administrator
⦁ Designed and implemented a SWIFT message analysis application utilizing SSIS, Java, SQL Server, and VB scripting.
⦁ Conducted housekeeping activities to reclaim wasted capacity, resulting in significant data storage cost savings for the organization.
⦁ Developed and implemented high availability and disaster recovery solutions for MS SQL and Oracle databases across the Asia Pacific region.
⦁ Fine-tuned Oracle and SQL Server production databases, achieving over 30% performance improvement.

Intel Corporation (Singapore) –Permanent | November 2015 – April 2018 
Intel Corporation is an American multinational corporation and technology company. It is the world largest and highest valued semiconductor chip makers based on revenue. 
Data Analyst (Senior Database Administrator):
⦁ Served as the CHD IT Database Services owner, managing the database infrastructure (Oracle, MSSQL, MySQL) with 100% availability and no major incidents since 2015. Provided technical recommendations and guidance to first - and second-level support database administrators.
⦁ As a member of the Global Database team, facilitated 24/7 production coverage for over 1,000 SQL Server instances, 50+ Oracle instances, and 500+ MySQL instances. Responsibilities included installation, configuration, backup and recovery, database security, data transformation services, query optimization, and patch upgrades.
⦁ Implemented a standardized backup solution for all databases globally, ensuring a consistent backup environment and mitigating potential disaster risks due to lack of backup.
⦁ Led the database migration project (Oracle, MS SQL, MySQL) from Lantiq to Intel domain, maintaining strong follow-up and reporting processes to ensure smooth execution and high-quality deliverables
⦁ Administered and managed storage devices across the Asia Pacific region (NetApp, Dell EMC, HP 3PAR) with a focus on high efficiency and continuous improvement.
⦁ Successfully completed NetApp 7Mode to C-Mode and Dell EMC to HP 3PAR data migration projects for Singapore, Bangalore, Korea, and Taiwan without major incidents or unplanned outages, ahead of SLA timelines.

Lantiq Asia Pacific Pte. Ltd (Singapore) –Permanent | June 2013 – November 2015
Lantiq was a fabless semiconductor company based in Germany and it has been acquired by Intel since February 2015. 
Senior Database Administrator:
⦁ Service owner of the IT database infrastructure (Oracle 11G/ 10G, MS SQL Server, MYSQL) globally, provided 24*7 database administration coverage to the mission critical production databases with continues improvements and ensured the issue been fixed within SLA and budget. 
⦁ Managed and conducted housekeeping activities to reclaim over 200TB wasted capacity, which helped company to save data storage costs.
⦁ Developed and implemented a comprehensive Disaster Recovery process for Oracle Databases to minimize the associate risks using Oracle RAC and Data Guard.
⦁ Developed and coordinated the implementation of configuration management database (CMDB) globally to having a single “source of record” for organization’s IT infrastructure. Used Power shell, java and TSQL for the implementation.
⦁ Managed company Asset Inventory with 99% accuracy.

Virtusa Corporation (Colombo, Sri Lanka / Chennai, India) – January 2005 – June 2013
Virtusa is a one of the leading worldwide provider of information technology (IT) consulting and outsourcing services.
Senior Consultant (Senior Database Administrator):
⦁ Served as Senior Database administrator (MSSQL Server, Oracle, DB2, MYSQL, and Sybase) or technical lead in the conclusion of 8 medium to large-scale Organizations including British Telecom, ClearWire, ICTA and IBM. 
⦁ Administrated and subsequently tuned the databases for different projects. ClearWire OLAP application performance improved over 80% and British Telecom production database improved over 30% after the tuning. 
⦁ Managed datacenters (IBM/ICTA) comprising more than 100 UNIX/Windows-based mid-range servers running on over eight operating systems and twelve different DBMSs, maintaining operational continuity without major infrastructure incidents.
⦁ Led the design and implementation of ETL processes for ClearWire, extracting data from various legacy systems (Sybase IQ, Unidata), integrating and cleansing data, and loading it into the Oracle database. Guided the PL/SQL team in developing optimal queries for enhanced performance.
Asia Pac Sri Lanka (Pvt) Ltd (Colombo) –Database Administrator | April 2003 – November 2004
 

⦁ Masters of Science in Management, University College Dublin Year 2018 September
⦁ Professional Graduate diploma, from British Computer Society (BCS) Year 2005 April. (Equivalent to UK University Honors degree in IT)