Senior MySQL DBA

Company: Punchh
Location: Austin
Posted on: January 17, 2020

Job Description:

Title Senior MySQL DBA About Punchh Headquartered in the Bay Area with offices in Jaipur, India and Austin, Texas, venture-funded, Punchh provides the top-tier digital marketing platform for brick and mortar retailers, combining AI and machine learning technologies, mobile-first expertise, and omni-channel communications designed to increase lifetime customer value. Leading global chains in verticals, including restaurant, convenience-stores, and hospitality, rely on Punchh to grow revenue by building one-to-one customer relationships at every stage of the customer lifecycle, converting anonymous customers to brand loyalists. Punchh services more than 135 enterprises across 12 countries and 37M+ consumers around the world. Punchh customers including Pizza Hut, Dairy Queen, TruFusion and more. Reporting to Senior Director of Engineering Location Austin, TX About this role We are seeking highly talented MySQL DBA to join our team. You will have extensive experience in a mission critical environment as database developer and administrator over a successful career. --You will primarily work on the design, development, and implementation of Punchh's of data architecture. What You'll Do Define and develop a data migration strategy between different products and platforms in a mission critical environment Define Schema best practices for our various database engines, and work with development teams on schema designs in regards to performance Develop complex SQL queries and stored procedures Engage in analysis, tuning, and optimization of various database products Work with our developers to optimize and tune their SQL queries Assist in the application development, debugging, and optimization with respect to data concerns. Provide input in the design and implementation of backup, recovery, and DR strategy Review application and database design for compliance Assist in troubleshooting and resolution of database issues Perform database upgrades and patches Provide leadership in database monitoring and provide concrete requirements for our 24x7 SRE team to implement What You'll Need Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience Ability to script in a high level language 7+ years of relational database development and/or administration in enterprise 7+ years of experience in database design, development Knowledge of development best practices (source control with Git, continuous integration, automated testing) Must demonstrate clear understand of logical and physical database design Experience in transactional and data warehouse solutions Must have extensive hands-on experience with MySQL in a large scale (Internet/Enterprise scale) 24x7 production environment Bonus Points If You Have Experience with software development life cycle (SDLC) in an agile environment Experience with NoSQL solutions such as Redis, Cassandra, MongoDB Hands-on production experience with Big Data applications such as Hadoop, Impala, and Spark Experience with cloud managed database engines such as Amazon RDS, ElastiCache - Redis, Snowflake Experience implementing a geo-distributed database deployment across 2 or more data centers Benefits Healthcare coverage, FSA, HSA Life and AD&D insurance 401K Competitive salaries, bonus and stock options Professional development EAP Maternity and Paternity (Bonding) Leave PTO Paid holidays Free lunch every single day, social events, plus a well stocked refrigerator Punchh is proud to provide equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. We also provide reasonable accommodation to individuals with disabilities in accordance with applicable laws. Notice to recruiters and placement agencies: If you are a recruiter or placement agency, please do not submit r--sum--s to any person or email address at Punchh prior to having a signed agreement with Human Resources. Punchh is not liable for and will not pay placement fees for candidates submitted by any agency other than its approved recruitment partners. Also, any r--sum--s sent to us without an agreement in place will be considered your company's gift to Punchh and may be forwarded to our Talent Acquisition team.

Keywords: Punchh, Austin , Senior MySQL DBA, Other , Austin, Texas