28 Jan
CQ Search Group
North York
Our North York client has a 12 month hybrid remote renewable contract for an Oracle DBA.....
Requirements:
- 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.
MUST HAVES:
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
Active Data Guard, GoldenGate, etc.) Cognos, Informatica PowerCenter, Power exchange & Data Quality
Administering and supporting and troubleshooting server/system issues related to Cognos, BO, Informatica, LDAP and Oracle DBs
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.