Job Overview
Category
Computer Occupations
Ready to Apply?
Take the Next Step in Your Career
Join CBTS and advance your career in Computer Occupations
Apply for This Position
Click the button above to apply on our website
Job Description
Job Description
Job Purpose:
Responsibilities:
Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security. Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting. Deploy and maintain database infrastructure on both on-premises servers and AWS cloud platforms, utilizing best practices for scalability, reliability, and cost-efficiency. Collaborate with cross-functional teams to design, implement, and optimize database architectures to meet business requirements and performance goals. Implement and maintain disaster recovery solutions, including backup strategies, replication, and failover procedures, for both on-premises and AWS deployments. Automate routine DBA tasks and workflows using scripting languages. Ensure compliance with security policies, regulatory requirements, and industry best practices for database operations and data protection. Monitor and response to DB alerts from monitoring tools and command center team. Monitor database performance and capacity utilization, proactively identifying and resolving issues to maintain optimal performance and scalability. Provide trend analysis to executive management to help them taking informed decisions regarding resource management. Lead, monitor and provide guidance to junior DBA. Collaborate with cross-functional teams to ensure smooth integration of databases with other systems and applications. Perform database capacity planning and trend analysis. Apply changes to the database following strict procedures of Change management policies and protocol. Must Have:
Experience with PostgreSQL database, Enterprise Failover Manager (EFM), Postgres Enterprise Manager (PEM) and PGBACKREST on Linux servers. Proficiency in end-to-end architecture of PostgreSQL database, including database design, development, administrate of large-scale database, OLTP and analytical data structures (logical and physical design) Experience managing PostgreSQL databases in AWS RDS and/or EC2 environments. Proficiency in PostgreSQL troubleshooting, performance tuning, SQL Tuning, access management and security setup, health monitoring and maintenance, PL/PGSQL (triggers, functions, ….) Experience in designing, implementing, and monitoring disaster recovery (DR) solutions for PostgreSQL databases including Backup and restore, Point-in-Time-Recovery (PITR), on-site/offsite replication. Experience managing Amazon RDS implementation of PostgreSQL. Experience in database and data migration from on-premises to cloud. Experience in creating Linux shell scripts.
Don't Miss This Opportunity!
CBTS is actively hiring for this Database Administrator position
Apply Now