-
Corp-Corp
-
W2-Permanent
-
W2-Contract
-
Contract to Hire
-
UG :- - Not Required
-
PG :- - Not Required
-
No of position :- ( 1 )
-
Post :- 20th Nov 2025
- Total IT Experience required 10 Years
- Should possess More than 4+ years of experience as a dedicated PostgreSQL DBA and Developer.
- Designing and developing PostgreSQL Schema user and role with user security management
- Design and develop stored procedures, functions, views and triggers
- Debug and tune PostgreSQL query and PostgreSQL SQL Performance engineering
- Design, implement and maintain database objects (tables, views, indexes, and database security
- Experience working with Pg_dump/PSQL/Pg_Ctl/Pg_repack/Vacume and Analyse process/Index and partition implementation
- Experience Monitoring Database with PG_Admin
- Experience Monitoring PostgreSQL Jobs and fixing the Job failure if any
- Experience in PostgreSQL Performance Improvement by tuning stored procedures, functions or Jobs or tune PostgreSQL.
- Configuration parameter setting to improve overall DB performance tuning.
- Monitor and administration of PostgreSQL Db server in Linux and windows platforms
- Knowledge on PostgreSQL DB Installation and Upgrades of DBs
- Analyze and develop strategies and approaches to import and transfer data between source, staging, and destinations server
- Test and prepare ETL processes for deployment to production and non-production environments
- Testing, 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