Position: DBA
Company: Grid Dynamics
Category: SQL
Experience required: 5y
English level: upper
Published: 2020-04-01T00:00:00+03:00

We are currently looking for a DB Developer who will support enterprise integration pattern (EIP) related work for the project. The tasks would have a wide range. Using ingestion framework to pull data from source ERP systems into EIP landing zone, Cloudera Hadoop related work to create tables and Impala views, Spark based custom extraction framework to ETL semantic layer views into S3, Aurora DB work. Cron jobs to schedule ETL processes.

Responsibilities:

-Review current DB normalization and database structures
Implement suggestions from findings;
-Review and apply performance improvements for DB partitioning;
-Performance tunning of long-running SQL queries;
-Helping the team to create efficient stored procedures;
-Design strategy to maintain large tables including processes to add new columns/partition;
-Definition of indexing strategy;
-Set the architectural direction, long-term vision, and guiding principles for the platform;
-Asses project requirements and design architecture for the platform;
-Define security and backup procedures;
-Design conceptual and logical data models and flowcharts;
-Design and set up database clusters, backup and recovery processes;
-Design and develop new databases and tables;
-Maintain and tune existing databases and tables;
-Assess current implementation, enhance the code to maximize application efficiency;
-Troubleshoot defects and perform system analysis to assist in solving technical and business-related problems/challenges;
-Work in collaboration with onsite and offshore development teams

Requirements:

-Hands-on experience in Mysql DB performance turning;
-Experience in working with the large implementation of MySQL databases ;
-Experience in query optimization, partitioning, MySQL stored procedures;
-Experience with optimization of DB normalization;
-Experience of using tools like Solarwinds for DB health/monitoring/performance;
-Knowledge AWS Aurora MySQL is a bonus;

We offer:

-Opportunity to work on bleeding-edge projects;
-Work with a highly motivated and dedicated team;
-Competitive salary;
-Flexible schedule;
-Medical insurance;
-Benefits program;
-Social package - medical insurance, sports;
-Corporate social events;
-Professional development opportunities.