In this role, you will support the health, performance, security, and scalability of the Data Warehouse and underlying cloud database ecosystems (e.g., AWS Redshift, PostgreSQL/Aurora). You will actively lead data architecture modernizations, optimize high-volume analytical query performance for BI engines (like WebFOCUS), and enforce the security posture.
Core Responsibilities
Database Architecture & Provisioning: Lead the engineering, configuration, performance tuning, and life cycle management of cloud-native analytical data stores (Amazon Redshift, AWS Aurora PostgreSQL, RDS)
Performance Optimization & Query Tuning: Proactively monitor system performance, optimize database parameters, design indexing/partitioning/distribution strategies, and refactor complex SQL stored procedures to accelerate query execution for reporting tools like WebFOCUS
Database Migration & Integration: Oversee the migration, replication, and synchronization of legacy data assets into modern cloud repositories using tools such as AWS Database Migration Service (DMS) and containerized pipeline orchestrators (e.g., Apache Airflow).
DevSecOps & Automation: Write operational automation scripts (using Python, Bash, or Infrastructure-as-Code frameworks like Terraform/CloudFormation) for automated schema deployments, DDL/DML migrations, health checks, and database maintenance tasks
Collaborative Data Support: Partner directly with Data Engineers, Business Analysts, and Software Architects to review schema designs, enforce data modeling best practices, and resolve complex data integration bottlenecks.
Requirements
Active Top Secret Clearance
Experience: 8+ years of progressive experience in database development and administration, with at least 4+ years dedicated to cloud database platforms (AWS preferred) supporting high-volume data warehouses or BI environments
Core Technical Stack: Advanced expertise in Amazon Redshift and PostgreSQL / Aurora administration.
ETL & Orchestration: Direct experience configuring database targets and connection pools for Apache Airflow, AWS Glue, or similar modern orchestration platforms.
SQL Mastery: Expert-level proficiency in advanced SQL, query plan analysis, query tuning, stored procedures, and schema optimization.
Scripting & Automation: Strong hands-on scripting skills in Python or Bash for automating database maintenance, monitoring alerts, and data pipeline tasks.
Backup & Security: Deep knowledge of cloud DB security practices and HA/DR strategies.
Preferred Additional Skills and Qualifications
BI Tool Integration: Familiarity with optimizing database performance specifically for TIBCO WebFOCUS or similar enterprise BI reporting engines.
Federal Financial Domain: Domain awareness of federal financial data structures (e.g., UFMS, procurement datasets) and government data governance policies.
Certifications: AWS Certified Database - Specialty, AWS Certified Solutions Architect, or relevant database industry certifications
Ryde is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Ryde will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.
All Job Ads are subject to GrabJobs’s Terms of Service. We allow users to flag postings that may be in violation of those terms. Job Ads may also be flagged by GrabJobs moderation team. However, no moderation system is perfect, and flagging a posting does not ensure that it will be removed.
Be the first to receive the latest Others Full-Time Jobs in the US.
Setup your job alert:
By activating job alerts, I agree to GrabJobs Terms & Privacy Policy. I can unsubscribe to job alerts anytime.
Skip
GrabJobs is the no1 job portal in the US, connecting you to thousands of jobs fast!
Find the best jobs in the US, apply in 1 click and get a job today!