Develop and maintain PostgreSQL and MySQL databases in alignment with agile development methodologies.- Write efficient, secure database code while ensuring data quality and privacy.
Implement database design principles, manage query optimization, index management, integrity checks, statistics, and understand isolation levels.
- Translate business rules into database objects and vice versa.
Create and optimize complex SQL queries, stored procedures, functions, triggers, and views in PostgreSQL.- Utilize JSON within PostgreSQL and understand its database support.
Proficient in PostGIS with a strong grasp of core geospatial concepts.
- Handle message queuing, full text indexing, and other high-performance data concepts.
Develop, modify, and implement SQL extracts as per client requirements.- Analyze and address database performance issues.
Create logical and physical data models.
- Document technical processes and write clear technical documentation.
Proficient in Data Warehouse and BI tools (e.g., Tableau, Looker).- Knowledgeable in Unix shell scripting.
Experience with MySQL installation and configuration in a multi-master environment.
- Detailed understanding of MySQL table types (MyISAM, Heap, Merge, INNO DB, ISAM) and MySQL Workbench.
Job Type: Full-time
Pay: 300,
- 00 - 1,000,000.00 per year
Jadwal: - Day shift
* Weekend availability
Experience:
- total work: 3 years (Preferred)
Work Location: In person
