DBA / SQL Developer

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.