MYSQL ID-12465
Job Description :
- 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
