Analyze, maintain, and optimize PostgreSQL and Microsoft SQL database environments. Optimize SQL queries and enhance data retrieval efficiency. Update database architecture, build schemas, and manage permissions. Manage Legacy and Platform as a Service databases. Monitor systems for availability and oversee database mirroring, replication, and failover. Support advanced PostgreSQL features like JSON, full-text search, and PostGIS. Generate queries and reports using PostgreSQL tools. Create, populate, and maintain PostgreSQL databases, materialized views, and indexes. Restore PostgreSQL databases from backups and support disaster recovery. Collaborate with teams to design, implement, and troubleshoot database issues. Assess future storage and performance needs, and maintain documentation. Work with Platform as a Service pre-built databases. Communicate effectively with customers, stakeholders, and technical specialists.