Database Administrator (Remote Opportunity)

Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity. Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL. Update database architecture, build schemas, tables, stored procedures, and manage permissions. 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.