Lead Database Administrator REMOTE

Noramtec Consultants; Montreal; Remote; CAD 90,000 - 120,000; Full time

Job summary

A technology consulting firm is seeking a Lead Database Administrator to manage Postgres and Oracle databases for critical projects. The ideal candidate will have extensive experience in database administration, particularly in cloud environments (AWS), and will oversee system design and ensure operational continuity. Strong scripting skills and recent experience with automation tools are preferred. This is a 12-month remote contract position.

Qualifications

• Experience with administration of databases on AWS Cloud.
• Recent exposure to support alternate RDBMS database flavors.
• 7-10 years experience as Lead DBA in complex environments.

Responsibilities

• Analyze database needs and recommend cost-effective solutions.
• Conduct systems design and feasibility studies.
• Resolve complex database issues independently.
• Participate in on-call production problem resolution.

Skills

Postgres Database Administration

Oracle Database Administration

Cloud Database Architecture

UNIX/Linux Knowledge

Scripting Skills

Database Performance Tuning

Troubleshooting

Automation Tools (Ansible, Jenkins)

Container Technologies (Docker)

Education

Bachelor’s degree in Computer Science

Master’s degree in Computer Science

7-10 years of IT experience

Tools

Oracle Enterprise Manager

Postgres Tools

AWS RDS

AWS EC2

Job description

Overview

Job Position : Lead Database Administrator

Job Location : Remote

Duration : 12-month contract

Job Description :

Performs all Postgres and Oracle Database Administration-related activities for major ETS projects independently with minimal supervision.

Responsibilities :

Participates in projects as assigned providing expertise related to Cloud Database Architecture (AWS or Azure). Analyzes database and information needs of projects and applications in order to recommend and implement cost-effective solutions.

Conduct systems design, feasibility, and cost studies and recommend cost-effective cloud-native solutions.

Develop standardized machine images and Cloud formation automation scripts for building non-prod and prod environments on AWS.

Experience in managing, maintaining, patching, upgrading, and ensuring operational continuity of both Postgres and Oracle Databases and associated components using the following products : Pegol Cluster, Postgres tools, Oracle Enterprise Manager, Data Guard, RMAN

Must have good UNIX, Linux knowledge and scripting skills

Schedules and coordinates database maintenance activities.

Strong capability and ability to resolve highly technical and complex database and infrastructure-related issues on their own before they impact production and the ETS business.

Provides technical expertise to the development of solutions for such items as DBMS tools and utility usage, database administration, backup and recovery, database performance tuning, and monitoring.

Ability to influence development organizations to comply with database best practices and database standards and practices.

Trouble-shoots database and / or software problems as they apply to design implementation or installation activities.

Performs database migrations, upgrades, and structure migrations.

Participates in 7×24 on-call, overnight off-hour production problem resolution activities as needed in the rotation.

Knowledge, Skills, and Abilities :

Must have experience supporting Postgres and Oracle Databases.

Must have experience with administration of Databases on AWS Cloud using RDS and / or EC2.

PostgreSQL Database Administrator in versions 9.x and 12.x with Postgres Advanced Server using Enterprise Manager and SQL analyzer.

Demonstrate recent, professional exposure to support alternate RDBMS database flavors like MS SQL SERVER, Aurora, & NoSQL.

7-10 years of experience, with at least the last 5-7 years as Lead DBA on all aspects of Postgres and Oracle Database Administration in a large / challenging database environment.

Experience with automation tools (Ansible, Jenkins) & container technologies (Docker, CoreOS) is a big plus and desired.

Experience supporting internet / web-based database applications with heavy concurrent user volume.

Education :

The contractor should have a bachelor’s degree or master’s in Computer Science or 7 to 10 years of related experience in IT or a related field