Mô Tả Công Việc
- Participate in Distributed Multi-tier Application Development, Database Design, Data processing, Data Warehouse and Support database technology on different platforms
- Understand and perform data modeling, processing and warehousing techniques, Design, implement and administer databases Server platform
- Ensuring Database security by restricting and following corporate standards
- Writing PL-SQL Queries that varies from single table simple SQLs to multiple table complex SQLs
- Document concise design, development, and testing processes for assigned projects
- Analytical and debugging, coordination with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables
- Use database utilities to troubleshoot performance issues from Application layer to database layer
- Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics
- Use TOAD or equivalent developer tools for day-to-day technical activities
- Perform query optimization & performance tuning using any of the tools like:
- SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, Database Engine Tuning Advisor,
- DBCC commands, DMVs and Third-Party Tools like Ignite, SQL Sentry Plan Explorer, Dynatrace
Yêu Cầu Công Việc
- Bachelor's degree (Computer Science/Information Technology/Electronics & Communication/ Information Science/Telecommunications)
- At least 3+ years of experience
- Certified in a Database technology stack added advantage
- Proficient in PL/SQL programming language
- Communication and Collaboration: Strong communication skills to effectively work with stakeholders, gather requirements, and collaborate with teams on database-related projects.
- Query Optimization: Skills in optimizing SQL queries and database performance, including proper indexing, query tuning, and analyzing execution plans.
- Database Administration: Creating database objects like Tables, packages, procedures.. or changes into existing objects, security, monitoring
- Experience with security standards
- Data Warehousing: Familiarity with concepts related to data warehousing, including dimensional modeling, star schemas, and data aggregation
- ETL (Extract, Transform, Load): Understanding of ETL processes and experience in data extraction, transformation, and loading from various sources into a database. Create/ Execute/ Monitor Oracle jobs
- Prepare & writing the Technical Document or update (Diagram and data architect)
- Experience with SVNGIT, Jira
- Experience in BI tools such as Power BI, Tableau, Qlik
- Proficient in building technical specification documents, including ERD, Database schema, swagger APIs
- Use TOAD as GUI, SQL navigator…
- Ability to read and understand English documents
Hình thức
Quyền Lợi
- 12 days annual leave + 3 days sick leave + 1 day birthday leave.
- 13th month salary bonus (Pro Rata).
- End of year party.
- Very competitive Salary and benefits.
- Health Care.
- Mid-year company trip.
- Monthly Team building.
- Fantastic Modern Offices.
- Latest technology.
- 5 days - working week.
- Training and Development.