Job Details




Requisition Id: RQ04796 Title: Senior Database Administrator
Role: Specialized IT Consultant Submission Deadline: Jan. 24, 2023, 2:30 p.m.
Start Date: April 4, 2023 End Date: April 5, 2024
Location: Toronto, ON #Candidates: 2

Job Description :

AMANST Inc. is looking for Senior Database Administrator for a contract opportunity with Ontario Government.

 

Estimated Business Days: 498 days

 

Must Haves

  • Oracle 19 C
  • Cognos
  • Golden Gate
  • Active Data Guard

 

Nice to have

  • Public Sector Experience

 

Description

  • Provide technical expertise with technologies including Oracle T7 Servers, Oracle 19C multi-tenant database/Oracle Active data guard, Oracle Enterprise cloud control (OEM CC), Oracle Golden Gate, Informatica / Cognos and Shadowbase
  • 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
  • Coordinate with Oracle support in opening tickets and providing information to find solutions and root cause analysis of ongoing issues.

 

Experience and Skill Set Requirements

 

Public Sector Experience – 5%

  • 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 – 50%

10+ years of experience in the following:

  • Database administration using Oracle technologies and products, including Oracle 19C, 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 – 35%

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 – 10%

  • 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

 



BACK