No C2C (Must work W2) Must be willing to work a hybrid schedule onsite 3 days a week in Plano, TX About the Role: We are seeking an experienced PostgreSQL Database Administrator (DBA) to join our team. The ideal candidate will have extensive experience in architecting large-scale production database platforms and managing PostgreSQL environments. This role requires a proactive individual who can ensure the reliability, performance, and security of our database systems. Key Responsibilities: + Architect and manage a large-scale production database platform. + Configure and manage PostgreSQL production and contingency replication features. + Maintain and support PostgreSQL HA clustered environments. + Perform failover, migration, and data restores in a HA environment. + Support database patching and provide continuous application support. + Handle crontabs and data backups using pgBackRest. + Manage Kubernetes/OpenShift clusters for PostgreSQL. + Create and maintain documentation, troubleshooting playbooks, and test failover and recovery plans. + Perform regular database maintenance tasks. + Write and maintain Ansible playbooks. + Monitor database performance and ensure optimum performance. + Identify and resolve potential database issues early. + Maintain backups and perform disaster recovery. + Monitor security and prevent unauthorized access to the database. + Schedule consistent maintenance on the server. + Maintain database schema and manage database availability. + Provide best practice guidance to the development team. + Resolve production data issues. + Manage tablespace and role management. + Ensure data integrity and maintain the database using various utilities. Required Skills & Experience: + Experience architecting a large-scale production database platform. + Strong knowledge of PostgreSQL production and contingency replication features and configuration. + Strong knowledge of PostgreSQL HA clustered environments. + Hands-on experience with failover, migration, and data restores in a HA environment. + Experience with database patching and continuous application support. + Proficient in handling crontabs and data backups using pgBackRest. + Proficient in managing Kubernetes/OpenShift clusters for PostgreSQL. + Experience creating and maintaining documentation, troubleshooting playbooks, and testing failover and recovery plans. + Ability to write Ansible playbooks. + PostgreSQL DBA experience in a 24x7 production environment. + Experience configuring, managing, and troubleshooting PostgreSQL on Linux. + Experience with database backup and recovery, including disaster recovery standards. + Experience with database design, optimization, and tuning. + Experience implementing database security concepts, including access, auditing, and encryption. + Ability to create database objects such as triggers and indexes. + Strong shell scripting skills. + Experience with DB replication. + Strong SME in Unix System Administration. • Expertise in Unix systems. • Experience in artifact repositories, dependency management and compliance engines to scan artifacts in Artifactory for vulnerabilities and policy violations. • Strong understanding of CICD pipeline. • Proficiency in scripting languages such as Python or Bash for automation. Experience Level Entry Level 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: • Medical, dental & vision• Critical Illness, Accident, and Hospital• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available• Life Insurance (Voluntary Life & AD&D for the employee and dependents)• Short and long-term disability• Health Spending Account (HSA)• Transportation benefits• Employee Assistance Program• Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a hybrid position in Plano,TX. Application Deadline 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.