- Analyze, maintain, and optimize MS/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 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.
- 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.
- Collaborate with developers, analysts, and IT teams to design, implement, and troubleshoot database issues.
AWSPostgreSQLSQL+2 more