Database Administrator (PostgreSQL)
Are you an expert in PostgreSQL and have experience working with AWS? Do you have a passion for keeping data secure, efficient, and accessible? Are you a passionate data professional with expertise in database administration and a knack for building efficient data pipelines? If so, then we want to hear from you!
We are seeking a highly motivated Database Administrator (DBA) to join our team and play a critical role in managing, maintaining, and optimizing our data infrastructure.
Responsibilities:
Design, install, configure, and maintain various database management systems (DBMS), including PostgreSQL database systems on-premises and/or in the AWS cloud environment, to meet organizational data needs.
Ensure optimal performance, scalability, and security across all database platforms.
Implement robust disaster recovery plans and perform regular backups to safeguard data integrity.
Monitor database activity, identify and troubleshoot performance issues to optimize data access and retrieval.
Manage user access and permissions across databases to enforce data security protocols.
Automate database tasks and scripting for improved efficiency and reduced manual workload.
Collaborate with developers and analysts to understand data requirements and design effective data storage and retrieval solutions.
Partner with data engineers to design and implement data pipelines for seamless data movement and transformation.
Stay up-to-date on the latest advancements in database technologies, data engineering practices, and best practices.
Qualifications:
Proven experience of 8+ years as a Database Administrator with a strong focus on PostgreSQL and strong understanding of database administration principles.
Solid understanding of database concepts, data modeling principles and data security best practices.
Experience working with cloud-based database management services (AWS, OCI)
Familiarity with data engineering principles and practices, including data extraction, transformation, and loading (ETL) processes.
Working knowledge of SQL and proficiency in writing complex queries for data manipulation and retrieval.
Familiarity with MySQL, Oracle and Cassandra databases (a plus).
Excellent analytical and problem-solving skills.
Strong communication and collaboration skills to work effectively with cross-functional teams (developers, analysts, data engineers).
Meticulous attention to detail and a commitment to accuracy.