Senior Database Administrator

Do you have 5+ years of experience working with federal/provincial/broader public-sector healthcare providers? Do you have experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies? If so, this would be a great opportunity for you!

Our client is looking for a Senior Database Administrator for a 18 month contract in North York.

This is an onsite role.

Rate: 467.06-504.13





Advantages
• Earn a competitive rate within the industry.

• Location: Onsite role.

• Potential for extension



Responsibilities
• Provide technical expertise with technologies including Oracle Servers, Oracle 19C multi-tenant database/Oracle, Oracle on AWS - RDS

Active data guard, Oracle Enterprise cloud control (OEM CC), Oracle Golden Gate, Informatica / Cognos

• Produce daily monitoring scripts for entire stack of DTE databases and reviewing them for any potential issues and pro-actively fixing them to keep things running smoothly.

• Operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery

• Provide installation, administration, fine-tuning and support for SAP Business objects, Cognos BI, Informatica PowerCenter, Oracle Goldengate and Oracle Active data guard

• Assist with any performance/functionality issues arising due to recent releases of code to production and proactively implement changes to avoid recurrence

• Create physical database designs

• Operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery

• Develop and maintain data design models, database schemas and scripts, technical documentation and specifications

• Provide build books/deployment guides for the deployment to higher environments

• Assist in change initiatives in planning for data / database design, database setup, migration, optimization and tuning, capacity planning, data conversion and other development and implementation-related activities

• Produce data and database management project plans. Develop and obtain approval for detailed plans and resource estimates

• Provide specialized technical expertise in database administration, data warehouse design, data modeling, Extraction, Transformation & Load (ETL), information management, BI solution design, development and maintenance

• Provide Database (Oracle technologies & products) expertise for troubleshooting, problem resolution and performance tuning of the production solutions in operation

• Provide professional opinions and recommendations for technical issues, management, briefings, etc., and provide expertise, offer solutions and lead implementation of approved recommendations



Qualifications
MUST HAVES:

• Public Sector Experience

· 5+ years of experience working with federal/provincial/broader public-sector healthcare providers

· Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices

· Ability to produce technical documentation that comply with industry standard practices

· Knowledge and experience with Public Sector Health related projects

· Knowledge and understanding of Ministry policy and IT project approval processes and requirements would be an asset

· Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies

· Experience with large complex IT Health-related projects.

• Technical Skills

10+ years of experience in the following:

· Database administration using Oracle technologies and products, including Oracle 19C, Oracle on AWS – RDS, Oracle RAC, RMAN backup/recovery, Data Compression and encryption, Oracle Data Guard, Oracle GoldenGate and Oracle EM

· Experience in complex BI/DW solution design, implementation, maintenance, and support, using Oracle 19C, Oracle Directory Server, Informatica PowerCenter & Data Quality, IBM Cognos, Business Objects in a Sun Solaris/RedHat environment

· Superior technical expertise in: enterprise data warehouse database configuration, optimization and tuning, support and maintenance with Oracle database in a Sun Solaris environment for complex Business Intelligence/Data Warehouse (BI/DW) solutions, Bi-Directional Data Replication for Active-Active Solution Crossing Data Centers, and multi-tier web-based off-the-shelf solutions tools, including Oracle technologies & products (Oracle Database, Active Data Guard, GoldenGate, etc.) Cognos, Informatica PowerCenter, Power exchange & Data Quality

· Experience with Cognos, BO, Informatica and LDAP servers

• Core Skills and Experience

10+ years experience in the following:

· Administering and supporting and troubleshooting server/system issues related to Cognos, BO, Informatica, LDAP and Oracle DBs

· Experience with physical database designs, operation and administration of database management system (DBMS), including database optimization, performance tuning, backup and recovery, partitioning, compression, and security

· Developing and maintaining data design models, database schemas and scripts, technical documentation and specifications

· Providing build books/deployment guides for the deployment to higher environments

· Experience with database setup, migration, tuning capacity planning, and data conversion in a large operation with multiple environments

· Maintaining data design models, database schemas and scripts, technical documentation and specifications

· Providing specialized technical expertise in database administration, data warehouse design, data modeling, Extraction, Transformation & Load (ETL), information management, BI solution design, development and maintenance

· Monitoring and enforcing database rules

· Providing Database (Oracle technologies & products) expertise for troubleshooting, problem resolution and performance tuning of the production solutions in operation



· Providing professional opinions and recommendations for technical issues, management, briefings, etc., and provide expertise, offer solutions and lead implementation of approved recommendations

· Coordinating with Oracle support, Informatica support and Cognos support in opening tickets and providing information to find solutions and root cause analysis of ongoing issues

· Producing project plans for database management activities

· Experience with middleware, gateways and reporting systems

· Experience in Incident, Change and Configuration Management procedures

· Experience with use of information retrieval packages and proficiency with query languages.

• General Skills

· Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions

· Exceptional analytical, problem solving and decision-making skills

· Demonstrated strong interpersonal, verbal and written communication, and presentation skills

· Proven troubleshooting and critical thinking experience

· Demonstrated ability to apply strong listening skills to facilitate issue resolution

· Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships

· Strong interpersonal, facilitation and negotiation skills with ability to build rapport with stakeholders and drive negotiations to a successful outcome

· Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively

· A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.



Summary
If you are interested in the Senior Database Administrator role in North York, please apply online at www.randstad.ca. Qualified candidates will be contacted.



Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.