SMX

Senior Database Developer (5480)

SMX • $95K — $160K *
Washington, DC 20011In-Person
Information Technology
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 8+ years experience in database development and administration, with 4+ years in cloud platforms (AWS preferred) for high-volume data warehouses or BI.
  • Advanced expertise in Amazon Redshift and PostgreSQL/Aurora administration.
  • Experience with ETL and orchestration tools like Apache Airflow or AWS Glue.
  • Expert-level proficiency in SQL, including query tuning and schema optimization.
  • Strong scripting skills in Python or Bash for automation.
  • Deep knowledge of cloud database security practices and high availability/disaster recovery strategies.
  • Active Top Security clearance.

Responsibilities

  • Lead the engineering, configuration, and lifecycle management of cloud-native analytical data stores.
  • Monitor and optimize database performance, including designing indexing and partitioning strategies.
  • Oversee the migration of legacy data to modern cloud repositories using AWS DMS and orchestration tools.
  • Develop operational automation scripts for schema deployments and database maintenance tasks.
  • Collaborate with Data Engineers and Business Analysts to address data modeling challenges.

Benefits

  • Health insurance
  • Paid leave
  • Retirement
  • Learning and development opportunities
  • A focus on investing in employees.
Full Job 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.

The proposed salary for this position is:

$95,600-$160,700 USD

About SMX

SMX is a company that concentrates on C5ISR, advanced engineering, and computing and also provides services, including cyber security and data analytics. Their previous search terms included Trident Technologies, Smartronix, Datastrong, and C2S Consulting Company, and their tradition of offering new technological solutions.

SMX Careers

Joining SMX presents a prime opportunity to be part of a diverse team of professionals, dedicated to pioneering innovations in the industry. SMX, a leader in technology and consulting, offers a variety of job opportunities that cater to ambitious individuals looking to make a significant impact in their professional journey.

Explore Career Opportunities

SMX is actively hiring and offers a range of positions that suit different skills and career aspirations. From entry-level roles to leadership positions, SMX is committed to fostering growth and excellence in every team member.

Internship Programs

SMX's internship programs provide invaluable industry experience, mentoring, and the opportunity to develop professional skills in a real-world setting. Internships are a stepping stone to full-time employment at SMX, offering a robust foundation in technology and business practices.

Professional Growth and Development

SMX is dedicated to the professional growth of its employees. With comprehensive training programs, including leadership development and diversity training, SMX ensures that every team member has the resources to thrive. Employees are encouraged to pursue continuous learning opportunities and gain certifications that enhance their career prospects.

Benefits and Culture

SMX is known for its inclusive culture and competitive benefits package designed to support the well-being and financial security of every employee. Benefits include health care, retirement plans, and paid time off, among others. The company culture at SMX promotes innovation, teamwork, and leadership, making it an ideal environment for professional development and personal growth.

Networking and Professional Development

Employees at SMX enjoy access to a vast network of industry professionals and thought leaders. Regular networking events, seminars, and workshops are integral to the company's commitment to employee development. These opportunities facilitate career advancement and innovation within the team.

Applying for a Position

To apply for a position at SMX, candidates are encouraged to submit a resume and cover letter through the SMX Careers portal. The hiring process at SMX is thorough, ensuring that both the company and its potential employees are well-matched. Candidates can expect a detailed interview process where they can showcase their skills and learn more about the job opportunities and culture at SMX.

Stay Connected with SMX Jobs

Keep up to date with the latest news, career tips, and job openings at SMX by subscribing to the SMX Careers newsletter. Tailored information about new positions, company updates, and industry insights will be directly delivered to subscribers.

Join SMX

Explore the exciting and rewarding career opportunities at SMX. With a commitment to diversity, innovation, and leadership, SMX is looking for passionate, curious, and solution-driven team players. Search open positions that match your skills and interests on the SMX Jobs portal today.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the dynamic and fulfilling career opportunities awaiting at SMX.
Learn more about SMX
Size
1,001 employees
Industry
Business Services
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at SMX

More Information Technology Jobs

Find similar Senior Database Developer (5480) jobs:

NationwideWashington, DC