Central Business Solutions Inc.

PostgreSQL Database Administrator (DBA)

Central Business Solutions Inc.  •  Atlanta, GA (Onsite)  •  16 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description


We are seeking a skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. As a PostgreSQL DBA, you will be responsible for the management, maintenance, and optimization of our PostgreSQL database systems. Your expertise will be essential in ensuring the availability, performance, and security of our database infrastructure.

Key Responsibilities:
  • Install, configure, and upgrade PostgreSQL database software and related tools.
  • Design and implement backup and recovery strategies to ensure data integrity and availability.
  • Monitor and tune database performance to optimize query execution and improve overall system efficiency.
  • Perform database capacity planning and resource management to ensure scalability and high availability.
  • Manage database security, including user access control, authentication, and data encryption.
  • Collaborate with development teams to design, implement, and optimize database schemas and queries.
  • Troubleshoot and resolve database-related issues, including performance bottlenecks, data corruption, and system failures.
  • Implement and maintain database replication, clustering, and high-availability solutions.
  • Develop and maintain documentation, including database design, installation procedures, and configuration details.
  • Stay up-to-date with the latest PostgreSQL features, technologies, and best practices.
  • Qualifications and Skills:
  • Bachelor's degree in computer science, information technology, or a related field (or equivalent work experience).
  • Proven experience as a PostgreSQL DBA, including installation, configuration, and administration of PostgreSQL database systems.
  • Strong understanding of relational database concepts and SQL.
  • Proficiency in performance tuning, query optimization, and troubleshooting database issues.
  • Experience with backup and recovery strategies, including point-in-time recovery and disaster recovery.
  • Familiarity with database security principles and best practices.
  • Experience with replication, clustering, and high-availability solutions for PostgreSQL (e.g., streaming replication, logical replication, Pgpool-II, Patroni).
  • Knowledge of Linux/Unix operating systems and shell scripting.
  • Excellent problem-solving and analytical skills.
  • Strong communication and collaboration skills.

Preferred Qualifications:
  • PostgreSQL certification (e.g., Certified PostgreSQL Professional).
  • Experience with other database systems such as MySQL, Oracle, or SQL Server.
  • Knowledge of cloud-based database services (e.g., Amazon RDS, Google Cloud SQL).
  • Familiarity with database automation and orchestration tools (e.g., Ansible, Terraform).
  • Understanding of containerization technologies (e.g., Docker, Kubernetes).
Central Business Solutions Inc.

About Central Business Solutions Inc.

Central Business Solutions Inc (CBS), founded in 2000 and headquartered in Newark, California, has carved a niche for itself in the global business solutions market. Our experience spans across various industries, serving both small businesses and Fortune 500 companies. Here's a breakdown of our core offerings:

Technology Solutions: CBS acts as your IT department's backbone, offering a comprehensive suite of services. We provide expert guidance on crafting a technology strategy that aligns with your business goals. This includes consulting on system architecture and implementation, ensuring your infrastructure is built for efficiency and scalability. Our expertise extends to software development, crafting custom solutions or integrating existing ones to streamline operations. But CBS doesn't stop at setup; we also provide ongoing maintenance and support to keep your technology running smoothly.

Outsourcing: Whether you need to supplement your existing IT staff or completely outsource your IT department, CBS offers flexible solutions. We can provide qualified personnel to handle specific tasks like software development, UI/graphic design, or recruitment. Alternatively, we can take over the entire IT management responsibility, freeing your internal team to focus on core business functions.

Consulting: Our expertise extends beyond technology. CBS offers consulting services to help you achieve your overall business goals. Our team of experienced professionals can analyze your operations and identify areas for improvement. We'll develop data-driven strategies to streamline processes, enhance efficiency, and ultimately deliver bottom-line results.

In essence, Central Business Solutions Inc goes beyond just being a vendor. We position ourselves as a strategic partner for businesses. By combining our IT prowess with business acumen, we help clients optimize technology infrastructure, streamline operations, and achieve sustainable success.

Industry
IT & Software
Company Size
51-200 employees
Headquarters
Newark, CA
Year Founded
2000
Social Media