Senior Lead Cloud Database Architect (MSSQL Focus) - RapidScale

$142,100 - $236,800/Yr

Cox Communications

Full-time - Senior

Remote

Broadcasting and Content Providers

About the position

The Senior Lead Cloud Database Architect (MSSQL Focus) at RapidScale is responsible for guiding customers in migrating to and operating within cloud environments, specifically focusing on data and databases. This role involves collaborating with a professional services team to address data challenges, modernize database platforms, and design data lakes and ETL pipelines. The architect will also provide consulting guidance and assist in planning and writing Statements of Work.

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

• Flexible vacation policy allowing employees to take as much vacation with pay as they deem consistent with their duties.
• Seven paid holidays throughout the calendar year.
• Up to 160 hours of paid wellness annually for their own wellness or that of family members.
• Additional paid time off for bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, parental leave, and COVID-19 vaccination leave.
• Generous 401(k) retirement plans with up to 8% company match.
• Comprehensive healthcare benefits with options for individuals and families, including a potential free employee-only plan.
• 10 days of free child or senior care through Care.com membership.
• Employee discounts on hundreds of items, from cars to computers to continuing education.
• Free internet, premium cable, and smart home automation in applicable markets.
• Pet insurance coverage.