Job Description
Role: Enterprise Database Administrator (PostgreSQL & DB2 Mainframe)
Descriptions:
"• Perform Administration Activities including installation, upgrades, migrations, patch management, repository maintenance, user/group administration, and job monitoring.
• Lead and support Data Migration initiatives involving legacy systems, data transformation, validation, reconciliation, and post-migration support.
• Strong proficiency in SQL and PostgreSQL database troubleshooting, performance tuning, query optimization, and data analysis.
• Experience in troubleshooting production issues through application log analysis, Documentum logs, database logs, and server logs, performing root cause analysis and resolution.
• Strong understanding of Load Balancing concepts, high-availability architectures, reverse proxies, traffic routing, session persistence, and performance optimization.
• Familiarity with cloud-native architecture principles and modern DevOps practices.
• Experience leveraging AI-powered developer productivity tools such as Kiro, GitHub Copilot or similar tools for code generation and solution design.
• Database Administration and Performance Management
• Monitor database performance and availability.
• Backup and Recovery manage failover and disaster recovery solutions.
• Ensure business continuity, data protection, configure and maintain replication environments.
• Work with cloud database services such as AWS RDS PostgreSQL or Azure PostgreSQL.
• Execute and monitor DB2 utilities and perform SQL tuning and access path optimization.
• Prepare RCA and incident reports, Managed backup, recovery, and disaster recovery processes.
• Provided production support and resolved database performance issues in z/OS environments."
Descriptions:
"• Perform Administration Activities including installation, upgrades, migrations, patch management, repository maintenance, user/group administration, and job monitoring.
• Lead and support Data Migration initiatives involving legacy systems, data transformation, validation, reconciliation, and post-migration support.
• Strong proficiency in SQL and PostgreSQL database troubleshooting, performance tuning, query optimization, and data analysis.
• Experience in troubleshooting production issues through application log analysis, Documentum logs, database logs, and server logs, performing root cause analysis and resolution.
• Strong understanding of Load Balancing concepts, high-availability architectures, reverse proxies, traffic routing, session persistence, and performance optimization.
• Familiarity with cloud-native architecture principles and modern DevOps practices.
• Experience leveraging AI-powered developer productivity tools such as Kiro, GitHub Copilot or similar tools for code generation and solution design.
• Database Administration and Performance Management
• Monitor database performance and availability.
• Backup and Recovery manage failover and disaster recovery solutions.
• Ensure business continuity, data protection, configure and maintain replication environments.
• Work with cloud database services such as AWS RDS PostgreSQL or Azure PostgreSQL.
• Execute and monitor DB2 utilities and perform SQL tuning and access path optimization.
• Prepare RCA and incident reports, Managed backup, recovery, and disaster recovery processes.
• Provided production support and resolved database performance issues in z/OS environments."
Numbers & Facts
| Location | Aurora, IL |
| Industry | Computer/IT Services |
| Company Size | 500 to 999 employees |
| Year Founded | 1990 |
| Website | http://q1tech.com/ |
About Company
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.
Skills
- Amazon Relational Database Service (RDS)unmatched
- Analysis Skillsunmatched
- Artificial Intelligence (AI)unmatched
- Cloud Architectureunmatched
- Cloud Computingunmatched
- Data Analysisunmatched
- Data Migrationunmatched
- Data Recoveryunmatched
- Database Administrationunmatched
- DevOpsunmatched
- Disaster Recoveryunmatched
- Documentum Enterprise Content Management (ECM) Systemunmatched
- Failoverunmatched
- GitHubunmatched
- High Availabilityunmatched
- IBM DB2unmatched
- IBM z-OS Operating Systemunmatched
- Identify Issuesunmatched
- Information/Data Security (InfoSec)unmatched
- Load Balancingunmatched
- Mainframe Computerunmatched
- Microsoft Windows Azureunmatched
- Performance Analysisunmatched
- Performance Managementunmatched
- Performance Tuning/Optimizationunmatched
- PostgreSQLunmatched
- Problem Solving Skillsunmatched
- Production Supportunmatched
- Query Optimizationunmatched
- Reconciliationunmatched
- Replication and Remote Mirroringunmatched
- Root Cause Analysisunmatched
- SQL (Structured Query Language)unmatched
- SQL Databasesunmatched
- Software Patchesunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder