Database Developer - SQL, Java

Astra North Infoteck Inc.; Vancouver; On-site; CAD 80,000 - 120,000; Full time

Job summary

A technology company is seeking a Database Engineer to develop and maintain database structures and Java applications. The role involves optimizing SQL queries and ensuring cybersecurity measures are implemented for CDN infrastructure. Candidates should have a Bachelor's degree in Computer Science or equivalent experience, with strong communication and teamwork abilities. The position is located in Metro Vancouver and supports cross-functional collaboration in a fast-paced environment.

Qualifications

• 5 years of experience in database and Java development.
• Experience in agile methodologies is a plus.
• Knowledge of networking protocols like HTTP, DNS, and TCP/IP.

Responsibilities

• Develop and maintain database schemas and optimize structures.
• Implement and maintain security measures for databases.
• Write and optimize complex SQL queries for performance enhancements.

Skills

Database Development

Java Development

SQL Query Optimization

Problem-solving

Team collaboration

Cybersecurity

Education

Bachelor’s degree in Computer Science

Tools

Oracle

SQL Server

MySQL

AWS

Java

React

Job description

Job Description

"Database Engineer

Database Development :

Develop conceptual, logical, and physical data models.

Create and maintain relational database schemas, optimizing table structures

Ensure data integrity and consistency through appropriate data modeling techniques.

Implement and maintain database security measures.

Writing and optimizing complex SQL queries, stored procedures and functions

Monitor database performance and identify areas for improvement.

Integrate data from various sources into a unified database environment.

Java Development :

Analysis, design and development of Java-based applications

High level and detailed application designs

Writing well designed, testable and efficient code ensuring code quality

Completing unit testing and supporting integration testing, End to End testing and UAT

Common :

Follow change management process

Work closely with project stakeholders to understand their data requirements, provide technical guidance and support.

Working cooperatively in a cross functional team environment

Experience in agile methodologies and ceremonies.

Technical competences required

Database Development :

• Strong understanding of database concepts, data modelling, and database technologies.
• Experience with any relational database is good (e.g., Oracle, SQL Server, MySQL)
• Advanced skills in writing, debugging and optimizing SQL queries
• Experience in data modelling techniques and database design principles
• Experience in identifying and resolving database performance issues
• Knowledge of AWS cloud platform

Java Development :

• Extensive experience in Java Development
• Strong understanding of object-oriented programming (OOP) principles
• Proficiency in Java frameworks like Spring and Hibernate

Knowledge in technologies - React, REST

Experience Required :

5

Requirements

Experience (Years) : 4-6 Essential Skills :

• Work with project teams throughout the organization to design, implement, and manage CDN infrastructure using Akamai, to ensure high availability, performance, and scalability for customer facing applications and business processes.
• Handle multiple priorities and assignments with excellence and precision.
• Be a part of a 24 / 7 / 365 organization (some after hours support is expected as part of normal on-call rotation).
• Directly support line of business development teams, provide guidance to them on implementation and changes for customer facing applications
• Develop and maintain security protocols and measures to protect CDN infrastructure from cyber threats.
• Monitor and analyze network performance, identifying and resolving issues to optimize content delivery of critical applications.
• Collaborate with cross-functional teams to integrate Akamai CDN solutions with existing systems and applications.
• Collaborate with information security teams to implement DDoS protection strategies and other security measures in the CDN.
• Provide technical support and guidance to clients and internal teams regarding CDN and security best practices.
• Work closely with vendor and professional service teams on delivery related activities and strategy. Qualifications :
• Bachelor’s degree in Computer Science, Information Technology, or a related field. OR similar work experience.
• Strong understanding of network protocols (HTTP / HTTPS, DNS, TCP / IP).
• Proven experience as a CDN Engineer or similar role, with a strong focus on cybersecurity.
• In-depth knowledge of Content Delivery Network technologies, including caching, load balancing, and content optimization.
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork abilities.
• Experience supporting 24 / 7 / 365 customer facing applications at enterprise scale.
• Awareness and experience with cybersecurity tools and practices, such as firewalls, intrusion detection / prevention systems, and encryption.
• Proficiency in scripting and automation (e.g., Python, Bash) a plus.
• Relevant certifications (e.g., CISSP, CEH) are a plus but not required.