Title : MYSQL DB Administrator
Duration : 12+ Months
Location : San Diego, CA or Pittsburgh, PA
Look for someone who has at least 7 plus years of experience
Job description, responsibilities and duties
• Manage MySQL and/or PostrgeSQL in production/QA/dev environments including installation, configuration, upgrades, schema changes, etc.
• Provide best practices on design, availability, replication, security, audit, and backup/recovery methodologies
• Continuously re-evaluate the infrastructure for opportunities for optimization
• Troubleshoot database issues and maintain database systems availability and scalability within production environments
• Perform capacity-planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support application needs
• Support multiple Agile scrum teams to produce quality deliverables and meet deadlines, while effectively managing priorities and communicating progress
• Occasional weekend work to support scheduled maintenance
• On call to respond to and resolve application issues to ensure production applications are online
• Commit to continuous learning by updating skill sets that will help our teams and self
Job requirements
• Significant experience (5+ years) managing complex production MySQL database systems, preferably at a large consumer-facing internet site.
• Expert with MySQL and/or PostGreSQL: server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backup, HA, etc.
• Ability to develop procedures, processes and conventions to standardize database operations
• Solid understanding of RDBMS security administration
• Agile framework-based work experience is highly desirable
• Proficient in the scripting language of your choice (shell, Perl, PHP, etc) for monitoring and custom automation
• Understanding of database packaged releases, patching strategy, and enforcing standards via tools
• Experience working with Subversion, Git, CVS, or other source code management tools
• Experience with Virtual environments (VMWARE) and Cloud based systems (AWS) Experience with CI/CD for database environments will be a plus
• Other (nice to have/willing to learn)
o Agile software methodology SCRUM
o Continuous integration (Jenkins or Hudson tools)
o Design Patterns
o NoSQL databases
o Git
o Soft Skills (mandatory)
Excellent communication
Ability to learn, absorb and apply new knowledge rapidly
Working in a team
Proactive approach
Working under pressure
Language Skills
English - advanced both written and verbal (mandatory)
Years of experience: 4+
Comments
Post a Comment
Thanks