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 and Qlik Data Replication.• 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 evolving data infrastructure needs.• 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 business goals.• 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 systems to Azure cloud environments.• 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.• Innovation in Database Migration and Optimization: Provide architectural guidance for migrating Couchbase and other database solutions, including version upgrades and performance optimization for both SQL and NoSQL databases.• Continuous Deployment and High Availability: Design and implement deployment strategies, ensuring high availability and streamlined, continuous deployment practices for production and pre-production 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 requirements.• 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 demands.• 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.• Cross-Functional Stakeholder Engagement: Partner with executive, product, data, and design teams, translating business needs into technical requirements, while ensuring data solutions meet evolving infrastructure needs.• Dynamic Team Collaboration and Support: Facilitate collaboration across departments in a fast-paced environment, supporting cross-functional teams in delivering impactful data-driven solutions.

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 Stock Exchange.• 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.• Data Backup and Recovery: Executed database backup and recovery processes and conducted regular integrity verifications to ensure data security and consistency.

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 scalability.• Database Optimization and Enhancement: Enhanced the functionality and resilience of Oracle database structures, including tables, procedures, and packages, through meticulous design, performance evaluation, testing, and modification.• Technical Documentation Development: Authored comprehensive technical documentation, including guidelines, policies, and procedures, to support consistent database management practices and adherence to industry standards.

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 secure operations.• 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