DATABASE ADMINISTRATOR

SUMMARY: 

Since 2006 PEX has been on a steady march to build and evolve a solution that helps improve the way organizations operate in order to make them more efficient, more nimble, and more competitive.

PEX has evolved into a robust, secure SaaS solution with a deep suite of workforce spend management capabilities, advanced card controls, real-time visibility into card usage, and improved reconciliation processes. More importantly, we are providing a better, more effective solution for thousands of companies and hundreds of thousands of people in the workforce. We work each day to find new ways we can help our clients operate more efficiently.

Our environment is a mix of Windows and Linux machines that reside on-premise and in the cloud. It is crucial that all work is performed under strict adherence to PCI DSS requirements, and our environment is required to be available 24x7.

WHO YOU ARE:

The Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of PEX’s database systems. Today we utilize SQL Server, MongoDB, and Redis at PEX.

WHAT YOU’LL DO:

• Designing and implementing solutions for high availability and disaster recovery, including data replication, backup, and recovery strategies
• Optimizing performance, including indexing, partitioning, and query optimization
• Capacity planning, including forecasting storage and resource requirements
• Setting up alerts and monitoring to ensure the health and performance of the databases
• Performing upgrades as required, including software upgrades and hardware upgrades
• Ensuring the security of the databases, including implementing security best practices, monitoring for security breaches, and implementing access controls.
• Managing and maintaining the databases, including troubleshooting and resolving issues, monitoring for performance issues, and implementing performance tuning
• Coordinating with other teams and stakeholders to understand their data needs and design solutions that meet those needs

REQUIRED SKILLS & QUALIFICATION 

• You should have a solid understanding of database management systems, including SQL Server, MongoDB, and Redis, as well as experience with tools and technologies used to manage and maintain databases. You should also have strong analytical and problem-solving skills, excellent communication and teamwork abilities, and the ability to work independently with minimal supervision.
• 5 years of experience with SQL Server and MongoDB
• 3 years of experience with Redis
• 2 years of experience with at least one scripting language
• 1 years of experience with Azure
• Familiarity with Windows and Linux OS
• Ability to participate in an on-call rotation.

BENEFITS

• 401(k) matching
• Unlimited Paid Time Off (PTO)
• Health Insurance 
• Referral Program 
• Remote Work