Job Description
PXG was founded by American entrepreneur and philanthropist Bob Parsons with the sole intent to design and develop the world’s finest golf clubs – and we believe we have done just that! With no cost or time constraints, PXG is committed to the long process of researching various alloys, exploring new technologies, and identifying the unique properties that make PXG clubs perform unlike anything else. With no set product release cycles, the company takes its time and pours every ounce of innovation into each new club design. PXG offers a full lineup of right and left-handed golf clubs, including drivers, fairway woods, hybrids, irons, wedges, and putters, as well as a complete line of high-performance, fashion-forward apparel. Ready to join the PXG team?
The Analytics Database Architect is responsible for planning and developing overall database design to support the Analytics team.
Responsibilities:
- Solve business problems and provide answers to business questions
- Participate meaningfully in requirements gathering
- Set up, configure, maintain, secure, and tune MySQL/SQL/Redshift instances
- Design, maintain, and secure MySQL/ SQL /Redshift databases
- Design, maintain and tune queries for Tableau datasources
- ETL data across multiple platforms
- Create and update SQL queries as needed
- Evaluate, recommend, and implement database backup & replication strategies
- Assist colleagues with query optimization, report generation, and database support
- Monitor databases and troubleshoot performance issues
- Provide feedback on capacity planning, future plans, and database-related trends
- Stay aware of developments in database technologies and explore alternatives
- Plan regular upgrades and migrations of databases
- Perform other related duties as required
Experience and Education Required:
- 5 years of experience with databases
- 2 years of experience with MySQL/SQL Server / Redshift
- Postsecondary education is helpful but not required if experience and expertise suffice
Skills Required:
- Focus on solving business problems
- Ability to consider the wider perspective of the business’s needs
- Ability to consider the myriad of details the daily work entails
- Ability to communicate effectively both verbally and in writing
- Ability to discern, evaluate, and communicate the tradeoffs in situations
- Display of a positive attitude and team spirit
- Ability to produce quality work under tight deadlines and multiple priorities
- Willingness to provide honest, helpful feedback to peers and management
- Display of curiosity and professional improvement
- Display of facile, deep expertise in database matters
- Knowledge of and adherence to Generally Accepted Software Development Practices (GAASDP)
Working Conditions:
This position primarily works in an office environment. Must be able to sit and stand for long periods of time.
YAM Worldwide is a drug-free, smoke-free, and fragrance-free work environment.
YAM believes in a diverse environment and is committed to equal employment opportunity and non-discrimination for all employees and qualified applicants without regard to a person's race, color, religion, creed, national origin or ancestry, ethnicity, sex, sexual orientation, gender (and gender identity or gender nonconformity), age, physical or mental disability, citizenship, past, current or prospective service in the uniformed services, genetic information or any other characteristic protected under applicable laws. YAM will make reasonable accommodations for qualified individuals with known disabilities, in accordance with applicable laws.