Database Specialist

Open Source Consulting

San Jose, Costa Rica

hace 4 días

Description :

We are presently seeking a relational database expert, preferably with big data and / or business intelligence experience.

Your role will include designing, developing, maintaining, and optimizing databases large and small.

The ideal candidate will have a deep background in database administration and a thorough understanding of the relational model including cost / benefit of different index types, data stores, sharding, etc.

Your responsibilities will consist of :

schema design and development

setting up and mantaining data flows between heterogenous systems. ( ETL )

replication setup and maintenance.

analysis of when and how to partition large datasets.

query, index and schema optimization

Develop solutions to solve business problems involving heterogeneous and large datasets

developing advanced business intelligence queries

writing stored procedures or triggers.

being the BI point person amongst the technical staff.

You will initially be working with the following technologies :

MySQL

MapR ( Hadoop )

Tableau

Relevant experience with other relational databases or similar Big Data platforms will be considered.

Required Qualifications :

5 years of MySQL database administration experience in a production environment

Bachelors (Masters preferred) in Computer Science or related field.

Ability to complete tasks like database optimization, tuning, and load balancing with your eyes closed (not literally!)

Expertise with data modeling and schema design

Experience performing database health monitoring and troubleshooting for MySQL Databases

Strong SQL programming skills and scripting skills (shell, perl, python, etc...)

Experience working in a primarily Linux based environment

Bonus Points for experience with technologies such as Hbase, Hadoop, Hive, Spark, or Cassandra

Experience with the following also desirable :

Fluent English

Background in CS theory : algorithms, efficiency, etc.

Experience in applying statistical analysis methods to large datasets

Participation in architecture and design phases of projects

Understanding of source control systems and how to use them (SVN, GIT)

Ability to write and present design documents

Excellent written, verbal and communication skills

Team player motivated by technical challenges