Procal - Database Developer - SQL/PostgreSQL (5-7 yrs)

Job Overview :

About the Role :

Procal Technologies is seeking a talented Database Developer with expertise in managing and migrating databases, particularly from MSSQL to PostgreSQL.

You will be responsible for database optimization, data structure management, and performance tuning.

The role involves working with SQL, Python, and Django in a dynamic environment and supporting multiple teams.

You will also need to quickly understand our current infrastructure and contribute to future expansions involving Google-based and Elastic-based solutions.

Key Responsibilities :

- Manage, migrate, and optimize databases, particularly MSSQL to PostgreSQL.

- Design and maintain database schemas and optimize data structures for performance.

- Use SQL for querying and analyzing data in both MSSQL and PostgreSQL.

- Collaborate with teams to understand data management needs and implement strategies.

- Work with Python and the Django framework to maintain the web services gateway.

- Process and parse data from robot XML files for analysis.

- Quickly learn the current infrastructure, including Microsoft SQL databases like webride and ezw post-processing.

- Work closely with internal teams (Courtney's, Mark's, Calvin's) to ensure smooth data handling.

- Contribute to future infrastructure expansions, including Google-based and Elastic-based solutions.

Required Skills :

- Proven experience with MSSQL and PostgreSQL databases.

- Strong proficiency in SQL and database management.

- Experience in Python programming and working with the Django framework.

- Understanding of data processing and parsing XML data.

- Ability to quickly grasp existing database infrastructure and usage.

- Familiarity with collaborating across teams to ensure optimal data solutions.

Bonus Skills :

- Experience with Google-based solutions and Elastic-based solutions.

- Knowledge of cloud-based database management.

- Experience with scaling, database security, and optimization.