Job closed.
Job Description
- Design, Development and Implementation of database system
- Install and configure MSSQL, POSTGRESQL
- Respond to queries related to database from user/ software development team
- Provide Database support services at all times to ensure continuous system availability
- Setup user access, privileges, and permission for database segmentation
- Perform database migration, backup and recovery
- Design specifications for database storage, database clustering, database security and audit solutions
- Produce database build documentation for standards adherence
- Utilize best practices, work plans, checklists and defined processes
- Perform database sizing and tuning
- Work with application architects to gather database requirements
- Participate in Software Development Project
- Test Databases and Perform Bug Fixes
Minimum Qualifications
- Candidate must possess at least Bachelor's Degree in Engineering (Computer/Telecommunication), Computer Science/Information Technology or equivalent.
- Required language(s): English.
- Minimum 3 to 5 Year(s) of working experience in the related field is required for this position.
- Required Skill(s): MySQL, MS-SQL, POSTGRESQL.
- Strong knowledge on different server operating system such as Windows, Unix, Linux and etc.
- Familiar with DOCKER.
- Experience in Performance Tuning of Databases (MSSQL, POSTGRESQL).
- Background in SQL Query, Stored Procedures and TSQL.
- Experience with MS SQL Server 2012 or above and experience with MS-SQL Server in a clustered environment is required.
- Understand the Concept of Relational Database, Database Design and Acrhitecture
- Experience with replication (transactional or log shipping).
- Understand strategy to tune performance, file distribution, memory management and tuning SQL Statement.
- Experience in ETL Tools such as Pentaho.
- Understand Backup and Restore Databases.
- Shell scripting OS ( windows/ Linux ) capabilities for monitoring, Cronjob/ job scheduler.
Perks and Benefits
- Medical / Health Insurance
- Medical, Prescription, Dental, or Vision Plans
Required Skills
- Database Software
- Oracle Database
- PostgreSQL
- SQL
- MySQL
- Database System Administration (DBA)
Jobs Summary
- Job Level
- Associate / Supervisor
- Job Category
- IT and Software
- Educational Requirement
- Bachelor's degree graduate
- Recruiter response to application
- Sometimes
- Office Address
- Jl. Prajurit KKO Usman dan Harun No.16, RT.1/RW.1, Senen, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10410, Indonesia
About ICDX
Indonesia Commodity & Derivatives Exchange (ICDX) provides facilities and infrastructure to its members to conduct prime commodity transactions and enforce laws and regulations to create a fair, transparent, cost effective, and well-organized market as a platform to form accountable and credible prices, and as a hedging tool. With abundant natural resources in Indonesia, ICDX is able to facilitate national interest as a global trading center for prime commodities such as Gold, Crude Oil, Foreign Exchange, Crude Palm Oil (CPO) and Tin.
ICDX collaborates with PT Indonesia Clearing House (ICH) and PT ICDX Logistik Berikat (ILB). ICH has a role as the guarantor institution for all transactions including managing risk management, margin, and transaction settlement. Meanwhile, ILB plays a role in physical transactions to eliminate country risk and also an integrated logistics management system as end-to-end services.