Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Internal Job Title: Database Administrator
Job Type: Permanent FullTime
Job Location: Ottawa ON
Work Model: Hybrid
Position Summary
As a Database Administrator (DBA) in our North American Service Delivery group you will be responsible for designing developing and deploying highly secure database solutions for our Canadian federal and provincial government customers. In this position you will provide ongoing support and tune and optimize their performance to ensure they remain highly available reliable and secure.
Responsibilities
- Database Design and Implementation:
- Design implement and maintain database systems to meet organizational requirements. Collaborate with System Architects to plan DBMS capacity and hardware requirements.
- Database Deployment:
- Install and configure the production system locally in advance of shipment to customer site. Train and support Developers and Local Service Providers (LSPs).
- Database Migration:
- Define database migration strategy and design replication topology and methodology. Develop migration procedures/scripts and perform the migration.
- Performance Monitoring and Tuning:
- Monitor database performance identify issues and optimize database performance.
- Security Management:
- Ensure database security by implementing access controls encryption and other security measures.
- Backup and Recovery:
- Develop and implement backup and recovery plans to protect data integrity.
- Troubleshooting and Support:
- Provide support for databaserelated issues including troubleshooting and resolving problems.
- Documentation:
- Create and maintain documentation for database configurations schemas changes processes and procedures.
Qualifications :
Knowledge Experience and Skills
- Education: Bachelors degree in Computer Science Information Technology (or a related field) or an equivalent combination of relevant education and work experience.
- Certifications: Oracle Certified Professional (OCP) Microsoft Certified: Azure Database Administrator Associate or similar certifications are assets.
- Knowledge: Database management principles data modeling SQL database security practices database tuning and optimization database backup and recovery basic networking concepts including TCP/IP DNS DHCP and network security practices.
- Experience: 47 years of experience in database administration.
- Soft Skills: Strong analytical and problemsolving skills excellent communication abilities attention to detail and the ability to work independently and as part of a team.
- Competencies: Organizational skills adaptability a proactive approach to identifying and solving issues and a strong sense of responsibility and accomplishment in completing tasks and achieving goals.
Technical Environment
- Operating Systems: Linux Windows Server
- Database Management Systems: Oracle PostgreSQL Mongo DB NoSQL (Elasticsearch)
- Virtualization: VMware HyperV XCPng
- Containerization/Orchestration: Docker Kubernetes
- Deployment/Configuration: Puppet Terraform Ansible Bicep Helmchart
- SQL and Scripting: SQL Python PowerShell Bash Ruby
- Security: Active Directory Kerberos LDAP TLS Bitlocker LUKS
- Cloud Platforms: AWS RDS Azure SQL Database
- Tools: Git tcpdump Wireshark PowerCLI Sysinternals Suite BIRT
Mandatory Requirements
- Language(s): Fluency in English (reading writing speaking)
- Work Hours: Ability to work oncall rotation (1 week on 3 weeks off)
- Travel: Ability to travel domestically/internationally (passport required) approx. 2 weeks/year
- Security Clearance: Ability to obtain (in a timely manner) maintain Government of Canada Secret (Level II) clearance
Additional Information :
Canadian Bank Note Company (CBN) is committed to fostering a diverse and inclusive workplace where all employees are treated with dignity and respect. We are proud to be an equal opportunity employer and do not discriminate on the basis of race color religion sex national origin age disability veteran status sexual orientation gender identity or any other legally protected status.
We provide equal employment opportunities to all individuals including women Indigenous Peoples persons with disabilities visible minorities and members of the 2SLGBTQ community. Our commitment to equity extends to all aspects of employment including recruitment hiring promotion compensation benefits training and development. As part of our commitment to providing an inclusive barrier free selection process we ask that if you are contacted regarding the competition for this position you advise the interview coordinator or any accommodation measures you may require.
At CBN we value the unique perspectives and experiences that each employee brings to our organization and we are committed to maintaining a workplace that reflects the diverse communities we serve. We believe that diversity and inclusion drive innovation and success and we strive to create an environment where every employee can thrive and contribute to our collective goals.
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
