Cloud Data Analyst / Data Scientist (DBA Modernization)
- Pay Rate: $80.50hour, depending on experience
-
Contract Length: 6 Months
-
Location: Calgary, Alberta
Raise is currently hiring a Cloud Data Analyst / Data Scientist (DBA Modernization) on behalf of our client. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our Client is a technology company that combines decades of industry expertise with next-generation AI technology that helps organizations reinvent how they build, operate and deliver by pairing human ingenuity with agentic systems that scale intelligence across the enterprise.
Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable.
Description
This role represents the evolution of a traditional Database Administrator (DBA) into a cloud-focused data, engineering, and analytics specialist. The emphasis shifts away from legacy operational DBA maintenance (backups, manual patching, physical infrastructure) toward query performance optimization, cloud database configuration, workload remediation, observability, data analysis, and platform enablement. As a Cloud Data Analyst / Data Scientist (DBA Modernization), you will work within agile, cross-functional client teams—serving as the technical bridge between enterprise database modernization, modern cloud architecture,
Responsibilities
Primary Focus Areas
- Query Optimization & Performance Analysis: Deep-dive workload analysis, indexing strategies, and SQL tuning for cloud database environments.
- Cloud Database Configuration & Operational Support: Fine-tuning managed cloud databases (Azure SQL, Azure PostgreSQL, Oracle Cloud/RDS) for throughput, elasticity, and cost.
- Application Workload Assessment & Remediation: Evaluating application data access patterns, identifying bottlenecks, and refactoring queries or structures for cloud scale.
- Data Quality, Reporting & Analytics Enablement: Structuring modernized data layers to support business intelligence, advanced analytics, and data science initiatives.
- Monitoring, Observability & Incident Triage: Establishing telemetry, dashboards, and automated alert systems for early issue detection.
- Automation & Operational Efficiency: Implementing Infrastructure as Code (IaC) and CI/CD automation to reduce manual database overhead.
Key Responsibilities & Deliverables
- Deliverables expected from the role:
- Database Modernization & Migration Assessments: Conduct legacy database profiling (e.g., Oracle, SQL Server, PostgreSQL) and deliver detailed cloud migration readiness and refactoring plans.
- Query Performance Benchmarks & Tuning Guidelines: Produce optimized execution plans, query rewrite documentation, and re-indexing strategies to reduce latency and infrastructure costs.
- Telemetry & Observability Dashboards: Build operational and health monitoring dashboards (using Azure Monitor, Datadog, Prometheus/Grafana, or native cloud tools) tracking query latencies, I/O, and throughput.
- Capacity & Cost Optimization Reports: Regularly analyze cloud database resource utilization, recommend auto-scaling policies, and right-size compute/storage instances.
- IaC & Deployment Scripts: Create reusable Terraform/Bicep scripts or automated CI/CD pipelines for database provisioning, schema migrations, and configuration management.
- Analytics & Data Science Pipeline Enablement: Prepare, clean, and model modernized datasets to support downstream BI tools (Power BI, Tableau) or machine learning features.
Qualifications
- 5+ years of total experience working with relational databases, database administration, data engineering, or database performance optimization.
2+ years of hands-on experience in cloud database environments (Azure, AWS, or GCP) supporting enterprise application modernizations or migrations.- Technical Skills
- SQL Mastery: Advanced proficiency in ANSI SQL, stored procedures, execution plans, CTEs, window functions, and database-specific dialect optimizations (T-SQL, PL/SQL, PL/pgSQL).
- Cloud Database Platforms: Proven experience with managed database services (e.g., Azure SQL Database/Managed Instance, Azure Database for PostgreSQL, Amazon RDS/Aurora, Oracle Cloud DB).
- Performance Tuning & Observability: Strong grasp of index strategy, execution plan analysis, lock/block troubleshooting, memory tuning, and monitoring tools.
- Infrastructure as Code & Automation: Practical experience using Terraform, Bicep, ARM templates, Ansible, or CloudFormation for database automation.
- Data Science & Analytics Tools (Asset): Experience with Python (Pandas, NumPy), R, Power BI, or Databricks for data profiling, trend analysis, and predictive modeling.
- DevOps & CI/CD: Familiarity with Git, Azure DevOps, GitHub Actions, and automated schema migration frameworks (e.g., Flyway, Liquibase).
- Soft Skills & Consulting Acumen
- Consulting Mindset: Ability to translate complex database issues into clear technical recommendations for developers and business value summaries for stakeholders.
- Agile & Cross-Functional Collaboration: Comfortable working alongside application developers, cloud architects, product managers, and data engineers.
- Problem Solving & Triage: Calm and systematic under pressure when diagnosing production bottlenecks or data degradation issues.
Education and Certifications
- Bachelor’s or Master’s degree in Computer Science, Data Science, Information Technology, Computer Engineering, or a related quantitative field (or equivalent practical industry experience).
- Preferred Certifications (Candidates with one or more of the following will stand out to the hiring team):
- Microsoft Certified: Azure Database Administrator Associate (DP-300) or Azure Data Engineer Associate (DP-200 / DP-203)
- AWS Certified: Database – Specialty or AWS Certified Data Engineer – Associate
- HashiCorp Certified: Terraform Associate (or equivalent IaC certification)
- Databricks Certified Data Engineer Associate or Snowflake SnowPro Core (Asset)
Looking for meaningful work? We can help!
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or any other Raise job posting (or have any other questions), please contact us at +1 800-567-9675 or [email protected].
#WES
#LI-SC1
