Database Administrator - NA Service Delivery Group (USA)
Database Administrator - NA Service Delivery Group (USA)
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
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Internal Job Title: Database Administrator
Job Type: Permanent FullTime
Location: United States (Continental)
Work Model: Remote
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).
Responsibilities
- 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 EntityRelationship (ER) diagrams and normalization techniques to ensure efficient data organization.
- Conduct Growth Projections: and capacity planning to accommodate future growth
- Database Installation:
- Installation: 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 userdefined 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 databaserelated 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: Write 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
- Bachelors degree in Computer Science/Engineering (or related field) or equivalent combination of relevant education and years of work experience
- Oracle and/or PostgreSQL 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
Experience
- 5 years of database administration experience
Technical Environment
- 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 Competencies
- Critical thinking skills
- Analytical skills problem solving skills
- Interpersonal skills
- Communication Teamwork and Collaboration
- Organization and time management skills
- Attention to detail
- Selfdirected
MANDATORY REQUIREMENTS
- Must be legally eligible to work in the USA
- Language: Must be fluent in English (reading writing speaking)
- Travel: Ability to travel domestically/internationally approx. 34 weeks/year
Additional Information :
CBN STI is a subsidiary of Canadian Bank Note Company (CBN). CBN designs and develops industry leading solutions for the following domains: Border Security Civil Identity Driver Identification and Vehicle Information Currency and Excise Control and Lottery and Charitable Gaming. To learn more visit .
As an Equal Opportunity Employer CBN STI/CBN is committed to achieving a skilled workforce that reflects the diversity of the American population. We welcome and encourage applications from individuals of all backgrounds including but not limited to women visible minorities persons with disabilities Indigenous peoples and members of the 2SLGBTQ community.
CBN STI/CBN is also committed to developing inclusive barrierfree selection processes and work environments. If contacted regarding this competition please advise the interview coordinator of any accommodation measures you may require.
Remote Work :
Yes
Employment Type :
Fulltime
Employment Type
Remote
