Job Description
• Design and implement effective database solutions and models to store and retrieve company/clients’ data.
• Examine and identify database structural necessities by evaluating client needs, operations, applications, and programming.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Install and organize information systems to guarantee company functionality.
• Prepare accurate database design, documentation and architecture reports for management and executive teams.
• Oversee the migration of data from legacy systems to new solutions.
• Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
• Recommend solutions to improve new and existing database systems.
• Educate staff members through training and individual support as well as encourage best practices in regular works.
Job Requirement
• Bachelor’s degree in computer science, computer engineering, or relevant fields
• Minimum 3+ years of experience – A plus in finance/banking/Insurance sector or consulting company
• Outstanding problem solver, keen with attention to details, and curious in nature to overcome challenges
• Strong knowledge of database structure systems and data mining, as stated in the following
• Experience with programming languages: SQL, T-SQL, Python
• Experience with Hadoop and big data tools like Spark, and Hive will be highly desirable
• Familiarity with ETL and data warehousing tools such as Talend, Airflow, SSIS, Informatica
• Familiarity with common database systems
o Relational Databases (RDMS): Postgres, MySQL, Oracle, MS SQL Server
o Cloud computing and database: Redshift, Azure SQL Database, Amazon S3, etc.
o NoSQL Databases: MongoDB, Cassandra, HBase, etc.
o Big Data: Hadoop, Spark, MapReduce, Hive, and Pig, and other Big Data Stacks
o Graph Database: Neo4j, Amazon Neptune, Redis, etc.
o Strong desire to establish standards of best practice, automation workflow and framework
o Soft and interpersonal skills:
o Great communication skills; able to present results to non-technical audience
o Excellent leadership and mentoring skills
o Attention to detail. Be a detective to identify and fix database problems and data quality
o Creativity in solving problems; think inside and outside the box to connect dots
o Positive and can-do attitude yet humble; get excited about learnings and challenging work
o Ability to abstract general principles from specifics