Systems Developer (DBA)

Job title: Systems Developer (DBA)

Job description: Canadian Bank Note Company develops, deploys and supports complex, secure solutions for currency, border security, identification, excise and lottery operations around the world. As a Database Administrator at CBN, you will have the opportunity to broaden your skill set as you experience the full cycle of database design, development, testing, deployment and support through the stabilization period for governments countries throughout North America, the Caribbean and South America. You’ll even have the opportunity to travel to these locations during the deployment and stabilization periods so if you don’t already have a valid passport, you’d best apply for one soon!

Success in the role will be driven by your ability to function effectively as part of a team in a cyclical environment. We are looking for someone who is open to both providing and receiving help – our systems are quite complex, and collaboration within the team often speeds development. The ability to stay organized and focused is essential as each project has strict timelines that must be adhered to due to the missional critical nature of our applications. The role will require a diversified skillset (ANSI SQL, PL/SQL, PostgreSQL, BIRT, Crystal Reports, Oracle BI, XML, Bash, Powershell, Ruby, Cloud etc.), but if you don’t possess all of these, don’t despair…so long as you are passionate about technology and have an appetite for learning, we still want to hear from you.

You’ll get to work alongside a lot of smart people (Project Managers, Systems Architects, Software Developers and Testers, Support Engineers, etc.) so good interpersonal skills will be a definite asset, especially when you are deployed at the customer’s site where you will see the project come to fruition.

What you can expect to do:

On a daily basis…

• Design and develop database applications. This will require the development of database SQL scripts to create database objects; designing relational databases as required; designing and developing database replications; designing and developing effective reports; developing, implementing, and testing backup and recovery plans; monitoring databases and tuning them to ensure they meet performance requirements.

• Create and maintain system environments. Develop Puppet classes and templates to automate server environments; deploy software that ensures compatible versions of frontend and backend database software and configuration; maintain functional development and test environments and ensure the data is consistent in all databases; troubleshoot system issues and liaise with developers and testers to pinpoint issues and provide fixes.

Two to three times a year…

• Deploy systems. Calculate the hardware requirements for the size of the database and system required and then install and configure the production system locally in advance of shipping to customer site. Travel to customer site to for deployment of hardware and system launch. Migrate data and provide training and support to Developers and local service providers.

• Provide system support through stabilization period. Stabilize the system and fix performance issues by monitoring and responding to production alerts pro-actively and provide first line support for any issues. Tune live system and deploy software updates as required. Write system documentation and handover to the Support team once stabilized.

Our ideal candidate has university degree in Computer Science/Engineering (or related field) and is okay with international travel and being on-call as required. Experience with all aspects of database administration is an asset, but we are also very open to considering recent graduates whose knowledge may fall more on the theoretical side rather than the practical side. A willingness to learn no matter what your experience level is an absolute must, as is eligibility for Government of Canada Secret (Level II) clearance.

As an Equal Opportunity Employer, Canadian Bank Note Company, Limited is committed to achieving a skilled and diversified workforce that reflects the diversity of the Canadian population. We encourage applications from women, visible minorities, people with disabilities and Aboriginal people. Canadian Bank Note Company Limited is committed to developing inclusive, barrier-free selection processes and work environments. If contacted regarding this competition, please advise the interview coordinator of any accommodation measures you may require.

Company: Canadian Bank Note Company

Expected salary:

Location: Ottawa, ON

Job date: Sat, 29 Oct 2022 22:42:20 GMT

Job Source: Careerjet.ca

Click Here to Apply