Note: The job is a remote job and is open to candidates in USA. WINTrio LLC is an 8(a) and HUBZone organization that delivers technical and professional services, including cloud, cybersecurity, software, and systems integration solutions, to federal and commercial customers. The Data Operations Specialist (Database Administrator) will operate and maintain an AWS-based data environment for the Surface Transportation Board, administering databases, monitoring platform health, managing the CKAN open data portal, responding to incidents, and delivering SLA-driven operational reporting.
Responsibilities
- Operate 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
Skills
- 3 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
- AWS Cloud Services: Lambda, Glue, Step Functions, Redshift, RDS (Postgres/SQL Server), S3
- Database Administration: backup/restore, tuning, patching, indexing, partitioning
- Data Cataloging: CKAN, open data portal management
- Monitoring & Observability: platform health monitoring, logging, alerting
- Documentation: SOPs, runbooks, SLA reporting
- Full time position
- Remote eligible; contractor services may be performed remotely per the contract's terms
- Standard business hours Monday through Friday
- No travel required
- Remote (Washington, DC metro area preferred); place of performance is 395 E Street SW, Washington, DC
- Recommended Certifications (not mandatory): AWS Certified Solutions Architect (Associate or Professional), AWS Certified SysOps Administrator, AWS Certified Security Specialty
Benefits
- Healthcare (Medical, Dental, and Vision)
- Flexible Spending Account (FSA) and Health Savings Account (HSA)
- 401(k) and Retirement Savings Plan
- Annual Bonus and Profit Sharing Opportunities
- Paid Time Off (PTO) and Vacation
- Employee Assistance Program (EAP)
- Life, Personal, and Voluntary Disability Insurance
- Remote eligible
- There is ample opportunity to grow in multiple dimensions, including federal cloud data operations, AWS architecture, and program leadership.
Company Overview
Company H1B Sponsorship