Senior Postgres DBA, Senior DB2 DBA
- Synchrony Systems Inc.
8 Hours Ago
NA
Yearly
San Antonio-TX
8-10 Years
Required Skills: PostgreSQL, PostgreSQL v11+, Installation, configuration, upgrades, patching, Performance tuning, Query optimization, SQL execution-plan analysis, Index management, Replication, Clustering, High availability, failover, Backup and recovery, Database monitoring, health checks, Security, roles, privileges, access management, PostgreSQL on Linux, AWS RDS PostgreSQL, cloud-hosted databases
Job Description
Senior Postgres /DB2 DBA
§ PostgreSQL/ DB2
§ PostgreSQL Database Administration (v11 and above)
§ Installation, configuration, upgrades, and patching
§ Performance tuning and query optimization
§ Replication, clustering, and high availability
§ Backup and recovery strategies
§ Database monitoring and health checks
§ PostgreSQL security and access management
§ PostgreSQL on Linux environments
§ Experience with AWS RDS PostgreSQL or cloud-hosted databases
§ IBM DB2 Database Administration
§ DB2 Performance Monitoring and Tuning
§ SQL Optimization and Index Management
§ Database Backup and Recovery
§ DB2 Security and User Administration
§ Database Migration and Upgrade Activities
§ Production Support and Incident Management
Additional Skills
§ Linux/Unix Administration
§ Shell Scripting (Bash/KSH)
§ SQL and Stored Procedure Development
§ Monitoring Tools and Alert Management
§ Database Migration and Modernization Projects
§ Git, Jenkins, CI/CD Concepts
§ Cloud platforms (AWS preferred)
§ ITSM and Change Management Processes
• Database Administration
• Install, configure, upgrade, patch, and administer PostgreSQL and DB2 databases.
• Manage database capacity planning, growth forecasting, and storage utilization.
• Create and maintain development, QA, UAT, and production database environments.
• Performance Management
• Monitor database performance and availability.
• Analyze and optimize SQL queries, indexes, and execution plans.
• Troubleshoot slow-running queries and application performance bottlenecks.
• Implement proactive monitoring and alerting mechanisms.
• Backup, Recovery & High Availability
• Design and execute database backup and recovery strategies.
• Maintain disaster recovery and business continuity solutions.
• Configure and support replication, failover, and high-availability architectures.
• Conduct regular DR drills and recovery validation exercises.
• Production Support
• Provide L3 database support for critical production environments.
• Perform root cause analysis for incidents and recurring issues.
• Participate in on-call support rotations when required.
• Prepare RCA documents and operational reports.
• Security & Compliance
• Implement database security standards and best practices.
• Manage user accounts, roles, privileges, and auditing.
• Ensure compliance with organizational and regulatory requirements.
• Support vulnerability remediation and security audits.
• Migration & Modernization
• Lead database migration initiatives between environments and platforms.
• Support cloud migration and modernization programs.
• Ensure minimal downtime and data integrity during migrations.
• Collaboration
• Work closely with application teams, architects, cloud engineers, and business stakeholders.
• Provide technical guidance and mentoring to junior DBAs.
• Participate in design reviews and architecture discussions.
