Aktana - Sr Database and Implementation Engineer (Chengdu)
Aktana is looking for a talented Database Engineer to help develop and administer large-scale data integration, data processing and data analytics database and platform.
Director of Engineering and Operations, China
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 logic
Analyze and understand data sources and end-user requirements to deliver data integration solutions for managing Aktana 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.
People and Project Management Skills
Excellent verbal and written English communication skills
Ability to lead and mentor heterogeneous engineering teams in complex projects
The incredible work ethic that thrives in fast-paced, collaborative, dynamic teamwork 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
2+ 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
2+ 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
NICE TO HAVE
Understanding differences in setup/tuning strategy for different OS platforms: especially Linux vs. Windows
Experience with NoSQL data management and analysis technologies such as Cassandra, MongoDB, Hadoop, HDFS, HBase, Pig, Hive, Redis, MemcacheD, Redshift
BS/MS degree in Computer Science or related fields and/or equivalent work experience.
Committed to customer success and innovation, Aktana is at the forefront of transforming how life sciences companies share information with healthcare providers (HCPs). Our proprietary platform harnesses machine learning algorithms to enable marketing and sales teams to seamlessly coordinate and optimize multichannel engagement with HCPs. Today 10 of the top 20 global biopharmaceutical companies are using Aktana to go to market smarter.
Aktana is growing fast and looking for exceptional talent to join our team. We value hard work, transparency, and collaboration – and we like to have fun too! Headquartered in San Francisco, we have offices around the world, including Philadelphia, New York, London, Barcelona, Tokyo, Osaka, and Shanghai.
If you are excellent,please reach out for us via: Protected content