Database Administrator

Route Smart Technologies, a leader in vehicle route optimization software technology, is seeking a Database Administrator to join our Product Development team. This role reports directly to the DBA Team Lead and is responsible for managing Postgre

SQL databases throughout development and production life cycles in an AWS environment.

The ideal candidate will have expertise in Postgre

SQL architecture, AWS RDS/Aurora, and database performance optimization.

The typical base pay range for this position at the start of employment is expected to be $100,000-$110,000 per year, depending on experience and location. Route Smart Technologies has different base pay ranges for different work locations within the U.S.

This is ideally a hybrid role. Candidates must be able to commute to the office in Melville, NY or Columbia, MD. Candidates must reside within 50 miles and be available to work onsite several days per week.

Remote work may be considered for candidates domiciled in one of the following states:
Maryland, New York, Pennsylvania, DC, Virginia, Arizona, California, Colorado, Florida, Idaho, Illinois, Indiana, Minnesota, New Jersey, North Carolina, Oregon, South Carolina, Texas, Washington.

Essential Duties & Responsibilities

• Design and develop logical and physical database structures based on customer requirements.
• Provide guidance on database standards and procedures.
• Collaborate with development, architecture, and release teams to ensure smooth Postgre
  
  SQL transition to production.
• Lead implementation of Multi-AZ and cross-region support, including migration to Aurora Global Database.
• Implement automated methods and best practices for Postgre
  
  SQL configurations in production and non-production environments.
• Manage backup/recovery functions for large Postgre
  
  SQL environments.
• Monitor system health and performance; set up alerting mechanisms.
• Manage user accounts, database security, and performance tuning.
• Plan and coordinate system upgrades and capacity planning.
• Manage Disaster Recovery environment and resolve incidents promptly.
• Generate detailed reports on Postgre
  
  SQL processes and resource usage.
• Other duties as assigned.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Technology, or a related field, or equivalent relevant work experience
• In-depth knowledge of Postgre
  
  SQL architecture with intermediate to advanced proficiency
• 3+ years of experience working in an RDBMS environment, with the majority of experience in a database administrator role
• At least 2 years of experience working in a cloud environment
• AWS RDS certification(s) preferred
• Ability to perform database patches and maintenance during off‑peak hours

Benefits

• Medical/Dental/Vision/STD & LTD Plans
• Employer paid Life Insurance Plan
• Employee Training & Development
• 401(k) Retirement Savings Plan w/ Employer Match
• Vacation/Sick/Holiday Leave
• Tuition Reimbursement
• Flex hours
• Casual Dress

Route Smart Technologies is proud to be an equal opportunity workplace. Individuals seeking employment at Route Smart Technologies are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, or sexual orientation.

We do not accept resumes from headhunters, placement agencies, or other suppliers that have not signed a formal agreement with us.

All candidates must have legal authorization to permanently live and work in the United States.

This position does not qualify for sponsorship.