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
Top Skills
What We Do
We translate strategy into long-term, sustainable, and measurable results by using our three-tier approach: Strategy, Capability and Execution.
We structure our work with clients around three critical questions:
1. STRATEGY — Are we doing the ‘right’ things?
Gut instincts alone are not enough to manage a growing enterprise. You need strong analytics to make the quantifiable strategic decisions that will drive your continued success. Capital spending and organizational initiatives must be aligned to the strategy.
We help you implement strategic alignment tools to prioritize your capital spending and strategic initiatives.
2. CAPABILITY — Are we ‘capable’ of doing the ‘right’ things?
Capability is the readiness of the company to navigate the path set by its strategy. The importance of capabilities was highlighted when research showed that some companies consistently outperformed others despite having similar strategies, market positions, value propositions and pricing.
Those leading companies were found to have superior capabilities that allowed them to perfect the implementation of their strategies.
We help you transform your organization and develop the capabilities required for strategy implementation. Our engagement is often structured around the four elements of capability: process, organization, systems, and performance.
3. EXECUTION — Are we ‘executing’ the ‘right’ things ‘right’?
Strategy and capability are essential to superior performance, but they alone are not sufficient for a company’s success. Excellence in execution is the third required ingredient.
Execution is about getting things done. Excellence in execution is about getting things done right every time.
Our involvement during the execution phase is usually categorized under one of the following categories or a combination thereof:
· Monitoring and measuring performance
· Outsourcing some of the client’s business functions
