Restaff/House Of NorwaySenior Database Developer
May. 2015 - Jun. 2019Ho Chi Minh city• Cooperate with development team to create and implement data model, design database structure.
• Modify existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Maintain database systems, including backup/restore, setup new Oracle Database Server, MSSQL Server.
• Implement database objects in Oracle and MSSQL based on requirements (Packages, Stored Procedures, Functions, Views, Indexes).
• Identify issues within databases, perform troubleshooting and implement effective solutions.
• Participate data transferring process from customer's databases systems to in house database systems by using SSIS, database link, web API services; including communicate to analyze and get agreement on business and technical requirements, perform data quality testing, interfaces testing.
• Consult to solve technical problems for customers.
• Cooperate with the development team to implement free-text search feature with ElasticSearch, including researching and defining a synchronization method between MSSQL and ElasticSearch, design data model in ElasticSearch, writing Elastic queries with Kibana.
• Provide weekly reports to Management Board, Marketing and Sale Teams.
• Create dashboard, reports for customers by using Power BI.
• Created technical documentation for database technologies, providing updates as needed.
• Technical: Oracle 10g, Oracle 11g, Oracle 12c, MSSQL 2012, Visual Studio, Microsoft TFS, Power BI, ElasticSearch.