Position Details:
Industry: Multinational Investment Bank And Financial Services Corporation
Work Location: Plano, TX/ Chandler, AZ/ Charlotte, NC.
Job Title: PostGre SQL Database Architect
Duration: 12 Months

Misson:

• Postgres SQL Database Administrator (DBA) who will be responsible for implementing high availability (HA) solutions and building critical database solutions as part of our strategic program. This role is crucial and requires availability for support and meetings during US hours, as well as engineering, testing, and support of various environments.

Day-to-Day Responsibilities:

• Provide comprehensive support for production applications, ensuring their stability, reliability, and performance.
• Conduct thorough problem analysis of applications, troubleshoot system errors, and address performance issues.
• Perform proactive application stability analysis to identify performance concerns, system errors, and improvement opportunities.
• Take ownership of root cause analysis and implement appropriate remediation strategies.
• Lead investigations into chronic issues to minimize business impact and maintain system health.
• Develop and implement proactive monitoring strategies.
• Collaborate with Engineering, Application Development, and Infrastructure teams to implement fixes, updates, and enhancements.
• Manage application operations, business continuity, server patching, vulnerability remediation, and monitoring setup.
• Lead production incident triaging calls and provide on-call support, including weekend rotations.
• Execute disaster recovery procedures and strategies.
• Respond to and resolve production tickets promptly to meet service level agreements (SLAs).

Required Skills: 

• Extensive experience in database administration, specifically with PostgreSQL.
• Proficiency in monitoring and maintaining databases, optimizing performance, and ensuring security.
• Strong skills in shell scripting and database replication.
• Ability to create playbooks and expertise in Unix System Administration.
• Experience in architecting large-scale production database platforms.
• Strong knowledge of Postgres production and contingency replication features and configurations.
• Expertise in Postgres HA Clustered environments.
• Proficiency in scripting languages such as Python or shell script.
• Strong experience with Linux and Ansible.
• Hands-on experience with failover/migration and data restores in HA environments.
• Experience with database patching and continuous application support.
• Familiarity with Splunk and Kafka.
• Proficient in handling crontabs and data backups using pgBackRest.
• Experience with Kubernetes/OpenShift clusters for PostgreSQL.
• Ability to create and maintain documentation, troubleshooting playbooks, and test failover and recovery plans.
• Perform regular database maintenance tasks.
• Ability to write Ansible playbooks.
• PostgreSQL DBA experience in a 24x7 production environment.
• Experience in configuring, managing, and troubleshooting PostgreSQL on Linux.

Must Have:

• PostgreSQL.
• Python/Shell Scripting
• pgBackRest.
• Kubernetes/OpenShift clusters for PostgreSQL.
• Emphasis on Database recovery and disaster mitigation.