RQ04205 - Database Administrator - Senior
Description
Are
you looking to partner with an organization that presents you to consulting
opportunities and supports you as a partner?
4318 - Database Administrator - Senior - 1 Year Contract - Hybrid Work - Toronto
We are seeking the services of one (1) Senior Database Administrator.
Essential technologies experience:
Task 1
· Monthly Performance
Status Report
Deliverables
· All deliverables that
consultant worked on during past month are included
· Progress and specific
accomplishment against the deliverable are described
· Status of consultant’s
deliverable compared to the project Baseline
Estimated Completion
Date
· Monthly
Task 2
· Manage and administer
the database and application servers used to support the Driver& Vehicle
data quality analysis activities.
Deliverables
· Apply database and
system patches and perform database change management activities
· Create, configure,
reorganize, and migrate database / objects
· Conduct database
capacity planning and database disaster recovery planning
· Design, test, and manage
database backup and recovery
· Provide support for
development and performance optimization of programs/jobs such as SQL*Loader
jobs, data loading jobs, transformation/ETL jobs, PL/SQL & SQL scripts and
Unix/Linus scripts etc
· Provide administration
support on application server and the setup & development on IBM InfoSphere
or Informatica Data Quality
Estimated Completion
Date
· Throughout the project
Task 3
· Support the project
delivery of data extraction, data analysis, data profiling and data cleansing
of the Driver & Vehicle data.
Deliverables
· Support project related
data extraction, profiling and data masking activities
· Liaise with project
stakeholders to analyze data quality issues and provide root cause analysis
· Provide support for
development and performance optimization of programs/jobs such as ETL, Perl,
Java, Python and Machine Learning programs etc
Estimated Completion
Date
· According to the project
schedule to be defined by the Project Manager and Technical
· Coordinator
Task 4
· Knowledge transfer to
ministry staffs or resources designated by the ministry
Deliverables
· Documentations
· Walk-through sessions
Estimated Completion
Date
· Throughout the project
Skill Set Requirements:
· Proven extensive
experience in designing, deploying, administrating and tuning high volume and
high-performance databases
· Proven extensive
experience in administrating Oracle 12c on Linux/Windows and database
performance tuning
· Experience with data quality
technologies and tools such as Infosphere, Informatica & OEDQ and the
installation of the tools
· Experience in database
migration, setup and management of on Premise, Cloud or Hybrid environments
· Experience and knowledge
on Cloud technology and solution including data transfer between on Premise and
Cloud
· Experience with the
Application Lifecycle Management (ALM) Tool
· Proven extensive
experience with high volume data extraction from heterogenous data sources,
data loading, data profiling, masking, transformation and cleansing
· Experience and
proficient in ETL technology, tools (e.g. InfoSphere, Informatica etc) and
programming
· Experience and
proficient in developing SQL*Loader scripts, optimized PL/SQL, complex queries
with SQL, Unix/Linux scripts (e.g. Perl), Excel and one or more other
programming languages
· Experience and knowledge
with Siebel EIM/EAI, OCH, EBS and PowerBI
· Experience with data
modelling, data mining and segmentation techniques
· Knowledge of Machine
Learning technology including environment setup, Python/R/Jupiter programming
to perform data analysis
· Strong analytical
skills, critical thinking and problem-solving skills to analyze and interpret
data
· Excellent analytical,
problem-solving and decision-making skills: verbal and written communication
skills: interpersonal and negotiation skills
· Ability to work
independently and with good quality on concurrent multiple projects
Experience and Skill Set
Requirements
Data Base Administration
Experience - 30%
· Proven extensive
experience in designing, deploying, administrating and tuning high volume and
high-performance databases
· Proven extensive
experience in administrating Oracle 12c on Linux/Windows and database
performance tuning
Data Quality Tools and
Environments - 25%
· Experience with data
quality technologies and tools such as Infosphere, Informatica & OEDQ and
the installation of the tools
· Experience in database
migration, setup and management of on Premise, Cloud or Hybrid environments
· Experience with the
Application Lifecycle Management (ALM) Tool
· Experience and knowledge
on Cloud technology and solution including data transfer between on Premise and
Cloud
Data Cleansing and
Transformation Experience - 25%
· Proven extensive
experience with high volume data extraction from heterogenous data sources,
data loading, data profiling, masking, transformation and cleansing
· Experience and
proficient in ETL technology, tools (e.g. InfoSphere, Informatica etc) and
programming
· Experience and
proficient in developing SQL*Loader scripts, optimized PL/SQL, complex queries
with SQL, Unix/Linux scripts (e.g. Perl), Excel and one or more other
programming languages
· Experience and knowledge
with Siebel EIM/EAI, OCH, EBS and PowerBI
· Experience and good
knowledge with data modelling, data mining and segmentation technique
· Knowledge of Machine
Learning technology including environment setup, Python/R/Jupiter programming
to perform data analysis
Problem Solving and
Communication - 20%
· Excellent analytical,
problem-solving and decision-making skills: verbal and written communication
skills: interpersonal and negotiation skills
· Ability to work
independently and with good quality on concurrent multiple projects
Requirements
Technical Skills
· Experience and knowledge
with Siebel and PowerBI
· Extensive experience in
administrating Oracle 12c on Linux/Windows and database performance tuning
· Experience with data
quality technologies and tools such as Infosphere and Informatica and the
installation of the tools
· Experience in database
migration, setup and management of on Premise, Cloud or Hybrid environments
· Experience and
proficient in ETL technology, tools and programming
· Experience and
proficient in developing PL/SQL, complex queries with SQL, Unix/Linux scripts
(e.g. Perl), Excel and one or more other programming language
Nice to Have:
· Public Sector
Skills
Sign in to read and join the discussion.