DBA / SQL Developer

ROSS; Mississauga; On-site; CAD 70,000 - 90,000; Full time

Job summary

A reputable technology services company in Peel Region, Mississauga is seeking a Database Administrator to provide technical support and ensure database integrity. Responsibilities include daily maintenance, troubleshooting, and risk mitigation for an optimal operating environment. Ideal candidates will have experience in data modelling, SQL development, and familiarity with various database management tools. This role offers an opportunity to work in a dynamic environment and make an impact.

Qualifications

• Proven experience in data modelling and SQL development.
• Familiarity with web-based applications on WebSphere/Java/Apache and IIS/.NET/Windows Server.
• Experience with RedHat Linux and Windows Server Operating Systems.

Responsibilities

• Perform daily technical administrative tasks to ensure database accessibility and stability.
• Provide technical support to staff and vendors for operational databases.
• Monitor performance and capacity issues to prevent instability.

Skills

Data modelling

SQL development

Database management tools

Advanced troubleshooting skills

Root-cause analysis

Education

Recognized University Degree or College Diploma

Tools

SnapManager for SQL

DBArtisan

RedGate

ER/Studio

ERWIN

Job description

Database Administrator

The Database administrator provides specialized technical input and support and ensures auditing, configuration standards, security levels and technical support are delivered timely and professionally to promote a sound operating environment.

This position will also involve some data modelling and SQL development work.

You Will:

• Perform technical administrative tasks relative to the environments on a daily basis to ensure the databases are accessible and stable via the applications.
• Provide assistance and technical support to other staff members/vendors to ensure the design and management of the databases are operational.
• Prevent security breeches, intrusions or attacks to the environment by ensuring appropriate measures are in place to allow for auditing, alerts and reporting on a daily basis.
• Develop and maintain reports that can be used on a daily/monthly basis for administrating the environments.
• Monitor and reports to management any performance, capacity or threshold issues that would result in an unstable environment.
• Schedule sessions with developers and 2nd level support staff to ensure knowledge transfer and application expertise is provided.
• Investigate with vendor support any patches or upgrades that apply permanent fixes to current versions of software/hardware.
• Perform risk mitigation steps as it relates to these types of changes to ensure the environments are stable on a scheduled basis

Operations support

• Maintaining critical environments in an “always on-call” function; being responsible for multiple environments that span both transactional and batch/report type database environments
• Advanced troubleshooting skills in client/server environments, detailed root-cause analysis, efficient/effective problem resolution
• Ability to integrate off-the-shelf tools with in-house developed scripts and programs to manage platforms and notify/alarm on call support in a proactively and timely

You must have:

• Data modelling and SQL development experience
• Database management tools (SnapManager for SQL (highly preferred), DBArtisan, RedGate, ER/Studio. ERWIN)
• Experience supporting web-based applications developed on WebSphere/Java/Apache and IIS/.NET/Windows Server
• Experience with RedHat Linux Operating System as well as Windows server Operating System
• Platform Integration, Management, Monitoring, and Administration tools (WebSphere MQ, Microsoft Operations Manager, HP OpenView, NetApp SnapManager, SnapMirror, SnapRestore)

Education Requirements:

Recognized University Degree or College Diploma. Vendor training, courses and accreditations