2,367 Postgresql jobs in the United States

Postgresql DBA

Job Description:

• Excellent interpersonal and communication skills

• Strong collaboration skills to work effectively across cross-functional teams

• Forward-thinking approach to infrastructure automation and scripting

• Ability to work with global teams across multiple time zones

• Self-motivated with the ability to work independently and seek guidance when needed

• Ability to understand application data requirements and recommend appropriate database solutions

• Responsible for designing, deploying, and maintaining EDB Postgres, PGD, and AWS RDS database clusters to support large-scale platforms and applications

• Create and manage fully functional database clusters across development, QA, and production environments, with experience in performance tuning

• Review existing configurations and recommend improvements

• Assist with planning and executing Postgres database upgrades and migrations

• Provide day-to-day administrative support and maintenance for Postgres and AWS Aurora databases

• Participate in production support and on-call rotations as needed

• Collaborate with Postgres and cloud vendors and utilize their support channels

• Develop and implement backup strategies, perform upgrades, and apply patches

• Identify inefficiencies and implement optimized solutions

• Design and execute data and database migrations to new hardware or platforms

• Lead best practices and database solution strategies at Mastercard

• Work with management to plan and implement new tools and data services

• Represent Database Engineering in strategic planning and long-term direction

• Support both internal and future cloud-managed Postgres systems, define best practices, and drive automation and innovation

• Collaborate with multiple application teams and developers

• Assist in defining long-term strategic goals for database development in alignment with stakeholders

***POSITION IS ONSITE IN NORCO, CA***

Job Summary

We are seeking a highly skilled Senior PostgreSQL Developer to join our team in Norco, CA. In this role, you will be responsible for designing, developing, and optimizing PostgreSQL databases to support mission-critical applications. You will work closely with engineers and stakeholders to ensure performance, scalability, and reliability across our systems.

As with any position, additional expectations exist. Some of these include, but are not limited to, adhering to normal working hours, meeting deadlines, following company policies as outlined by the Employee Handbook, communicating regularly with assigned supervisor(s), staying focused on the assigned tasks, and completing other tasks as assigned.

Responsibilities

• Design, implement, and maintain PostgreSQL databases and schemas
• Develop and optimize complex queries, functions, and stored procedures
• Perform database performance tuning and troubleshoot issues
• Implement replication, partitioning, indexing, and backup strategies
• Ensure database security and compliance with organizational standards
• Collaborate with developers, architects, and system admins to support application needs
• Provide mentorship and guidance on database best practices

Basic Qualifications

• 5+ years of hands-on experience with PostgreSQL development and administration
• Strong knowledge of schema design, indexing, and query optimization
• Experience with replication, partitioning, and clustering strategies
• Proficiency in performance tuning and troubleshooting database bottlenecks
• Solid experience with Linux environments and scripting (Bash, Python, or similar)
• Familiarity with cloud platforms (AWS, Azure, or GCP) is a plus
• Strong problem-solving skills and ability to work independently and in a team
• Secret Security Clearance Required
• U.S. Citizenship Required
• If applicable: If you are or have been recently employed by the U.S. government, a post-employment ethics letter will be required if employment with VSolvit is offered

Preferred Qualifications

• Experience with other databases (Oracle, MySQL, etc.)
• Familiarity with CI/CD pipelines and DevOps tools
• Knowledge of data modeling and ETL processes

C ompany Summary

Join the VSolvit Team! Founded in 2006, VSolvit (pronounced 'We Solve It') is a technology services provider that specializes in cybersecurity, cloud computing, geographic information systems (GIS), business intelligence (BI) systems, data warehousing, engineering services, and custom database and application development. VSolvit is an award winning WOSB, CA CDB, MBE, WBE, and CMMI Level 3 certified company. We offer a customizable health benefits program that best meets the needs of its employees. Offering may include: medical, dental, and vision insurance, life insurance, long and short-term disability and other insurance products, Health Savings Account, Flexible Spending Account, 401K Retirement Plan options, Tuition Reimbursement, and assorted voluntary benefits. Our goal is to grow together and enjoy the work that we do as a team.

VSolvit LLC is an Equal Opportunity/Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.

PostgreSQL Database Developer

Employment Type: Full Time, Experienced level

Department: Information Technology

CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Business Intelligence platform focused on providing data solutions that empower our federal customers. You will support a migration from the current Oracle database to a Postgres database and manage the database environments proactively. As we continue our growth, you will play a key role in ensuring scalability of our data systems.

CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities.

Skills and attributes for success:

- Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database

- Create and maintain technical documentation, using defined technical documentation templates, as well as gain an in-depth knowledge of the business data to propose and implement effective solutions

- Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements

- Ensure the availability and performance of the databases that support our systems, ensuring that they have sufficient resources allocated to support high resilience and speed.

- Perform and assist developers in performance tuning

- Proactively monitor the database systems to ensure secure services with minimum downtime and improve maintenance of the databases to include rollouts, patching, and upgrades

- Create and maintain technical documentation using defined technical documentation templates, as well as gaining an in-depth knowledge of the business data to propose and implement effective solutions

- Work within a structured and Agile development approach

Qualifications:

- Bachelor's degree

- Must be US Citizenship

- 7 years of experience with administrating PostgreSQL Databases in Linux environments

- Experience with setting up, monitoring, and maintaining PostgreSQL instances

- Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes

- Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool

Ideally, you will also have:

- Experience implementing and maintaining data warehouses

- Experience with AWS RDS for PostgreSQL

- Experience with Oracle databases

- Experience leveraging the Ora2Pg tool

- Experience with working in cloud environments such as Azure and/or AWS

- Prior federal consulting experience

Our Commitment:

Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems.

For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work.

Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.

We care about our employees. Therefore, we offer a comprehensive benefits package.

- Health, Dental, and Vision

- Life Insurance

- 401k

- Flexible Spending Account (Health, Dependent Care, and Commuter)

- Paid Time Off and Observance of State/Federal Holidays

Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Join our team and become part of government innovation!

Explore additional job opportunities with CGS on our Job Board:



For more information about CGS please visit: or contact:

Email:

#CJ

$106,773.33 - $144,906.66 a year

Job Description

Senior PostgreSQL DBA

Help the world buy it and go

Cantaloupe is a FinTech company that is constantly evolving the way companies across the globe manage, optimize, and automate the critical decisions made on a daily basis. We are committed to helping businesses grow smarter, better, and faster than ever before. Our vision is to ultimately help the world buy it and go.

Position Overview:

This position is responsible for managing and maintaining all databases in the Company to meet defined SLAs. This role will lead a team of database administrators on Azure and AWS, and ensure that data is consistently available, accessible, optimized, backed up, monitored, and secure. This position will be responsible for database tasks such as schema design, performance tuning, capacity planning, upgrades, patching, and change control activities. This position also entails all activities associated with the management and operations of lower database environments and working closely with developers, system administrators, and quality engineers to ensure system availability, continuity, data integrity, and performance of production databases.

Responsibilities:

• Reengineer and optimize Microsoft SQL Server databases on Azure
• Tune PostgreSQL and MSSQL databases on AWS and Azure to reduce cost.
• Support all activities associated with PostgreSQL and MSSQLL databases.
• Support the production environment by proactively managing the performance, integrity, and security of all applications' databases and database servers.
• Set up, monitor, and maintain disaster recovery solutions for production databases.
• Design, create and maintain highly available and secure database instances.
• Create databases and database objects such as tables, indexes, views, triggers, and stored procedures to support the Applications.
• Create ad-hoc reports at management and business requests and perform data analysis.
• Assist in the management of the hardware and software as related to the operations of the databases, including system development, maintenance, and recommendations for purchases of new hardware and software.
• Perform under limited supervision, maintain the reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
• Responsible for synchronizing and migrating data and database objects between development, quality assurance, and production environments.
• Mentor and provide support to developers in best practices for database design, programming, and tuning.
• Responsible for database administration including database system architecture, configuration, database creation, security, performance tuning and monitoring, backup and recoveries, database replication, failover strategies, data partitioning, and scripting.
• Conversant with AWS RDS, Aurora, and Microsoft SQL Servers.
• May write PL/SQL code to load, migrate, summarize, and analyze data in support of application developers and other business objectives.
• Consult with developers to optimize query performance and provide best practices.
• Prepare/review implementation plans for major code pushes on production systems.
• Document all changes, upgrades, maintenance, and procedures following controls.
• Analyze products and recommend them to senior management.
• Participate in an on-call rotation that provides 24x7x365 support of critical systems.
• Plan growth and changes (Capacity planning) on servers and databases
• Work closely with other team members for effective IT operations and business continuity
• Prepare a data archiving and retention policy

Preferred Experience:

• Minimum of 10 years Postgres DBA experience in an enterprise environment
• Minimum of 3 years leading role in Database Administration
• Bachelor's Degree in Computer Science or comparable education and experience
• Strong SQL background and demonstrable ability to optimize complex SQL queries
• Experience with Unix or Linux, and Cloud Infrastructure
• Knowledge of PostgreSQL, RDS, Aurora, Parameter groups, Azure, AWS, Microsoft SQL Server, CloudWatch, and Oracle
• Experience in the card processing industry and understanding of financial systems
• Ability to handle frequent change and remain composed in stressful situations
• Experience with Cloud Infrastructure and High Availability solutions

Why choose Cantaloupe:

We offer competitive benefits not just limited to compensation but also offer:

• Medical, Dental, & Vision Benefits coverage, plus additional benefits (Life Assistance Program, Financial Wellness, and Nutritional Counseling)
• 401(K) with employer match effective upon the first day of employment
• 18 days PTO + (9) Observed Company Holidays
• Tuition Reimbursement

As part of our commitment to maintaining the highest standards of financial integrity, this position may also involve responsibilities related to SOX compliance.