Note: The job is a remote job and is open to candidates in USA. Cognitive Medical Systems, Inc. is an IT and software engineering services company focused on improving technology delivery for U.S. government healthcare programs. The Cloud Database Administrator will design, administer, optimize, secure, and tune database and data platform environments supporting CMS drug data processing and payment reconciliation systems. The role also manages backups, disaster recovery, Databricks administration, schemas, migrations, security compliance, and database testing.
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
- Bachelor's degree in Computer Science, Information Systems, or related field; 6 or more years in database administration including 3 or more years on cloud data platforms
- Hands-on production experience with AWS Redshift Serverless and Snowflake for large-scale data warehousing
- Experience with Amazon Athena query optimization and Amazon S3 data lake management
- Experience with Databricks cluster and workspace administration
- Strong SQL skills for performance tuning, schema development, stored procedures, and data migrations
- Experience with database security controls including encryption, IAM-based access, audit logging, and vulnerability remediation
- Ability to pass CMS and internal required background checks for public trust
Benefits
- Be part of a mission-driven organization making a difference in healthcare IT.
- Collaborate with innovative and passionate professionals that are there to support you at every turn.
- Enjoy a supportive work/life balance with the flexibility of a 100% remote company.
- Benefit from opportunities for growth and development in a dynamic environment.
Company Overview