Senior Lead Cloud Database Architect (MSSQL Focus) - RapidSc

Cci Services - Denver, CO

Full-time - Senior

Denver, CO

Construction of Buildings

About the position

The Senior Lead Cloud Database Architect at RapidScale is responsible for guiding customers through the migration and operation of their databases in cloud environments such as AWS, Azure, and GCP. This role focuses on addressing data challenges, modernizing database platforms, and designing data lakes and ETL pipelines, while collaborating with both colleagues and clients to ensure successful cloud integration.

Responsibilities

• Collaborate closely with colleagues and customers to solve data challenges.
• Assess and remediate sizing/performance/configuration issues.
• Plan and execute data migrations, alone or as part of larger cloud migration efforts.
• Modernize database platforms (MSSQL/Oracle->PgSQL/Aurora).
• Design and implement data lakes and ETL pipelines.
• Provide consulting guidance to customers and prospects, assist colleagues with the planning and writing of Statements of Work.

Requirements

• A BA/BS Degree with 8 years of relevant overall experience, or a MS degree with 6 years of relevant overall experience, or a Ph.D and 3 years of experience, or 12 years of overall relevant experience without a college degree.
• 8+ years of diverse database administration and architecture experience, and a minimum of 3 years of relevant public cloud experience.
• Specialty/Intermediate level AWS and/or Azure cloud data certification (AWS Database Specialty, DP-100, DP-203, DP-300, DP-500).
• Expert level familiarity with at least one of the following SQL Databases: PostgreSQL, MSSQL, Oracle, both on-prem and in the cloud (AWS RDS, Azure SQL, etc.).
• Expert level familiarity with at least one of the following NoSQL Databases: MongoDB, DynamoDB, Redis, Cassandra, CouchDB, Cosmos, ElasticSearch/OpenSearch.
• Hands-on experience using ETL tools to get data into and out of databases and data warehouses/data lakes.
• Intermediate level experience with one or more Infrastructure-as-Code implementations (ARM, CloudFormation, Terraform).
• Familiarity with Identity and Access models in on-prem (Active Directory), public cloud (AWS IAM, Azure AD), and in-schema.
• Hands-on experience running migration tools, including but not limited to: backup/restore, log shipping/mirroring, Always On Availability Groups, AWS Database Migration Services, Schema Conversion tool, Azure Migrate, Azure Data Migration Assistant, AWS Glue.

Nice-to-haves

• Professional/Expert level Cloud Architecture certification (AWS Certified Solutions Architect - Professional, AZ-305).
• Intermediate to expert level familiarity with a commercial analytics or data warehousing platform such as Databricks, Snowflake, RedShift, Azure DataLake.
• Experience with AI/ML applications and pipelines.
• Industry knowledge in any of the following verticals is highly desired: Healthcare/HealthTech, Financial Services/FinTech, SaaS, E-Commerce.

Benefits

• Best-in-class benefits package including healthcare options from day one.
• Professional development and continuing education support.
• Flexible work schedules and time-off policies.
• Competitive salary package with bonus and incentive plans.
• 10 days of free child or senior care through Care.com.