Database Administrator / Software Engineer

Overall Job Purpose

System Administration, Database Administration, Server Administration for MODEC Asset Integrity Management System (AIMS). System is currently coded in .Net stored in oracle database and will move to MS Azure Cloud in 2023.

• 5% Prepare daily AIMS Database Backups
• 5% Perform daily AIMS Database server maintenance to prevent database crash, maintain database high performance, reliability, availability
• 5% Perform daily AIMS Application server maintenance for better performance, connectivity
• 30% Data management of bi-weekly inspection uploads provided by vendors for MODEC FPSO's
• Review the vendor submitted inspection upload sheet data, documents submitted for upload to AIMS database
• Data cleanse, prepare vendor submitted inspection upload sheet data to meet the AIMS Tables specification and maintain the data relations within AIMS database
• Upload the inspection data into AIMS Database
• Upload the vendor submitted inspection documents into AIMS database
• 20% Perform AIMS Workpacks creation, extract from AIMS the past Inspection data, documents to share inspection vendor to execute the workpacks in offshore
• 20% Perform data (or) documents extraction from AIMS for adhoc requests related to compliance to Client (for invoice clearance during end of each quarter) third party review/analysis (ABS Survey, Integrity Review)

15% Support DnA Team who will undertake project for relocate of AIMS to MS Azure. Once system is relocated then this position would undertake same role in MS Azure cloud.

• Stakeholder Management for MODEC Asset Integrity Management System gather functional requirements from end users and propose cost time resource estimate (CTR) for AIMS enhancements.
• engage with end users to propose solution to AIMS enhancements, interfacing between systems
• follow up with end users for the CTR proposals, timelines for CTR executions, clarify dependencies in delivering the CTR deliverables
• prepare user guides which enables end users to engage with AIMS systems
  Troubleshoot, resolve IT issues encountered by end users with regards to AIMS application

System Implementation, System Support for MODEC Asset Integrity Management System design and implement enhancements in AIMS application based on agreed, approved CTR's

• Perform testing of functional requirements, deploy latest enhancements into AIMS server for User Review (or) Acceptance, GO Live
• Resolve issues reported by end user in AIMS and re-deploy changes into AIMS server for User Review (or) Acceptance, and access resolved items from Live/Production instance
• Refine code changes to accommodate broad set of data, documents: captured, submitted by vendors as part of inspection campaign
• Develop interfaces which enables systems to communicate(or)report data, apply business logics based on exchanged data, and maintain autonomous communication between system for the data exchange

Tertiary IT Ecosystem support

• MMS Contracts Management system - understand the existing system rolled out by IT Team, provide available enhancements, support to end users

Core Responsibilities

1. System Administration, Database Administration, Server Administration for MODEC Asset Integrity Management System.
   Stakeholder Management for MODEC Asset Integrity Management System
   System Implementation, System Support for MODEC Asset Integrity Management System
   Tertiary IT Ecosystem support
2. Train end users (onshore office personnel required by the MODEC personnel or the client) to ensure they understand all process and procedural changes with appropriate training materials and deliver the training.
3. Identify improvements to existing MODEC standard systems at Operational Business Unit Level and submit the proposed improvement to the team in MMS Singapore.
   Manage requirements change (Bugs in Softwares) and involve stakeholders(onshore office personnel) in all change decisions.
   Review the solution design to ensure all of the requirements are fulfilled and looking for opportunities to meet additional business needs without increasing the technical scope of the project.
4. Maintenance and development of a network of industry and professional contacts to ensure that MODEC is aware of current technology and management practices and is able to make use of this where appropriate.
5. Ensure the MODEC Asset Integrity Management System database reflects the corrosion management plan.
   Ensure correct linkage between SAP CMMS and AIMS database. Resolve work order queries with onshore teams to ensure both CMMS and AIMS have the same status.

Educational Qualification:

Engineering, Technology, Management

Certification(s):

• Oracle 11G: 5+ years of :
  (a) Database Administration, Database Installations and Support, Implementing Client Server Setup
  (b) Creating Database Model Design, Solutioning to Database business project requirements
  (c) PL/SQL, Apps and Reports Development, T-SQL Queries
• Micrsoft SQL Server 2015: 5+ Years of:
  (a) Designing Business Intelligence Solutions with Microsoft SQL Server
  (b) Administering Microsoft SQL Server 2012/2014 Databases
  (c) SQL Server Integration Services, Reporting Services, Analytical Services
• Micrsoft .Net Framework, COM + Services :7+ Years of
  .Net (ASP, C Sharp, C++, VB) Web Development, Mobile Development(Windows CE, iOS),
  Device Driver (32 Bit, 64 Bit), Biztalk Integration with MS SQL Server
  (a) Programming in HTML5 with JavaScript and CSS3
  (b) Programming in C# 6.0, WCF Services, Web API's, WPF 4.0
  (c) Developing ASP.NET MVC Web Applications

COM + Services Advanced Programming, Mobile Application Development

• BootStrap, JQuery, Angular JS, Cascading Stylesheet 3, Telerick, Java
• Excel VBA, Access VBA, SHarepoint Excel Services
• MS Azure Cloud - 3+ Years of experience

Relevant Experience:
Database Administration, System Development, Agile Management, Server Administration, System Migration/Integration, Transformation projects, relocating of systems from physical to cloud server, MS Azure experience.

Language(s) and Software:

• Microsoft Visio 2010, Microsoft Project 2010, Microsoft Excel 2010
• Microsoft Visual Studio 2015, Oracle 11g Database Client - Server Administratio
• Innovator Business Analyst Enterprise, Microsoft SQL Server Business Intelligence
• Power Pivot, Power BI
• SQL Server 2015, SQL Server Integration Services, SQL Server Reporting Services
• Biztalk, RFID CEPAS Programming

Key Behaviors:

• Strong analytical and evaluation capability.
• Excellent people relational skills.
• Excellent communication skills.

• Monthly wage: VND70-80,000,000 (gross)
• 13th month salary for every 12 months of employment
• Monthly mobile phone charge allowance: VND 500,000
• Annual salary review (every July, depending on Group's financial status in theyear).
• Discretionary bonus (every March, depending on Group's financial situation in the year)
• Paid leave: 16 days of annual leave for 1st one year of service and to be increased following number of years of service with company + 14 days of sick leave/year
• Mandatory insurance contribution at max. salary allowed by law.
• Coverage of Medical treatment expenses as per Company's Healthcare plan
• Personal accident & term-life insurance for self and immediate family member (legal spouse/children)
• Premium annual medical check-up program
• Annual safety awards and tradition Vietnamese's Tet gift
• Company's functions: team building trip, year-end party, etc.
• Working equipment: new laptop and software included