Role & Responsibilities: Database Sizing and Capacity planning, installation, configuration, database design and migration. Collaboration with Technical team to provide optimal database solution. Performance monitoring, security, troubleshooting, as well as backup and data recovery. Involve in the planning and development of the database, map out the conceptual design for a planned database, refine the logical design with specific data model. Maintain data standards and refining the physical design to meet system storage requirements, database integrity and consistency. Preventive Maintenance check for Production Databases. Install and test new versions of the database management system (DBMS). Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata) and control access permissions and privileges. Provide tools and techniques to the team for developing database tasks such as performance tuning, data analysis, database design and schema comparing and so on. Involve in Data Analysis process and write Database Stored Procedure, Function and view that needed in Data Analysis Process. Assemble large, complex data sets that meet functional, and non-functional business requirements. Optimal extraction, transformation, and loading of data from a wide variety of data sources. Experience with Data warehouse, Data Lake and ETL Pipeline Understanding programming concepts, modeling framework, statistical theory, Big Query, Power BI, Tableau, Azure, AWS, Big Data Technology are optional.
Ability to learn and adapt to new technologies quickly. Cooperate with other teams in building the architecture of the project including DB Design and System Design. Develop new software projects in both window and web platform by evaluating analysis, problem definition and solution development. Develop existing programs by analyzing and identifying areas for modification. Maintain existing software according to the incidents and requests. Integrate multiple devices to the projects according to the requirements. Analyze and test programs before formal launch. Mentor junior and share knowledge and development experience. Support the deployment engineers and collaboration. Give software training to support engineers and junior developers. Prepare ISO documentation by individual system. Install prerequisite devices, software, and database setup. Give deployment instruction to Support Engineers. Support and follow up deployment for website and client applications if operation is needed.