DBA / SQL Developer

ROSS; Mississauga; On-site; CAD 65,000 - 95,000; Full time

Job summary

An established industry player is seeking a skilled Database Administrator to ensure the stability and performance of critical database environments. This role involves technical administration, SQL development, and data modelling, requiring advanced troubleshooting skills and experience with various database management tools. The successful candidate will work closely with developers and support staff, providing vital operations support to maintain an 'always on-call' function. If you are passionate about database management and thrive in a dynamic environment, this opportunity is perfect for you.

Qualifications

• Experience in data modelling and SQL development is essential.
• Familiarity with database management tools is highly preferred.

Responsibilities

• Ensure databases are stable and accessible via applications.
• Monitor performance and report any issues to management.

Skills

Data modelling

SQL development

Database management tools

Advanced troubleshooting

Platform Integration

Education

Recognized University Degree

College Diploma

Tools

SnapManager for SQL

DBArtisan

RedGate

ER/Studio

ERWIN

WebSphere MQ

Microsoft Operations Manager

HP OpenView

NetApp SnapManager

SnapMirror

SnapRestore

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:

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

Operations support

1. Maintaining critical environments in an “always on-call” function; being responsible for multiple environments that span both transactional and batch/report type database environments.
2. Advanced troubleshooting skills in client/server environments, detailed root-cause analysis, efficient/effective problem resolution.
3. 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 proactive and timely manner.

You must have:

1. Data modelling and SQL development experience.
2. Database management tools (SnapManager for SQL (highly preferred), DBArtisan, RedGate, ER/Studio, ERWIN).
3. Experience supporting web-based applications developed on WebSphere/Java/Apache and IIS/.NET/Windows Server.
4. Experience with RedHat Linux Operating System as well as Windows server Operating System.
5. 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.

Click here to apply online