DB Administrator (offline)

Our client is one of the biggest global manufacturing services company based in the United States. The services provided by the customer include design engineering, manufacturing, supply chain, and materials technology services. We help customer’s development organization with several mission-critical projects including global tracking and analysis systems and cloud-based auto replenishment services. Our distributed international teams, located in Eastern Europe and the United States are deeply integrated with customer side teams, located in the United States and Asia.

If you are excited about all aspects of modern engineering, from writing great code, to creating architectures, designing components, interacting with clients and delivering a working system to production, then you are the kind of person we are looking for. If you enjoy freedom and responsibility, creative thinking, leading and mentoring others, then join our team of world-class developers, QA engineers, DevOps engineers, architects, and managers.

We are currently looking for a DB Administrator 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

About us
Grid Dynamics is the engineering services company known for transformative, mission-critical cloud solutions for retail, finance and technology sectors. We architected some of the busiest e-commerce services on the Internet and have never had an outage during the peak season. Founded in 2006 and headquartered in San Ramon, California with offices throughout the US and Eastern Europe, we focus on big data analytics, scalable omnichannel services, DevOps, and cloud enablement.

About Grid Dynamics

Grid Dynamics is a world-class expert company with highly scalable distributed solutions and CI/CD. We help one of the biggest financial companies on the East Coast to solve the challenging problems that affect the entire development organizations, like building enterprise web services with millisecond response time, or improving development processes by introducing Agile, test automation, TDD, and CI/CD processes.

Company website:
https://www.griddynamics.com