Asela Nanayakkara Email & Phone Number

Vancouver, British Columbia, Canada

• Design and Architect Scalable Solutions: Lead the design and architecture of end-to-end solutions across cloud and on-premises environments, leveraging technologies such MS SQL, Couchbase, Azure SQL, Cosmos DB, Oracle.
• Stakeholder Collaboration: Act as a liaison between technical and non-technical teams, including data analytics and engineering teams, to align data infrastructure solutions with organizational goals and support.
• Cloud Migration Strategy and Optimization: Develop and implement comprehensive migration strategies for SQL and Oracle databases to Azure cloud environments, optimizing data processing and analytics performance.
• Project Management and Scope Definition: Work closely with stakeholders to define project scope, objectives, and deliverables. Develop detailed timelines, migration strategies, and roadmaps to ensure alignment with.
• Data Integration and Replication Architecture: Design robust, scalable, and high-performance data integration solutions using Qlik replication and other technologies, ensuring seamless replication from on-premises.
• Solution Reliability and Scalability: Architect and oversee the implementation of highly available, reliable, and scalable data replication and migration solutions, with a focus on both cloud and hybrid environments.

Remote

• Lead and Inspire High-Performing Teams: Provide strategic guidance and leadership to a skilled, motivated team of professionals, fostering a collaborative environment to achieve business objectives.
• Architect and Design Data Solutions: Spearhead the design, planning, and implementation of scalable and efficient relational database architectures, ensuring alignment with both functional and non-functional business.
• Data Pipeline Optimization and Automation: Identify and implement process improvements, including automating workflows, enhancing data delivery, and redesigning infrastructure to meet high-performance and scalability.
• Expertise in SQL and Data Querying: Apply advanced SQL skills and extensive knowledge of relational databases, leveraging diverse database platforms to support comprehensive data access and manipulation.
• Root Cause Analysis and Data Insights: Conduct root cause analyses on both internal and external datasets, driving insights that inform strategic decisions and uncover optimization opportunities.
• Advanced Data Engineering with Unstructured Datasets: Utilize strong analytical skills to design solutions for complex, unstructured data, integrating data architecture that meets diverse business needs.

Dubai, United Arab Emirates

• Senior Engineer responsible for implementing and integrating stock market Order Management Software for two premier stock brokerage firms in Dubai, U.A.E.
• System Planning, Implementation, and Integration: Spearheaded the planning, implementation, and integration of Order Management Systems with regional stock exchanges, including the Dubai Financial Market and Abu Dhabi.
• Database and Application Deployment: Deployed and configured database solutions, and managed JBoss applications within Linux environments, ensuring seamless operation and optimal performance.
• FIX Protocol Configuration and Testing: Conducted extensive FIX protocol testing and configuration in alignment with requirements of stock exchanges, ensuring regulatory compliance and system accuracy.
• Database Quality Assurance: Performed comprehensive testing of database systems, identified and addressed defects, and implemented upgrades in adherence to industry-standard technical procedures.
• Software Installation and Troubleshooting: Installed and troubleshot in-house developed software products, ensuring reliable system functionality.

Sri Lanka

• Oracle Database Systems Architecture and Implementation: Planned, designed, and implemented robust Oracle Database Management Systems to support critical business applications and ensure optimal performance.
• Oracle 11g R2 RAC and Grid Infrastructure: Led the design and deployment of Oracle 11g R2 environments, including 3-node Real Application Clusters (RAC) and Grid Infrastructure, ensuring high availability and.
• Database Optimization and Enhancement: Enhanced the functionality and resilience of Oracle database structures, including tables, procedures, and packages, through meticulous design, performance evaluation, testing.
• Technical Documentation Development: Authored comprehensive technical documentation, including guidelines, policies, and procedures, to support consistent database management practices and adherence to industry.

Sri Lanka & United Arab Emirates

• Oracle Database Design and Optimization: Designed, reviewed, and modified Oracle database structures, including data schemas, tables, procedures, and packages, to ensure peak performance, robust functionality, and.
• Installation and Maintenance of Database Environments: Installed and maintained Oracle and MS SQL database environments, supporting both stability and scalability.
• Database Governance and Documentation: Established and managed comprehensive guidelines, policies, procedures, and processes to uphold database integrity and standardize practices.
• IBM WebSphere and MQ Deployment: Configured, deployed, and troubleshot IBM WebSphere and IBM MQ environments, optimizing system integration and functionality.
• FIX Protocol Configuration and Prototyping: Led FIX protocol prototyping and configuration adjustments to comply with stock exchange regulations and ensure regulatory alignment.

Sri Lanka

Bachelor Of Science, Computing & Information Systems

Master Of Business Administration - Mba, Business Administration And Management, General

Financial Analysis and Management Managing Human Capital Marketing Management Management Skills and Entrepreneurship Strategic Management.

Master In Big Data Analytics, Data Science

Advanced Databases Big Data Programming Cloud Computing Data Analysis Data Mining Data Warehousing Research Methods Text Analytics