Database Administrator

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 :