Postgres DBA

Cognizant; Charlotte (NC); On-site; USD 110,000 - 150,000; Full time

Job summary

Cognizant in Charlotte, NC is seeking a PostgreSQL DBA to design, implement, and operate scalable data models for utilities analytics. You will ensure high availability, backups, and secure access across Production, UAT, and Development environments.

The role emphasizes performance tuning, capacity planning, and collaboration with onsite and remote teams to deliver reliable data driven services for customers and communities.

Qualifications

• Extensive hands-on PostgreSQL experience in enterprise environments.
• Knowledge of data warehousing and dimensional modeling.
• Experience with utilities/energy domain data is a plus.
• Proficiency in data integration tools and scripting in PostgreSQL ecosystems.
• Familiarity with hybrid work practices and collaboration tools.

Responsibilities

• Administer and maintain PostgreSQL databases across Production, UAT, and Development environments.
• Ensure database availability, reliability, and operational stability.
• Perform database provisioning, configuration, and lifecycle management.
• Manage database startup, shutdown, connectivity, and service health validation.
• Monitor database growth, storage utilization, and capacity planning.
• Design, implement, and test backup and recovery strategies.
• Plan and execute High Availability and replication configurations.
• Tune PostgreSQL parameters, memory, I/O, and autovacuum settings.
• Implement security standards and access controls.
• Coordinate incident, problem, and change management activities.
• Develop automation scripts for health checks and maintenance tasks.
• Create and maintain SOPs, runbooks, and recovery procedures.

Skills

PostgreSQL

DBA experience

Performance tuning

Data modeling

Data governance

Education

Bachelor's degree in Computer Science or related field

Tools

Bash

Python

PostgreSQL utilities

Job description

Location: Charlotte, NC - 100% onsite

Leading PostgreSQL DBA to create scalable data models for utilities domain use cases and enabling trustworthy analytics that advance organizational decisions and deliver positive value to customers and communities through reliable data driven services.

About Cognizant’s CIS Practice:

Cognizant’s CIS (Cognizant Infrastructure Services) Practice is a global leader in providing IT infrastructure services. We deliver innovative solutions to optimize and transform IT infrastructure, ensuring business agility and operational efficiency. Our services include cloud computing, data center management, network services, and cybersecurity. We focus on understanding client needs and delivering customized solutions to drive business success.

In this role, you will:

Database Administration & Operations

• Administer and maintain PostgreSQL databases across Production, UAT, and Development environments.
• Ensure database availability, reliability, and operational stability.
• Perform database provisioning, configuration, and lifecycle management.
• Manage database startup, shutdown, connectivity, and service health validation.
• Monitor database growth, storage utilization, and capacity planning.

2. Backup, Recovery & Disaster Recovery

• Design, implement, and test backup and recovery strategies.
• Perform logical and physical backups using PostgreSQL utilities.
• Conduct restore validations and recovery drills.
• Define and maintain RPO/RTO objectives.
• Ensure disaster recovery readiness and periodic DR testing.

3. High Availability & Replication

• Design and support PostgreSQL HA architectures.
• Configure and maintain streaming replication and logical replication.
• Monitor replication health and replication lag.
• Plan and execute failover and switchover activities.
• Support enterprise-grade HA/DR solutions.

4. Performance Tuning & Optimization

• Analyze and resolve database performance bottlenecks.
• Tune PostgreSQL parameters, memory, I/O, and autovacuum settings.
• Review and optimize SQL execution plans.
• Design indexes, partitioning strategies, and query optimization solutions.
• Monitor lock contention, blocking sessions, and database wait events.

5. Security & Compliance

• Implement database security standards and best practices.
• Manage users, roles, privileges, and access controls.
• Enforce least-privilege principles.
• Support audits, compliance requirements, and security reviews.

6. Incident, Problem & Change Management

• Resolve critical incidents within SLA commitments.
• Perform Root Cause Analysis (RCA) and drive preventive actions.
• Support change, release, and deployment activities.
• Coordinate recovery activities during major incidents.

7. Automation & Monitoring

• Develop automation scripts using Bash, Python, Shell, or PostgreSQL utilities.
• Automate health checks, maintenance tasks, and reporting.
• Implement proactive monitoring, alerting, and observability solutions.
• Monitor backups, jobs, replication, and database health.

8. Documentation & Knowledge Management

• Create and maintain SOPs, runbooks, architecture documents, and recovery procedures.
• Maintain operational documentation and troubleshooting guides.
• Produce health reports, audit evidence, and management updates.

What you’ll need to succeed:

• Possess extensive hands on experience working with PostgreSQL including design tuning partitioning and management of large datasets in complex enterprise environments
• Apply strong knowledge of data warehousing dimensional modeling and relational design principles to construct efficient and maintainable schemas suited for high volume analytics
• Demonstrate practical exposure to utilities or energy domain data such as metering asset management and usage analytics enabling better alignment between data solutions and industry needs
• Bring solid proficiency in data integration tools scripting or procedural languages that work effectively with PostgreSQL ecosystems to orchestrate reliable data movement and transformation
• Exhibit familiarity with hybrid work practices and collaborative tools which support effective communication and coordination across onsite and remote teams during standard day shifts
• Show understanding of data governance security and compliance requirements including concepts such as role based access retention and quality controls to ensure trustworthy data operations
• Display experience in performance monitoring and capacity planning for database platforms enabling proactive tuning and stable operation under growing data and workload demands within the organization
• Support cloud migration and hybrid database deployments and lead complex troubleshooting and performance investigations.

Applications will be accepted until Oct 26th 2026. Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.