MYSQL

• Database Engineer, Infrastructure DBA will be responsible for working with a diverse multi-faceted team that supports a multi-platform databases environment.
• This individual must possess general experience in production support and engineering of database infrastructure.
• The ideal candidate for this position must possess production operational experience in the management of multiple databases within a DevOps framework.
• This individual is responsible to for achieving an efficient technical infrastructure both om-prem and cloud,
• which includes appropriate tools to support production operations and will be a key contributor to a small team of highly talented professionals who are responsible for managing databases across a global enterprise.
• Gap Inc Infrastructure is a global team that focuses on providing 24/7 operational support for our customer environments, as well as up taking new technologies and services and ensuring successful deployment to these live environments.
• We are looking for a MariaDB Administrator to help us develop, design and improve our database solutions.

Reporting Level :

• This position will report to the Sr. Manager of the Database Infrastructure product team.

Shift Schedule :

• This person will work in shifts
• On-call support including periodic after hours and weekend support responsibilities.

Responsibility :

• Strong proficiency in MySQL/MariaDB 10.x database management
• Experience with various replication topology in MySQL/MariaDB
• Manage replication and maintain high availability
• Provide support for large scale MariaDB instances across production and development environments.
• Builds a network of strong, collaborative relationships (e.g., with customers,
• employees, business colleagues, and external partners) that increases collaboration
• and communication – Product Development Teams, Architects and Data Architects.
• Analyze data access and modification requirements to ensure efficient SQL and
• optimal database design
• Monitor and optimize MariaDB database performance and capacity planning
• Backup & Recovery using MariaBackup utility and native tools
• Performance-tuning consultation by working closely with software vendors to tune
• the database and meet application specific needs
• Ensures creation of runbooks for vendor partners and service providers in the
• assembly, configuration and administration of the application database
• Develop and enforce standards, policies, and procedures for managing databases
• Challenges established ways of doing things to improve the organization’s
• capabilities around commitments, actions and results
• Performs Capacity Planning for storage and performance; includes proper
• monitoring, trend analysis, and modeling.
• Strong understanding of hardware performance, memory and I/O
• understanding Linux/Unix server performance tuning at the OS level.
• Focus on automation to improve availability and scalability in our production environments.
• Help architect existing and new services in our production environments
• requiring minimal downtime and zero performance impact.
• Serve in an on-call rotation as an escalation contact for critical production issues

Minimum Required Expertise:

• 5 – 8 years of experience as an MySQL/MariaDB DBA.
• Working knowledge of operating system internals (Shell scripting, monitoring,
• debugging) in Linux environments is required
• Experience implementing database schema changes in live production environment
• Experience with monitoring tools like Nagios, Graphite, New Relic and Datadog
• Experience working with database and system maintenance procedures
• Experience with automated database migration techniques
• Experience with Agile development methodologies is highly desirable
• Good understanding of Azure and OCI platforms.
• Experience with cloud based databases is big plus
• Familiarity with one or move database technologies is a plus (MySQL, SQL Server,
• DB2-LUW and Postgres).
• Knowledge of AIX UNIX operating systems is a plus
• Good understanding of MariaDB Maxscale and MonYog
• Working knowledge with Chef
• Minimum of Bachelor’s degree in MIS/IT, business administration, or related
• discipline

Soft Skills:

• You enjoy working in a collaborative environment with multiple teams across
• different time zones
• You love to be challenged and like working in high pressure situations. If the game is on the line you want the last shot
• You have exceptional communication skills and work well in a team environment where the goal is to spread knowledge