Database Administrator - Calgary, Canada - GeoLOGIC Systems Limited

GeoLOGIC Systems Limited
GeoLOGIC Systems Limited
Verified Company
Calgary, Canada

2 weeks ago

Sophia Lee

Posted by:

Sophia Lee

beBee Recruiter


Description

Term:
Permanent Full Time, Hybrid Flexibility


Application:
accepted only through the geoLOGIC Careers Centre


At
geoLOGIC we are passionate about the energy sector's access to premium data and up-to-date information and knowledge - we know it is essential that our customers' are able to maintain their competitive edge.

Our global users are continually provided with industry-leading data, software, analytics, education, news and insights that enable them to make vital decisions.

Our people make us successful.

We're driven by a team of individuals whose unique backgrounds and experience allow us to provide the best products and customer service on the market.

Together we will transform the energy intelligence landscape.


On the Data Services team, you are expected to work with senior developers to assist in projects and be an active participant in their implementation, and transition to taking on more responsibility within projects as time progresses.


The Data Services team is responsible for:

  • Development and maintenance of geoLOGIC's client-facing Oracle Database (geoLOGIC Data Centre
  • gDC) and SQL Server Database
  • Development of our quality assurance system for all our internal data processes
  • Using standard and custom ETL frameworks
  • Oracle, SQL Server, PL/SQL, C# and Python among other technologies
  • Automated processes to consume data from external sources
  • Performing data analysis for other departments and clients as required
  • Feeding data to multiple firstparty commercial software products
  • Consolidation of data processes to gain efficiencies

Relationships:


Reporting to the Data Services Manager, this position involves close connections within a team of diverse talents, ranging from Sr Data Developer to.

NET developers to GIS developers.


How will you spend your day?

  • Assisting in supporting critical projects both in terms of operational and product roadmap requirements
  • Collaborating with team members to provide data solutions which align with our customers' needs
  • Implementing changes in database operations and ensuring data is readily available to endusers
  • Minimizing downtime of databases and ensuring data provided is accurate
  • Managing database access and keeping stored data up to date
  • Providing feedback, and support to the team on the usage of data provided
  • Ensuring that the database is adequately backed up so that vital information can be retrieved in case of accidental loss or security breach
  • Monitoring performance and providing information on ways to improve the authenticity and security of data
  • Maintaining the efficiency of the database by providing regular checks and data updates

Ready to Apply? Here's what we're looking for:

  • A combination of 5+ years' experience in a team environment of
  • Oracle and SQL Server administration
  • ETL and data design
  • Proficient in writing SQL, some PL/SQL, Python and creating materialized views required
  • Extensive experience in database management, and maintenance, backups, restores, and recovery
  • Experience with Linux editors and shell scripts required
  • Excellent knowledge of data backup, recovery, security, and integrity
  • Familiarty with database design, documentation, patching and upgrading versions
  • Superior time management, interpersonal skills and a desire to collaborate
  • The ability to work under pressure to resolve live issues with systems in production
  • A passion to learn and work with new data, and the ability to quickly contextswitch
  • Strong analytical and problemsolving skills, with attention to detail
  • Ability to work independently and as part of a team
  • Strong team focus, and a selfmotivated drive to support excellent data solutions

Qualifications:


  • Postsecondary degree in a computer discipline or relevant certification
  • 5+ years of commercial experience

Other Assets:


  • Experience with PostgreSQL and Elasticsearch
  • Familiarity with cloud implementations in AWS & Azure
  • Experience with the management of spatial data, and Esri tools
  • Linux system admin
  • Knowledge of Canadian Oil and Gas data
  • Oracle Database Administration Certified
  • SQL Server Database Administration Certified
  • PPDM CPDA

More jobs from GeoLOGIC Systems Limited