OPPORTUNITY, EXPERIENCE, REWARDS, RECOGNITION, TRUST
... The Dominion has been serving the insurance needs of Canadians for more than 100 years. Still 100% Canadian owned, today we are one of Canada's largest property and casualty insurance companies. With offices across Canada and nearly 1200 employees, we are proud to provide high quality home, automobile and business insurance products to Canadians.
When it comes to the work environment, The Dominion is a big company that acts like a small company. We pride ourselves on transparency, where team players flourish through openly sharing ideas.
The Dominion has a multi-faceted integrated systems environment comprised of Java-based web applications, legacy mainframe systems, end-user client computing, and a business intelligence environment. The web applications run in a WebSphere/Oracle environment on our AIX platform and are developed in Java following J2EE standards. The legacy systems run in a CICS/COBOL environment on our z/OS mainframe.
We have an established Enterprise Architecture that is used to guide updates and improvements to the application and infrastructure portfolios. We use a Software Development Lifecycle Methodology and a Project Management Methodology, and employ standards in executing the projects. Clarity and Open Workbench are used to assist in planning and monitoring our project portfolios.
This position reports into the Data Centre Management (DCM) team. In DCM, we support and maintain a secure, stable, scalable and highly available technical infrastructure environment that meets the needs of the business in a proactive manner. We strive for operational excellence to achieve a high level of customer satisfaction in a cost-effective manner which is in-line with the expectations of the business. And finally, we safeguard the company and client information.
The Senior Database Administrator manages the corporate database environments to ensure the provision of current, responsive, available, and cost-efficient operations. You will ensure database integrity and security in order to provide a secure, reliable and consistent environment. You will advise on and implements effective and recoverable database technologies designed to meet The Dominion's business goals. You will work with a high level of autonomy.
As a key member of the Data Centre Management team, you are resourceful, analytical and methodical in your approach to technical challenges. You are a quick learner with the ability to easily assimilate information from a variety of sources, from user and administration guides through to support forums, to help arrive at practical and efficient solutions. You are results-oriented and leverage consultative, collaborative, and facilitation skills to implement and support applications effectively and professionally. You produce high quality work and ensure that solutions are cost effective, align with solutions architecture and company standards, and meet business requirements. You also have strong leadership skills and exhibit the ability to foster collaboration and consensus among your peers. You are open to working flexible hours in order to accommodate system promotes and to provide extended and on-call support. You enjoy being part of a company large enough for career opportunities, yet small enough to provide a sense of belonging and give you the chance to make a difference.
- Manages host and distributed database environments to provide current, responsive, available and cost efficient operations.
- Provides support, as needed to Application Services.
- Designs and tunes database environments to ensure applications meet performance requirements and to ensure that there is no unauthorized access.
- Creates all levels of database environments to enable development and testing for production.
- Participates in the development of standards and procedures for all new database methodologies used by The Dominion in order to ensure a consistent architecture. Ensures that standards are adhered to.
Minimum - Seven years progressive experience in an enterprise environment, including at least three years DBA experience and practical programming experience.
Minimum - Three year college diploma with a major in computer science, or, equivalent experience. Platform Certifications are an asset.
As the ideal candidate, you have a breadth of knowledge and experience in the end-to-end enterprise environment (including basic knowledge of computer networks, processor technologies and storage subsystems) and detailed knowledge of server and mainframe computing environments (including AIX and Windows Operating Systems and Java/WebSphere/Oracle-based n-tier applications) and understand the interconnectivity among the components. You have in-depth knowledge of major DBMS's including Oracle and SQLServer. You are proficient in the use of database utilities and related tools, including backup and recovery, and have a strong knowledge of database internals (i.e. catalogue structures, buffer pools, APIs). You have extensive knowledge of relational database concepts and experience in the use of a Structured Query Language, preferably SQL. You have a strong knowledge of and practical experience with the ITIL service management processes, and display the ability to view the services IS offers from a business point of view. Knowledge of WAN, LAN, network operating systems, Windows OS, MS Office Suite products, routers and Internet firewall technology, telecommunications, personal computer hardware, SAN, and infrastructure management software and processes are assets.
Technical ability, team player, ability to learn, written communication, service oriented,
flexible/adaptable, analytical, organisation and planning.