What are the responsibilities and job description for the PostgreSQL DBA position at TEKsystems?
NO C2C. W2 ONLY. CANDIDATES MUST SIT ONSITE 3 DAYS A WEEK IN PLANO, TX.
TEKsystems is currently looking for a PostgreSQL DBA with 5 yrs of experience in an enterprise environment. Candidates will be responsible for the below duties.
Schedule :
It will be M-F 8 to 5 but will have to work an on-call schedule on a rotational basis. The on-call schedule will be every 6 weeks on weekends and will have to respond if there are any issues.
- Required Skills & Experience
- Postgres DBA, strong shell script skills, DB replication, ability to create playbooks, and strong SME in Unix System Administration
- Experience architecting a large-scale production database platform.
- Strong Knowledge of Postgres production and contingency replication feature and configuration
- Strong Knowledge of Postgres HA Clustered environment.
- Strong hands-on experience on failover / migration and data restores in a HA environment.
- Support Database patching and ability to provide continuous support for the Application.
- Proficient in handling crontabs and data backups using pgBackRest.
- Proficient in handling Kubernetes / OpenShift cluster for PostgreSQL
- Creating and maintaining documentation, troubleshooting playbooks, testing 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 (Postgres) on Linux
- Experience with database backup and recovery, including implementing disaster recovery standards (Postgres)
- Experience with database design, optimization, and tuning (Postgres)
- Experience with implementing database security concepts, including access, auditing, and encryption.
- Create the objects in the database, such as triggers, indexes, etc.
- Monitor the performance of the database and ensure optimum performance.
- Identify potential issues in the database to solve them early.
- Maintain backups and perform disaster recovery in case a disaster destroys the database.
- Monitor security and prevent any unauthorized access to the database.
- Pay and Benefits
The pay range for this position is $50.00 - $67.00 / hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following :
This is a hybrid position in Plano,TX.
This position is anticipated to close on Feb 21, 2025.
About TEKsystems :
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Salary : $50 - $67
