JOBS

Database Administrator

Vaughan (ON) Both (on-site & remote)
Opportunity Number: 2073203
Duration
6 Month Contract
IndustrySpecialization
Municipal GovernmentDatabase
LanguageSecurity Clearance
English verbal and writtenCriminal Check at time of placement
Start PeriodDate Posted
Two weeks +Wednesday, September 14, 2022
Job Description

Our large-scale municipal client is looking for a Database Administrator to join their team. This individual will work alongside the Infrastructure Architecture and Operations group in the Office of the Chief Information Officer Department to maintain implemented Oracle and Microsoft SQL technologies.

Our client's enterprise computer network is based on the following standards:
- OS: Windows 2016, 2019, 2022, Oracle Linux 7+;
- Oracle Databases: Oracle 11gR2 platform and newer;
- Oracle Database Application v19.8;
- Oracle Real Application Cluster (RAC); and
- Microsoft SQL Server Databases: SQL Server 2014 and newer.

Need to know:
- Submission requires 3 references and proof of education and certifications.
- Working hours are 8:30 AM to 4:30 PM
- Hybrid environment
- Contract length: 1000 hours

Roles and Responsibilities

  • Provide Oracle and MS SQL Server database administration, availability, scripting, automation and operations support
  • Install and configure Oracle and MS SQL Database services and/or related software
  • Install and configure ODA and related software
  • Install, configure manager and upgrade ODA Virtualized Platform and Oracle Enterprise Manager
  • Install required patches on ODA
  • CentOS / RHEL / Oracle Linux system administration and scripting
  • Install and configure MS SQL Always-On availability groups, Always-On fallover cluster and/or database monitoring
  • Install and configure Oracle Active data Guard, Data Guard, Real Application Cluster (RAC), Recovery Manager (RMAN)
  • Perform database backups, restores and recovery on both Oracle and MS SQL databases
  • Execute database tuning and optimization: memory, performance, storage management
  • Develop and implement security procedures for databases, including access and user account management
  • Perform Oracle and MS SQL Server upgrades and apply patches
  • Execute database and application upgrades
  • Creation of development, staging and production environments for new applications
  • Analyze Oracle and MS SQL Server performance and recommend improvements
  • Apply problem solving skills to troubleshoot and resolve technical problems
  • Allocate database storage and develop plans for future storage requirements
  • Check latest patches for databases and recommend patch installation and testing developed environments


Qualifications and Experience
  • 7+ years of experience in the role of Oracle Database Administrator, MS SQL Database Administrator or equivalent
  • To be considered for this role, the Database Administrator should be certified as a Microsoft Certified Solutions Associate (MCSA) in SQL version 2014 or newer and Oracle DBA certified in version 12c or newer



We’re an equal opportunities employer committed to increasing diversity and inclusion in today’s workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Minorities, women, LGBTQ candidates, and individuals with disabilities are encouraged to apply. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.
Merci de l’intérêt que vous manifestez pour ce poste. La description du poste nous a été fournie en anglais par notre client. Si vous souhaitez passer l’entrevue avec nous en français ou fournir votre CV en français, nous vous confierons à une personne de notre équipe qui parle français.

Opportunity Number: 2073203

Similar Jobs

Data Engineer - Secret Clearance

 Contract

 Ottawa

 Two weeks +

Database Administrator

 3 year Contract

 Ottawa

 Two weeks +

Sr. Database Administrator /SQL Server, Azure

 Permanent

 Toronto

 ASAP