Database Administrator

Database Administrator

RouteSmart Technologies, a leader in vehicle route optimization software technology, is seeking a Database Administrator for their development team in Melville, NY. The ideal candidate will be responsible for the administration of PostgresSQL databases throughout the development and production lifecycles in an AWS environment. You will ensure optimal database performance by analyzing database issues and monitoring database performance.

Essential Duties & Responsibilities

• Design and develop logical and physical database designs from customer requirements
• Implement automated methods and industry best practices for optimal PostgreSQL configurations for production and non-production environments

• Conduct technical reviews and walkthroughs of system design documentation with development and design team members
• Assist in managing backup and recovery functions for large PostgreSQL environments.
• Proactively monitor and setup alerting mechanism for both database and supporting hardware to ensure optimal system health, availability, and performance.
• Create/Manage user accounts, establish database security, performance tuning in terms of query execution, etc.
• Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects
• Assist in managing Disaster Recovery environment
• Identify and resolve incidents and address to user problems/concerns
• Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.

• Migrate DDL scripts to implement schema changes as part of the Software Development Life Cycle.

• Perform other duties as assigned

Qualifications & Requirements

• AWS RDS certification(s)
• Will be required to occasionally perform patches and other maintenance operations during off-peak hours

Education & Experience

• Bachelor’s Degree in Computer Science, Information Systems, Business

Technology, or a related field

• Proven knowledge of the PostgreSQL architecture

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 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
• 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.

Job Type: Full-time

Pay: $100,000.00 - $120,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Education:

• Bachelor's (Required)

Experience:

• PostgreSQL: 2 years (Required)
• Amazon RDS: 2 years (Preferred)

Work Location: One location