Advance Career Solutions logo

Postgresql Administrator

Advance Career Solutions

8 - 13 years

Hyderabad Pune

Posted:1 day ago

Job Description

Job Title: PostgreSQL + Power BI Engineer

Experience:

Job Description

We are looking for an experienced PostgreSQL + Power BI Engineer with strong expertise in database development, SQL programming, data modelling, and business intelligence reporting.

The ideal candidate should have hands-on experience working with PostgreSQL databases and developing interactive dashboards and reports using Microsoft Power BI. The candidate will be responsible for managing data, writing optimized SQL queries, integrating database sources with Power BI, and delivering meaningful business insights through effective reporting solutions.

Key Responsibilities

  • Design, develop, maintain, and optimize PostgreSQL databases.
  • Write complex SQL queries involving joins, subqueries, CTEs, views, functions, and stored procedures.
  • Perform database performance tuning, query optimization, and troubleshooting.
  • Develop interactive dashboards, reports, and visualizations using Power BI.
  • Build data models and establish relationships between multiple data sources.
  • Create DAX measures, calculated columns, and calculated tables to support business reporting requirements.
  • Use Power Query for data extraction, transformation, and loading.
  • Integrate PostgreSQL databases with Power BI for reporting and analytics.
  • Work on data validation, data quality checks, and report accuracy.
  • Troubleshoot database connectivity, data refresh, query performance, and reporting issues.
  • Collaborate with business stakeholders and technical teams to understand reporting requirements and deliver appropriate solutions.
  • Maintain existing dashboards, reports, database objects, and documentation.

Required Technical Skills

PostgreSQL:

  • Strong hands-on experience with PostgreSQL.
  • Advanced SQL queries, joins, subqueries, CTEs, and views.
  • Stored procedures, functions, and database objects.
  • Indexing, query optimization, and performance tuning.
  • Database troubleshooting and data management.

Power BI:

  • Hands-on experience with Power BI Desktop and Power BI Service.
  • Dashboard and report development.
  • Strong knowledge of DAX and Power Query.
  • Data modelling, relationships, and data visualization.
  • Data refresh, report publishing, and performance optimization.
  • Experience connecting PostgreSQL with Power BI.

Mandatory Skills

  • PostgreSQL
  • Microsoft Power BI
  • SQL
  • Hands-on experience integrating PostgreSQL with Power BI.

Preferred Skills

  • Experience in database performance tuning.
  • Knowledge of ETL and data transformation processes.
  • Understanding of data warehousing and reporting concepts.
  • Experience working with large datasets and complex reporting requirements.

Skills Required

Database administration Postgresql DBMS Migration Performance tuning Database migration Administration Performance

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Hybrid

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Advance Career Solutions logo
Advance Career Solutions

RecommendedJobs for You

Advance Career Solutions logo

Postgresql Administrator

Advance Career Solutions

Hyderabad, Pune

Advance Career Solutions logo

Postgresql Administrator

Advance Career Solutions

Hyderabad, Pune