Data Support Specialist

Position Title: Data Operations Specialist (Database Administrator) Location: Remote (Washington, DC metro area preferred); place of performance is 395 E Street SW, Washington, DC Client: U.S. Department of Transportation, Surface Transportation Board (STB) Work Authorization: Must be eligible for a Moderate Risk (MBI level) background investigation prior to accessing STB systems Application Email: View email address on click.appcast.io apply, please submit your resume to View email address on click.appcast.io or complete the application form below.Apply online through the WINTrio Careers Portal: Job Posting: Data Operations Specialist (Database Administrator) WINTrioJob SummaryWINTrio LLC is seeking an experienced Data Operations Specialist (DBA) to support a federal data management program for the Surface Transportation Board. This role operates and maintains an AWS based data environment, ensuring stability, reliability, and security across cloud pipelines, databases, and the agency's public data portal. The ideal candidate has hands on production experience administering AWS managed databases and a strong operational mindset for monitoring, incident response, and SLA driven reporting.Key ResponsibilitiesOperate and maintain established AWS based workflows, including Lambda, Glue, Step Functions, Redshift, RDS Postgres, SQL, and S3.Perform ongoing database administration: tuning, patching, backup and restore, and general maintenance.Manage the agency's open data portal and CKAN data catalog, ensuring accurate and timely dataset publication and supporting new data visualizations.Monitor platform health, logging, and alerts, and perform initial incident triage and response.Maintain and update SOPs, runbooks, and operational documentation on at least a quarterly basis.Provide end user support and training related to database access, credentials, and data usage tools.Monitor data quality, observability, logging, and alerting across the environment.Deliver monthly SLA performance reports covering pipeline success rates, incident summaries, data availability, and operational metrics.Meet performance standards including a 95%+ pipeline success rate, incident acknowledgment within 4 business hours, and documented RTO/RPO objectives on backups.Required Qualifications3 to 7+ years of experience administering Amazon Redshift, RDS (PostgreSQL or SQL Server), or comparable managed data stores.Experience designing relational schemas, star/snowflake models, indexes, and partition strategies.Experience with routine DBA tasks: backup/restore, tuning, patching, and performance optimization.Experience supporting data warehouses in production and resolving performance issues.Experience applying federal data management expectations, including auditability, traceability, and quality controls.Experience working in a federal or regulated environment with stakeholders, CORs, and structured deliverables.Experience delivering work under SLAs with documented quality controls and formal acceptance processes.Must be eligible for a Moderate Risk (MBI) background investigation.Technical Skills & ToolsAWS Cloud Services: Lambda, Glue, Step Functions, Redshift, RDS (Postgres/SQL Server), S3Database Administration: backup/restore, tuning, patching, indexing, partitioningData Cataloging: CKAN, open data portal managementMonitoring & Observability: platform health monitoring, logging, alertingDocumentation: SOPs, runbooks, SLA reportingRecommended Certifications (not mandatory): AWS Certified Solutions Architect (Associate or Professional), AWS Certified SysOps Administrator, AWS Certified Security SpecialtyWork EnvironmentFull time position.Remote eligible; contractor services may be performed remotely per the contract's terms.Standard business hours Monday through Friday.No travel required.WINTrio BenefitsHealthcare (Medical, Dental, and Vision)Flexible Spending Account (FSA) and Health Savings Account (HSA)401(k) and Retirement Savings PlanAnnual Bonus and Profit Sharing OpportunitiesPaid Time Off (PTO) and VacationEmployee Assistance Program (EAP)Life, Personal, and Voluntary Disability InsuranceGrowth OpportunitiesThere is ample opportunity to grow in multiple dimensions, including federal cloud data operations, AWS architecture, and program leadership. We are a completely employee driven company, and our continued success is built on the talent, dedication, and innovation of our team members.Equal Opportunity EmployerWINTrio LLC is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
recblid h2m039vuc20meug5nk71zywoy4v6te