Job Listing

JOB DESCRIPTION

Summary

Energy Components Global Solutions is a product suite developed by Our Client for the Oil and Gas industry. It monitors business processes for the production, transport and sales of oil and gas, and facilitates collaboration between license holders in oil fields around the world.

Our Client also offers the Industry standards for oil companies’ operations of personal transport, logistics and safety.

Primary Accountabilities and Deliverables

• Build, operate and support Tieto O&G cloud environments
• Respond to support requests via tickets and collaboration tools within response time SLAs
• Troubleshoot performance degradation or loss of service as time-critical incidents
• Building customer solutions, leveraging automation and delivery mechanisms for efficiency and scalability
• Ownership of issues, including collaboration with other teams and escalations

The effectiveness of the role will be measured in the following areas

• The provision of Cloud Platform and related services in measurement against the agreed SLAs
• The safe and stable integration of new projects into the existing platform.
• Flexible to adopt new technology learning

Essential skills and attributes

Application Management:

• Designing schema, access patterns, locking strategy, SQL development, and tuning.
• Modifying the database structure
• Optimizing application and end-user queries (reactive tuning)
• Archiving data
• Generating needed ad hoc reports by querying from the database
• Proactive performance tuning

Access Management:

• Enrolling users and maintaining system security
• Controlling user access to the database
• Locking down host access
• Securing database privileged credentials (SYSDBA or SYSTEM for Oracle; sa for SQL Server)

Database Management:

• Parameter configuration and tuning
• Cache management
• Job scheduling

Monitoring:

• Monitoring performance metrics, response times, and request rates
• Alerting (AWS-RDS)
• Object access
• Logs

Platform Management:

• Ensuring compliance with database vendor license agreement
• Designing and implementing disaster recovery (DR) solutions
• Allocating system storage and planning future storage requirements for the database system
• Installing, upgrading & managing database application
• Performing data backups
• Creating, managing, and monitoring high-availability (HA) systems
• Patching the software that powers your database
• Troubleshooting DB errors and potentially contacting vendors for technical support
• Create automation for repeating database tasks
• AWS Database Migration Service
• Develop data migration plans to migrate legacy on-premises databases into AWS data stores
• Work on indexing, replicating and performing disaster recovery services across multiple AWS regions
• Writing, designing, testing, implementing and maintaining database applications using SQL or other database programming languages

Ticketing Tool:

• Jira
• Service Now

Additional Tools/ Knowledge:

• Experience with DevOps tools such as Jenkins, Terraform, Kubernetes etc
• Strong command of SQL and SQL server tools
• PowerShell and Unix shell scripting skills
• Familiarity with SSAS, SSIS, SSRS
• Amazon Aurora, AWS DynamoDB (preferred or NoSQL)
• Current hands-on working knowledge of AWS Databases such as RDS, RedShift, Aurora.
• Learns – worked on any/all aspects of AWS Databases and storage patterns to include, Amazon Aurora, Relational Database Service (RDS), Dynamo, Redshift, Neptune, TimeSeries, Elasticache and Document DB

Certification Requirement:

• Oracle DBA certified
• AWS Certified Database – Specialty (DBS-C01)
• ITIL

General Requirements:

• Working in a 24X7 Support Model
• Ready to work in shifts
• On-Call Support

As a person you are:

• Proactive and have a practical approach to implementation for all theoretical Information Security / Quality models. 
• able to challenge pre-set standards across organizations with leadership while collaborating with everyone.
• able to take everyone together to achieve goals.
• Has the same values as Tieto values
• Honest & Ethical.
• Clear in your thoughts and communication.
• Objective in your approach
• Professional attitude at work
• Self-motivated & Self organized person
• Good team player, attention to detail and ability to work well with others
• Having ownership and a sense of responsibility.
• Having a “Customer first” attitude