Database Administrator (Infrastructure & Operations) - Information Technology

ABC Benefits Corporation; Alberta; Remote; CAD 70,000 - 90,000; Full time

Job summary

A leading organization in Alberta is seeking a Database Administrator to manage and optimize their database infrastructure. This role involves designing database solutions, ensuring data integrity, and providing support for database operations. The ideal candidate will have a strong background in Oracle and SQL Server technologies and be committed to delivering high-quality service. Join a diverse team that values innovation and community leadership.

Qualifications

• Minimum 2 years of experience with Oracle and SQL Server databases.
• Experience with ETL, data migration, and data warehousing.

Responsibilities

• Design and implement database tables, views, and procedures.
• Optimize queries and conduct database patching.
• Provide 24x7 on-call support.

Skills

Troubleshooting

Communication

Attention to Detail

Organizational Skills

Analytical Skills

Education

Bachelor's Degree in Computer Science

Technical Diploma

Tools

Oracle

Microsoft SQL Server

RedHat Enterprise Linux

ER/STUDIO

Job description

Database Administrator (Infrastructure & Operations) - Information Technology page is loaded

Database Administrator (Infrastructure & Operations) - Information Technology

Apply locations Work From Home Alberta time type Full time posted on Posted 10 Days Ago job requisition id R838

Alberta Blue Cross is an Alberta based organization dedicated to delivering exceptional customer experience and community leadership. We’re committed to providing the best health coverage to over 1.8 million members and take an active role in promoting wellness. We believe in what we do—and place trust in our employees to deliver our vision.

Working at Alberta Blue Cross means having a career where you’ll be recognized for your contributions. We value diversity, encourage our team members to maintain a healthy work-life balance and provide opportunities for career growth.

OVERVIEW:

Working as part of a larger Database Administration team, the Database Administrator is responsible for the continued highly performant, efficient and secure operation of the database infrastructure.

WHAT YOU WILL DO:

• Design, develop and implement database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications.
• Perform logical to physical model transformation, data migration, ETL (Extract, Transform, Load), and data warehousing.
• Work with data architecture/database design software such as ER/STUDIO.
• Responsible for all aspects of database administration including installation, configuration, performance tuning, product upgrades, security, auditing, capacity planning, backup and recovery, and high availability.
• Optimize queries, reports, and application code response time using tools such as Oracle Enterprise Manager, managing optimizer statistics, and SQL Profiles/baselines for tuning.The successful candidate should be intimately familiar with the Oracle Optimizer.
• Conduct database patching, including analysis, risk assessment, testing, and implementation.
• Plan and implement database-related software upgrades using best practices for mitigation of associated risk.
• Support and participate in a mature department-wide change management process.
• In partnership with our business users and application development and support staff, ensure that Alberta Blue Cross business and data needs are understood.
• Contribute innovative and transformative ideas to leverage database technology to align with the ever-changing needs of our business and customers.
• Liaise with other Information Technology staff to ensure that all operational requirements associated with the database environment are met.
• Provide production on-call support (24x7) on a rotation basis.

WHAT YOU WILL HAVE:

• A bachelor’s degree or diploma in Computer Science or related technical diploma.
• A minimum of 2 years of experience working with Oracle database and Microsoft SQL Server database technology, including maintenance, troubleshooting and support.
• Experience with logical to physical model transformation, data migration, ETL, and data warehousing.
• Experience with data architecture and associated database design software is an asset.
• Previous experience in database performance tuning, including sound knowledge with respect to the workings of the Oracle Optimizer.
• Strong technical knowledge of Oracle database technology components, including Recovery Manager (RMAN), Data Guard, GoldenGate, Diagnostics and Tuning Pack, and Enterprise Manager.
• Previous experience with RedHat Enterprise Linux, including high degrees of proficiency with the RHEL command line and associated shell scripting.
• Experience with database masking and database virtualization technologies is a definite asset.
• Foundational knowledge of operating systems, networks, storage devices, along with how they relate to a database environment.
• Strong troubleshooting & application support skills, along with excellent verbal and written communication skills are essential for the successful candidate.
• Strong relationship building and interpersonal skills.
• Superior attention to detail demonstrated through a high degree of accuracy in completed tasks and projects.
• Exceptional organizational and analytical skills.

This position will remain open until a suitable candidate is selected.

Alberta Blue Cross is an inclusive employer committed to a workplace that reflects the diversity of the communities we serve. We empower and are advocates for our team members by welcoming, respecting and valuing their unique perspectives, backgrounds, and experiences.

We offer the opportunity to work in an innovative, high-energy team-focused environment. If you have the qualifications we are looking for, apply online at careers.ab.bluecross.ca

Similar Jobs (3)

Solution Architect (Contract) – Information Technology

locations 2 Locations time type Full time posted on Posted 4 Days Ago

Finance & HR System Analyst – Information Technology

locations 2 Locations time type Full time posted on Posted 19 Days Ago

Procurement Governance & Technology Specialist – Procurement

locations 2 Locations time type Full time posted on Posted 15 Days Ago

Alberta Blue Cross is an Alberta based not-for-profit, dedicated to delivering exceptional customer experience and community leadership. We are committed to providing the best health coverage to over 1.8 million members and take an active role in promoting the wellness of all Albertans.

We believe in what we do—and place trust in our employees to deliver our vision.

* The Blue Cross symbol and name are registered marks of the Canadian Association of Blue Cross Plans, an association of independent Blue Cross plans. Licensed to ABC Benefits Corporation for use in operating the Alberta Blue Cross Plan. † Blue Shield is a registered trade-mark of the Blue Cross Blue Shield Association.