Database Developer

Bridgenext is a digital consulting services leader that helps clients innovate with intention and realize their digital aspirations by creating digital products, experiences, and solutions around what real people need. Our global consulting and delivery teams facilitate highly strategic digital initiatives through digital product engineering, automation, data engineering, and infrastructure modernization services, while elevating brands through digital experience, creative content, and customer data analytics services. Don’t just work, thrive. At Bridgenext, you have an opportunity to make a real difference - driving tangible business value for clients, while simultaneously propelling your own career growth. Our flexible and inclusive work culture provides you with the autonomy, resources, and opportunities to succeed. We are looking for a Database Developer to work on complex problems requiring creative, data-intensive solutions in order to effectively and efficiently automate operations at scale. In this role, you will be expected to work autonomously and contribute to several high impact projects including optimizing all application touchpoints with the database systems. You will be working in CST business hours, which are 8 AM CST to 5 PM CST. You will also have on-call duties outside CST business hours as well and you will need to respond to high-priority incident pager. Responsibilities Enhance and optimize existing databases for peak performance Find bottlenecks in high volume OLTP environments and deliver optimal solutions Understand database execution plans and how to use the information to optimize code Monitor and analyze database performance and ensure effective and efficient utilization of database systems/processes Maintain a high bar for quality and performance of your product with vigorous attention to detail and automated testing Experience with continuous integration, delivery, desired state processes tools and constraints Set and maintain database standards Design and implement highly available database architectures using proven frameworks and tools Provide documentation and training to other Engineering stakeholders Closely collaborate with application developers and Product Managers and interact with stakeholders across the organization to optimize SQL code and database structures to continuously improve how we design, build, and ship software as a highly functional team Be a force-multiplier on the velocity and quality of your team Provide technical leadership on database systems and solutions Workplace: Full-time working hours. Remote, working from home, based in Canada and supporting Central Timezone business hours. Must Have Skills Be a technical leader with previous experience leading technical projects and show ownership of database design 5+ years of practical experience building and supporting Postgres and Azure SQL databases Extensive experience with query tuning and troubleshooting including indexing, ensuring proper join techniques, etc. Excellent SQL programming writing, maintaining and testing codes using “outside the box” approach Knowledge of scripting languages such as PowerShell, Python, Bash and other command line utilities Ability to understand complicated problems and craft into simple solutions that can be maintained by the rest of the team Ability to participate in and contribute to code management in GitHub including actively collaborating in peer-reviews, feature branches, and resolving conflicts and commits Previous experience providing individual mentoring and training on databases, best practices and tools Ability to recommend, test, and evaluate new technologies, software tools, and required skill sets; recommend and implement improvements Adaptable to change and able to work independently and as part of a team Strong sense of responsibility with a bias towards action Comfortable self-directing and prioritizing your own work Preferred Skills Previous Database Migration and SSIS/ADF exposure is an asset Azure experience preferred Exposure to NoSQL databases such as MongoDB a plus Experience with Kafka or similar distributed stream processing systems beneficial Expertise in database administration, including experience with a variety of database, cloud applications, and distributed processing technologies Professional Skills Excellent English written and verbal communication skills Excellent analytical, decision-making and problem-solving skills Strong team and individual player Maintains composure during all types of situations and is collaborative by nature High standards of professionalism, consistently producing high quality results Self-sufficient, independent requiring very little supervision or intervention Demonstrate flexibility and openness to bring creative solutions to address issues Bridgenext is an Equal Opportunity Employer Seniority level Mid-Senior level Employment type Full-time Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Bridgenext by 2x Get notified about new Database Developer jobs in Kanata, Ontario, Canada. #J-18808-Ljbffr