Cloud Database Architect

CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit www.cbts.com.

OnX is a leading technology solution provider that serves businesses, healthcare organizations, and government agencies across Canada. OnX combines deep technical expertise with a full suite of flexible technology solutions—including Generative AI, Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, OnX delivers comprehensive technology solutions for its clients’ transformative business initiatives. For more information, please visit www.onx.com.

Essential functions

We are looking for a SQL Architect to spearhead end-to-end database design, development, and migration initiatives. The ideal

candidate will have extensive SQL design and development expertise. A good understanding of AWS services. You will be responsible

for ensuring optimal database performance, designing scalable data structures, and leading cloud integration efforts.

Key Responsibilities:

• Database Design & Architecture:
• Create scalable and efficient SQL database schemas tailored to enterprise needs.
• Develop data models (logical, physical, conceptual) that align with business requirements.
• Ensure adherence to best practices for performance, security, and maintainability.
• Plan and implement high availability and disaster recovery solutions.
• SQL Development & Optimization:
• Develop and optimize stored procedures, queries, and database code to meet performance SLAs.
• Conduct query tuning, indexing strategies, and database refactoring to ensure efficient execution.
• Collaborate with application developers to ensure best-in-class integration between the database and application tiers.
• Migration from On-Premise to AWS:
• Assess existing on-premise environments for migration readiness including data complexity, volume, and performance needs.
• Develop and execute detailed migration plans, including risk assessments, cutover strategies, and rollback procedures.
• Use AWS-native tools such as Database Migration Service (DMS), Schema Conversion Tool (SCT), or custom solutions to seamlessly transfer databases.
• Security & Compliance:
• Ensure security best practices in user management, data encryption (at rest and in transit), and data masking.
• Comply with relevant data governance and regulatory standards (GDPR, HIPAA, PCI-DSS, etc.) where applicable.
• Work with security teams to conduct periodic audits and implement remediation measures.
• Documentation & Maintenance:
• Maintain thorough documentation of database designs, migration plans, and AWS setups.
• Monitor database performance, conduct maintenance, and manage upgrades.

Required Qualifications:

• 10+ years in SQL database design, development, and administration.
• 1+ years working with AWS cloud services in a database-focused role.
• Experience deploying scalable database solutions in production.

Technical Skills:

• o Expert proficiency in SQL (e.g., T-SQL, PL/SQL) and RDBMS platforms
• o Strong understanding of database design principles (normalization, data modeling).
• o Hands-on experience with AWS database services (RDS, Aurora, Redshift) and migration tools (AWS DMS).
• o Skills in performance tuning, query optimization, and troubleshooting.
• o Familiarity with scripting languages (e.g., Python, Bash) for automation.
• • Soft Skills:
• o Exceptional problem-solving and analytical abilities.
• o Effective communication skills for technical and non-technical audiences.
• o Ability to juggle priorities and lead in a fast-paced setting