Principal Cloud Database Architect

Partner.Co
Full_time

Based on the provided job listing, here's the enhanced job description following the specified format:

📍 Job Overview

  • Job Title: Principal Cloud Database Architect
  • Company: Partner.Co
  • Location: Remote (Lehi, Utah, US)
  • Job Type: Remote
  • Category: Database Administration
  • Date Posted: 2025-06-20
  • Experience Level: Senior

🚀 Role Summary

The Principal Cloud Database Architect will serve as the primary guardian of our mission-critical database systems supporting global operations across 60 countries. This role combines deep Oracle expertise with proficiency in modern cloud database technologies including PostgreSQL, MySQL, and AWS serverless architectures. The CDA will ensure optimal performance, reliability, and security of existing Oracle environments while actively supporting our cloud transformation initiative through expertise in AWS database services and serverless computing.

💻 Primary Responsibilities

  • Database Management & Optimization:

    • Manage and optimize Oracle, PostgreSQL, and MySQL database systems supporting mission-critical applications.
    • Perform advanced database tuning across multiple platforms, including query optimization, index management, and performance monitoring.
    • Develop, maintain, and optimize complex PL/SQL procedures, functions, and packages, as well as stored procedures in PostgreSQL and MySQL.

  • Cloud Database Migration & Architecture:

    • Design and implement serverless database architectures using AWS Lambda and managed database services.
    • Collaborate with engineering teams on database architecture decisions for migration to AWS.
    • Implement database security best practices and ensure compliance with global data protection requirements across all platforms.

  • Database Backup, Recovery, & Disaster Recovery:

    • Design and execute database backup, recovery, and disaster recovery procedures for multi-platform environments.
    • Monitor database performance across Oracle, PostgreSQL, and MySQL environments and proactively identify optimization opportunities.

  • Legacy System Maintenance & Cloud Transformation:

    • Support legacy system maintenance while leading cloud database migration initiatives.
    • Provide 24/7 on-call support for critical database issues across all platforms.

  • Database Documentation & Knowledge Transfer:

    • Create and maintain comprehensive database documentation and procedures for multi-database environments.
    • Share knowledge and best practices with the team through mentoring and collaborative documentation.

🎓 Skills & Qualifications

Education:

  • Bachelor's degree in Computer Science, Information Systems, or related field.

Experience:

  • 5+ years of database administration experience with Oracle as primary focus.
  • Additional experience with PostgreSQL and MySQL administration.
  • Experience with AWS database services (RDS, Aurora, DynamoDB) and serverless architecture knowledge.
  • Background supporting global, distributed systems preferred.

Required Skills:

  • Expert-level Oracle database administration experience (11g, 12c, 19c, 21c).
  • Advanced PL/SQL development and optimization skills.
  • Deep expertise in Oracle performance tuning, including execution plan analysis and query optimization.
  • Proficiency with Oracle Enterprise Manager, AWR reports, and performance monitoring tools.
  • Experience with database security, backup/recovery, and high availability solutions across multiple platforms.
  • Knowledge of Oracle partitioning, indexing strategies, and storage optimization.
  • Experience with cloud database migration strategies and multi-database environments.
  • Background in database replication, data integration, and ETL processes.
  • Understanding of database design principles and data modeling across SQL and NoSQL platforms.
  • Knowledge of Oracle GoldenGate or similar replication technologies a plus.

Preferred Skills:

  • Proficiency with AWS Lambda, serverless computing, and event-driven database architectures.
  • Experience with large-scale, mission-critical database environments across multiple platforms.
  • Background supporting global, distributed systems.

💰 Compensation & Benefits

Salary Range:

  • The salary range for this role is not specified in the job listing. Based on industry standards for a senior database administrator role with extensive experience and remote work, the estimated salary range is $150,000 - $200,000 per year. This range is inclusive of the full-time salary and any additional compensation components such as bonuses or stock options.

Benefits:

  • Health Benefits: Including Medical, Dental, and Vision insurance, as well as HSA contributions.
  • Flexible Paid Time Off: Take the time you need, plus 11 company holidays!
  • 401(k): We match 100% up to 3% of your contribution, and then another 50% up to 5% of your contribution. We guarantee Safe Harbor immediate vesting.
  • Mental Health Benefits: All employees have access to our Employee Assistance Program (EAP), giving you free mental health resources and helpful tools.
  • Supplemental Benefits: Including 100% company paid Basic Life & AD&D insurance and long & short-term disability coverage.
  • Legal Services: Consult with attorneys for free if the need ever arises, and receive resources for creating legal documents, filing taxes, etc.
  • Effective Products: Gain access to our full range of health & wellness products.

🌐 Team & Company Context

Company Culture:

  • Industry: Financial technology and services.
  • Company Size: Medium-sized (100-249 employees).
  • Founded: 2018.
  • Team Structure: The database team is part of the broader engineering organization, working closely with development, QA, and DevOps teams to ensure optimal performance and reliability of our global systems.

Development Methodology:

  • Agile Methodology: The team follows Agile/Scrum methodologies and sprint planning for database development and maintenance tasks.
  • Code Review & Quality: The team emphasizes code review culture and peer programming practices to ensure high-quality database design and implementation.
  • Deployment Strategies: The team uses CI/CD pipelines and automated deployment strategies to ensure efficient and reliable database management.

📈 Career & Growth Analysis

Web Technology Career Level:

  • Senior Database Administrator: This role represents a senior-level position in the database administration career path, focusing on mission-critical systems, cloud migration, and team leadership.

Reporting Structure:

  • The Principal Cloud Database Architect reports directly to the Director of Database Engineering, working closely with other senior database administrators and the broader engineering leadership team.

Technical Impact:

  • The Principal Cloud Database Architect has a significant influence on the performance, reliability, and security of our global database systems, ensuring optimal user experience and data protection for our customers.

🌟 Work Environment

Office Type:

  • Remote: The role is fully remote, with no requirement to work from a company office.

Office Location(s):

  • The primary remote work location is Lehi, Utah, US, with the flexibility to work from other remote locations within the United States.

Work Schedule:

  • The work schedule is flexible, with a focus on maintaining 99.99%+ uptime for mission-critical systems and supporting global team collaboration.

📄 Application & Technical Interview Process

Interview Process:

  1. Screening Interview: A 30-minute call to discuss your experience, skills, and career goals.
  2. Technical Deep Dive: A 60-minute technical interview focusing on your database administration experience, performance tuning, and cloud migration strategies.
  3. Final Interview: A 30-minute meeting with the hiring manager to discuss your fit for the role and the company culture.

Portfolio Review Tips:

  • Highlight your experience with mission-critical database systems, cloud migration projects, and performance optimization strategies.
  • Include specific examples of your PL/SQL development and optimization skills, as well as your experience with AWS database services and serverless architectures.
  • Showcase your ability to manage and optimize multi-database environments, and discuss your approach to database security, backup, and disaster recovery.

Technical Challenge Preparation:

  • Brush up on your knowledge of Oracle, PostgreSQL, and MySQL database administration, as well as your experience with AWS database services and serverless computing.
  • Review your understanding of database performance monitoring, query optimization, and indexing strategies.
  • Prepare for questions about your experience with database replication, data integration, and ETL processes.

ATS Keywords:

  • Programming Languages: Oracle, PL/SQL, SQL, PostgreSQL, MySQL, AWS Lambda, JavaScript.
  • Web Frameworks & Libraries: None specified.
  • Server Technologies: Oracle, PostgreSQL, MySQL, AWS RDS, Aurora, DynamoDB, AWS Lambda, serverless architectures.
  • Databases: Oracle, PostgreSQL, MySQL, AWS RDS, Aurora.
  • Tools: Oracle Enterprise Manager, AWR reports, performance monitoring tools, AWS Management Console, AWS CLI, Git, JIRA, pgAdmin, MySQL Workbench.
  • Methodologies: Agile/Scrum, CI/CD, DevOps, serverless computing, event-driven architecture.
  • Soft Skills: Problem-solving, analytical thinking, communication, collaboration, leadership, mentoring, documentation, knowledge transfer.

📌 Application Steps

To apply for this Principal Cloud Database Architect position:

  1. Submit your application through the application link provided in the job listing.
  2. Prepare a portfolio showcasing your experience with mission-critical database systems, cloud migration projects, and performance optimization strategies.
  3. Tailor your resume to highlight your relevant database administration experience, skills, and achievements.
  4. Prepare for the technical interview process by reviewing your knowledge of Oracle, PostgreSQL, and MySQL database administration, as well as your experience with AWS database services and serverless computing.
  5. Research the company and its technology stack to demonstrate your understanding of the role and the company's cloud transformation initiative.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and web technology industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.

Application Requirements

Expert-level Oracle database administration experience and proficiency with PostgreSQL and MySQL are required. Candidates should have experience with AWS database services and a strong background in large-scale, mission-critical database environments.