Job Opportunities API

 Who we are: Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow. We are proud to employ and support military veterans who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply.     We are seeking a mid/senior- level Application Database Administrator to support our Agile sprint teams and manage production database environments. The ideal candidate brings solid, hands-on expertise with MySQL and PostgreSQL, strong data modeling capabilities, and a demonstrated track record in performance tuning and production support. This role works closely with development teams throughout the sprint lifecycle and is expected to operate with a good degree of independence, mentor junior team members, and contribute to database architecture decisions. Key Responsibilities Sprint Team Support Actively participate in Agile/Scrum ceremonies (sprint planning, standups, retrospectives, backlog grooming) as the database subject matter expert Review user stories and technical requirements, providing database design input and effort estimates Partner with developers to translate application requirements into efficient, scalable database structures Provide timely turnaround on database changes to keep sprint deliverables on track Guide and review the work of junior DBAs or developers on database-related tasks Data Modeling Independently design and maintain logical and physical data models using tools such as Erwin Develop conceptual data models aligned with business and application requirements Ensure models support normalization standards, referential integrity, and long-term scalability Own data dictionaries, schemas, and entity relationship diagrams (ERDs) Lead data model reviews with development, architecture, and business stakeholders Identify and resolve data model conflicts across multiple applications/systems Database Administration (MySQL & PostgreSQL) Install, configure, and maintain MySQL and PostgreSQL instances across dev, test, staging, and production Manage database schemas, users, roles, and security/access controls Own backup, restore, patching, and upgrade strategy and execution Design, implement, and maintain replication, high availability, and disaster recovery solutions Evaluate and recommend improvements to database architecture and standards Performance Tuning Proactively monitor database performance metrics and identify bottlenecks before they impact users Analyze and optimize complex, slow-running queries, indexes, and execution plans Tune database configuration parameters for optimal throughput and resource utilization Lead capacity planning and scalability assessments for growing application workloads Establish performance benchmarks and monitoring best practices Production Support Serve as senior/primary DBA support for production systems, including on-call rotation Lead troubleshooting and resolution of complex database incidents, outages, and performance degradation Drive root cause analysis on production issues and implement preventive/long-term fixes Own database change management for deployments and releases, minimizing risk and downtime Develop and maintain runbooks, SOPs, and incident documentation Serve as an escalation point for critical/high-seve