RouteSmartTechnologies, 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. RouteSmartTechnologies 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.
Qualifications
* 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 and Work Environment
* RouteSmart offers its employees numerous opportunities for professional development. Our goal is to provide our employees the chance to learn and grow as the company grows. We recognize that our employees are our most valuable asset. The work they do is key to our ability to provide high quality service to our clients.
* We also recognize that our employees are unique individuals with their own lifestyle and interests.
* RouteSmart Technologies pays a significant share of the cost of benefits for our employees. We believe our investment makes good business sense by helping to create a positive and productive work environment. Among the benefits we offer are:
* 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