Under the general direction of the Business Systems Manager, the SQL Developer is responsible for Database Administration, writing complex SQL queries, designing and maintaining relational database schemas, optimizing data access patterns, and supporting ETL and reporting workflows using SQL Server Management Studio (SSMS) and Oracle-based platforms.
The SQL Developer will also administer billing and activations databases for security, performance, maintenance, and integrations, along with other administrative duties. If you are looking for a position with clear ownership and a direct impact on operational success, this is the role for you!
Duties and responsibilities:
- Install, configure, and maintain database management systems (DBMS) such as SQL Server, PostgreSQL, MySQL, or Oracle.
- Continuously monitor database performance and tune queries, indexes, and configurations to ensure optimal speed and efficiency.
- Write, test, and optimize SQL queries, stored procedures, and scripts to support reporting, data analysis, integrations, and business system processes.
- Develop and implement backup strategies and disaster recovery plans to prevent data loss and ensure business continuity.
- Manage user access, permissions, and encryption to protect sensitive data and ensure compliance with security policies.
- Ensure data accuracy, consistency, and high availability through proper design, replication, and failover mechanisms.
- Collaborate with IT/developers and analysts to design efficient database structures, schemas, and data models.
- Diagnose and resolve database issues, including downtime, slow queries, and system errors.
- Monitor storage and system usage trends to plan for future growth and scale databases as needed.
- Automate routine database tasks such as backups, updates, and monitoring using scripts and tools.
- Maintain documentation of database systems, procedures, and policies, and ensure compliance with regulatory standards.
- Coordinate with other developers to ensure a mutual understanding of systems and timeline requirements.
- Monitor internal provisioning systems and report any abnormalities to the Business Systems Manager.
- Implementing and ensuring system airtime & billing requests are processed in a timely manner to meet our customers’ expectations. Follow-through communication on open carrier escalations and provisioning.
- Assist in other duties as assigned.
Qualifications:
- Bachelor’s degree/Diploma in Engineering/Computer Science or related field/experience
- Minimum 5 years of experience as a SQL developer/data base administrator
- Familiar with SQL (PostgreSQL, MySQL), and able to design/modify relational schemas, adapt Stored Procedures
- Familiarity or experience with replication
- Strong computer skills, especially Microsoft Excel.
- Organized and detail oriented.
- Good verbal and written communication skills
- Enthusiastic and personable, with the ability to adapt and thrive in constant change.
- Collaborative individual with a positive attitude
- Must be able to work independently in a fast-paced environment.
- Dependable, self-starter and self-motivated, innovative problem solver
- Must be able to work flexible hours including some evenings as needed.
- Willingness to embrace and live the core values of Network Innovations.
- Familiar with Linked SQL Services
- Strong knowledge of SSMS and Oracle databases.
Nice to have
- API Integration experience
- Knowledge in Power BI
- Experience with NetSuite ERP
Direct reports:
Working conditions:
This position typically operates in a professional office environment. Standard office hours are 8am to 5pm, however, work outside of regular office hours and occasional travel will be required. This role routinely uses standard office equipment and software.
Physical Requirements
- Sitting and using a computer for extended periods of time.
Benefits:
- Competitive salary
- Great culture. BBQs and company events!
- Employer Paid Health, Dental, and Insurance plan.
- Additional Life and Critical Illness insurance options
- Health Spending Account
- Employee Family Assistance Program (EAP)
- Company Matched RRSP or TFSA
- On-site Parking
- Hybrid work environment. 3 days in-office and 2 days remote per week.
- Full-time, Permanent
About Network Innovations
Keeping people connected anywhere on the planet is more than just our expertise – it’s our mission. Network Innovations is a technology and systems integrator that provides secure and seamless global communications solutions. Our customers conduct some of the most important work on the planet, whether it’s helping a remote island rise again after a hurricane, defending a country's borders, preventing a catastrophic power grid failure… you get the deal. What this means for our team is that we come to work each day knowing that it matters. We’re forward thinkers and problem solvers who thrive on challenges. Determination, integrity, humility, and respect are at our core. If you’re looking to grow with an organization that values collaboration, diversity, and learning, you’re in the right place.
Network Innovations is committed to fostering a diverse and inclusive work environment. We live our core values and look to them to drive business results and help our customers conduct some of the most important work on the planet. We believe a diverse global workforce allows us to create customer intimacy and sustained profitability. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, age, national or ethnic origin, marital status, family status, disability, genetic characteristics. Whether you are starting your career or have decades of experience, we welcome you to join our mission to connect our world securely and seamlessly.
Accommodations during the application process are available upon request. While we appreciate all applicant submissions, only those considered to be most qualified will be contacted for further assessment.
Benefits:
- Dental care
- Employee assistance program
- On-site parking
- Paid time off
- RRSP match
- Vision care
Application question(s):
- Are you able to reliably commute to our Calgary office for this position?
- Please describe your experience with SQL (such as PostgreSQL or MySQL), SQL Scripts, relational schema design, and stored procedures.
- How many years of experience do you have as a SQL developer, working with API integrations and please describe your experience in this area?
Work Location: Hybrid remote in Calgary, AB T2G 4B7
