Postgres DBA

More than 4+years of experience as a dedicated Pstgresql DBA and DevelopersDesigning and developing Postgresql Schema user and role with user security managementDesign and develop stored procedures, functions, views and triggersDebug and tune Postgresql query and Postgresql SQL Performance engineeringDesign, implement and maintain database objects (tables, views, indexes, and database securityExperience working with Pg_dump/PSQL/Pg_Ctl/Pg_repack/Vacume and Analyse process/Index and partition implementationExperience Monitoring Database with PG_AdminExperience Monitoring Postgresql Jobs and fixing the Job failure if anyExperience in Postgresql Performance Improvement by tuning stored procedures, functions or Jobs or tune postgresql.conf configuration parameter setting to improve overall DB performance tuning.Monitor and administration of Postgresql Db server in Linux and windows platformsKnowledge on Postgresql DB Installatoin and Upgrades of DBsAnalyze and develop strategies and approaches to import and transfer data between source, staging, and destinations serverTest and prepare ETL processes for deployment to production and non-production environmentsTesting, Continuous Deployment, Automated Testing, etc.Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts.Provide day to day direction to the offshore team and regular status to the clients.Excellent interpersonal skills and an ability to work with diverse personality types across geographies