MySQL Support Engineers Sought For Positions in Australia, Russia, Mexico and Philippines

Oracle, the world's premier database company, is hiring expert technical support staff for MySQL - the world's most popular open source database! By joining this proven team of MySQL professionals, you will assist customers in the resolution of their issues with your wide-ranging skill set. From explaining database internals to reviewing schema design, from application architecture review to client code analysis, from best practices definition to defect analysis - customers will look to you for assistance in addressing their needs in a timely, professional manner. You will continually exercise and grow your diverse skills as you deliver the highest quality support possible to customers. Work location is flexible.

Job duties are varied and complex utilizing independent judgment. May have project lead role. 4 years experience with Core products or five years experience with Applications products and have a technical degree i.e., BS Computer Science/Management Information Systems/Science/ Engineering/Math/Physics/Chemistry with a 3.0 GPA OR (for Applications) proven professional/ technical experience, i.e., demonstrating an understanding of Applications at a functional and technical level (preferably Oracle)

Additional Details: Successful candidates will possess the following characteristics and qualifications:

·       Excellent knowledge of the MySQL server (preferably MySQL Cluster) and utilities

·       Experience managing MySQL in production settings

·       3+ years C/C++ or Java software development experience

·       Practical experience with distributed computing

·       Understanding of high availability, load balancing, and performance

·       Understanding of database engine design and implementation

·       Strong troubleshooting skills

·       Strong experience with Linux development environments

·       Proven skills in solving complex issues

·       Ability to pass all levels of MySQL Certification

·       Excellent spoken and written communications skills in English

·       A desire to serve customers with a passion

·       A desire to be a team player within a small virtual community

·       Ability to manage multiple priorities with limited supervision


Detailed Description and Job Requirements

As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues.

As a Sr. Support Engineer, you will be the technical interface to customers, Original Equipment Manufacturers (OEMs) and Value-Added Resellers (VARs) for resolution of problems related to the installation, recommended maintenance and use of Oracle products. Have an understanding of all Oracle products in their competencies and in-depth knowledge of several products and/or platforms. Also, you should be highly experienced in multiple platforms and be able to complete assigned duties with minimal direction from management. In this position, you will routinely act independently while researching and developing solutions to customer issues.

Job duties are varied and complex utilizing independent judgment. May have project lead role. 4 years experience with Core products or five years experience with Applications products and have a technical degree i.e., BS Computer Science/Management Information Systems/Science/ Engineering/Math/Physics/Chemistry with a 3.0 GPA OR (for Applications) proven professional/ technical experience, i.e., demonstrating an understanding of Applications at a functional and technical level (preferably Oracle)

As part of Oracle's employment process candidates will be required to successfully complete a pre-employment screening process. This will involve identity and employment verification, professional references, education verification and professional qualifications and memberships (if applicable).

Job: Support
Travel: No
Job Type: Regular Employee Hire
Organization: Oracle
Locations; Australia, Russia, Mexico and Philippines

For more information see Russia Mexico Australia Philippines  

Russia: https://oracle.taleo.net/careersection/jobdetail.ftl?job=20000018&lang=en
Mexico: https://oracle.taleo.net/careersection/jobdetail.ftl?job=200000ZL&lang=en
Australia: https://oracle.taleo.net/careersection/jobdetail.ftl?job=19001JEU&lang=en
Philippines: https://oracle.taleo.net/careersection/jobdetail.ftl?job=190019PY&lang=en

The MySQL Track at the Southern California Linux Expo 2020

  Friday March 6th you need to be in Pasadena, California for the MySQL Track at the Southern California Linux Expo. SCaLE is the biggest open source show in North America and the only one in the great Los Angeles area. 

  We have been lucky to have a MySQL track for the last several years and this year I think we have the best lineup ever!  We start at 9:30 in room 101 with Michael Marx's presentation on InnoDB Cluster, then switch to Building a Database as a Service on Kubernetes by Lucy Burns and Abhi Vaidyanatha.  Next Alexander Rubin speaks on Protecting Personal and Health Data in MySQL before lunch.

After lunch comes Implementing MySQL Database-as-a-Service using Open Source tools by Matthias Crauwels. That session is followed by sessions on isolation levels by Pep Pla, new MySQL feratures by me, and PMM from Peter Zaitsev.

And we finish with an ProxySQL introduction from the always entertaining Solomon Chang.

So please attend the MySQL track and drop by the MySQL booth in the expo hall.

MySQL 8.0 DBA Certification Exam Now Available

You can now earn your MySQL 8.0 DBA Certification Exam is now available. It is Oracle Exam 1Z0-908 and I was one of the many question writers.  Some of you may remember when I was the head of MySQL Certification and I can assure you this is a very complete test of all your MySQL DBA skills. And it asks very relevant questions and not trivial facts. So anyone taking this exam and earning this certification really knows their MySQL!

So what do you need to know:

Architecture

• Configure client connections to the server
• Understand how MySQL stores data
• Understand how InnoDB stores data and logs
• Configure buffers and caches
• Understand and use the Data Dictionary

Security

• Create user accounts and roles
• Use authentication plug-ins
• Control user and role permissions
• Recognize common security risks
• Secure MySQL server connections
• Provide password and login security
• Secure the MySQL host environment
• Prevent SQL injection attacks
• Encrypt MySQL data
• Configure MySQL Enterprise Firewall

Query Optimization

• Examine how MySQL optimizes queries
• Analyze queries with MySQL Enterprise Monitor
• Create indexes to improve server performance
• Monitor and understand index statistics

High Availability Techniques

• Explain how replication provides high availability and scalability
• Configure replication
• Explain the role of the binary log in replication
• Configure multisource replication
• Explain the role of replication threads
• Monitor and troubleshoot replication
• Describe MySQL InnoDB cluster and Group Replication
• Configure a MySQL InnoDB cluster
• Perform an InnoDB cluster recovery

Server Installation and Configuration

• Install and use the MySQL server and client programs
• Identify the files and folders created during installation
• Start and stop MySQL
• Upgrade MySQL
• Configure MySQL by using options and option files
• Configure MySQL variables
• Launch multiple MySQL servers on the same host

Monitoring and Maintenance

• Configure and view MySQL log files
• Monitor MySQL processes and status
• Configure MySQL Enterprise Audit
• Use MySQL Enterprise Monitor to view activity in MySQL
• Monitor database growth and explain capacity planning
• Troubleshoot problems with locked resources

Backups and Recovery

• Distinguish between the different types of backup
• Implement a backup strategy
• Backup and restore data with MySQL Enterprise Backup
• Use mysqldump and mysqlpump to perform logical backups
• Explain when and how to use raw file backups
• Back up the binary log

You can register for your exam here.

DBA Gym -- Free Workouts to Shape Up Your Database Strengths

Need to pump up your form or at least your third normalized form?  If you want to be a better developer, database administrator, or data expert then you need to know about normalizing your data. What is data normalization? Well Wikipedia says it is is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency.

Did you know there is a free GYM that lets you work on forms.  There are even quizzes  to help you test your knowledge.  This is part of the Oracle Gym and I started the Normally Normalized: Third Normal Form workout. 

The course states Normalizing your data structures is a key step towards high quality database design. This workout introduces you to Third Normal Form, from Wikipedia and the Database Programmer. And I can assure you that the workouts are brief, fun, and will really pack on mental muscle.

You will need an Oracle login which is free and each workout is short. Actually the two supporting documents and the three quizzes are each 5-6 minutes so in a half an hour you can complete the entire workout, or save each part by itself over a longer time period.

Other Courses are available such as deductive logic, PL/SQL, and knowing the difference between RANGE and ROWS in a windowing function.  Now most of these workout are designed for the Oracle database but the concepts usually fir very well with MySQL too. While me MySQL-ers may not need to use PL/SQL the materials on the higher level concepts are invaluable and the quizzes are going to make you think.

So if you are looking for a challenge or need a quick workout, please check out the Oracle Gym.