MySQL Database Administrator

Accesso - Lake Mary, FL - Who We Are accesso® is a world-wide software company delivering industry leading virtual queuing, eCommerce and ticketing solutions for the attractions, cultural and leisure industries. The accesso Passport ticketing suite was built for where your customers shop - whether at the front gate, on their computers at home or from their mobile phones. The attractions industry's #1 eCommerce engine has sold 28+ million tickets online per year and processed over $1 billion transactions annually. Our innovative approach to up-selling, cross-selling and simply selling more are key differentiators of our proprietary hosted technology and an important component of maximizing revenue. What You Will Do We are currently seeking a database administrator (DBA) to join our data and analytics team to manage multiple highly available and high transaction level databases. As part of this team, you will be responsible for the performance, integrity and security of multiple enterprise databases. You'll be involved in the planning and development of databases, as well as troubleshooting issues on behalf of the users. As a database administrator you will see that database performance is managed to expected levels. We will expect you to work well under pressure, have excellent problem-solving techniques, and be able to quickly adapt and learn. Location: Lake Mary, FL ***Please note in light of COVID-19, all of our employees globally are telecommuting until further notice.*** Reports to: Director, Business Intelligence and Analytics Travel Requirement: none Responsibilities Include: Ensure that our database systems are available and performing within standards with 24/7 availability Establish the needs of users and monitor user access and security, controlling access permissions and privileges Monitor performance in order to provide fast responses to the Engineering teams and proactively diagnose potential problems Coordinate and work with the software engineering teams to ensure proper query performance and index management Ensure that standards are met in the designs for planned databases and related entities Ensure that there are provisions for data security and recovery control (ensuring all data is retrievable in an emergency) Install and test new versions and service patches of the database management system (DBMS) as required Maintain data standards, including adherence to the Data Protection Act Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata) Develop, manage and test back-up and recovery plans Ensure that storage and archiving procedures are functioning correctly Work closely with infrastructure engineers, software engineers, I.T. and security personnel Communicate regularly with infrastructure, applications and operational staff to ensure database integrity and security Required Qualifications: Minimum 3+ years of experience in database administration of complex systems using MySQL (primary) and SQL Server Expertise in database performance tuning and optimization Experience with large database management with extremely high transactional loads Strong knowledge of SQL, security practices, best practices for recurring maintenance Advanced troubleshooting and problem-solving capabilities Excellent communication and written skills Ability to collaborate in a team and work independently to complete tasks Bonus Qualifications: Experience working Amazon RDS environments, particularly Amazon Aurora DBs Experience with other RDBMS technologies, especially PostgreSQL Experience working with AWS Redshift Perks & Benefits: Competitive compensation package including discretionary annual bonus opportunity. 4-weeks of Paid Time Off for employees up to 3-years of tenure (higher accrual thereafter); 8-hours of paid Volunteer Time Off to give back to organizations and groups you feel most passionately about; 2-weeks of paid Parental Leave so you can bond with your child(ren) following a birth, adoption, or foster care placement; Inclusive Family Benefits - access to end-to-end support for maternity, surrogacy, adoption, and fertility, with a $5,000 benefit toward surrogacy, adoption, and fertility; Three different medical insurance plans to choose from, including an employer-contributed HSA; Employer-paid short & long-term disability and life insurance; Matching 401K; Unlimited access to Udemy for Business for continued learning and career development; A flexible work schedule around our core business hours. WORKING AT accesso: accesso is taking precautions to protect the health and wellness of our employees around the world during the current pandemic, including but not limited to the temporary suspension of business travel and the implementation of remote work. Albert Einstein said, “In the midst of difficulty lies opportunity.” At accesso, this time of uncertainty has created opportunities for us to strengthen our partnerships as we continue innovating on future technology needs in a post-COVID world; to grow as a company as we identify areas for improvement in business processes and practices; and to focus on our wellbeing as we learn to navigate a new circumstance while staying meaningfully connected with our individual selves, families and teams. When we are in the office, we have FUN! From our bright, open spaces, foosball and ping-pong tables, caffeine and snack-filled cafes, we've created office environments all over the world that nurture our team members' creativity and fosters our company's core values: Passion, Teamwork, Commitment, Integrity, and Innovation. These values are celebrated globally, by region, and by team through a multitude of recognition programs such as iValue, Rockstar, and Legends Awards. We are empowered to do our jobs and then are recognized and rewarded for doing it well. Our teams work really hard, encourage and motivate one another, and love to celebrate personal and professional accomplishments as a family. This creates an atmosphere where people are eager to solve problems together and want to continuously do better for not only themselves, but for their teams and peers. We are an Equal Opportunity Employer and believe in the power of inclusivity. We are committed to creating a diverse environment for our employees to celebrate one another's unique qualities. Any hiring decision made is assessed on the basis of qualifications, merit, and business need. We are an Equal Opportunity Employer and believe in the power of inclusivity. We are committed to creating a diverse environment for our employees to celebrate one another's unique qualities. Any hiring decision made is assessed on the basis of qualifications, merit, and business need. Read more about at accesso. ABOUT accesso: At accesso, we understand that technology is a critical component to our client's success and the happiness of their guests. No business should have to settle for technology that creates more issues than it solves! Technology should be the solution, not the problem. Our clients need powerful technology solutions to grow their businesses and create connected guest experiences - and accesso delivers! That's why over 1,000 venues in 30 countries have chosen to partner with us.​ ​​ The status quo is not an option. If you're not moving forward, you're falling behind. With our accesso solutions, venues can empower their staff with the control, data and confidence to make informed decisions that will drive revenue, create operational efficiencies and improve guest experiences.... - Permanent - Full-time

source http://jobviewtrack.com/en-in/job-4e1f41694c100e0c460745432905030e0b49071c1b125e444f2f601d3c3f6b5461070508000e165406091d1c5829794c59050d0f5411002e11323f2b67611005001d4358495f4c10001c25395930392d6f5e551340/226558b6a8c168b206768d31b79b01ac.html?affid=f584d43114bf1954a48e3ec6be21b6ec