What are the responsibilities and job description for the PostgreSQL Database Administrator position at Corelleaf Design Studio?
Description:
Position Summary:
We are seeking a skilled Platform Engineer to manage, maintain, and optimize our on-premise commercial software applications built on PostgreSQL, Express.js, React, and Node.js. The ideal candidate will be responsible for deploying, monitoring, securing, and scaling the PERN stack infrastructure within a Linux-based virtualized environment. This role requires expertise in database administration, Linux system management, scripting/automation, and security best practices. This role also includes app administration, installation, deployments, configurations, versioning, app patching, performance monitoring and optimizations.
Key Responsibilities:
Platform Administration & Maintenance
Manage and optimize PostgreSQL databases, including backups, replication, indexing, and query performance tuning.
Deploy, configure, and maintain Express.js, React, and Node.js applications on Linux virtual machines. This includes NGINX and PM2 platforms.
Oversee on-premises system infrastructure, ensuring high availability and performance.
Implement and maintain CI/CD pipelines for automated deployments.
Troubleshoot and resolve system, application, and network issues.
Security & Operations
Review system hardening, data encryption, and access control policies align with security best practices.
Work with other teams to monitor vulnerabilities and apply security patches and updates.
Assist in defining firewall rules, intrusion detection, and role-based access control (RBAC).
Review compliance with data governance and regulatory requirements.
Ensure proper backup, disaster recovery, and redundant configurations.
Support & Documentation
Provide technical support for platform-related issues and troubleshooting.
Maintain clear documentation for deployments, configurations, and troubleshooting guides.
Train and support developers and IT staff on best practices and operational procedures.
Required Skills & Qualifications:
5-7 years
Strong expertise in PostgreSQL administration, including replication, backup strategies, and performance tuning.
Experience deploying PERN stack applications in a cloud or on-premises environment.
Knowledge of CI/CD tools like GitHub actions, Azure Devops pipelines, or Ansible for automation.
Scripting and automation experience with Bash, Python or similar scripting.
Preferred Qualifications:
Prior experience in IT infrastructure, DevSecOps, or SRE roles.
Proficiency in Linux app and database server administration, with experience such as Ubuntu or RHEL.
Understanding of network security, firewalls, VPNs, and SSH hardening.
Knowledge of OpenID Connect (OIDC) or Ldap as well as IAM tools such as Entra ID, Okta, Active Directory, or centralized authentication mechanisms.
Familiarity with virtualization platforms (VMware or Hyper-V).
Notes:
Candidate MUST be CURRENT resident. NO RELOCATION ALLOWED. All work must be done within the State. 100% remote work is an option. Can accommodate if candidate wants to work onsite.
Job Type: Contract
Pay: $62.00 - $65.00 per hour
Expected hours: 40 per week
Schedule:
- Day shift
Ability to Commute:
- Madison, WI 53703 (Preferred)
Ability to Relocate:
- Madison, WI 53703: Relocate before starting work (Preferred)
Work Location: In person
Salary : $62 - $65
