> Markdown version of [/jobs/ext/2427618-senior-database-developer-5480](https://www.wearedevelopers.com/jobs/ext/2427618-senior-database-developer-5480). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Database Developer (5480) - **Company:** SMX, LLC - **Location:** Washington, DC, United States - **Experience:** Expert - **Salary:** $95,600.0 - $160,700.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Airflow, Amazon Web Services, Data Analysis, Automation of Tests, Bash Shell, Cloud Database, Cloud Engineering, Databases, Data Architecture, Data Governance, Data Integration, Extract Transform Load (ETL), Data Manipulation Languages, Data Warehousing, Database Development, Monitoring of Systems, Python (Programming Language), PostgreSQL, Performance Tuning, Query Optimization, SQL Stored Procedures, SQL Databases, Scripting, Sql Optimization, Database Optimization, Cloudformation, SC Clearance, Database Migration, AWS Aurora, Kubernetes, AWS Glue, WebFOCUS, Tools for Reporting, Terraform, Data Pipelines, Devsecops, TIBCO (Software), Amazon Redshift - **Published:** August 2, 2026 - **Apply:** https://dejobs.org/x/x/93242CA17D884634AC6E637834DBA9CE/job/ ## About the Role * 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. * Security Clearance: Active Top Secret clearance. ## Description Are you a Senior Database Architect who thrives at the intersection of enterprise cloud infrastructure, high-performance data warehousing, and mission-critical availability? We are seeking a Senior Cloud Database Developer to serve as the core database authority for the Business Intelligence Suite. In this role, you will support the health, performance, security, and scalability of the FFD Data Warehouse and underlying cloud database ecosystems (e.g., AWS Redshift, PostgreSQL/Aurora). You will not simply be executing routine O&M; you will actively lead data architecture modernizations, optimize high-volume analytical query performance for BI engines (like WebFOCUS), and enforce the security posture. If you are looking to engineer and maintain an enterprise data platform for executive federal decision-makers, this is the position for you. This position is on site in Washington, DC and requires an active Top-Secret clearance., * Database Architecture & Provisioning: Lead the engineering, configuration, performance tuning, and lifecycle 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., * 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 ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [How we built an AI-powered code reviewer in 80 hours](https://www.wearedevelopers.com/videos/1511-how-we-built-an-ai-powered-code-reviewer-in-80-hours) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Tips, Techniques, and Common Pitfalls Debugging Kafka](https://www.wearedevelopers.com/videos/838-tips-techniques-and-common-pitfalls-debugging-kafka) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [20 Essential Tools For Backend Development](https://www.wearedevelopers.com/magazine/218-20-essential-tools-for-backend-development) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)