- Create and update database architecture, build schemas, tables, stored procedures, and manage permissions.
- Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip.
- Analyze, maintain, and optimize PostgreSQL /Microsoft SQL database environment to ensure 99.9% availability and data integrity.
- Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency.
- Manage, improve, and work with Legacy databases and Platform as a Service databases.
- Monitor systems for availability, oversee database mirroring, replication, and failover.
- 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.
AWSPostgreSQLPython+5 more