Informica Solutions
Location
Mumbai | India
Job description
Job Title : PostgreSQL SQL Developer
Experience : 3-5 Years
Job Overview:
The PostgreSQL SQL Developer plays a crucial role in the development and management of
PostgreSQL databases. Responsible for designing and implementing database schemas,
writing complex SQL queries, optimizing database performance, ensuring data security, and
collaborating with other teams to support application development.
Responsibilities:
1. Database Design and Modelling:
o Design and implement efficient and normalized database schemas.
o Create and modify tables, indexes, and constraints based on application
requirements.
o Optimize database structures for performance and scalability.
2. Query Development:
o Write and optimize complex SQL queries for data retrieval, manipulation, and
reporting.
o Tune queries and analyse execution plans to enhance performance.
o Implement best practices for indexing and query optimization.
3. Database Development:
o Develop stored procedures, triggers, and functions using SQL and PL/PGSQL.
o Create and maintain database views and materialized views.
o Implement data migration and transformation processes.
4. Performance Optimization:
o Monitor and analyse database performance using tools and techniques.
o Identify and address performance bottlenecks and slow-running queries.
o Collaborate with system administrators to optimize hardware resources.
5. Data Integrity and Security:
o Ensure data integrity by enforcing constraints and validation rules.
o Implement security measures to protect sensitive data.
o Manage user access privileges and roles.
6. Backup and Recovery:
o Develop and maintain backup and recovery strategies.
o Perform routine backups and ensure data recoverability.
7. Version Control and Deployment:
o Utilize version control systems to manage database changes.
o Coordinate database deployments in collaboration with development and
operations teams.
8. Documentation:
o Maintain comprehensive documentation of database design, schema changes,
and processes.
o Create and update documentation for database-related guidelines and
standards.
9. Collaboration:
o Collaborate with software developers, data analysts, and other stakeholders to
understand data requirements and optimize database usage.
o Provide technical expertise and support to cross-functional teams.
Qualifications:
Bachelor's degree in Computer Science, Information Technology, or related field (or
equivalent experience).
Proficiency in PostgreSQL and its related tools and utilities.
Strong knowledge of SQL and database design principles.
Experience with performance tuning and query optimization.
Familiarity with version control systems (e.g., Git) and deployment workflows.
Understanding of data security and compliance standards.
Excellent problem-solving and analytical skills.
Effective communication and teamwork abilities.
Preferred Skills:
Experience with PL/PGSQL programming.
Knowledge in Using GUI interface for DB operations (Ex. Navi Cat)
Experience of using ETL Too ls (ODI, OBIEE, SSIS) etc.
Knowledge of database administration tasks.
Familiarity with NoSQL databases and other data storage technologies.
Understanding of cloud database services (e.g., AWS RDS, Google Cloud SQL).
Job tags
Salary
Rs 9 - 10 lakhs p.a.
