Senior Database Administrator/Engineer at FreightPOP

I’m helping FreightPOP find a top candidate to join their team full-time for the role of Senior Database Administrator/Engineer.

“Cloud-based AI-powered enterprise transportation management software (TMS) designed to simplify logistics."

Compensation:
USD 40K - 85K/year.

Location:
Remote (for Mexico, Costa Rica, Argentina, Brazil, Colombia, Uruguay, Peru residents)

Mission of FreightPOP:
"We simplify and streamline the transportation management experience for manufacturers, distributors, retailers, and 3PL’s by reducing friction and connecting systems for a seamless and optimal supply chain."

What makes you a strong candidate:
- You are expert in database administration, Microsoft SQL Server, and SQL.
- You are proficient in database design, database optimization, database security, and database recovery.
- English - Fully fluent.

Responsibilities and more:
We are seeking an experienced Database Administrator / Database Engineer (DBA/DBE) to support our development team, optimize database performance, and ensure the security, reliability, and scalability of our SQL Server environment hosted in AWS.

The Database Admin is responsible for all aspects of database management. This includes owning the processes and approvals for changes and governance, database security, maintenance, and optimization as well as database backup, redundancy, and disaster recovery. You must be familiar with all the newest technologies and database-related items that can help FreightPOP. You will also work with various teams on strategic items and tactical projects when they involve anything relating to the database or database servers. You are also responsible for keeping all documentation updated and working appropriately. Furthermore, you need to communicate and escalate issues to the executive team and managers.

What you’ll do
As a DBA/DBE at FreightPOP, you will:
- Be the database owner - Ensure the database is maintained, updated, and needed, and is optimized regularly for optimal performance based on the FreightPOP 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 slow-running 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 updated 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 we’re 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.

Nice to have
- Experience with CI/CD pipelines for database changes.
- Experience with analytics platforms such as Snowflake, and Power BI.