Database Administrator

Stelco - Hamilton, ON (23 days ago)

Apply Now

With a legacy that spans over 100 years, Stelco is a 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.

About the role

The Database Administrator performs daily database administration against relational databases, including database migrations, database refreshes, database maintenance tasks and problem resolution, and backup and recovery (RMAN). In addition, this position is involved in software installations and patching, shell scripting, code promotions, as required.

This position reports to the Application Services Manager.

Your day-to-day

  • Perform administration support for any of the following databases: Oracle DBMS, MS SQL, MS Azure, MS Industrial SQL, MS Access
  • Work with application support to identify database requirements; analyze department applications, programming, and operations; evaluate existing systems; and design proposed systems
  • 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
  • Perform Backup & Recovery utilizing RMAN
  • Support high availability databases utilizing RAC
  • Perform database performance and tuning
  • Configure and implement GRID
  • Develop and maintain shell scripts
  • Perform SQL query optimization and tuning
  • Maintain database and data security
  • 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 back-up, and recovery specifications
  • Maintain database performance; implement new releases; complete maintenance requirements; and evaluate computer operating systems and hardware products
  • Be available for off-hours production support, with an on-call rotation
  • Support data modeling activities to make data available to the business and optimize its performance

What you bring to the table

Job Qualifications

  • Bachelor’s degree in Information Systems, Computer Science, Math, Engineering or equivalent work experience
  • 7+ years of experience as a Database Administrator
  • Knowledge in Oracle DBMS, Oracle RDB, MS SQL, MS Industrial SQL, IBM DB2, MS Access
  • Strong understanding of relational database technologies
  • Experience with at least 1 programming language
  • Strong SQL skills
  • Familiarity with performance and tuning
  • UNIX, LINUX , Windows, OpenVMS, including shell scripting
  • Familiarity with database architecture, both logical and physical
  • Familiarity with Power Bi
  • Familiarity with Azure SQL
  • Self-starter with the ability to automate monitoring and administration tasks

Job Skills and Knowledge

  • Excellent oral and written communication skills
  • Attention to detail
  • 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 – adjusts 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 minimal supervision

Your work environment

  • Normal, fast-paced office environment for a high impact team

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.

Job Type: Full-time