Position: Data Engineer
Company: DataMola
Category: SQL
Experience required: 3y
English level: upper
Published: 2022-07-01T00:00:00+03:00

RESPONSIBILITIES
● Architect, design, and implement large scale data management and business analytics solutions at a detailed level by applying industry knowledge, best practices, and architectural guidance to ensure system functionality, performance, and cost efficiencies
● Create packages, procedures, functions, triggers, and views to implement business logics
● Analyze and understand data sources and end-user requirements to deliver data integration solutions for managing data.
● Design, build, test, implement, and support ETL/Data Integration solutions that meet defined requirements
● Formulate and implement monitoring, security, and availability policies, procedures and standards relating to server and storage management.
● Manage database updates to production using SQL scripts or other automation technology
● Script and/or develop in-depth application and database monitoring tools and recovery mechanisms.
● Background in tuning and optimizing of MySQL, SQL Server, Oracle, or Postgres environments as well as diagnosing and solving performance issues.
REQUIREMENTS:
● People and Project Management Skills
○ Excellent verbal and written English communication skills
○ Ability to lead and mentor heterogeneous engineering teams in complex projects
○ Incredible work ethic that thrives in fast paced, collaborative, dynamic team work environment
○ Ability to work on multiple projects simultaneously, meeting different schedules and deadlines
○ Proven ability and desire to deliver projects on time, on quality
○ Able to cope with and thrive in uncertain and changing project requirements
○ Ability to lead technical projects and code at the same time
○ Experience with/understanding of Agile development processes
● Technology Skills and Experience
○ 5+ years database development and architecture experience in a production environment supporting large data platforms.
○ Strong experience of data modeling, schema design, and stored procedures○ Strong experience on SQL, Procedural SQL including programming and ways to optimize SQL code in one of RDBMS environments
○ 4+ years of ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (required)
○ Experience with ETL (required), Pentaho (preferred), Informatica or similar tools
○ Working experience with both high volume OLTP and high volume batch processing
○ Tuning experience with high volume OLTP and high volume batch processing
○ Strong scripting and automation skills with bash, perl, python, java, or ruby on Linux and Windows environments.
○ Demonstrated understanding of RDBMS clusters and replication with one of RDBMS systems: MySQL , SQL Server, or Oracle,
○ Extensive experience on system and database monitoring
○ MySQL , SQL Server, or Oracle certification required
○ Demonstrated self-motivation and a personal track record of life-long learning
● Pluses:
○ Understanding differences in setup/tuning strategy for different OS platforms: especially Linux vs. Windows
○ DNS Services
○ Experience with NoSQL data management and analysis technologies such as Cassandra, MongoDB, Hadoop, HDFS, HBase, Pig, Hive, Redis, MemcacheD, Redshift