Hello Everyone,
Hope you are doing good!!!!
My name is Pavan and I work with SPAR Information System., I have a great opportunity for you, please find the job details below, if you are interested in applying please send me your updated resume and best time for you to discuss about this opportunity in details.
Job title: PostgreSQL Developer
*Employment Type:* Full-Time
Location: Oxford, Michigan
*Experience:* 3 5 Years
## About the Role
We are seeking a talented PostgreSQL Developer to join our team and take ownership of designing, developing, and optimizing our database systems. You will play a critical role in building robust, high-performance database solutions that power our applications and analytics platforms. The ideal candidate brings strong hands-on PostgreSQL expertise and a solid understanding of ETL processes as an added advantage.
## Key Responsibilities
- Design, develop, and maintain PostgreSQL databases, including schemas, tables, views, indexes, and stored procedures.
- Write complex, well-optimized SQL queries, functions, and triggers to support application and reporting needs.
- Perform database performance tuning, including query optimization, indexing strategies, and execution plan analysis.
- Manage database migrations, version control, and schema evolution across development, staging, and production environments.
- Implement and enforce data integrity, constraints, referential integrity, and validation rules.
- Set up and manage database replication, backups, point-in-time recovery, and disaster recovery plans.
- Collaborate with application developers, data analysts, and DevOps teams to ensure seamless data integration and availability.
- Monitor database health, disk usage, connection pooling, and resource consumption; proactively resolve performance bottlenecks.
- Develop and maintain documentation for database architecture, data dictionaries, and operational procedures.
- Participate in code reviews, provide technical guidance on database best practices, and support junior team members.
## Required Qualifications
- *3 to 5 years of professional experience* working with PostgreSQL in a development or engineering capacity.
- Strong proficiency in *SQL*, including complex joins, window functions, CTEs, subqueries, and aggregate functions.
- Hands-on experience with PostgreSQL-specific features such as *PL/pgSQL*, extensions (e.g., PostGIS, pg_trgm, hstore), partitioning, and JSONB handling.
- Solid understanding of *database design principles*, including normalization, denormalization, star/snowflake schemas, and indexing strategies.
- Experience with database *performance tuning* - analyzing query plans (EXPLAIN/ANALYZE), optimizing slow queries, and managing connection pooling (e.g., PgBouncer).
- Familiarity with database *migration tools* such as Flyway, Liquibase, or Alembic.
- Knowledge of *backup and recovery* strategies, including pg_dump, pg_basebackup, WAL archiving, and replication (streaming/logical).
- Comfortable working in *Linux* environments and using command-line tools for database administration.
- Strong problem-solving skills and attention to detail.
## Nice to Have - ETL & Data Integration Skills
- Experience designing and building *ETL/ELT pipelines* to extract, transform, and load data from various sources into PostgreSQL.
- Familiarity with ETL tools and frameworks such as *Apache Airflow, Talend, dbt, Apache NiFi, or **Informatica*.
- Knowledge of data transformation techniques including cleansing, deduplication, type casting, and incremental loading.
- Experience working with *data warehousing* concepts and integrating PostgreSQL with analytical platforms.
- Exposure to *Python or Bash scripting* for automating data workflows and database maintenance tasks.
- Understanding of *CDC (Change Data Capture)* tools and techniques (e.g., Debezium, logical decoding).
## Additional Nice to Have
- Experience with cloud-managed PostgreSQL services (AWS RDS/Aurora, Azure Database for PostgreSQL, Google Cloud SQL).
- Familiarity with containerization (Docker) and CI/CD pipelines for database deployments.
- Exposure to NoSQL databases (MongoDB, Redis) or message brokers (Kafka, RabbitMQ).
- Knowledge of REST API development and how databases integrate with backend services.
- PostgreSQL-related certifications or contributions to open-source PostgreSQL projects.
## What We're Looking For
- A self-driven professional who takes ownership of database reliability and performance.
- Someone who communicates clearly with both technical and non-technical team members.
- A collaborative team player who is comfortable working in agile, cross-functional environments.
- A continuous learner who keeps up with PostgreSQL releases, community best practices, and emerging data technologies.
## What We Offer
- Competitive salary and comprehensive benefits package.
- Opportunities for professional development and certification support.
- A collaborative, innovation-focused work culture.
- Flexible working arrangements and work-life balance.
Never miss an opportunity! Create an alert based on the job you applied for.