PostgreSQL DBA

iTech US, Inc.

San Antonio, TX, United States

2 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Microsoft Windows Artificial Intelligence Amazon Web Services Microsoft Azure Cloud Database Code Generation Information Systems Databases Data Validation Data Transformation Data Migration IBM DB2

+29 more

Linux DevOps Disaster Recovery Documentum Failover PostgreSQL Mainframes Nagios Operational Databases Performance Tuning Productivity Software Query Optimization Release Management Reverse Proxy Shell Script Z/OS Load Balancing Microsoft Power Automate GitHub Copilot System Availability Database Performance Generative AI Amazon Relational Database Service Information Technology Patch Management Database Replication Database Installation Sql Tuning Legacy Systems

Job description

* Perform database administration activities including: + Database installation, configuration, upgrades, and migrations + Patch management and repository maintenance + User and group administration + Job monitoring and database maintenance * Administer and support PostgreSQL and Mainframe DB2 environments. * Monitor database performance, availability, capacity, and health. * Perform SQL tuning, query optimization, execution plan analysis, and access path optimization. * Execute and monitor DB2 utilities in z/OS environments. * Troubleshoot complex production database issues and perform Root Cause Analysis (RCA). * Analyze application logs, Documentum logs, database logs, and server logs to identify and resolve production issues. * Support data migration initiatives involving: + Legacy systems + Data transformation + Data validation + Data reconciliation + Post-migration support * Manage database backup, recovery, failover, replication, and disaster recovery solutions. * Ensure database environments meet business continuity and data protection requirements. * Configure and maintain database replication environments. * Work with cloud database services including AWS RDS PostgreSQL and/or Azure PostgreSQL. * Understand and support load balancing, high availability, reverse proxy, traffic routing, session persistence, and performance optimization. * Support database environments running on Linux, Windows, and z/OS. * Develop and maintain Shell scripts for database administration and operational activities. * Collaborate with application, infrastructure, DevOps, and engineering teams. * Follow Change Management and Release Management processes. * Utilize monitoring and alerting tools to proactively identify database issues. * Apply Generative AI and AI-powered developer productivity tools such as GitHub Copilot, Microsoft Copilot, AWS Kiro, or similar tools for code generation, troubleshooting, and solution design. * Support modern cloud-native architecture and DevOps practices. * Prepare detailed incident reports, RCA documentation, and operational documentation.

Requirements

Education: At least a bachelor s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required