Hi ,
This is Sawan Kumar from Smart IT Frame; I have below open position. Let me know if you interested in this position..
Job Title : Oracle & PostgreSQL Database Administrator
Job Location : Chicago, IL
Duration : 12 Months
JD:
- Migration experience (Oracle to PostgreSQL)
- Code refactoring experience (SQL code refactoring and rewriting experience in Postgres)
- Post migration tunning experience.
- PostgreSQL Query Optimization and data migration
- Handling large data Optimization and performance issues in PostgreSQL.
- Postgres developer Query Performance Tuning
- Work with development teams to troubleshoot and fix performance related issues
- Migration experience to move databases from Oracle to Cloudsql for PostgreSQL
- Perform data copy from ON prem to GCP CloudSQL
- CDC configuration of Primary schemas as applicable.
- Strong troubleshooting skills
- Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.
- Oracle PL/SQL databases like TABLES,VIEWS,PROCEDURES,FUNCTIONS,PACKAGES,INDEXES,TRIGGERS,MVs
- Have done data migration activities from Oracle On-prem to PostgreSQL on prem/cloud
Warm Regards,
Sawan Kumar
US IT Recruiter
Smart IT Frame LLC