Job Description :
MemSQL Admin
Hands on experience with MemSQL
3 years hands on with MemSQL, 7 years total experience
Build MemSQL solution and lead, collaborate with team
Coding optimization, DB Design
DB understanding, ETL processing
Other DB experience – Oracle, Teradata
Installation, migration, configuration, maintenance, technical support and troubleshooting of MemSQL Leverage different automation methods to deploy MemSQL cluster in different environments 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 infra teams for provisioning the new VMs, setup access to VMs via service IDs, prep the servers to be leveraged for clustering Work with various 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 Work with cross-functional technology teams for firewall changes, security updates, bug fixes, monitoring and performance tuning (scaling, clustering, Load balancing) Build and monitor server usage statistics to identify possible performance issues/enhancements for BI Applications Linux server setup, deployment, and maintenance Proficiency with scripting languages (powershell, perl, python) 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 Document best practices for development and administration for optimum performance Provide off-hours and weekend support in an on-call rotation