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 :
MapR ( Hadoop )
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 :
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