Upstream
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
- Proven working experience in database optimization
- 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
- Proven hands-on Software Development experience
- Good communication with English
- Good problem-solving skills
- Good documentation skills
- Flexible to travel
Benefit of Working with Visuna?
- A dedicated member of the team responsible for your placements and welfare
- Some of the best day rates in the industry
- FREE worldwide insurance and Medevac cover whist on a Placement
- 24/7 access to our specialist support team
- Assistance and advice on a range of business topics
- FREE access to our Competency Scheme
- Increased exposure to potential clients and more placement opportunities