Freelance Data Base Administration

As a Freelance Senior Database Administrator specializing in PostgreSQL and AWS RDS, you will be responsible for managing and optimizing high-load PostgreSQL database environments, monitoring and tuning complex SQL queries, resolving performance bottlenecks, optimizing indexes and configurations, designing backup and recovery strategies, and executing database upgrades across on-premises and AWS RDS environments. Additionally, you will lead migration projects, automate database operations, and collaborate with cross-functional teams to enhance platform reliability and scalability. Key Responsibilities: - Manage and optimize high-load PostgreSQL database environments. - Monitor, analyze, and tune complex SQL queries. - Identify and resolve database performance bottlenecks. - Optimize indexes, query execution plans, and PostgreSQL configurations. - Design and implement backup, recovery, and disaster recovery strategies. - Plan and execute PostgreSQL version upgrades and migrations. - Perform compatibility assessments for stored procedures, functions, triggers, and application workloads. - Validate database stability, performance, and data integrity post-upgrades. - Design, provision, and manage AWS RDS PostgreSQL environments. - Support cloud database architecture, scalability, security, and high-availability initiatives. - Lead database migration projects between on-premises and AWS environments. - Automate database operations using scripting and DevOps practices. - Collaborate with application, infrastructure, and DevOps teams to enhance platform reliability and scalability. Qualifications Required: - 7+ years of Database Administration experience. - Strong hands-on expertise with PostgreSQL. - Deep understanding of PostgreSQL internals, architecture, and performance tuning. - Experience with query optimization, index tuning, execution plan analysis, and database configuration tuning. - Proven experience in executing PostgreSQL version upgrades and migrations. - Strong expertise in compatibility testing and upgrade validation. - Experience managing AWS RDS PostgreSQL environments. - Strong Linux/Unix administration skills. - Knowledge of backup, recovery, replication, and failover strategies. - Strong SQL troubleshooting and performance analysis skills. - Experience supporting large-scale or high-traffic production systems. - Strong communication and stakeholder management skills. About CodeVyasa: CodeVyasa is a product engineering firm collaborating with global organizations in various sectors. The team of 750+ engineers focuses on Product Engineering, Cloud Engineering, Data Engineering, Agentic AI, and Generative AI solutions. As a Freelance Senior Database Administrator, you will have the opportunity to work remotely on enterprise-scale cloud database platforms, with consistent monthly payouts and transparent payment cycles. As a Freelance Senior Database Administrator specializing in PostgreSQL and AWS RDS, you will be responsible for managing and optimizing high-load PostgreSQL database environments, monitoring and tuning complex SQL queries, resolving performance bottlenecks, optimizing indexes and configurations, designing backup and recovery strategies, and executing database upgrades across on-premises and AWS RDS environments. Additionally, you will lead migration projects, automate database operations, and collaborate with cross-functional teams to enhance platform reliability and scalability. Key Responsibilities: - Manage and optimize high-load PostgreSQL database environments. - Monitor, analyze, and tune complex SQL queries. - Identify and resolve database performance bottlenecks. - Optimize indexes, query execution plans, and PostgreSQL configurations. - Design and implement backup, recovery, and disaster recovery strategies. - Plan and execute PostgreSQL version upgrades and migrations. - Perform compatibility assessments for stored procedures, functions, triggers, and application workloads. - Validate database stability, performance, and data integrity post-upgrades. - Design, provision, and manage AWS RDS PostgreSQL environments. - Support cloud database architecture, scalability, security, and high-availability initiatives. - Lead database migration projects between on-premises and AWS environments. - Automate database operations using scripting and DevOps practices. - Collaborate with application, infrastructure, and DevOps teams to enhance platform reliability and scalability. Qualifications Required: - 7+ years of Database Administration experience. - Strong hands-on expertise with PostgreSQL. - Deep understanding of PostgreSQL internals, architecture, and performance tuning. - Experience with query optimization, index tuning, execution plan analysis, and database configuration tuning. - Proven experience in executing PostgreSQL version upgrades and migrations. - Strong expertise in compatibility testing and upgrade validation. - Experience managing AWS RDS Po