13 Plpgsql Jobs

You should have at least 6+ years of experience working as a PostgreSQL DBA or in a similar database administration role. Your responsibilities will include demonstrating a strong understanding of PostgreSQL architecture, installation, configuration, and management. Proficiency in SQL, PL/pgSQL, and implementing database optimization techniques is crucial for this role. Experience with PostgreSQL replication methods such as streaming and logical replication is required. You should also possess a robust knowledge of database security practices and be well-versed in data privacy laws. Familiarity with backup and recovery techniques and tools like pg_dump and pg_restore is essential. Additionally, experience with cloud database platforms like AWS RDS for PostgreSQL and Azure Database for PostgreSQL is preferred. You should be proficient in Linux/Unix systems administration and have a good grasp of scripting languages such as Bash and Python. Knowledge of other skills, such as PostgreSQL on Kubernetes or containerized environments, NoSQL databases, and relational databases like MySQL and Oracle, is considered a plus. Understanding automated deployment tools like Ansible and Chef, as well as experience with monitoring tools like pgAdmin, Prometheus, and Grafana, will be beneficial in this role.,

As a Lead PostgreSQL, you will be responsible for administering, maintaining, and optimizing PostgreSQL databases to ensure high performance, reliability, and availability. Your key responsibilities include database management & maintenance, database design & development, performance monitoring & optimization, data security & compliance, database migration & version control, backup & disaster recovery, and UPI PSP Schema Knowledge. You will collaborate with developers and architects to design database structures that support application requirements and develop schemas, indexes, tables, views, and functions. Monitoring database performance, identifying bottlenecks, and implementing optimization strategies will also be part of your role. Implementing and managing database security, conducting regular security audits and backups, and supporting database version upgrades and migrations are essential tasks. To succeed in this role, you should have 7+ years of experience as a Database Administrator, primarily with PostgreSQL. Proficiency in PostgreSQL database management, tuning, and optimization, strong knowledge of SQL, PL/pgSQL, indexing, and query optimization, and experience in database security, access controls, and regulatory compliance are required. Familiarity with backup, disaster recovery, and high-availability strategies is also crucial. You should possess a Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience). Additionally, having strong problem-solving skills, attention to detail, and the ability to collaborate with cross-functional teams will be beneficial for this role.,

You have an opportunity to join a dynamic team as a Senior Oracle PL/SQL Developer with expertise in Postgres SQL. With 10+ years of experience in Oracle databases, you will be responsible for hands-on development and support in Oracle DB. Your role will involve proficient PL/SQL coding, implementing queries, packages, stored procedures, cursors, functions, and triggers. It is essential to possess the ability to debug and document SQL and PL/SQL code effectively. In this role, you should have a solid understanding of database designs and data modeling techniques. Experience in data loading, validations, and exposure to PostgreSQL DB with PL/pgSQL coding will be advantageous. Additionally, familiarity with DB migrations from Oracle to Postgres is a plus. Knowledge or exposure to Oracle Database administration tasks is desirable. An ideal candidate will have a good grasp of GCP cloud infrastructure and tools. Effective communication with onshore clients and dependent teams is crucial. Problem-solving skills, along with a positive can-do attitude, are essential. The role requires a proactive approach, the ability to work with minimal supervision, and a strong team player mindset. If you are looking to leverage your extensive experience and skills in Oracle PL/SQL and Postgres SQL in a collaborative environment, this role offers an exciting opportunity for professional growth and development. Join us in Bangalore, Hyderabad, Pune, or Kolkata, and be part of a team that values your expertise and contributions.,

As a PostgreSQL Database Administrator, you will play a crucial role in supporting product development teams by designing and managing scalable database schemas to build efficient and scalable data-driven applications for the container shipping industry. Your responsibilities will include collaborating with the product development team to design and maintain database schemas, optimizing query performance, and managing AWS Aurora PostgreSQL clusters. You will be responsible for designing database schemas that meet business and application requirements, maintaining data models for consistency and optimal performance, and implementing tables, indexes, and constraints to ensure high data integrity and performance. Additionally, you will analyze and optimize slow-running queries, tune PostgreSQL parameters for optimal performance, and work on improving database performance and addressing bottlenecks. As a PostgreSQL DBA, you will manage and administer AWS Aurora PostgreSQL clusters, ensuring high availability, backup, recovery, and disaster recovery planning. You will also optimize the use of cloud-based resources in AWS Aurora to ensure cost-effective and efficient use, monitor and maintain database systems in cloud environments, and ensure data security and availability. Furthermore, you will be responsible for ensuring that the database architecture complies with organizational security policies and best practices, implementing database encryption, user management, and access controls, and monitoring database security to address any vulnerabilities or compliance concerns. Automation of routine database tasks, documentation of database designs, performance optimizations, and providing technical guidance and training to developers are also key aspects of this role. To be successful in this role, you should have over 7 to 11 years of technology experience, with at least 5 years of experience in PostgreSQL database administration, including query optimization, schema design, and performance tuning. Strong expertise in PostgreSQL database design, SQL, PL/pgSQL, and advanced PostgreSQL features, as well as familiarity with AWS services and cloud database management practices, are essential. Proficiency in query tuning tools, database backup, recovery, replication, and failover strategies is also required. Additionally, you should possess excellent problem-solving skills, strong communication skills, and an engineering degree in computer science, Information Technology, or a related field. Experience with containerized databases using Docker or Kubernetes, event-driven architectures using Kafka, and CI/CD pipelines and Flyway Script would be a plus. Join us in this exciting opportunity to contribute to the development of efficient and scalable data-driven applications for the container shipping industry.,

Join us at LexisNexis Risk Solutions to be a part of building impactful solutions in healthcare technology. Are you passionate about creating high-quality software that can make a meaningful difference Do you thrive in collaborative environments, enjoy supporting others, and bring a positive, solutions-focused perspective to your work Our mission at LexisNexis Risk Solutions is to assist organizations in assessing and managing risk responsibly. In the Healthcare division, we strive to enhance health outcomes and improve industry operations through robust data, innovative technology, applied analytics, and deep healthcare knowledge. We are dedicated to privacy, security, and the ethical use of data in all aspects of our business. As a Software Engineering Lead, you will have the opportunity to guide a team of engineers, contribute to complex projects, and help set the direction on project plans, schedules, and methodologies. This role involves hands-on technical work as well as leadership responsibilities in people management. Responsibilities: - Act as the primary contact for software development queries and challenges, working collaboratively across technical and non-technical roles to clarify requirements and resolve issues. - Write and review clear specifications for system components to help tackle complex software challenges. - Translate business requirements into effective software designs in collaboration with your team and stakeholders. - Encourage best practices in software development, quality assurance, and coding standards using methodologies like Agile and Waterfall, fostering a learning-focused workplace. - Mentor and support the development of early-career engineers, sharing knowledge and promoting professional growth. - Contribute to people-management activities, including inclusive hiring and onboarding, providing constructive feedback, and ensuring a respectful and welcoming work environment. - Provide resources and support to your team, offering ongoing feedback and coaching to help individuals achieve their goals. - Stay updated on new technologies and industry trends, encouraging innovative thinking and continuous improvement among team members. Requirements: - Proficiency in Java and Springboot application development, including database integration and API and user interface development. - Experience with Github Actions, database technologies (PL/PGSQL, Elasticsearch, Cassandra, Oracle, PostgreSQL), web and UI technologies (JSP, JavaScript, AJAX, jQuery, HTML, CSS), and cloud platforms (AWS or Azure). - Understanding of Agile and Waterfall methodologies, ability to lead teams, collaborate with internal and external partners, and apply best practices in software engineering and data modeling. - Strong project planning, organization, and change management skills, with the ability to manage and delegate across multiple projects of varying scopes. - Demonstrated problem-solving abilities, including leading teams to troubleshoot and diagnose project issues and develop effective solutions. - Excellent communication and interpersonal skills, capable of sharing information clearly and accessibly with diverse audiences through various channels. We welcome candidates who bring diverse experiences, backgrounds, and perspectives, are eager to learn and grow, value teamwork, collaboration, and respect for colleagues, and seek an accessible and supportive workplace. LexisNexis Risk Solutions is an equal opportunity employer committed to diversity, equity, and inclusion. We strive to create an environment where all team members feel welcomed, respected, and empowered to do their best work. If you require adjustments or accommodations during the application or interview process, please inform us.,

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world. Your role includes having 4+ years of experience as a PostgreSQL DBA in production environments. You should have a strong knowledge of PostgreSQL internals, architecture, and tools, along with proficiency in SQL and PL/pgSQL. Experience with replication (streaming, logical), clustering, and failover mechanisms is also required. As a PostgreSQL DBA, you will be responsible for installing, configuring, and upgrading PostgreSQL databases and related tools. Monitoring database performance and proactively addressing issues, performing database tuning, indexing, and query optimization, as well as implementing and managing backup and recovery strategies will be part of your duties. Join Capgemini as a PostgreSQL DBA because of the company's global reputation for delivering cutting-edge technology solutions and its strong focus on innovation and digital transformation. Capgemini's diverse client base across industries offers a dynamic environment where you can apply PostgreSQL expertise to solve real-world challenges at scale. Capgemini is a global business and technology transformation partner, helping organizations accelerate their dual transition to a digital and sustainable world while creating tangible impact for enterprises and society. With a responsible and diverse group of 340,000 team members in more than 50 countries, Capgemini has over a 55-year heritage and is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market-leading capabilities in AI, generative AI, cloud, and data, combined with deep industry expertise and a partner ecosystem.,

SecuvyAI is a cutting-edge SaaS company specializing in responsible data and AI governance. Our platform leverages machine learning and GenAI to automate the protection of sensitive data, privacy, and compliance across structured and unstructured sources in the cloud and on-premises. We're serving Fortune 500 clients and hyper-growth technology firms who depend on us to manage billions of records, unlock actionable business insights, and confidently ensure compliance with global regulations. We are seeking a highly skilled SQL Developer/Architect with deep expertise in designing, developing, and optimizing large-scale, mission-critical PostgreSQL databases along with Typescript or ReactJS. You'll join a team dedicated to responsible data discovery, governance, and privacy at scale. This is a unique opportunity to work with massive datasets and cutting-edge data platforms powering the next generation of AI and compliance solutions. Key Responsibilities - Architect, design, and implement highly scalable and available PostgreSQL database solutions to support SaaS product requirements. - Develop, optimize, and maintain complex SQL queries, stored procedures, views, triggers, and functions for high-volume production environments. - Model complex data structures and create efficient data pipelines for structured and unstructured data at scale. - Tune database performance, including indexing, partitioning, sharding, and query optimization, for petabyte-scale workloads. - Ensure database reliability, security, backup, disaster recovery, and regulatory compliance across multi-tenant cloud environments. - Collaborate closely with Engineering, AI/ML, and Product teams to translate business needs into robust database architectures. - Document database standards, schemas, and processes; conduct thorough code reviews and performance audits. - Stay current with advancements in PostgreSQL and the broader database ecosystem; recommend and implement best practices. Required Qualifications - Bachelors or Masters degree in Computer Science, Information Systems, or a related field. - 5+ years of hands-on experience with PostgreSQL in large-scale, high-availability, and mission-critical applications. - Demonstrated ability to model, design, maintain, and tune complex relational databases managing billions of records. - Advanced SQL skills, including PL/pgSQL, window functions, and performance tuning. - Deep understanding of database internals, high-availability architectures, security, and compliance requirements for sensitive data. - Familiarity with cloud-based deployments (AWS, GCP, or Azure) and automation of database operations. - Experience working with data privacy, compliance, or regulatory frameworks (GDPR, CCPA, HIPAA, etc.), a strong plus. - Excellent written and verbal communication skills. Preferred Qualifications - Experience with emerging data catalog, data lineage, or AI governance platforms. - Exposure to large-scale unstructured data management and search technologies. SecuvyAI Offers - An opportunity to work at the intersection of AI, Privacy, and Data Governance with a talented, mission-driven team. - A high-impact role building transformative solutions for top enterprises and global brands. - Flexible work arrangements and competitive compensation. This job description is synthesized using general SQL/PostgreSQL developer/architect requirements from leading sources as well as unique company attributes for SecuvyAI from the provided description.,

As a Senior Database Developer at Kobie's India Tech Hub, you will have the opportunity to be one of the first hires in an exciting new venture. Kobie, a leading player in the loyalty industry, is expanding its global footprint by establishing a Tech Hub in India. This initiative aims to create deep connections with customers through personalized, data-driven loyalty experiences, further enhancing enterprise value through loyalty. Your role will involve designing scalable, data-driven solutions for high-impact loyalty platforms, leveraging your expertise in PL/pgSQL, efficient SQL queries, performance tuning, and ETL workflows. You will work with Oracle and/or PostgreSQL databases, handling complex data structures to support data integration, transformation, and analytics. As a key member of the team, you will be responsible for developing and maintaining database solutions that facilitate client onboarding, reward processing, data quality assurance, and operational performance. Collaboration with cross-functional teams such as developers, QA specialists, analysts, and DBAs will be essential to optimize data pipelines and queries, ensuring they meet the evolving needs of clients and marketing platforms. Your impact will be significant as you contribute to import and extract processes, data migration efforts, troubleshooting data quality and performance issues, tuning queries for optimal performance, supporting data integration from various sources, and providing technical assistance to stakeholders. Your ability to work both independently and collaboratively, manage priorities effectively, and communicate with technical and non-technical team members will be crucial for success. To excel in this role, you should have 5-7+ years of experience in SQL query design and maintenance, proficiency in Oracle and/or PostgreSQL, expertise in performance tuning, ETL development, data security, and a track record of working in team environments. Bonus skills include experience with data mapping tools, modern cloud platforms like Snowflake, job scheduling automation, version control systems, and supporting Java-based development teams. At Kobie, known for its award-winning culture and innovative loyalty solutions, you will be part of a collaborative and growth-focused environment. As a trusted partner to global brands, Kobie focuses on building lasting emotional connections with consumers through strategy-led technology solutions. The launch of the India Tech Hub presents an exciting opportunity to be part of a culture that values diversity, equity, inclusion, and giving back to the community. Joining Kobie means access to competitive benefits, comprehensive health coverage, well-being perks, flexible time off, and opportunities for career growth. The integration of new teammates in India with U.S. teams, exposure to global projects, and the future establishment of a physical office in Bengaluru emphasize Kobie's commitment to collaboration and connection. This is your chance to be part of something significant and shape the future of the Kobie India Tech Hub. Apply now and contribute to delivering innovative customer experiences for renowned brands while working alongside industry leaders in the loyalty space.,

As a Database Administrator at P Square Solutions LLC, a part of Neology Inc, you will be responsible for designing, creating, and managing efficient database tables, schemas, and relationships based on business requirements. Your role will involve ensuring that data models are scalable, secure, and optimized for performance while participating in data modeling activities to support data integrity and normalization. Your key responsibilities will include developing and maintaining complex PostgreSQL functions, stored procedures, and triggers, as well as implementing business logic within the database using SQL, PL/pgSQL, and other scripting languages. Collaboration with application developers to integrate databases into system architecture will also be a significant part of your role. You will be expected to analyze slow-running queries and optimize them to improve database performance, along with implementing indexing strategies, partitioning, and other performance enhancement techniques. Continuous monitoring, troubleshooting, and improvement of query execution times and database efficiency will be essential aspects of your work. Data management and integrity will be crucial, and you will need to ensure the accuracy and consistency of data by implementing proper data validation, referential integrity, and constraints. Additionally, performing data migrations and transformations to meet changing business requirements and maintaining updated documentation for database structures, procedures, and standards will be part of your daily tasks. To excel in this role, you should have a strong proficiency in PostgreSQL, including PL/pgSQL and SQL, and proven experience in designing and managing relational database schemas and tables. Expertise in creating efficient PostgreSQL functions, stored procedures, views, and triggers, as well as hands-on experience with database performance tuning, query optimization, and indexing, will be required. Experience working with Linux-based environments for hosting and managing PostgreSQL databases and scripting experience with Python, Bash, or other automation tools for database operations are also preferred technical skills. Knowledge of version control systems like Git and experience working within Agile development teams will be beneficial. Hands-on experience with query optimization, indexing, statistics, and familiarity with NoSQL databases like Redis, cloud-based database services such as AWS RDS, AWS Aurora, Azure Database for PostgreSQL, performance tuning tools like Toad, PEM (Postgres, enterprise manager), Redgate, and data archival and purging processes will be considered an added advantage for this role.,

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world. Your role includes having 4+ years of experience as a PostgreSQL DBA in production environments. You should possess a strong knowledge of PostgreSQL internals, architecture, and tools, along with proficiency in SQL and PL/pgSQL. Experience with replication (streaming, logical), clustering, and failover mechanisms is essential. Your responsibilities will involve installing, configuring, and upgrading PostgreSQL databases and related tools, monitoring database performance, and proactively addressing issues. Additionally, you will be expected to perform database tuning, indexing, and query optimization, as well as implement and manage backup and recovery strategies. What you will love about working here is joining Capgemini as a PostgreSQL DBA because of the company's global reputation for delivering cutting-edge technology solutions and its strong focus on innovation and digital transformation. Capgemini's diverse client base across industries offers a dynamic environment where you can apply PostgreSQL expertise to solve real-world challenges at scale. Capgemini is a global business and technology transformation partner, helping organizations accelerate their dual transition to a digital and sustainable world while creating tangible impact for enterprises and society. With a responsible and diverse group of 340,000 team members in more than 50 countries, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. The company delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market-leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.,

As a Pentaho ETL Developer based in Sydney/Melbourne/Brisbane, your primary responsibilities will include designing, developing, automating, monitoring, and maintaining ETL jobs, batches, processes, and metadata for data transfer to and from various internal and external sources. You will be tasked with troubleshooting data issues, proposing, testing, and implementing solutions, as well as documenting technical requirements and solutions. Additionally, you will participate in design and code reviews, project planning, and ensuring accurate requirements fulfillment within an agile environment. Your qualifications for this role should include demonstrated experience with Pentaho ETL tools, software development, and proficiency in programming languages such as Java (Groovy), JavaScript, SQL, PL/pgSQL, and PL/SQL. Experience with the Pentaho Kettle tool, SQL optimization for platforms like PostgreSQL and Oracle, as well as familiarity with NoSQL databases like Cassandra will be advantageous. Knowledge of Kimball ETL architecture techniques, Unix/Linux operating systems, data integration tools, and scripting languages like bash, Python, or Perl is also required. You should possess excellent communication, analytical, and development skills, along with a strong understanding of real estate information systems standards and practices. Ideally, you will have at least 5 years of experience working in a data warehouse environment handling ETL processing, as well as knowledge of data warehouse and master data management concepts. Effective teamwork, adaptability to changing priorities, and customer-centric approach are key attributes for success in this role.,

The project involves the migration of a financial instruments trading legacy mainframe system to a new technical, highly-scalable platform. The successful migration and creation of a scalable platform have positioned it as the strategic platform for providing advisory services for a major financial institution. This has resulted in further investment in legacy system migrations and technical enhancements. The project is currently spread across multiple locations including Weehawken, Wroclaw, Toronto, and Pune. The main responsibilities of this role include reengineering existing applications, introducing an additional application interface layer to query underlying data from third-party applications, and ensuring the following: - Writing clean code - Testing code thoroughly - Participating in backlog refinement, planning, and demos - Conducting code reviews - Collaborating with stakeholders to clarify requirements - Participating in solution architecture design and implementation The ideal candidate should possess the following skills: - Full-stack software development experience - Strong Front-end skills with 3+ years of experience in JS + React - Strong JAVA 7 and 8 experience with 6+ years of professional web-based and API development in Java - Practical experience in SQL - Experience in MS Azure or other Cloud platforms Additional skills that would be beneficial for the role include: - Experience with microservices architecture and Spring framework - Knowledge of PostgreSQL and PL/pgSQL - Background in the banking sector or with enterprise programs Proficiency in English at a B2 Upper Intermediate level is required for this position.,

As a PostgreSQL developer at Movius, you will be responsible for designing, developing, and maintaining databases within secure hosted environments. Your role will involve utilizing PostgreSQL to create scalable, reliable, and high-performance database solutions. You should hold a Bachelors or Masters degree in Computer Science or a related field, along with a minimum of 7 years of professional experience in databases. Your expertise in Database Design will be crucial as you design and implement PostgreSQL solutions that meet the organization's requirements. Programming skills are essential as you will be writing and maintaining code to interact with the PostgreSQL database using languages like SQL, PL/pgSQL, and Python. Query Optimization will be a key aspect of your responsibilities to enhance performance and ensure prompt responses to user queries. Database Maintenance and Monitoring are vital tasks to ensure the proper functioning, availability, and security of the database. Troubleshooting skills will be necessary to address any issues promptly and efficiently, ranging from errors and crashes to performance problems. Documentation plays a significant role in your work, as you will be responsible for creating and updating documentation related to the database schema, configuration, and administration. Collaboration with fellow developers, database administrators, and stakeholders is crucial to ensure that the database effectively meets the organization's needs. Continuous Improvement is encouraged, and you will be expected to explore new methods to enhance the database's functionality and performance continually. Your familiarity with PostgreSQL replication and high availability implementation will be an added advantage in this role. Overall, as a PostgreSQL developer at Movius, you will be at the forefront of database design, development, and maintenance using PostgreSQL, a robust and widely utilized DBMS. Your contributions will be instrumental in supporting the organization's database requirements effectively.,