System Administrator

Job Title: System Administrator (Linux and PostgreSQL Database)

Job Summary:

We are seeking a skilled and motivated System Administrator with expertise in Linux systems and PostgreSQL database management. The ideal candidate will be responsible for installing, configuring, maintaining, and optimizing our Linux-based infrastructure and PostgreSQL databases. This role requires a proactive individual with strong problem-solving skills and a passion for ensuring system reliability, performance, and security.

Key Responsibilities:

Linux System Administration:

Install, configure, and maintain Linux servers and related software.
Monitor system performance, identify bottlenecks, and implement improvements.
Ensure system security through regular updates, patches, and configurations.
Automate routine tasks using scripting languages (e.g., Bash, Python).
Manage server storage, backups, and disaster recovery solutions.
Troubleshoot hardware and software issues promptly.

PostgreSQL Database Administration:

Install, configure, and manage PostgreSQL databases in production, staging, and development environments.
Monitor database performance, tune queries, and optimize indexing.
Implement database security measures, including encryption and access controls.
Perform regular backups and restorations to ensure data integrity.
Develop and maintain documentation for database processes and policies.
Troubleshoot database-related issues and provide timely resolutions.

General Responsibilities:

Collaborate with development and DevOps teams to support application deployment and database integration.
Create and maintain system and database documentation, including configurations, workflows, and best practices.
Implement and maintain monitoring solutions for both servers and databases.
Provide on-call support for critical system or database issues.

Required Skills and Qualifications:

Education: Desirable: Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
Experience: 3+ years of experience in Linux system administration and PostgreSQL database management.
Proficiency in Linux distributions such as Ubuntu, CentOS, or Red Hat.
Strong understanding of PostgreSQL architecture and best practices.
Experience with backup, recovery, and database replication strategies.
Desirable: Hands-on experience with configuration management tools (e.g., Ansible, Puppet, or Chef).
Familiarity with shell scripting and one programming language (e.g., Python).
Knowledge of network protocols, firewalls, and security best practices.
Strong problem-solving and analytical skills.

Preferred Skills:

Experience with cloud platforms like AWS, Azure, or Google Cloud.
Desirable: Familiarity with containerization technologies (e.g., Docker, Kubernetes).
Understanding of CI/CD pipelines and DevOps practices.
Desirable: Experience with monitoring tools like Prometheus, Grafana, or Nagios.

What We Offer:

Competitive salary and benefits package.
Opportunities for professional growth and certification.
A collaborative and supportive work environment.
Flexible work hours and the option for remote work, depending on business needs.

How to Apply:

If you are passionate about Linux and PostgreSQL and are looking for a challenging yet rewarding role, please submit your resume and a cover letter outlining your relevant experience to careers@youtestme.com.