Database Administrator - Jobs in Regina, SK

Job Description

Who is eHealth SaskatchewaneHealth Saskatchewan is a Treasury Board Crown Corporation with a unique blend of healthcare, information technology and citizen services. Our vision is: “Connected healthcare, accessible to everyone, everywhere.” Our mission is: “We collaborate to transform healthcare through the use of information and innovative technology.” eHealth is a dynamic and complex environment, constantly evolving and quickly changing as we live our values of excellence, integrity, teamwork, courage, resilience and collaboration. Our organization plays an important role in providing IT services to patients, healthcare providers, the Ministry of Health and the Saskatchewan Health Authority. eHealth teams engage directly with health system partners and other stakeholders both provincially and federally to ensure all services are delivered efficiently and effectively.A large and complex organization, eHealth is comprised of 30+ clinical and non-clinical program (service) areas that all work together to support health care providers and teams across the province in delivering the best possible care to patients, providers, citizens, and health system users. Programs range from primary care to acute care, and includes laboratories, pharmaceuticals and diagnostics. Additional programs that also support patient care and information, include Virtual Care, the MySaskHealthRecord, and the Provincial Electronic Health Record. eHealth is also responsible for the administration of various pieces of legislation to manage the registration of/changes to all vital event records (e.g. birth, marriage, death, etc.), registration of legal name changes, registration of adoptions, and for maintaining the provincial health registry for health services eligibility and distribution of health services cards.The eHealth teams engage directly with health system partners and other stakeholders both provincially and federally to ensure all services are delivered efficiently and effectively.Database Administrator RoleThe ideal candidate will have extensive experience as a SQL Server database administrator with some knowledge of Oracle databases while working with large-scale, massively concurrent, highly available distributed systems. You will be working with a group of highly skilled DBAs and application support analysts. Your focus will be on the health of the SQL Server databases of our entire application stack through the lifecycle of the system. You will be an expert in designing, building and maintaining databases – both for applications built in house as also for applications purchased off the shelf from vendors. Knowledge of UNIX as an operating system is essential for this position.You will be responsible for configuring and monitoring interfaces with other systems, maintain systems, user databases, instances, schemas, table spaces, tables, indexes, buffer pools, and logs, and managing system and database user IDs, group permissions, backups, recoveries and providing expertise related to DB performance, high availability, and scalability. You will play an important role in data migrations between systems including data refreshes. You will also be responsible for planning, installation, and maintenance of DBMS software in standalone and cluster environments, database automation through stored procedures and scripting. You will proactively gauge the performance of the application and database and provide recommendations to achieve the optimal architecture. You will also proactively assess and evaluate scalability of the databases and make appropriate recommendations. You will be directly responsible for maintaining the integrity of our databases and thereby or mission critical applications that serve the health sector in the province of Saskatchewan. You will be part of the incident resolution process and thus will need to be a part of the on call rotation that provides 24 x 7 DBA support. Furthermore, the successful candidate will also have extensive working knowledge, understanding and possible certification in:

• Database high availability technologies (i.e. clustering, Data Sharing);
• Operating systems such as Unix, Linux, and Windows;
• Ability to participate, analyze, and remediate the impact of software, database or infrastructure changes;
• Experience in Oracle RAC, ASM, RMAN, GridControl and Dataguard is an asset;
• Experience in SQL Server will be required;
• Experience in Avamar backups will be an asset;
• Excellent communication skills; ability to communicate technical information to both technical and non-technical groups;
• Ability to work independently and in a team;
• Excellent problem solving skills;
• Experience in working in a 24 x 7 environment and being on call; and
• Strong interpersonal skills.

The knowledge and skills required for this position would be attained through the completion of a post-secondary degree in computer science or a related discipline, supplemented by 4 years of increasing responsibility within a database environment. An equivalent combination of education and experience in a similar role may be considered.You will be:

• Flexible, organized and quick to learn in order to independently prioritize and organize own workload to meet tight deadlines and successfully complete projects in a changing environment;
• Patient, honest, discreet and respectful/tactful while working with various types personal health information etc.;
• Service-oriented, thorough, reliable, disciplined, organized, and strong attention to detail in order to complete tasks for clients and coworkers etc.;
• Creative, logical, and have a strong motivation for continuous improvement and learning; and
• Empathetic, diplomatic and sensitive in order to respond to issues and concerns of others who may be angry or frustrated.

Competencies:Communication:

• Ability to write a variety of detailed, accurate and clear material at a level appropriate to the target groups.
• Ability to orally explain or present (technical) information to a wide variety of technical and non-technical individuals and/or groups in a clear, accurate and understandable manner.
• Ability to actively listen, paraphrase and ask precise questions in order to clarify and understand information being received.

Leadership:

• Ability to conceptualize, develop, monitor, adjust and implement projects, taking into consideration numerous and changing priorities, and or resources to achieve project goals.
• Ability to constructively lead, advise and encourage others to achieve success in their work and contribute to the effectiveness of the work team.

Problem Solving:

• Ability to independently interpret, comprehend and apply technical instructions and concepts to successfully acquire, install, modify, configure and maintain hardware and software components and administer networks.
• Ability to diagnose technical problems such as delays, malfunctions and errors in order to determine the true cause of the problem and provide a (workable/reasonable/optimal) solution in a reasonable timeframe.
• Ability to identify and respond to issues and concerns of others who may be angry or frustrated to reach a mutual understanding.

Interpersonal:

• Ability to create an environment that recognizes, supports, respects and welcomes diversity of employees and clients.
• Ability to build cooperative working relationships with coworkers and clients to ensure credibility and confidence in services provided.
• Ability to consult and collaborate with colleagues and stakeholders to establish partnerships/obtain, exchange and confirm information/establish and maintain agreements/ identify solutions/develop and maintain standards.

Team/Independence:

• Ability to work independently and participate as a team member to meet the needs of clients and co-workers and to build productive, positive work relationships.

Organizational:

• Ability to independently prioritize and organize one’s own workload to meet tight deadlines and successfully complete projects in a changing environment.

Analytical:

• Ability to identify, explore and evaluate options on data processes and methodologies, information technology and potential systems design to make feasible recommendations. Ability to gather, understand and synthesize specialized information in a way that can be applied to meet the needs of the organization and within given constraints.

Technical:

• Ability to design new or adapt existing systems/applications taking into account design alternatives, business requirements, and cost, recourse and time constraints.

If this role sounds like the opportunity you’ve been looking for to challenge yourself, make a difference in people’s lives, and showcase your abilities – we would love to hear from you!Anticipated Start Date: November 21st, 2022Grade: 11SITWe are committed to workplace diversity.Number of Openings: 1Closing Date: Oct 24, 2022, 12:59:00 AMQuick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job
• SimplyHired OnDemand

Stay Connected