TRUSS EMPLOYMENT OPPORTUNITy

DBA (SQL Server and AWS) for Hire

Locations

SHARE THIS:
ABOUT THE EMPLOYER

Our client is a leading SaaS Transportation Management System (TMS) provider that helps businesses simplify and optimize their shipping operations. Their cloud-based platform integrates seamlessly with various carriers, ERPs, and WMS solutions, allowing customers to streamline logistics, reduce costs, and improve efficiency.

WHAT WILL YOU WORK ON?

  • Be the database owner – Ensure the database is maintained, is updated and needed and is optimized regularly for optimal performance based on the company application needs.
  • Assist Developers with Database Design – Collaborate with developers to create efficient database schemas, enforce best practices, and review code for optimal SQL execution.
  • Optimize Queries & Performance – Analyze and improve slowrunning queries, optimize stored procedures, and fine-tune indexing strategies.
  • Database Maintenance & Administration – Manage backups, restores, and disaster recovery plans; monitor database health, storage, and performance metrics.
  • Index & Query Optimization – Continuously improve indexing strategies, optimize query execution plans, and help reduce query latency.
  • Security & Compliance – Implement and enforce database security controls, including access management, encryption, and auditing.
  • Updates & Patching – Keep SQL Server environments up to date with the latest patches, security updates, and AWS optimizations.
  • Capacity Planning & Scalability – Plan for growth by ensuring our database infrastructure is scalable and efficient.
  • Monitoring & Alerting – Set up and maintain monitoring solutions to proactively identify performance bottlenecks and resolve potential issues before they impact users.

WHAT SKILLS AND EXPERIENCE ARE WE LOOKING FOR?

  • 5+ years of experience as a SQL Server DBA/DBE, preferably in a cloud-based SaaS environment.
  • Strong expertise in SQL Server performance tuning, query optimization, and indexing strategies.
  • Experience working in AWS-hosted SQL Server environments, including EC2-based deployments.
  • Proficiency in database security best practices, access controls, encryption, and compliance frameworks.
  • Hands-on experience with database backups, restores, and disaster recovery planning.
  • Ability to work closely with developers to review database code, optimize queries, and enforce best practices.
  • Familiarity with automation tools for database maintenance and monitoring.
  • Experience with T-SQL, stored procedures, triggers, and database migrations.
  • Strong troubleshooting and problem-solving skills.
  • Excellent communication skills with the ability to explain complex database concepts to developers and stakeholders.

ARE THERE ANY OTHER REQUIREMENTS?

  • Experience with CI/CD pipelines for database changes.
  • Experience with analytics platforms such as Snowflake, and Power BI.

The crosstime duration is 3-4 hours (9:00 PM – 12:00 AM). GMT+4/GMT+5

Featured benefits:

This is an excellent opportunity to work with a leading logistics technology company and contribute to innovative solutions that drive efficiency in supply chain management. If you have a passion for building scalable applications and working with modern web technologies, we encourage you to apply!

apply back to jobs