Database and Programming Analyst

Responsible for the definition, management and support of
the database environments associated with the Production project implementation
under general supervision of the technical lead. Is able to implement and
maintain project data model including managing the performance, integrity and
security of databases. Capable of making effective and efficient decisions
regarding database models and infrastructure. Skills are typically acquired
through 5+ years of experience implementing and managing databases.

Job Role

• Develops and maintains project data model.
  
• Develops and maintains DB connections to Landmark
  infrastructure including DB administration
  
• Manages and supports databases including developing required
  queries and stored procedures
  
• Establishes the needs of users and monitoring user access
  and security
  
• Assists team with the debugging and optimization of SQL
  queries and stored procedures.
  
• Ongoing database performance tuning and upgrades, including:
  monitoring and evaluation of all database patches and service packs
  
• Designs and manages database import / export processes used
  to populate test databases and global data marts. Builds automated build
  scripts
  
• Develops and maintains ETL/programs to transform multiple
  data sources (Structured/unstructured data, OPC/PI real time data) to project
  database
  

Education Licensure and Experience

• Completion of an undergraduate degree in Computer Science,
  Computer Engineering or MIS
  
• Certification in related tool e.g. SQL, .NET, Oracle is
  desirable.
  

Role Specific Knowledge

• 5+ years of experience implementing and managing databases;
  excellent team working capabilities; Oil and gas domain experience is
  desirable.
  

Skills

Technology

• Understanding of relational databases and concepts
  
• Experience with TSQL and PL/SQL
  
• Good working with SQL server/Oracle/Postgres
  
• Proven experience with system analysis and database design
  
• Proven experience with ETL
  
• Experience with backup/recovery and DBA
  
• Good understanding of data security
  
• Experience working in VDB design and implementation
  
• Experience with .NET and any programming language is
  desirable.
  
• Experience working in big data is desirable
  
• Data science knowledge is desirable
  
• Domain (proficient in at least one of the 2 domain areas
  below)
  
• Experience working as oil and gas domain
  
• Landmark Business Domain Production
  

General

• Good communication in English
  
• Good problem-solving skills
  
• Flexible to travel
  

Company Industry

• Oil & Gas

Department / Functional Area

• IT Software

Keywords

• Database And Programming Analyst