Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
Some similar recruitments
Regional Travel &Amp; Tour Manager
Recruited by Mad Monkey 10 months ago
Address Tanjung, Indonesia
Associate Data Intelligence (Sirclo)
Recruited by Dealls – Jobs & Mentoring (YC W22) 11 months ago
Address Kota Tangerang, Indonesia
Business Intelligence Analyst - Lead
Recruited by Absa Group 11 months ago
Address Prime, Indonesia
Business Support Intern (Sirclo)
Recruited by Dealls – Jobs & Mentoring (YC W22) 11 months ago
Address Kota Tangerang, Indonesia
Data Intelligence Intern (Sirclo)
Recruited by Dealls – Jobs & Mentoring (YC W22) 11 months ago
Address Kota Tangerang, Indonesia
Data Intelligence Intern Jobs
Recruited by SIRCLO 11 months ago
Address Kota Tangerang, Indonesia
Trainee Business Intelligence Consultant (Data Engineer)
Recruited by Axians NL 1 year ago
Address Laren, Indonesia
It Dbi: Database &Amp; Business Intelligence
Company | PCS Group |
Address | Kota Tangerang, Indonesia |
Employment type | FULL_TIME |
Salary | |
Category | Jasa TI dan Konsultan TI |
Expires | 2023-10-06 |
Posted at | 8 months ago |
Key Responsibilities
- Enhance the performance of existing database programs and ensure optimized performance.
- Experience working with the ELK stack (Elasticsearch, Logstash, Kibana) for log and event data management.
- Review all new query development before implemented in production, cooperating with the related developers team.
- Support developers in troubleshooting and tuning problematic queries.
- 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.
- Create best practice guidance on query design compatible with the company’s existing data to maximize efficiency and performance.
- Debug database scripts and programs, as well as resolving conflicts.
- Conduct regular database best practice workshops / training to developers to increase knowledge on database design and awareness of database flaws and common pitfalls.
- Maintain and monitor query performance on the production database.
- Contribute to our Business Intelligence efforts, utilizing data to inform strategic decisions.
- Familiarity with multi-database environments and data synchronization strategies.
- Support developers with SQL query creation and optimization.
- Support developers with a focus on database design, query design, query tuning performance, and indexing strategy.
- Familiar with PostgreSQL procedure, function, view, materialized view, trigger & scheduler agent.
- Great knowledge in Structured Query Language (SQL) and database design.
- Advance knowledge of PL/pgSQL/MSSQL Server, SQL, execution analysis & optimization, indexing strategies, etc.
- Advance working SQL knowledge and experience working with a variety of databases.
- Proficiency in MySQL and MongoDB.
- Good knowledge and experience in tuning query and database indexing.
- Knowledge of DBaaS on Cloud is a plus.
- Familiarity with Python and Apache Kafka is a plus.
- Plus points for experience in programming and/or familiarity with Go programming language (Golang).
- Proficient in English, both verbally and in writing.
- Strong communication skills; ability to deliver detailed information between team members and to other teams; ability to glean knowledge from received information.
-
Marketing Officer Jobs
By PT. Livindo Artha Gracia At Banten, Indonesia 8 months ago
-
Research Intern (Seagrass Transplantation)
By CarbonEthics At Bintan, Indonesia 8 months ago
-
Regional Asset Lead Jobs
By Beam Mobility At Indonesia 8 months ago
-
Ui/Ux Application Design (Fresh Graduated)
By Sahaware Indonesia At Bandung, Indonesia 8 months ago
-
Devops Manager Jobs
By Skubbs At Indonesia 8 months ago