Senior Engineer Database Administrator
Current* Installation and configuration of PostgreSQL database.* Responsible for managing and maintaining PostgreSQL databases in a production environment.* Developed database schemas and created tables, views, and indexes to meet the specific needs of the business.* Configured user management, accounts, privileges, roles, and profiles in the database server.* Scheduled regular backups and restores of PostgreSQL databases to ensure data availability.* Optimized PostgreSQL databases for performance by tuning queries and indexes.* Good in monitoring and maintenance activities like VACUUM, ANALYZE, VACUUM FULL, REINDEX.* Experienced in setting up the fail-over and fail-back in PostgreSQL.* Have worked and good knowledge on AWS,Azure cloud platforms and have Designed, implemented, and managed PostgreSQL databases in both cloud platforms.