About Hype

Owned and operated under the Hype Insight group of companies, Hype Invention is a digital marketing agency based in Colombo. Our team consists of young, dynamic content writers, marketing specialists, designers, and web developers. With a focus on global clients, our portfolio includes projects from Europe, Australia, Canada, and the United States.

What will be you doing?

• Responsible for implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SaaS platform
• Supports the ongoing database reporting and analytical needs of the organization
• Ensures the database design and operations support the availability, scalability, and recoverability needs of the business
• Performs tuning and capacity management to ensure the database meets the performance needs of the business
• Guides and provides direction to developers and engineers on database development, design principles, query optimization, and index management in a fully automated deployment pipeline
• Ensures all infrastructure solutions and operational activities adhere to the security and operating policies established by the organization
• Provides on-call coverage for production support and other duties as required

Qualifications

• 1+ years experience administering highly available PostgreSQL databases and any Unstructured databases
• Proficiency in writing SQL packages, functions, triggers, and executing large-scale data updates and deletions.
• Proficiency in query optimization, indexing knowledge, modeling basics, materialized views, triggers, stored procedure development, and partitioning
• Proficiency in SQL and experience in Python
• Experience with enterprise data and cloud initiatives such as cloud-native data warehouses, implementation of data management & analytics solutions on AWS, Snowflake, Azure and/or Google Cloud.
• Experience with AWS and RDS, and Version Control systems like Git
• Familiarity with Flask, Fast API, and API development and management is a plus.