Database Administrator - Hamilton, Canada - Stelco

Stelco

Verified Company

Hamilton, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

_With a legacy that spans over 100 years, Stelco is company that has grown along with Canada and its global partners.

We understand that twenty-first century competition demands the highest quality products, period.

So, Stelco is bringing together the people, technology, and unmatched market knowledge to, once again, take on that challenge from here at home.

_

Database Administrator

Job Location:
Hamilton

Job Overview

The Database Administrator is to perform daily database administration against relational databases, including software installations and patching, shell scripting, backup and recovery, RMAN, database migrations, database refreshes, database maintenance tasks and problem resolution.

This position reports to the Application Services Manager

Job Responsibilities

Perform administration support for any of the following databases: Oracle DBMS, MS SQL, Azure SQL, MS Industrial SQL, MS Access
Conduct overall maintenance, administration, monitoring, and problem resolution for relational databases
Carry out database software installation and patching
Perform database creation and database migrations to alternate servers and database upgrades
Conduct database refreshes and clones
Experience with Oracle Data Guard
Proficient knowledge on SQL Server Always ON, installation configuration and tuning
Perform Oracle Backup & Recovery utilizing RMAN
Perform MS SQL Backup & Recovery utilizing MS tools
Working knowledge of Azure Cloud
Azure SQL administration, for PaaS config
Knowledge of Power BI (web portal, configuration, integration with Oracle, SQL data sources development)
Perform PL-SQL and T-SQL database performance and tuning
SQL Server both instance and query level, onprem and cloud
Oracle both instance and query level, onprem
Develop and maintain shell scripts
Maintain database and data security
Be available for offhours production support, with an oncall rotation
Maintain the production, development, and test databases that are deployed for Stelco systems
Recommend solutions by defining database attributes and functional capabilities, database security, data backup, and recovery specifications
Maintain database performance; implement new releases; complete maintenance requirements; and evaluate computer operating systems and hardware products
Oracle Enterprise Manager 13c Administration, installation, and upgrade
Experience in improving DBs security posturing with respect to compliance and vulnerability management
Experience with Tenable vulnerability management tool, for DB compliance
Nice to have: Familiarity with Idera Diagnostic tools, installation, and upgrade
Nice to have: Support and performance tune Extract, transform, load related data warehouse DB workloads

Job Qualifications

Bachelor's degree in Information Systems, Computer Science, Math, Engineering or equivalent work experience
7+ years of experience as a Database Administrator
Strong understanding of relational database technologies
Strong SQL skills
Familiarity with performance and tuning
UNIX, LINUX, Windows, including shell scripting
Experience with at least 1 programming language or scripts
Familiarity with database architecture, both logical and physical
Understanding ERP systems (D365 is preferred)
Selfstarter with the ability to automate monitoring and administration tasks

Job Skills and Knowledge

Excellent oral and written communication skills
Ability to communicate effectively speaks and writes clearly, listening effectively, relating ideas/concepts to various groups of people (customers, service provider groups, technical partners)
Teamwork reaches out to peers and cooperates with supervisors to establish an overall collaborative working relationship
Flexibility and adaptability adjust quickly to changing priorities and conditions
Honesty and integrity does not cut corners ethically, does what is right
Strong work ethic pride in work product
Critical thinking, analytical ability
Able to structure and process qualitative and quantitative data and draw insightful conclusions from that
A probing mind asks questions to get to the root cause
Ability to manage priorities for timely completion of assignments with mínimal supervision

Working conditions

Normal, fastpaced office environment for a high impact team.
Onsite / remote work options are available, this is not a 100% remote position and onsite presence will be required.
Offhours production support, with an oncall rotation required.
In accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, Stelco is an equal opportunity employer who is committed to providing an inclusive and barrier free recruitment and selection process. Applicants should advise Human Resources if they require any type of accommodation during the recruitment process._

Benefits: