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