IT: Staff Database Optimization Engineer
PCS Group
- South Tangerang, IndonesiaPT Pasifik Cipta Solusi L.50 , Kav. 13-15 Jalan Jendral Sudirman , South Tangerang, Banten, IndonesiaSouth TangerangBantenIndonesiaIndonesia
- 6.500.000,00 IDR - 9.500.000,00 IDR / monthIDR650000095000006500000MONTH
- Toàn thời gianFULL_TIME
Miêu Tả Về Công Việc
- Support developers with a focus on database design, query design, query tuning performance, and indexing strategy.
- Review all new query development before implemented in production, cooperating with the related developers team.
- Maintain and monitor query performance on the production database.
- Enhance the performance of existing database programs and ensure optimized performance.
- Debug database scripts and programs, as well as resolving conflicts.
- Support developers in troubleshooting and tuning problematic queries.
- Create best practice guidance on query design compatible with the company’s existing data to maximize efficiency and performance.
- Conduct regular database best practice workshops / training to developers to increase knowledge on database design and awareness of database flaws and common pitfalls.
- Perform database backup/restore and indexing table (PostgreSQL & MSSQLserver).
- Perform PostgreSQL database parameter tuning and data migration from or into PostgreSQL using ETL tools like SSIS, Apache Airflow, Informatica, etc.
- Familiarity with multi-database environments and data synchronization strategies.
- Experience working with the ELK stack (Elasticsearch, Logstash, Kibana) for log and event data management.
- Support developers with SQL query creation and optimization.
- Contribute to our Business Intelligence efforts, utilizing data to inform strategic decisions.
Trình độ tối thiểu
- Great knowledge in Structured Query Language (SQL) and database design.
- Proficiency in MySQL and MongoDB.
- Good knowledge and experience in tuning query and database indexing.
- Advance knowledge of PL/pgSQL/MSSQL Server, SQL, execution analysis & optimization, indexing strategies, etc.
- Familiar with PostgreSQL procedure, function, view, materialized view, trigger & scheduler agent.
- Advance working SQL knowledge and experience working with a variety of databases.
- Familiarity with Python and Apache Kafka is a plus.
- Knowledge of DBaaS on Cloud is a plus.
- Willing to Work From Office (Not Hybrid)
Personal Attributes
- Strong communication skills; ability to deliver detailed information between team members and to other teams; ability to glean knowledge from received information.
- Proficient in English, both verbally and in writing.
- Plus points for experience in programming and/or familiarity with Go programming language (Golang).
Tóm tắt công việc
- Trình Độ Công Việc
- Phó Giám Sát/Giám Sát
- Ngành Nghề
- IT and Software
- Yêu cầu học vấn
- Tốt nghiệp Cử nhân
- Nhà tuyển dụng trả lời hồ sơ
- Sometimes
- Địa chỉ văn phòng
- Jl. Anggrek Loka Jl. Anggrek Lili No.41, Rw. Buntu, Kec. Serpong, Kota Tangerang Selatan, Banten 15310
- Ngành nghề
- Information Technology / IT
- Vị trí đang tuyển
- 1 vị trí tuyển dụng mới
- Trang web
- https://pcsindonesia.co.id/
Về PCS Group
PCS Indonesia is a company engaged in financial technology products and services. We provide payment solutions with the latest technology and in accordance with the development of the world.