Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies, and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction.
Amazing things happen when we work in environments where everyone feels a true sense of belonging and when candidates have the requisite skills and opportunities to succeed. At Droisys, we invest in our talent and support career growth, and we are always on the lookout for amazing talent who can contribute to our growth by delivering top results for our clients. Join us to challenge yourself and accomplish work that matters.
Job Title PostgreSQL DBA
Job Location Phoenix, AZ [Onsite Work]
Duration 12 Months
Rate $60/hr C2C // $50/hr W2
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.
Droisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work environment.