MemSQL-GraphDB Admin

austin, Texas

Our client is seeking a MemSQL/GraphDB Admin to join their team in Austin, TX or Franklin Lakes, NJ.

The MemSQL/GraphDB Administrator will serve as a key member of the Enterprise Reporting Platforms team. This role’s primary focus will be to install and configure new Neo4j GraphDB Clusters and providing technical support to business stakeholders for Neo4j and MemSQL environments. The candidate will be responsible for installation, maintenance and troubleshooting of MemSQL/Neo4j and cross train to serve as a backup as needed for other BI Applications such as Tableau and Alteryx in the shared environment.

Essential Functions:

  • Installation, migration, configuration, maintenance, technical support and troubleshooting of MemSQL on Linux platform
  • Strong knowledge of Linux server setup and deployment for BI Applications is a must
  • Leverage different automation methods to deploy MemSQL/Neo4j clusters
  • Experience with Knowledge Graphs, Graph databases Neo4j
  • Develop process/automation around Database Security (Roles, Groups, Row Level Access etc.)
  • Troubleshoot Database errors
  • Strong Background around SQL & SQL Server Tools
  • Familiar with data transformation/aggregation using Scala/Spark jobs
  • Contribute to architecture and capacity planning activities
  • Configure backup processes, document and thoroughly test restore of the clustered environment to prove out the proper backup processes in place
  • Work with cross-functional technology teams for provisioning new VMs, prep VM access, firewall changes, security updates, bug fixes, monitoring and performance tuning (scaling, clustering, Load balancing)
  • Work with various technical teams such as security, network operations and dev leads to integrate MemSQL into external client portal
  • Responsible for server maintenance/Upgrades and validation after patching
  • Perform and support in Change management for software and hardware upgrades
  • Build reports/dashboards out of Metadata tables (Users, Tables, Databases) for MemSQL & Neo4j to monitor server usage to identify any performance issues or ways to best utilize resources
  • Proficiency with scripting languages (powershell, perl, python) is a plus
  • Involve in POC for open source BI tools and propose ideas to expand overall team’s skillsets
  • Manage and support migration of objects from development to production environments
  • Configure/Optimize Servers settings
  • Apply trace logs on servers in case of troubleshooting complex incidents
  • Work with stakeholders, including product and other engineers as needed
  • Apply database and application performance tuning techniques for keeping all environments at optimal performance
  • Provide off-hours and weekend support in an on-call rotation

Required Skills:

  • 5-8 year’s relevant experience with Bachelor’s degree or have a Master’s degree with 3-5 years of relevant experience
  • Must have recent hands-on experience with MemSQL Administration in a clustered environment or recent hands-on experience with installation and administration or Neo4j (GraphDB) clustered environment
  • Strong Technical knowledge in security and architecture of new patterns for BI platforms
  • Setup and configuration of Linux and Windows Servers (setup, configure, security implementation, firewalls requests etc.)

Skills, Knowledge & Abilities:

  • Experience working with Agile methodologies and cross-functional teams (Product Owners, Scrum Masters, Developers, Designers, Business Analysts)
  • Deep knowledge of MemSQL Server or Neo4j architecture
  • Strong organizational, multi-tasking and time management skills to meet key timelines
  • Excellent communication and problem-solving skills

Job keywords:

Address
Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs