**Position** : Database Administrator **Location** : Manapakkam, Chennai, IND-TN **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. CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit **www.cbts.com** . We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, age, disability, religion, sex, sexual orientation, gender identity, gender expression, protected veteran, military status or any other characteristic protected by law. Due to U.S. Government requirements applicable to foreign-owned telecommunications providers, non-US citizens will be required to submit to an extensive government agency background check which will necessitate disclosure of sensitive Personally Identifiable Information.