• Analyze, maintain, and optimize PostgreSQL and Microsoft SQL database environments to ensure high availability, performance, and data integrity. • Identify and resolve performance bottlenecks, optimize SQL queries, and improve data retrieval efficiency. • Design and maintain database architecture, including schemas, tables, indexes, stored procedures, and security permissions. • Manage and support legacy databases and Platform as a Service (PaaS) database solutions. • Monitor systems for availability and oversee database replication, mirroring, failover, and disaster recovery processes. • Implement backup, restore, and recovery strategies, including point-in-time recovery and WAL archiving. • Support advanced PostgreSQL features such as JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using tools such as pgAdmin, psql, and third-party database clients. • Collaborate with developers, analysts, and infrastructure teams to design, implement, and troubleshoot database solutions. • Assess future storage and performance needs and maintain accurate technical documentation. • Provide recommendations on database policies, procedures, and emerging technologies. • Communicate effectively with customers, stakeholders, and technical specialists. • Contribute to team objectives and take on additional responsibilities as needed.