Conexess – Conexess Design Skip to main content

MemSQL/GraphDB

Job Title
MemSQL/GraphDB
Job ID
27428288
Location
Austin,  TX 78758
Other Location
Description

Our History:
From our start in 2009, Conexess has established itself in 3 markets, employing nearly 200+ individuals nation-wide. Operating in over 15 states, our client base ranges from Fortune 500/1000 companies, to mid-small range companies. For the majority of the mid-small range companies, we are exclusively used due to our outstanding staffing track record

Who We Are:
Conexess is a full-service staffing firm offering contract, contract-to hire, and direct placements. We have a wide range of recruiting capabilities extending from help desk technicians to CIOs. We are also capable of offering project based work.

Conexess Group is aiding an Austin, Texas based client in their search for a MemSQL/GraphDB Administrator.  This is a long term opportunity with a competitive compensation package. 

******We are unable to work C2C on this role******

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.

List 3-5 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 an 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

#LI-DS1

Option 1: Create a New Profile