Description
Are you a PostgreSQL Database Administrator with a passion for solving complex challenges and optimizing database performance? This opportunity allows you to manage and maintain PostgreSQL databases, including installation, configuration, and performance tuning. You will also handle PostgreSQL replication, assess and improve SQL performance, and troubleshoot issues.
Responsibilities
- Manage and maintain PostgreSQL databases.
- Handle PostgreSQL replication and troubleshoot performance issues.
- Develop shell scripts and automate routine tasks to streamline operations.
- Work with AWS services such as EC2, RDS, and Aurora, implementing cloud deployments using Jenkins, Bitbucket, and Terraform.
- Utilize PostgreSQL PGAdmin for client connectivity and oversee upgrades, backups, and recovery.
- Use ticketing and monitoring tools (like ServiceNow, Zenoss, CloudWatch) to track and resolve issues.
Must-Have Skills
- 10+ years of PostgreSQL DBA experience.
- Deep understanding of PostgreSQL's storage engines and hands-on experience with large, dynamic environments.
- Skilled in shell scripting and automation for database tasks.
- Experience with AWS EC2, RDS, and Aurora, as well as cloud deployment tools like Jenkins and Terraform.
- Strong skills in performance tuning and problem-solving.
- Excellent verbal and written communication skills.
Desired Skills
- Familiarity with additional databases such as DB2 UDB, Oracle, MySQL, Microsoft SQL Server, MongoDB, or Cassandra.
- Experience with configuration management tools like SCCM, Puppet, or Ansible.
- Ability to implement automation to reduce manual tasks.
- Bachelor's degree or similar experience.
Why You'll Love This Opportunity
- Enjoy a flexible work schedule with three days in the office and two days remote.
- Earn \(90 per hour on a W-2 basis or \)100 per hour if you are an independent contractor.
- Work with a major firm on impactful projects and advance your skills.
How To Apply
If you're excited about this opportunity, we'd love to hear from you! Please send us your recent resume and let us know your availability for interviews and your start date.
Note: You must have a green card or be a U.S. citizen. Visa entanglements or H1-B holding companies are not eligible.
Employment Type: Full-Time