• Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity. • Analyze, maintain, and optimize Microsoft SQL database environment to ensure 99.9% availability and data integrity. • Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL and Microsoft SQL. • Update database architecture, build schemas, tables, stored procedures, and manage permissions. • Manage, improve, and work with Legacy databases and Platform as a Service databases. • Provide recommendations on policies, procedures, and emerging technologies. • Monitor systems for availability, oversee database mirroring, replication, and failover. • Support advanced PostgreSQL features like JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip. • Create, populate, and maintain PostgreSQL databases, materialized views, and indexes for analysis and reporting. • Restore PostgreSQL databases from backups and support disaster recovery activities using WAL archiving and point-in-time recovery. • Collaborate with developers, analysts, and IT teams to design, implement, and troubleshoot PostgreSQL database issues. • Assess future storage and performance needs, and create and maintain comprehensive PostgreSQL documentation. • Work with Platform as a Service pre-built database to optimize and manage as needed for growing solutions. • Communicate effectively with customers, stakeholders, and technical specialists.