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.
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.
At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.
We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.
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).
Similar jobs
Est. 137,450 USD
SMX is hiring a Data Engineer responsible for designing, building, and maintaining scalable data architecture that powers our AI, analytics and reporting. Collaborate closely with Analysts, AI Engineers, and Software Eng…
Est. 86,150 USD
SMX is hiring a Data Analyst responsible for profiling data sources, documenting data lineage, and aligning data to a common domain model that powers enterprise data products, APIs, and analytics. Working closely with da…
Est. 140,250 USD
We are seeking an experienced Cloud Architect to join our State and Local Platforms and Data Managed Services team. In this key role, you will design, implement, and manage cloud solutions across a diverse portfolio of c…
Est. 105,100 USD
We are looking for a skilled Cloud Engineer to join our State and Local Platforms and Data Managed Services team. As a core member of our operations group, you will work across multiple client environments, implementing,…
Est. 137,450 USD
The Cyber Security Engineer will provide security engineering, compliance, and risk management support for cloud-based systems aligned with NIST SP 800-53, FedRAMP, and DoD IL4–6 requirements. The role will advise partne…
Est. 111,050 USD
The mission of the client service delivery team at SMX is to create and deploy innovative products to our federal customers. The CFO Control Tower Budget and Spend (BAS) solution is a planning and reporting solution that…
Est. 137,600 USD
SMX is seeking Cloud Analysts (Junior/Mid/Senior) supporting the design and implementation of secure, scalable multi-cloud infrastructure and services in support of enterprise analytics and mission-critical systems for t…
Est. 137,600 USD
SMX is seeking Cloud Systems Engineers (Junior/Mid/Senior/SME) supporting the design and implementation of secure, scalable multi-cloud infrastructure, applications, and services in support of enterprise cloud migration…
Est. 81,200 USD
SMX is actively searching for a dynamic and adept Junior Cloud Engineer to support our government client in Huntsville, AL. This role emphasizes operational excellence, championed by a commitment to quality, articulate c…
Est. 150,000 USD
SMX is seeking a dynamic and experienced Technical Lead to guide a team of talented engineers in the design, development, and delivery of mission-critical solutions. This is a hybrid role for a leader who is passionate a…
Est. 104,250 USD
SMX is actively searching for a dynamic and adept Cloud Engineer to support our government client in Huntsville, AL. This role emphasizes operational excellence, championed by a commitment to quality, articulate communic…
Est. 128,500 USD
SMX is seeking an Azure DevSecOps Engineer supporting the design and implementation of secure, scalable multi-cloud infrastructure, applications, and services in support of enterprise cloud migration and mission-critical…
Est. 137,450 USD
SMX is seeking a Senior Solutions Architect to join a federal pursuit. How would you like to be part of a leadership team made up of experts and senior level staff who have experience, capacity and capability to lead lar…
Est. 128,500 USD
SMX is currently looking for a highly motivated Software Engineer - Front End Web Applications to contribute to the design, build, support, and implementation of the Budget and Spend (BAS) solution. This is an exciting r…
Est. 137,600 USD
SMX is seeking Cloud Subject Matter Experts (Junior/Mid/Senior) supporting secure, scalable multi-cloud infrastructure and services in support of business and mission-critical systems for the United States Air Force. Col…
Est. 137,600 USD
SMX is seeking Information Assurance/Cybersecurity Specialists (Junior, Mid, and Senior) with a foundation in information systems, multi-cloud, network administration, systems administration, and cybersecurity. This role…
Est. 129,000 USD
SMX is seeking a Knowledge Systems Integrator to support government client at Camp Smith. The Knowledge Systems Integrator (KSI) / Knowledge Manager will enable units to leverage emerging AI technologies and integrate th…
Est. 156,500 USD
SMX is seeking an AI Engineer to support government client at Camp Smith. The AI Engineer designs, develops, tests, and improves AI-enabled systems that support client operations, business processes, and organizational K…
Est. 97,650 USD
SMX is currently looking for a highly motivated Software Engineer - Front End Web Applications to contribute to the design, build, support, and implementation of the Budget and Spend (BAS) solution. This is an exciting r…
Est. 121,500 EUR
SMX is seeking an experienced Data Strategist & Analytics Specialist to serve as the primary data authority for our organization's Theater/Tactical Mission Network (TMN) operations. This individual will be responsibl…
Est. 114,600 USD
SMX is seeking Cloud Functional Specialists/Experts (Junior/Mid/Senior) supporting the design and implementation of secure, scalable multi-cloud infrastructure, applications, and services in support of enterprise cloud m…
SMX is seeking a Senior Systems Engineer / ISR Communications professional to support the design, implementation, operation, security, and troubleshooting of enterprise and mission-focused network infrastructure. The ide…
Est. 156,500 USD
SMX is seeking an AI Engineer and Integrator to support government client at Camp Smith. The AI Integrator serves as the client-facing AI integration lead and secondary AI Engineer. This role sits close to the client and…
Est. 152,500 USD
Outside Analytics has recently become a proud subsidiary of SMX, marking an exciting collaboration that enhances our collective capabilities to deliver cutting-edge digital transformation solutions. Are you interested in…
Est. 65,000 USD
SMX is looking for a highly motivated Data Management Specialist to support our government client in Huntsville, AL. Essential Duties & Responsibilities Work closely with team members and customers to support the man…
Est. 104,500 USD
SMX is seeking a QA Tester/Engineer to ensure the quality, reliability, and performance of enterprise software applications and cloud-native solutions. The ideal candidate is a detail-oriented qualit… SMX is seeking a QA…
Est. 147,750 USD
SMX has an immediate opportunity for a Software Developer who is excited to apply their talents to our customer's challenging project and one who will thrive in a collaborative environment. The ideal candidate is a recog…
Est. 173,100 USD
SMX is seeking a dynamic Sr. Program Manager to lead a large-scale, mission-critical IT modernization and transformation program for a federal agency focused on national security and law enforcement. The Program Manager…
Est. 72,250 USD
We are seeking a highly skilled and analytical Data Manager to support our government client in Huntsville, AL. In this role, you will bring together your data management and hands-on technical experience to support data…
Est. 150,000 USD
SMX is looking for a Field Support Representative Operations to support SOCPAC J6 TACLAN operations across the PACOM Theater. The FSR Operations is a highly skilled IT specialist responsible for maintaining, troubleshoot…