Database Administrator

Internal Job Title : Database Administrator

Job Type : Permanent, Full-Time

Job Location : Richmond, Virginia / Remote (VA, WI, NY, NC, SC)

Work Model : Hybrid

Position Summary

As a Database Administrator in our North American Driver and Vehicle Solutions (DVIS) group , you will be responsible for designing, implementing, and maintaining the database systems that underpin our suite of driver information system solutions for our US customers (VA, NC, NY, and WI Department of Motor Vehicles ).

What We Can Offer You

Compensation : We seek long term relationships with our employees and recognize and reward them with a competitive total compensation package that includes :

A 401k with company matching contributions;

Paid time off (PTO);

Group health, dental, vision, and life insurance;

Access to employee and family assistance program; and

Access to virtual mental health and wellness apps.

Career : As a knowledge-based organization we will provide you with a wealth of learning opportunities and challenging work that will grow your knowledge, skills and abilities. At CBN STI, we encourage and empower our employees to chart their own career path, putting you in control of your future.

Culture : Personal character is the foundation of our culture. CBN STI’s 7 Core Principles shape and guide our behaviours and underpin the sense of community you will experience at CBN STI. Equity, diversity and inclusivity are important to us as an organization, and we are committed to fostering and developing a work environment where every employee is treated with dignity and respect.

What You Will Do

Database Design and Development

Design Database Structures : Create logical and physical database designs that meet application requirements and optimize performance.

Develop Schemas : Define and manage database schemas, including tables, indexes, views, and relationships.

Implement Data Models : Use Entity-Relationship (ER) diagrams and normalization techniques to ensure efficient data organization.

Conduct G rowth P rojections : and capacity planning to accommodate future growth

Database Installation :

Installa tion : Utilize orchestration tools to ensure consistency on installs

Query Optimization

Write SQL Queries : Develop complex SQL queries to retrieve, manipulate, and analyze data effectively.

Optimize Performance : Analyze query performance and implement indexing strategies to enhance data retrieval speed.

Stored Procedures and Functions : Create and maintain stored procedures, triggers, and user-defined functions to automate tasks and enforce business logic.

Data Security and Integrity

Implement Security Measures : Establish user roles and permissions to protect sensitive data from unauthorized access.

Ensure Data Integrity : Use constraints, transactions, and validation rules to maintain accurate and consistent data.

Performance Monitoring

Monitor Database Performance : Regularly track database performance metrics to identify bottlenecks or issues.

Tune Databases : Adjust configurations, indexes, and queries based on performance analysis to ensure optimal operation.

Collaboration with Development Teams

Work with Application Developers : Collaborate closely with software developers to integrate database solutions with applications.

Provide Technical Support : Assist development teams in troubleshooting database-related issues during application development.

Testing and Troubleshooting

Conduct Database Testing : Implement testing procedures to validate database functionality, performance, and security.

Debug Issues : Identify and resolve database errors or performance problems promptly.

Root Cause Analysis : W rite clear on concise reports on root cause of incidents.

Backup and Recovery Management

Manage Backups : Establish regular backup schedules to ensure data is securely backed up.

Develop Recovery Plans : Create disaster recovery plans to restore databases in case of failure or data loss.

Documentation

Create Technical Documentation : Maintain comprehensive documentation of database designs, processes, standards, and procedures for future reference.

Update Documentation Regularly : Ensure that all documentation reflects current practices and system configurations.

Qualifications

Knowledge and Experience

Bachelor ’s degree in Computer Science / Engineering (or related field) or equivalent combination of relevant education and years of work experience

Oracle and / or Postgre SQL certifications are assets, but not required

Knowledge of the following :

Database design principles and data modeling

ETL processes and data warehousing concepts

Data security best practices

Cloud based database services

Agile development methodologies

ITIL processes

5 years of database administration experience

Technology

O / S : Linux

DBMS : Oracle (ASM) and Postgres

Query Languages : SQL

Scripting Languages : Python, Bash

Cloud : AWS / Azure

Configuration / Orchestration : Puppet, Ansible , Chef

Soft Skills and Characteristics

Critical thinking skills

Analytical skills, problem solving skills

Interpersonal skills

Communication, Teamwork and Collaboration

Organization and time management skills

Attention to detail

Self-directed

MANDATORY REQUIREMENTS

Must be legally eligible to work in the USA

Fluency in English

Ability to travel domestically / internationally approx. 3 - 4 weeks / year

About Us

CBN Secure Technologies, Inc. (CBN STI) is a wholly owned subsidiary of Canadian Bank Note Company, Limited (CBN). CBN STI is a leader in the manufacture and production of award-winning polycarbonate identification products (Driver’s Licence and Identification (DL / ID) cards) for various US states, including Virginia, North Carolina, New York, and Wisconsin.

CBN designs and develops industry leading solutions for the following domains : Driver and Vehicle, Border Security, Civil Identity, Currency and Excise Control, and Lottery and Charitable Gaming. To learn more, visit www.cbnco.com .

Equal Opportunity Employer

As an Equal Opportunity Employer, CBN STI strives to achieve a workforce that reflects the diversity of the American population. We encourage applications from women, people of color, LGBTQIA individuals, people with disabilities, and others from minority groups and diverse backgrounds.

CBN STI is also 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.