Oracle Database Administrator - Jobs in Mississauga, ON

Job Description

Job Summary: Experienced Oracle DBA required to support production environments in Oracle Cloud (IaaS and PaaS), with a good grasp of related IT technologies (Linux, networking) and a keen interest in extending their skills set to Cloud technologies, through perpetual learning and skill improvement.Duties and Responsibilities:

• Oracle DBA support in CPAS environments in and as needed in remote client environments:
• Oracle RDBMS software installs, patching and database creation,
• setting up and maintaining database security,
• database upgrades and migrations,
• schema exports and imports (as needed)
• setting up and maintaining robust backup protection for all databases in environment,
• performs backups, recoveries, and failovers to “hot” standby environment,
• database replication (Data Guard and Dbvisitt Standby),
• database patching (quarterly CPU and out of cycle),
• issue resolution,
• performance monitoring and tuning

• Oracle DBA support in in 7x24 production environments
• Daily monitoring for:
• Success of daily database backups,
• Check state of database replicas,
• Potential occurrence of database errors
• Service errors and issues,
• Database performance issues,

• Performs backup recovery as needed, tests backups ensuring validity and fitness for use
• Opens Support Request tickets and works with Oracle Support Team on issue resolution
• Makes recommendations regarding enhancements and/or improvements
• Communicates with team members, staff, and clients
• Supports team’s development effort and production deployment roll-out from DBA role perspective
• Develops and maintains good, up-to-date, hands-on practical knowledge and skills with regards to Oracle database products and best practices.
• Maintains, always improving Oracle database product knowledge and skills.,
• Works with users to resolve problems, creates new solutions and serves as a technical resource.
• Aptitude for technical issue troubleshooting and problem solving.
• Assist with other activities, when requested.

Knowledge and Experience:

• Oracle Certification, DBA track.
• 5+ years of work in Oracle DBA role (exclusively), supporting production and development environments.
• Ability to script and automate job role tasks.
• Possession of excellent interpersonal skills to resolve problems in a professional manner
• Experience with database implementation in Cloud environment (OCI preferably).
• Bachelor’s degree or the equivalent combination of education plus relevant experience, in Computer Science, or related field.

Skill and Ability in Detail:

• Medium to Advanced Oracle DBA skills with hands-on support of mission-critical Oracle databases

(Patching, securing, auditing, RMAN Backup and recovery, hands-on experience with Data Guard, Enterprise Manager, with SQL skills set suitable for the DBA job role)

• Linux skills are mandatory: proficiency with command line and utilities and Bash scripting
• Optional Python/PowerShell/Perl considered an asset
• Basic Windows Server literacy
• “Nice to have” skills:
• Basic networking and firewalling skills (i.e.: subletting, routing, securing networks, etc.)
• Experience with Open-source web technologies, Tomcat/JBoss/Apache
• Experience with Configuration management tools, including Ansible, Chef, Puppet
• Experience with Cloud-specific automation technologies (Terraform, OCI SDK, REST APIs, etc.)

• Experience with supporting environments operating from any of big public cloud environments (OCI preferred)
• Excellent written and verbal communication skills.
• Highly motivated
• Team player
• Enthusiastic and high level of creative energy.
• Self-starter with solid interpersonal skills projecting a very positive customer service-oriented attitude.
• Good working knowledge of OCI environment is a plus.
• Able to prioritize work, meet deadlines and perform well under pressure.
• High integrity and commitment to quality.
• Adaptive to changing situations.
• Deals with ambiguity efficiently and makes sound decisions.
• Takes initiative and seeks responsibility.
• Demonstrates personal accountability / commitment for clients, projects, tasks and responsibilities

Avenu Summary: Avenu provides local governments with ways to achieve more predictable revenue that supports growth, fuels modernization and ensures compliance with mandated but underfunded programs. Avenu’s revenue enhancement and administrative solutions find and recover license, permit and other taxes that cities and counties struggle to collect. The insights and improved fiscal posture enables governments to deliver expected services and sustain a high quality of life for residents.Avenu is an Equal Opportunity Employer. Selection for a position will be made without regard to race, religion, national origin, sex, political affiliation, marital status, non-disqualifying physical handicap, and age.Job Type: Full-timeQuick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected