PostgreSQL DBA

1 week ago


Bengaluru, Karnataka, India DXC Technology Full time ₹ 15,00,000 - ₹ 30,00,000 per year

Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.

DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer will be responsible for developing ETL primarily utilizing Microsoft & Azure technologies within industry recognized ETL standards, architecture, and best practices.

RESPONSIBILITIES


• Act as a technical expert in the designing, coding, unit testing, supporting, and debugging of data warehouse software components in all aspects of SDLC


• Apply cloud and ETL engineering skills to solve problems and design approaches


• Troubleshoot and debug ETL pipelines and creating unit tests for ETL pipelines.


• Assess query performance and actively contribute to optimizing the code


• Write technical documentation and specifications


• Support internal audit by submitting required evidence


• Create reports and dashboards in the BI portal


• Work with Development Lead, DWH Architect and QA Engineers to plan, implement and deliver best ETL strategies


• Work with business analysts to understand requirements to create technical design specifications, gaining a sound understanding of business processes for related applications so that integration processes fulfill the end-user requirements


• Communicate effectively in a collaborative, complex and high performing team environment as per Agile principles

REQUIREMMENTS


• Proven work experience as an ETL Developer


• SQL Server , SSIS and SSMS


• Advanced knowledge of relational databases and dimensional Data Warehouse modelling concepts


• Good understanding of physical and logical data modeling


• Very good understanding of modern SaaS / PaaS data solutions in a cost conscious approach


• Expert level of knowledge of Microsoft Data stack


• Experience in developing and deploying data oriented solutions in Cloud (Azure / Synapse Analytics / Fabric)


• Experience in designing and implementing data transformation and ETL layers using Data Factory, Notebooks


• Experience with PowerBI for report & dashboard creation. PowerQuery and/or DAX is an advantage.


• Experience in / understanding of Azure Data Lake Storage


• Knowledge / use of CI/CD tools and principles, preferably Azure DevOps or Bamboo


• Strong SQL knowledge, able to create complex SQL queries and good understanding of stored procedures, views, indexes, functions, etc.


• Good working knowledge of at least one scripting language. Python is an advantage.


• Experience with GIT repositories and working with branches. GitHub, Azure DevOps or Bitbucket experience are preferable.


• Ability to troubleshoot and solve complex technical problems


• Good understanding of software development best practices


• Working experience in Agile projects; preferably using JIRA


• Experience in working in high priority projects preferably greenfield project experience


• Able to communicate complex information clearly and concisely.


• Able to work independently and also to collaborate across the organization


• Highly developed problem-solving skills with minimal supervision


• Understanding of data governance and enterprise concepts preferably in banking environment

Nice to have:


• Microsoft Fabric


• Snowflake


• Azure DevTest Labs, ARM templates


• Azure PurView


• Banking / finance experience


  • PostgreSQL DBA

    2 weeks ago


    Bengaluru, Karnataka, India, Karnataka MNC Full time

    Senior PostgreSQL/Database Administrator (DBA) – On-Prem & AWS RDSRole OverviewWe are seeking an experienced Senior PostgreSQL/ DBA with strong expertise in EDB PostgreSQL, Oracle and AWS RDS for PostgreSQL to join our team. The ideal candidate will be responsible for the administration, performance tuning, high availability, and security of...

  • PostgreSQL DBA

    2 weeks ago


    Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    TCS Hiring for PostgreSQL DBA Experience Range : 10 To 15 yearsJob Location : Delhi, Hyderabad, Bengaluru, Pan IndiaJOB DESCRIPTIONMust have skills: PostgreSQL installation and Configuration on Linux/Windows OS platform.Configuring HA, DR databases.Database upgrades and applying PSU packs.Hands on experience in writing/troubleshooting shell...

  • PostgreSQL DBA

    2 weeks ago


    Bengaluru, Karnataka, India, Karnataka Infinite Computer Solutions Full time

    PostgreSQL Experience managing PostgreSQL databases. Install, configure, and upgrade PostgreSQL database systems on Linux platforms.Experience setting up and managing Cassandra or MongoDB or CosmosDBMonitor and manage database performance, capacity, and health to ensure optimal functionality and availability.Perform regular backups, recovery, and disaster...

  • PostgreSQL DBA

    5 days ago


    Bengaluru, Karnataka, India, Karnataka Infinite Computer Solutions Full time

    Work Location: -Whitefield, Bangalore / Mepz, Chennai5 Days working from OfficeExperience:- 7+ YearsPostgreSQL Experience managing PostgreSQL databases. Install, configure, and upgrade PostgreSQL database systems on Linux platforms.Experience setting up and managing Cassandra or MongoDB or CosmosDBMonitor and manage database performance, capacity, and health...

  • AWS Redshift DBA

    2 days ago


    Bengaluru, Karnataka, India Infosys Full time

    Skills: AWS Redshift DBA Or AWS Aurora PostgreSQL/ MSSQL &RDSExperience: 5-8 yearsLocation - Bangalore (Prefer to relocate )Education: B.tech, BCA, B.ScEducational RequirementsBachelor of Engineering,BTech,BSc,BCA Service Line Cloud & Infrastructure ServicesResponsibilities A day in the life of an Infoscion • As part of the Infosys delivery team, your...


  • Bengaluru, Karnataka, India DigitalRecruiter™ APP Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role OverviewWe are hiringexperienced PostgreSQL Database Administrators (DBAs)for one of our clients, aleading global technology company. The role involves providing BAU support, performance tuning, and maintenance for PostgreSQL environments while ensuring database availability, security, and reliability. The candidate will also collaborate closely with...

  • SQL DBA with Azure

    4 days ago


    Bengaluru, Karnataka, India Digital Placement Full time

    Company Overview:Digital Placement is a reputable staffing and recruiting company operating in India. We provide excellent staffing solutions for various industries, including technology, healthcare, finance, and more.Role and Responsibilities:We are currently looking for an experienced SQL DBA with expertise in Azure and any one of the following:...


  • Bengaluru, Karnataka, India, Karnataka LTIMindtree Full time

    Role: PostgreSQL Database AdminExperience: 8 years to 12 yearsLocation: PAN IndiaJob Description:12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shiftsKEY...

  • SRE DBA Manager

    6 days ago


    Bengaluru, Karnataka, India Ivanti Full time

    Job Title: Cloud DBA Manager - SQL ServerLocation: Bangalore, IndiaJob Type: Full-timeAre you an ambitious Cloud DBA Manager with expertise in SQL Server on Azure and AWS. The ideal candidate will have strong leadership skills, experience in managing cloud database operations, and the ability to drive database strategy in a cloud environment. In addition to...

  • Technical Consultant

    2 weeks ago


    Bengaluru, Karnataka, India, Karnataka Getronics Full time

    About the CompanyGetronics family is an ICT Services group consisting of the Getronics and Connectis brands. With an extensive history that extends over 130 years, the Getronics family has 4000+ employees in 22 countries across Europe, Asia Pacific & Latin America, and has a complete portfolio of integrated ICT services for the large enterprise and public...