Jr. Database Administrator (DBA)
We are looking for a Database Administrator (DBA) who has previous experience working with databases, structures and their data. the expertise and appetite for building fun and highly interactive interfaces within an innovative and fast-growing gamified marketing company. If you love to solve problems and thrive in an exciting fast-paced environment, we are looking for you!
About Us:
Since 2008, our fast-growing company has helped build some of the most successful web-based marketing programs for the casino gaming industry. Our fun and exciting online gamification platform enhances customer engagement, acquisition, retention, and spend by embedding either into our client’s website or hosted as a standalone promotion. In our patent-pending model, customers can earn free virtual currency and claim vouchers to drive customers from the website into a client’s brick and mortar property for reward redemption. Our system has a proven track record to increase financial performance and increased property visits for our clients. The team collectively has designed award-winning programs, ranging from small corporations to Fortune 500 multinational businesses.
Position Summary:
The primary responsibility of this MySQL Database Administrator position is to manage and maintain several existing databases, as well as data import and troubleshooting problems as they arise. You must be a self-starter, proactively monitoring performance and availability of MySQL instances within the enterprise. You must communicate well with others to ensure consistency and continuity of operations, as well as providing knowledge transfer with developers, reporting agents and managers working with MySQL. Additional responsibilities include security management, assisting and serving as a resource for developers and will be involved with SDLC tasks.
- Monitor databases
- Monitor scheduled jobs
- Help import and load database data daily
- Write new reports on existing database data
- Resolve and troubleshoot MySQL issues
- Optimize database performance, health, resource use, and physical implementations of databases
- Analyze pull requests from the development team and provide input on improvements to their queries to optimize performance
- Identify and communicate other performance improvement opportunities
- Perform database and application deployments, perform environment refreshes as requested
- Create and maintain documentation of new processes and system implementations
- Provide general knowledge sharing with the other team members
- Continually seek training and ongoing learning opportunities for MySQL and related technologies, within the constraint of available time
- Provide recommendations to better meet best practices and continually seek to improve the environment
- Use our ticket management system for assigned tasks and to log time on projects
Requirements for Position
- A strong knowledge in Microsoft Excel or open-source variants, and how to use it to manipulate and clean data prior to final import into the database
- General knowledge of database management concepts and principles
- Ability to install, maintain, modify, and upgrade database software on your local computer
- Adept at following detailed written instructions
- Must be able to work within the guidance and regulation of an enterprise change management process
- Ability to learn new programs and technologies quickly
- Ability to learn our existing database structure quickly and understand the rules and restrictions of how data is stored
- Able to be highly detail oriented and organized
- Must be highly motivated, works well both independently and collaboratively
- Willing to take ownership of tasks through completion
- Possesses excellent communication skills, both oral and written. Able to work with managers and developers
- Excellent time management skills with the ability to multi-task, prioritize, and work in a fast-paced environment in order to meet assigned deadlines
Qualifications:
- Bachelor’s degree in Computer Science or equivalent technical job experience
- Minimum of 3 years of experience with architecture, installation, configuration, configuration and SQL tuning, troubleshooting and administration of MySQL required
- Expertise in complex queries
- Strong knowledge of replication, relational database modeling and design skills a plus
- Management of MySQL instances (incl: backup/restore methodologies, etc.) is a plus
- Experience working with MySQL Workbench is a plus
- Experience working with AWS is a plus