PostgreSQL Database Programmer and Administrator – Onsite, Malaysia
We are the Database team at Deriv.com, the custodians of the company’s database, which is critical to the company’s daily operations. We turn raw data into actionable intelligence, ensure data integrity, implement security controls, monitor data traffic, troubleshoot issues, and plan for expansion as the company grows. We ensure our databases are tough enough to withstand the threat of cybersecurity breaches.
Founded in 1999, Deriv.com (formerly Binary.com) is a pioneer in online trading. We enable our customers to trade on the world’s financial markets. Focused on customer-centric solutions, we aspire to be the world’s leading online trading service provider.
A career at Deriv.com offers you the opportunity to make an impact in a fast-growing organisation that’s at the cutting edge of online trading technology.
As a PostgreSQL Database Programmer and Administrator at Deriv.com, you will plan, install, and maintain database systems to ensure the security, integrity, and seamless flow of information for our high-traffic online trading platform.
What you’ll do
Plan, install, and configure world-class database systems that meet business objectives and the needs of end-users.
Assist Back-end developers in writing production-ready SQL code.
Plan and carry out the upgrade and migration of databases.
Develop, implement, and test database backup and recovery plans.
Manage database and data security by controlling access to data through authentication, authorisation, and auditing.
Perform tests to ensure database performance and security, as well as data integrity.
Document and administer database policies, procedures, and standards.
Plan and execute data extraction for efficient loading in our data warehouse, and ensure extracted data is useful and properly formatted.
Troubleshoot and debug problems in existing database systems, and find new ways to improve their speed, functionality, and scalability.
What you have
Experience as a Postgres DBA, with advanced hands-on knowledge of:
Experience with database testing tools such as pgTAP
Experience with data extraction and reporting for data warehouse/cube
Knowledge of Linux system administration, including configuration and automation tools such as Chef as well as Shell scripting
Excellent spoken and written English communication skills
What’s good to have
Knowledge of Perl and other scripting languages
Experience with Multidimensional Expressions (MDX)
What we’ll give you
Productive work atmosphere
Cooperation, support, and empowerment
Career progression opportunities
Annual performance bonus
Casual dress code
Travel and internet allowances
Cyberjaya is a well-planned township with no shortage of residences, restaurants, retail outlets, and recreational facilities. Blending urban development with nature, Cyberjaya is rich with lush greenery, lakes and parks, making it ideal for work and play. The Maju Expressway (MEX) conveniently connects Cyberjaya to Kuala Lumpur city and the rest of the Klang Valley, while the Dedicated Transport Services (DTS) provides reliable transportation for those commuting to and from Cyberjaya. Thirty minutes away from KL city centre, our Cyberjaya office is where you can experience the ultimate work-life balance.