Database Administrator, Qualico

Title: Database Administrator

Location: 3203 - 93rd Street NW, Edmonton

At Qualico, our people make the difference. We offer an exciting place to build your career with competitive compensation and benefit packages, company matching RRSP/DPSP program, employee home purchase program, and employee discounts.

Job Overview

Reporting to the Data Architect, as the Database Administrator you will provide expertise in systems integration and designs/implements processes that integrate data from FTP sites and databases. You also manage and maintain database systems, ensuring high performance, security, and availability.

Your day-to-day responsibilities will include:

• Administering, developing, testing, and maintaining databases, with a focus on MS SQL Server Enterprise and Standard editions.
• Optimizing MS SQL Server systems for performance efficiency.
• Creating and monitoring SSIS packages.
• Managing, configuring, and providing support for SSRS.
• Monitoring database systems to ensure secure services with minimal downtime.
• Implementing and managing database access and designing backup and recovery systems to ensure data integrity.
• Evaluating and proposing new database technologies and strategies to improve existing systems.
• Developing and managing ETL processes for data transfer between FTP sites and databases.
• Constructing and implementing database and file systems for data extraction, transformation, and loading.
• Managing the transfer of files and data through FTP sites.
• Developing and maintaining integrations between FTP sites and SQL Server databases, ensuring seamless data exchange.
• Adhering to and enforcing database standards and methodologies, ensuring data consistency and integrity.
• Collaborating with the IT team to understand data needs and achieve project goals.
• Regularly assessing system performance, preparing reports, and suggesting improvements.

As our ideal candidate, you are...

• Organized; you effectively manage your time while balancing multiple priorities.
• A strong communicator; you clearly express your thoughts in conversation and in written communication.
• An active listener; you seek to understand and listen to others in a non-judgmental way.
• Detail oriented; you focus on detailed accuracy when dealing with a high volume of work.
• A team player; you contribute as a team member and share equally in the exchange of ideas, concepts and process outcomes.

Essential Requirements:

• Bachelor's degree in Computer Science or a related field.
• Minimum 5 years of progressive experience in database administration.
• Advanced knowledge of data backup, recovery, security, and integrity with SQL Server.
• Experience with MS SQL Server Enterprise edition, including database design, documentation, and coding.
• Ability to develop and manage ETL processes.
• Excellent problem-solving and analytical skills.
• Ability to work in a team environment.
• Satisfactory verification of criminal record check.
• Proficient in Microsoft Office programs (Outlook, Word, Excel, Teams, SharePoint and PowerPoint) and MS SQL Server Enterprise and Standard editions, including Always On High Availability.
• Ability to configure, manage, and troubleshoot Windows Cluster, SQL FCI Cluster, SQL Always On, Database Replication.
• Proficient understanding of SaaS based SQL services/On-premises data gateways, FTP protocols, and FTP sites.
• Ability to setup, configure, and execute ETL operations, integrating FTP sites and SQL Server databases.

What We Value

• Creating trusting and successful working relationships.
• Taking responsibility for the outcome of decisions and actions.
• Cooperating with team members in a supportive and respectful manner.
• Staying current with technical job skills.
• Setting clear, measurable and achievable goals.

Work Conditions

You primarily work in an office setting during regular business hours. Overtime may occasionally be required.

About Us

Qualico is a fully integrated real estate development company with offices in Winnipeg, Calgary, Edmonton, Vancouver, Regina, Saskatoon, Austin and Dallas-Fort Worth, Texas.

Since its inception in 1951, the company's activities span the entire real estate spectrum and include residential land acquisition and development, single-family and multi-family home divisions, commercial and industrial development, property management, concrete ready mix, building supply and manufacturing divisions. To learn more, click here.

Qualico welcomes applications from people with disabilities. Accommodations are available upon request during the assessment and selection process.

Candidates being considered will be contacted. We thank you for your interest. Join our Talent Community to stay up to date on job opportunities and to find out why we have the best reason to come to work every day.

Closing date: October 23, 2024