Senior Database Administrator

AI overview

Lead PostgreSQL management and optimization while mentoring junior staff and driving database transitions to AWS environments in a hybrid work setting.

RouteSmart Technologies, a leader in vehicle route optimization software technology, is seeking a Senior 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 deep expertise in PostgreSQL architecture, AWS RDS/Aurora, and database performance optimization. This position also serves as a backup to the DBA Team Lead, making technical decisions in their absence to ensure continuity and stability in database operations. 

The typical base pay range for this position at the start of employment is expected to be $120,000–$130,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 

  • Mentor Database Administrator staff in coordination with VP of Product Development and DBA Team Lead, including task assignment and review. 
  • Stay current on PostgreSQL (Aurora) and AWS database technologies; recommend and integrate new solutions into RouteSmart products. 
  • Develop maintenance roadmaps for AWS database services to ensure timely patching and updates. 
  • Design and implement logical and physical database structures based on customer requirements. 
  • Provide guidance on database standards and procedures. 
  • Collaborate with development and architecture 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
  • 5+ years of experience as a Database Administrator, with the majority focused on PostgreSQL environments.
  • In-depth knowledge of PostgreSQL database architecture.
  • At least 2 years of experience working in a cloud environment.
  • AWS RDS certification(s) or other industry-standard DBA certifications strongly preferred.
  • Ability to perform database patching and maintenance during off-peak hours.

Benefits

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.

Perks & Benefits Extracted with AI

  • Flexible Work Hours: Flex hours
  • Health Insurance: Medical/Dental/Vision/STD & LTD Plans
  • Other Benefit: Casual Dress

RouteSmart Technologies Delivers Like No OtherLeading organizations in the newspaper, postal and parcel delivery, public works and utilities industries have to come to rely on RouteSmart Technologies to solve their complex routing problems. With an unrivaled combination of insight, experience, and industry specialization, RouteSmart Technologies has established itself as a leader in vehicle route optimization software technology for the community of clients we serve.Driven by a passion for vehicle routing technology that achieves measurable results, RouteSmart route optimization technology is continually being enhanced by an expert team focused exclusively on the needs of our clients. Comprised of the leading geospatial technologies from Esri and HERE (formerly NAVTEQ and Nokia Maps), RouteSmart software integrates with client-side systems to form a complete routing solution for meeting the demanding operational needs of the industries we serve.In our fourth decade of providing sustainable route optimization solutions that sweat the details of solving the most complex routing challenges with the highest degree of precision and processing performance, RouteSmart Technologies and our network of exclusive distributors is passionate about driving costs and inefficiencies out of the routing operations of our customers. With deployments that span the globe, RouteSmart Technologies software forms the backbone of organizations that are responsible for delivering or servicing millions of addresses on a daily basis.

View all jobs
Salary
$120,000 – $130,000 per year
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Senior Database Administrator Q&A's
Report this job
Apply for this job