South Asia Gateway Terminals (SAGT), the first public private partnership container terminal in Sri Lanka, commenced operations in 1999, launching the Port of Colombo as global trade’s pre-eminent gateway hub to South Asia. Today, the terminal is one of the three operators in the Port of Colombo and continues to offer global container shipping lines and related stakeholders a competitive service as a world class container terminal in the Port of Colombo.
The company is a Board of Investment flagship entity with a majority Sri Lankan shareholding, and is backed by John Keells Holdings, A. P. Moller Maersk Group of Denmark, Sri Lanka Ports Authority and Evergreen Marine of Taiwan.
If the prospect of working in an extremely dynamic, global industry at a Company that is a global leader in its class and located in South Asia’s largest hub-port excites you, we would be delighted to receive your application for the following position
Job Profile:
The Systems Engineer requires a high degree of specialized expertise and skill in maintaining established standards of quality and accuracy to provide a specialized technical problem solving and ingenuity while working within approved organizational systems and technology.
Main Responsibilities of the job:
Develop, maintain, and optimize reports using SQL Server Reporting Services (SSRS).
Design and create interactive dashboards and reports in Power BI based on business requirements.
Integrate data from multiple sources, ensuring data consistency, accuracy, and integrity across all systems.
Manage, configure and maintenance of company databases, ensuring performance, integrity and security, following best practices and adhering to the standards.
24*7 support of database and related mission-critical application environments, both on-premises and the Cloud.
Manage SQL Server/ Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end including Microsoft SQL backup and recovery strategies while maintaining high availability solutions including replication and clustering.
Communicate, coordinate with IT and business teams to successfully resolve support and maintenance issues related to database, reports and related applications.
Share technical expertise, achieve and maintain the defined ICT service levels and provide backup technical support for all ICT systems and Infrastructure deployed in the company.
Candidate’s Profile:
The ideal Candidate should have:
The ideal candidate should be a technical specialist who is able to work within a structured environment while ensuring that the work is accomplished quickly and efficiently with a high degree of quality and detail.
Have a degree from a recognized university in Computer Science or equivalent qualifications.
Having Microsoft SQL related certification or advanced SQL training from recognized institution will be an added advantage.
5+ years hands-on experience in any combination of database technologies such as Microsoft SQL, Oracle, MySQL, including database engine, integration services, reporting services and analysis services.
Hands on experience in SQL Server Installation, configuration and maintain high availability and disaster recovery solutions including Microsoft SQL clustering, always-on, mirroring and replication.
Good understanding of report development, query optimization, architecture and data management are essential. Hands on experience is needed in a reputed data visualization tool.
Have knowledge in parts and shipping business process would be an added advantage.
(Send in your updated CV to HR department on or before 26th of October 2024.)