Cloud Database Architect (Remote) – AWS Redshift & Snowflake

Cognitive Medical Systems, Inc.; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

Cognitive Medical Systems, Inc. is seeking a Cloud Database Administrator for a remote role focused on CMS DDPS and PRS, supporting AWS Redshift Serverless, Snowflake, and relational databases.

You will design, administer, and secure data environments, optimize queries, manage backups, and work with Databricks. A Bachelor's degree and 6+ years in database administration are required, with 3+ years on cloud platforms.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 6+ years in database administration including 3+ years on cloud data platforms.
• Hands-on production experience with AWS Redshift Serverless and Snowflake.
• Experience with Amazon Athena query optimization and Amazon S3 data lake management.
• Databricks cluster and workspace administration experience.
• Strong SQL skills for performance tuning, schema development, and migrations.
• Experience with database security controls including encryption, IAM, audit logging, and vulnerability remediation.
• Ability to pass CMS and internal required background checks for public trust.

Responsibilities

• Administer, monitor, and optimize all DDPS/PRS database environments including AWS Redshift Serverless, Snowflake, Amazon Athena query optimization, and relational databases supporting application operations.
• Perform database performance tuning, query optimization, index management, and workload management across all platforms.
• Manage database backup, recovery, and high-availability configurations; validate backup integrity and support DR testing and RTO/RPO compliance.
• Support Databricks workspace administration including cluster management, job scheduling, and notebook/pipeline performance.
• Develop and maintain database schemas, stored procedures, and data migration scripts supporting application development and legislative implementation work.
• Ensure all database environments comply with CMS ARS security controls including encryption at rest and in transit, access control, audit logging, and vulnerability remediation timelines.
• Support database testing using DBFit/FitNesse; coordinate with the QA Manager on data quality validation and test environment database management.

Skills

SQL performance tuning

Data modeling

Cloud databases

Security/compliance

Backups & DR planning

Education

Bachelor's degree

Tools

AWS Redshift Serverless

Snowflake

Databricks

Amazon Athena

Amazon S3

Job description

Cognitive Medical Systems, Inc. is seeking a Cloud Database Administrator for a remote role focused on CMS DDPS and PRS, supporting AWS Redshift Serverless, Snowflake, and relational databases.

You will design, administer, and secure data environments, optimize queries, manage backups, and work with Databricks. A Bachelor's degree and 6+ years in database administration are required, with 3+ years on cloud platforms.