IN-Senior Associate_Database Developer_Data & Analytics_Advisory _Bangalore

PWC

5 - 10 years

Bengaluru

Posted: 27/02/2025

Job Description

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives.

As a business application consulting generalist at PwC, you will provide consulting services for a wide range of business applications. You will leverage a broad understanding of various software solutions to assist clients in optimising operational efficiency through analysis, implementation, training, and support.

Job Description & Summary: We are seeking a skilled Database Developer with strong expertise in PostgreSQL and SQL Server to support our database migration efforts. The ideal candidate will have hands-on experience in writing and optimizing stored procedures, functions, triggers, and complex queries. This role requires proficiency in both T-SQL and PL/pgSQL, along with a deep understanding of query optimization and performance tuning. This role involves converting database objects from SQL Server to PostgreSQL and ensuring efficient and optimized database operations.

Responsibilities:

Key Responsibilities:

· Migrate database components from SQL Server to PostgreSQL, including stored procedures, functions, triggers, and complex queries.

· Rewrite and optimize SQL Server code to ensure efficiency and performance in PostgreSQL.

· Implement equivalent PostgreSQL features and ensure smooth functionality post-migration.

· Optimize queries, indexes, and database performance to enhance efficiency.

· Troubleshoot and resolve issues related to database migration and performance.

Mandatory skill sets:

· Strong hands-on experience with PostgreSQL development.

· Proficiency in writing stored procedures, functions, and triggers in PostgreSQL and SQL Server.

· Expertise in T-SQL and PL/pgSQL programming.

· Extensive experience in query optimization and performance tuning.

· Proven experience in converting database objects from SQL Server to PostgreSQL.

· Ability to analyze and rewrite complex queries efficiently.

· Strong problem-solving and debugging skills.

· Excellent communication and teamwork abilities.

Preferred skill sets:

· Experience working on large-scale database migrations.

· Familiarity with cloud-based database solutions.

· Knowledge of database security best practices.

Years of experience required:

5 to 8 years

Education qualification:

Graduate Engineer or Management Graduate

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Bachelor in Business Administration, Bachelor of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Structured Query Language (SQL)

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Assessment, Performance Management Software {+ 16 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

About Company

PricewaterhouseCoopers (PwC) is a global professional services firm providing audit, tax, and consulting services. PwC helps organizations manage financial risks, comply with regulations, and improve performance through its expertise in industries like finance, healthcare, and technology.

IN-Senior Associate_Database Developer_Data & Analytics_Advisory _Bangalore

PWC

Job Description

About Company

Services you might be interested in

One-Shot Campaign