Facebook pixel

Mysql or Mongo Database Consultant
Confirmed live in the last 24 hours
Locations
Remote • Northeastern United States, USA
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
AWS
Bash
Development Operations (DevOps)
Docker
Google Cloud Platform
Linux/Unix
Microsoft Azure
MongoDB
MySQL
Kubernetes
Python
NoSQL
Ansible
Requirements
  • While we understand you might not have everything on the list, to be the successful candidate for the MySQL & Mongo DBC job you are likely to have skills such as
  • Strong knowledge and experience in installing, configuring and upgrading MongoDB databases, as well as general administration
  • Schema design, performance tuning, query optimization, backup solutions (Physical and Logical) Replica set (elections, read/write concerns, arbiters) etc
  • Sharding (choosing a good shard key, balancer, moving chunks, zoning shard with pre-split chunks, etc)
  • Engine selection and usage
  • Detailed understanding of monitoring requirements
  • Demonstrable experience of administering Linux based systems
  • Knowledge about virtualized environments such as VMWare, Docker and/or Kubernetes
  • Knowledge of public cloud providers (AWS, Google Cloud, Digital Ocean and/or Azure)
  • Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues
  • Very good documentation skills
  • Scripting/automation tooling (bash/python and Ansible) experience would be great
  • Nice to haves include; Understanding of current IT service standards such as ITIL. Being a contributor to Open Source projects relevant to MongoDB, MySQL or other database or infrastructure software. Completed MongoDB University courses
Responsibilities
  • The Database Consultant (DBC) will, as part our team based approach, supply complete support for all aspects of database and application infrastructure to a variety of Pythian customers
  • Our collaborative Mongo environment means everyone works together to solve complex puzzles and develop innovative solutions for our customers
  • You'll work closely with the customer teams to understand their needs, in both a project based and long term support capacity
  • You'll create and document database standards, create optimized queries, indexes, and data structure
  • Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support
  • Use database vendor provided tools and Pythian developed accelerators to performance tune various database system, specific queries and applications scenarios
  • Diagnose and address database performance issues using performance monitors and various tuning techniques
  • Identify areas of opportunity and recommend appropriate improvement suggestions
  • Work with our SRE organization to help configure and deploy High-Availability and Disaster Recovery solutions for critical applications to meet customers needs
  • Cross-functional training in NoSQL, Site Reliability Engineering and DevOps methodologies are encouraged
  • When you're not fixing things, you'll be authoring new blog posts on interesting topics for our open-source community to digest, creating new articles in our customer facing knowledge base for more frequently seen issues, and hosting webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community
Pythian

201-500 employees

IT consulting and managed services provider
Company mission
As a global IT services company, Pythian helps organizations transform by leveraging data, analytics, and the cloud. Pythian designs, implements, and supports customized solutions for the toughest data challenges. Delivering thousands of projects to the cloud, because they believe it is the very best place to be.
Company Values
  • Stand apart, stand above - A key differentiator for us is that we’re technology agnostic, which allows us to partner with our clients to address their pain points and needs, as well as offering flexible contract models.