Software Engineer IV

For over half a decade, Hudson Manpower has been a trusted partner in delivering specialized talent and technology solutions across IT, Energy, and Engineering industries worldwide. We work closely with startups, mid-sized firms, and Fortune 500 clients to support their digital transformation journeys. Our teams are empowered to bring fresh ideas, shape innovative solutions, and drive meaningful impact for our clients. If you're looking to grow in an environment where your expertise is valued and your voice matters, then Hudson Manpower is the place for you. Join us and collaborate with forward thinking professionals who are passionate about building the future of work.

Top Skills Must Have

- API Design and Integration

- Database Engineering and Optimization

- PostgreSQL (Performance Tuning, Query Optimization, Replication, and Monitoring)

- Ruby on Rails Framework

- Application Performance and Scalability

Nice To Have

- Cloud platform experience (AWS, Azure, or GCP)

- Familiarity with GraphQL and modern API design principles

- Experience with CI/CD pipelines and DevOps integration

- Exposure to containerized environments (Docker, Kubernetes)

Key Responsibilities

- Design, implement, and maintain high-performing PostgreSQL databases supporting large-scale transactional systems.

- Develop and optimize RESTful and GraphQL APIs within Ruby on Rails applications.

- Collaborate with software engineers, architects, and DevOps teams to ensure database reliability, scalability, and observability.

- Conduct advanced query optimization, indexing, and partitioning to achieve sub-second response times.

- Implement database security, replication, and disaster recovery strategies.

- Support continuous integration and deployment workflows with database migration best practices.

- Analyze performance bottlenecks, provide solutions, and proactively tune database systems.

- Participate in Agile ceremonies, code reviews, and architecture discussions to drive continuous improvement.

- Maintain comprehensive documentation for schema design, queries, and stored procedures.

Qualifications Required

- Bachelor’s in Computer Science, Engineering, or related field (or equivalent experience).

- 5+ years of professional experience in database design and software engineering.

- Advanced expertise in PostgreSQL, including performance tuning, indexing, and query optimization.

- Strong proficiency with Ruby on Rails application architecture.

- Hands-on experience designing APIs (REST or GraphQL) for high-volume applications.

- Experience using version control tools (Git, GitHub).

- Understanding of Agile methodologies, CI/CD pipelines, and test-driven development.

Preferred

- Cloud platform expertise (AWS RDS, Aurora, or Azure Database for PostgreSQL).

- Familiarity with caching mechanisms (Redis, Memcached).

- Experience with observability and monitoring tools (Prometheus, Datadog, New Relic).

- Knowledge of database migration, backup, and restore strategies.

- Security-first mindset for data protection and compliance (encryption, auditing, access control).