Company Overview
XPECT Solutions, LLC has built a strong reputation by supporting our clients in meeting their strategic goals and mission objectives. We provide high quality resources for a wide range of IT and security solutions at best-value pricing. Our success is built on a solid foundation of well-vetted, highly technical personnel, a disciplined project management approach, and an overarching commitment to customer service. We develop, test, deploy, and support exceptional solutions that enhance system functionality, while maximizing reliability and availability, and ensure the tightest security.
Job Overview
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
Benefits
Xpect Solutions, LLC is a one-of-a-kind employer with a talented team that is cleared at various levels and is certified in dozens of industry-recognized certifications. Our talented staff are the key to our success. They bring the knowledge, experience and technical skills to deliver the best solutions to our customers.
We support our team by providing open communication, win-win partnerships with clients and vendors, a team-oriented culture, and a focus on professional development and growth for a long-lasting and happy career.
We offer a benefits package that is designed to keep our most important assets - our employees - healthy, happy, energized and moving forward. Our philosophy is simple - empower our employees with the benefits, resources and the financial incentives they need to be successful.
Benefits and Perks:
- A competitive Medical, Dental, and Vision plan
- Retirement Savings Plan
- Life Insurance
- AD&D Insurance
- Short Term and Long Term Disability Insurance
- 3 weeks of annual PTO
- 11 days of Holiday PTO
- Performance Awards
- Referral Bonus Plan (of up to $5,000/year)
- Education Reimbursement/Training (of up to $2,500/year)
#CJ