Optimus Fox is a dynamic and innovative technology company that specializes in Block chain. We are committed to delivering cutting-edge solutions that empower businesses to thrive in the digital age. As a part of our continuous growth and expansion, we are seeking a highly skilled SQL Database Developer to join our talented team.
As a SQL Database Developer at OptimusFox, you will play a pivotal role in designing, implementing, and maintaining our database systems. Your expertise in SQL programming and database management will be essential in optimizing data storage, retrieval, and integrity. You will collaborate with our cross-functional teams to ensure seamless integration of our applications with the database infrastructure. If you are passionate about data, love working with databases, and are eager to contribute to our mission, this position is ideal for you.
Responsibilities:
Develop simple and complex stored procedures, functions, and views to meet enhancement requirements.
Provide best practice guidance to the development team with regard to database design and usage.
Develop automation technologies to expedite the process of loading data into the end target;
Develop ETL strategies for integrating data from multiple sources in data warehouses;
Design and develop relational databases;
Develop appropriate corrective actions to resolve production data issues;
Design database schema to meet new enhancement requirements.
Optimize database performance.
Requirements:
Minimum of 2+ years of experience working with PostgreSQL
Familiarity with PostgreSQL support for JSON
Demonstrated experience writing complex stored procedures and queries;
Proven experience troubleshooting and solving complex databases schemas/warehouses;
Understanding and experience of Software Development Life Cycle;
Strong analytical and communication skills;
Bachelor’s degree preferred;
Experience in database development, administration, and management;
Proven experience using ETL for data integration;
Proven experience with integration from SQL to Postgres;
Proven experience with integration from SQL to postgres.
Perks and Benefits:
Competitive salary package.
Flexible work hours and remote work options.
Opportunities for career growth and skill development.
Friendly and inclusive work environment.