Database Administrator

RouteSmart 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 PostgreSQL databases throughout development and production lifecycles in an AWS environment. The ideal candidate will have expertise in PostgreSQL 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. RouteSmart 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 PostgreSQL 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 PostgreSQL configurations in production and non-production environments. Manage backup/recovery functions for large PostgreSQL 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 PostgreSQL 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 PostgreSQL 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 RouteSmart Technologies is proud to be an equal opportunity workplace. Individuals seeking employment at RouteSmart 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. #J-18808-Ljbffr