About the Role:
We are seeking a skilled and ambitious Database Design Consultant to join our growing technical solution design & implementation team. In this critical role, you will participate in all aspects of the software development lifecycle, from initial concept and design to implementation and maintenance. Your responsibilities will focus on designing and enhancing a high-performance, scalable, and reliable relational database that supports mission-critical applications and handles millions of records. Additionally, you will be one of several key contributors in bridging the gap between our frontend and backend developers by translating complex functional and technical requirements into clear, well-documented specifications.
Key Responsibilities:
- Participate in all phases of the software development lifecycle, including requirements gathering, design, development, testing, deployment, and maintenance.
- Serve as a subject matter expert on relational database design and advise our clients on what design choices best meet their needs.
- Design and develop database schemas, considering data models, scalability, performance, and maintainability.
- Scope and solution database integrations with various internal and external systems, including APIs, ETL processes, and other databases.
- Translate functional requirements into clear and actionable technical specifications for the development team, including database architecture and SQL query, procedure, and trigger parameters.
- Collaborate closely with frontend and backend engineers to ensure alignment and address any technical challenges.
- Effectively communicate with stakeholders across different departments, including product managers, engineers, designers, and business analysts.
- Present complex technical information in a clear and concise manner to both technical and non-technical audiences.
- Conduct code reviews and provide constructive feedback to other engineers.
- Identify and mitigate potential technical risks and challenges.
Qualifications:
Required
- Bachelor's degree in Computer Science, Computer Engineering, or a related field, or equivalent experience.
- Proven experience translating complex business requirements into clear and actionable technical specifications for SQL queries, procedures, and triggers.
- Strong experience in designing and developing large-scale relational databases, including data modeling, schema design, and performance tuning.
- Experience with Agile development methodologies
- Experience with database integration with various systems, including APIs, ETL processes, and other databases.
- Extensive SQL skills, including writing complex queries, optimizing performance, and troubleshooting issues.
- Excellent problem-solving, analytical, and communication skills.
- Ability to work independently and as part of a team.
Good to Have
- Experience with at least one modern front-end framework (React, Angular, Vue.js) and C# or Java
- Experience with developing in Oracle backends is a plus.
- Experience with cloud platforms (AWS, Azure, GCP)
- Experience with API design principles (e.g., OpenAPI Specification)
- Strong understanding of software design principles, including object-oriented programming, design patterns, and data structures
- Experience with microservices architecture