Droisys · 3 months ago
Postgre SQL Developer
Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives. They are seeking a PostgreSQL Developer responsible for designing and implementing efficient data models, performance tuning strategies, and ensuring database security and compliance.
Responsibilities
Data Model Design and Implementation
The individual will be responsible for designing and implementing efficient data models for the Mid Office application. These models must be crafted with a focus on scalability and optimal performance to meet the evolving needs of the business
Performance Tuning Strategies
Developing and executing strategies for performance tuning is a key responsibility. This covers query optimisation, index management, and the continuous enhancement of database performance to ensure smooth and efficient operations
Data Retention and Purging Policies
Creating and maintaining data retention and purging policies is essential. The role involves balancing regulatory requirements with the need for optimal system performance, ensuring compliance while maintaining efficiency
Cross-Functional Collaboration
Collaboration with cross-functional teams is required to align database design with application requirements and overall business objectives. Effective communication and teamwork are vital to ensure that database solutions meet stakeholder needs
Database Security and Compliance
Implementing and managing robust database security measures is necessary to ensure data integrity and compliance with industry standards. This includes proactively addressing security concerns and adhering to best practices
Documentation
The role includes developing and maintaining comprehensive documentation for database structures, procedures, and best practices. Clear and thorough documentation supports knowledge sharing and continuity within the team
Database Monitoring and Issue Resolution
Regular monitoring of database performance is required, with a proactive approach to identifying and addressing potential issues before they impact operations
Code Review and Feedback
Participation in code reviews is expected, providing constructive feedback to team members to uphold quality standards and encourage continuous improvement
Continuous Learning and Improvement
Staying up-to-date with the latest PostgreSQL features and industry trends is encouraged. The individual should recommend and implement improvements to the database infrastructure as appropriate
Qualification
Required
At least 7 years of experience in database administration and development, with a minimum of 3 years focused specifically on PostgreSQL
Proven track record in leading and mentoring database development teams
Strong understanding of performance tuning, query optimisation, and indexing strategies
Experience in data modelling and database design within complex, high-transaction environments
Proficiency in SQL and PL/pgSQL, along with experience in using database migration tools
Knowledge of data retention strategies and compliance requirements relevant to the travel industry
Experience with database monitoring tools and conducting performance analysis
Strong problem-solving skills, with the ability to perform effectively under pressure in a fast-paced environment
Excellent written and verbal communication skills, capable of explaining complex database concepts to non-technical stakeholders
Familiarity with Agile methodologies and DevOps practices
Preferred
Familiarity with travel industry data structures and processes is advantageous
Experience with cloud-based database services, particularly AWS RDS for PostgreSQL, is considered a plus
Company
Droisys
Droisys is leading innovative company working on technologies like gamification, Artificial Intelligence, app development, etc.
H1B Sponsorship
Droisys has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (13)
2024 (8)
2023 (16)
2022 (7)
2021 (13)
2020 (14)
Funding
Current Stage
Growth StageRecent News
Digital Journal
2025-02-01
Company data provided by crunchbase