Data Engineer - PostgreSQL
- Prudent Globaltech
- 5 - 10 years
- Hyderabad
- 4 months ago
- Email to a friend
- Report this job
Job Description
About the Role:Key Responsibilities:
- Design, implement, and maintain PostgreSQL database systems for high availability and performance.
- Write efficient, well-documented SQL queries, stored procedures, and database functions.
- Analyze and optimize slow-performing queries and database structures.
- Collaborate with software engineers to support schema design, indexing, and query optimization.
- Perform database migrations, backup strategies, and disaster recovery planning.
- Ensure data security and compliance with internal and regulatory standards.
- Monitor database performance and proactively address bottlenecks and anomalies.
- Automate routine database tasks using scripts and monitoring tools.
- Contribute to data modeling and architecture discussions for new and existing systems.
- Support ETL pipelines and data integration processes as needed.
- Bachelor's degree in Computer Science, Information Systems, or related field.
- 5 years of professional experience in a database engineering role.
- Proven expertise with PostgreSQL (version 12+ preferred).
- Strong SQL skills with the ability to write complex queries and optimize them.
- Experience with performance tuning, indexing, query plans, and execution analysis.
- Familiarity with database design best practices and normalization techniques.
- Solid understanding of ACID principles and transaction management.
- Experience with cloud platforms (e.g., AWS RDS, GCP Cloud SQL, or Azure PostgreSQL).
- Familiarity with other database technologies (e.g., MySQL, NoSQL, MongoDB, Redis).
- Knowledge of scripting languages (e.g., Python, Bash) for automation.
- Experience with monitoring tools (e.g., pgBadger, pg_stat_statements, Prometheus/Grafana).
- Understanding of CI/CD processes and infrastructure as code (e.g., Terraform).
- Exposure to data warehousing or analytics platforms (e.g., Redshift, BigQuery).
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Data EngineerEmployement Type: Full timeContact Details:
Company: Prudent GlobaltechLocation(s): Hyderabad
Keyskills: continuous integration sql postgresql python transaction management amazon redshift ci/cd data warehousing redis gcp devops mysql bigquery prometheus etl mongodb cloud sql amazon rds data engineering nosql grafana bash terraform aws gcp cloud
Similar positions
Prudent Globaltech
Prudent technologies & Consulting, Inc. is a full-service information technologies consulting firm with more than 18 years of specialisation in IT staffing, Data Analytics and Customer Application Development Solutions. Service range from IT Project Solutions to Offshore IT Solutions to IT...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in