freehire launches on Product Hunt on 26 August.

Follow →

cBEYONData + SMX

Discussion

Senior Database Developer (5480)

Summary

Senior Database Developer designs, optimizes, and secures cloud data warehouses (AWS Redshift, PostgreSQL/Aurora) for a federal BI suite, ensuring high-performance analytics for executive decision-makers.

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.

Essential Duties & Responsibilities:

  • 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.

Required Skills & Experience

  • 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.

Desired Skills & Experience

  • 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

#CJPOST

# LI-SA1

The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

The proposed salary for this position is:
$95,600—$160,700 USD

SMX is an Equal Opportunity employer including disabilities and veterans.

Selected applicant may be subject to a background investigation and/or education verification.

SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).

Show

What this application asks

greenhouse

First Name, Last Name, Email, Phone, Resume/CV, Cover Letter

  • Preferred First Name optional
  • LinkedIn Profile optional
  • Website optional
  • Legal First Name
  • Legal Last Name
  • Full Middle Name
  • Suffix optional
  • Street Address
  • City
  • State choose one
  • Postal Code
  • Are you at least 18 years of age? choose one
  • What level of security clearance do you currently hold? choose any
  • Work Authorization choose one
  • Will you at any time require any form of work authorization, visa, or other immigration sponsorship? choose one
  • Salary Requirements
  • Have you previously worked for SMX or a subsidiary? choose one
  • WE ARE AN EQUAL OPPORTUNITY EMPLOYER. Applicants and employees are considered for positions and are evaluated without regard to mental or physical disability, race, color, creed, religion, sex, gender, national origin, ancestry, age, genetic information, military or veteran status, sexual orientation, gender identity or expression, marital status, familial status or any other legally protected status under applicable law or other similar factors that are not job-related. No question on the application is intended to secure information about these subjects. We encourage all qualified individuals to apply for employment. We also provide reasonable accommodation to qualified individuals with disabilities in accordance with the Americans With Disabilities Act and applicable state and local law. If you require assistance or a reasonable accommodation to complete the application or any aspect of the application process, please contact the Talent Acquisition team at talent@smxtech.com. All applicants must properly complete this employment application; failure to do so may result in denial of employment. Rhode Island Applicants: PURSUANT TO THE WORKERS’ COMPENSATION LAW SECTION 28-29-6, THE ORGANIZATION INFORMS YOU THAT IT IS SUBJECT TO THE WORKERS’ COMPENSATION LAWS. IF YOU PROVIDE FALSE INFORMATION ABOUT YOUR ABILITY TO PERFORM THE ESSENTIAL FUNCTIONS OF THE JOB WITH OR WITHOUT ACCOMMODATION, YOU MAY BE BARRED FROM FILING A CLAIM UNDER THE PROVISIONS OF THE WORKERS’ COMPENSATION ACT OF THE STATE OF RHODE ISLAND. choose one
  • I have read and agree to the SMX Data Privacy Policy. choose one
  • I agree to the Conditions of Application and Employment statement below. choose one
  • I hereby authorize this electronic signature submittal to serve as my legal signature. choose one
  • Enter Full Legal Name
  • Date (mm/dd/yyyy)

See also

141,978 jobs
Python jobs
216,809 jobs
Senior-Level jobs
100,682 jobs
AWS jobs
33,370 jobs
Terraform jobs
29,142 jobs
PostgreSQL jobs
14,516 jobs
Remote Worldwide jobs
37,331 jobs
JavaScript jobs
54,834 jobs
TypeScript jobs
45,878 jobs
React jobs
6,352 jobs
Go jobs

Tailor your CV for this role?

We couldn't check your fit for this role — add a CV to your profile to see it next time.

A new version of freehire is available