At Access, we believe great things happen when people come together. Our discount and rewards solutions are designed to connect three very important groups: organizations, their members, and the merchant community. 

The result? Everyone wins. Merchants tap into the affinity members share with their organizations. Organizationscreate loyalty and generate revenue. And members are happy because they save money.

Access employees enjoy a flexible, friendly, people-oriented work environment with all-employee parties, activities that include family and friends, employee recognition, a fantastic nationwide employee discount program, and a strong focus on career development.  

Access Development is seeking a confident, top class Postgres Database Administrator to work with our Engineering/Development and DevOps teams as well as support our new BI and ETL initiatives in our Salt Lake City Office.

You’ll support new and existing Postgres database systems, both internally managed and Amazon RDS instances, help guide best practices in database administration, introduce innovation with automation, and develop and support ETL processing for our Data Warehouse. The DBA will be responsible for maintaining these environments running in an AWS Linux/Unix environment.

You should have advanced knowledge of Postgres Utilities, creation and implementation of fully functional Postgres databases, ability to maintain multiple development, QA and production Postgres environments with strong experience in performance tuning on Postgres.

KEY ACCOUNTABILITIES:

This role requires a motivated self-starter who can hit the ground running, quickly taking on tasks and applying their strong, prior experience to tackle the challenges presented. This would include:

• Responsible for providing day-to-day support and maintenance for existing and PostgreSQL databases.
• Build database scripts to support ETL, OLAP, OLTP, Data Warehouse, and operations
• Search for, identify, and correct data access performance and content quality issues
• Assist in troubleshooting and resolving problems within our environment
• Individual contributor performing both data design, modeling, and coding
• Design and build database solutions that are both highly available and highly performing.
• Administration, management, and monitoring of all Postgres database systems.
• Help support proper backup and disaster recovery procedures.
• Good understanding of Database Architecture, Performance tuning of databases,
• Pro-actively Identify bottlenecks and resolve them quickly.
• Proactive monitoring of Postgres databases for performance and scalability
• Update skills continuously with emerging technologies and apply them as and when needed.
• Work with developers on performance tuning, query optimization, index tuning.
• Support PostgreSQL database in AWS.
• Maintain a positive, upbeat, “can-do” attitude.

SKILLS SUMMARY:

• BS Degree in Computer Science or equivalent work experience.
• 5+ years relevant DBA experience
• 3 to 5 years of experience with Postgres
• 1 to 2 years of experience with Cassandra
• 3 years of experience working in Linux and UNIX environments - MS Windows a plus
• Strong understanding of Postgres performance tuning (partitioning, striping, data warehouses, data marts and other advanced physical data modeling techniques)
• Strong experience in replication, clustering, tuning, sizing
• Proven knowledge and experience in designing database schemas to align with development and business goals and objectives 
• Experience in a 24/7 production environment support
• Strong experience supporting mission critical relational databases
• Expert level of Postgres knowledge
• Experience with backups, restores, recovery (xDB/Slony/ Pgbouncer)
• Experience with High Availability Solutions and sharding
• Proficient in tuning database processes and queries
• Experience in supporting Postgres databases in AWS 
• Excellent written and verbal communication skills 
• Strong teamwork, decision-making, documentation and analytical skills
• Shell programming, SQL, bash

While this job description attempts to describe the essential functions of the position, it does not prescribe or restrict the tasks that may be assigned. It does not restrict management’s right to assign or reassign duties or responsibilities to this job at any time. 

We recognize people as our most valuable asset. Your contributions will be valued and celebrated by a closely-knit team that is committed to excellence. We offer competitive wages, and benefits package includes medical insurance, prescription drug coverage, a lifestyle discount program for personal/family use, a 401k and profit sharing plan, paid holidays and personal time.

To apply for this position, please complete an Initial on-line Job Application and attach your resume and cover letter expressing why you are a great fit for this position at http://www.accessdevelopment.com/careers/

Access Development is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. Access Development does not discriminate on the basis of disability, veteran status or any other basis protected class under federal, state or local laws.

All your information will be kept confidential according to EEO guidelines.

Access has been a leading provider of loyalty programs worldwide since 1984. We leverage the world's largest private savings & discount network to drive customers to retailers, create loyalty for organizations, and help their members and customers save money every day. Our employees enjoy a flexible, friendly work environment, competitive wages, excellent benefits, and employee discounts nationwide.