Senior Database Administrator
REF: #001
ADGA is hiring a Senior Database Administrator to join our team that provides development and in-service support of Human Resources (HR) Enterprise Resource Planning (ERP) applications, including the Human Resources Management Systems, Military Pay Systems, Military Command Software Centre, Defence Learning Network etc. to our DND client and Canadian Armed Forces members.
Tasks will include, but not limited to:
- Provide guidance to client team members on techniques to apply as well as existing coding structures in programming and program coding.
- Configure application software by establishing performance parameters and customizing details to achieve optimal technical performance.
- Monitor application load and software to achieve optimal technical performance
- Provide technical support to development staff for the Oracle client installation
- Manage DND Oracle application environment – Production, Training, Staging and Integration environments.
- Work with SSC staff, manage applications running on SSC mainframe Linux hardware.
- Proactively manage the DND Oracle Enterprise DB management configuration and recommend future hardware upgrade and software requirements
- Investigate violations of security and report incidents of hacking attempts to the Technical Authority.
Qualifications
- Must demonstrate at least 10 years of experience as a Database Administrator.
- Experience as an Oracle Database Administrator for large organizations (20,000 users with 2000+ concurrent users) managing, supporting and tuning large production databases and hosting servers.
- Experience modeling, designing and developing HRMS (Human Resources Management System) applications.
- Experience configuring and managing Active Data Guard.
- Experience configuring and managing Oracle Advanced Security.
- Experience configuring and providing technical support for Oracle databases running over IMB Z Systems.
- Ideal candidates will have a College/CEGEP Diploma or University Degree.
Additional Information
- Must hold a valid Secret level 2 clearance with PSPC and obtain a Controlled Goods Certificate.
- Will need to be on call every weekend and weekdays to ensure the MCSC application environment will be maintained to be fully operational.
- Hybrid role. (Initial period, there will be a need to be on-site on a more regular basis)
*Our recruitment systems include artificial intelligence–enabled tools; however, AI is not used to screen, evaluate, or make decisions about applicants for this role.
*Unless otherwise stated, all job postings reflect a current vacancy at the time of publication.
Work-Life Balance
We strongly support a healthy and productive work-life balance. This starts with a flexible approach to work, and policies designed to support employees through their day-to-day routines and major life events. For example, we offer a Maternity/Parental Top-Up (up to 52 weeks) and a Reservist Leave Top-Up (up to 180 days).
Belong@ADGA
ADGA continuously strives to integrate advanced Diversity, Equity & Inclusion (DEI) approaches and practices into our work culture. Our employee-based DEI Committee explores activities and invites discussions that foster an environment where all employees feel valued, respected, and heard.
Compensation
Above and beyond our commitment to offer a competitive base salary, ADGA has a company-wide profit-sharing plan for all full-time and part-time employees.
Comprehensive Benefits and Total Rewards
We offer a comprehensive benefit program, providing employees with the choice between base or enhanced plans. Depending on the plan, ADGA pays for Health & Dental, a Health Spending Account, Short-Term Disability, an Employee Assistance Program, and a Telemedicine service. Also offered: discounts on gym memberships, 5,000+ perks through Perkoplis, a Deferred Profit Sharing Plan, and access to a wide range of other employee-centric services and savings programs.