Database Administrator - Calgary, Canada - GeoLOGIC Systems Limited
2 weeks ago
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.
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
-
Technical Sales Specialist
Calgary, Canada - 1 day ago
-
Web Design Specialist
Calgary, Canada - 3 days ago
-
Completions Specialist
Calgary, Canada - 3 weeks ago
-
Completions Specialist
Calgary, Canada - 1 week ago