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 Sr Lead Cloud Architect at Cox Communications is responsible for guiding customers in migrating to and operating in 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 position requires a strong background in cloud technologies, database administration, and architecture, with a commitment to helping customers solve complex problems in the cloud.

Responsibilities

• Collaborate closely with colleagues and customers to solve data challenges.
• Assess and remediate sizing/performance/configuration issues.
• Plan and execute data migrations, either independently or as part of larger cloud migration efforts.
• Modernize database platforms from MSSQL/Oracle to PgSQL/Aurora.
• Design and implement data lakes and ETL pipelines.
• Provide consulting guidance to customers and prospects, assisting colleagues with planning and writing 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, with 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 manage data in 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 Healthcare/HealthTech, Financial Services/FinTech, SaaS, or E-Commerce.

Benefits

• Flexible vacation with pay based on duties and company needs.
• Seven paid holidays throughout the year.
• Up to 160 hours of paid wellness annually for personal or family wellness.
• Paid time off for bereavement, voting, jury duty, volunteering, military leave, parental leave, and COVID-19 vaccination leave.
• Comprehensive healthcare benefits from day one, with options for individuals and families.
• 10 days of free child or senior care through Care.com membership.
• Generous 401(k) retirement plans with up to 8% company match.
• Inclusive parental leave policies, comprehensive fertility coverage, and adoption assistance.
• Employee discounts on various items and services.
• Free internet, premium cable, and smart home automation in applicable markets.
• Pet insurance options.