| PostgreSQL Database Administration at Mclean, Virginia, USA |
| Email: [email protected] |
| From: Abhishek, heliogic [email protected] Reply to: [email protected] Position Title:- PostgreSQL Database Administration Must have : PostgreSQL Location:- McLean, VA (Day 1 Onsite 3 Days onsite 2 days Remote) Mandatory : Passport number Required 8+ only Update from Customer:- Sybase to PostgreSQL migration project (On perm in linux server red hat not on cloud) - multiple databases, we use ispirer tool to migrate schema from sybase to postgre. DMS to migrate data Any db to PostgreSQL is fine Hands on knowledge in PostgreSQL Experience to store procedure and triggers migration What tool they used for PostgreSQL schema migration In that tool, where do you provide source/target details and what details you give. What information you enter for migrating data (for example in DMS migration task, source and target end points) If there is performance issue, from where you will find which query is causing the issue and from where you will fetch that query Unix/Linux experience experience in installation in unix environment, backup, restore How do you start postgre store procedure difficulties in current project and how it was handled python knowledge will be added advantage Job Description: At least 3 years of experience in PostgreSQL Database Administration on Linux including: oInstallation, configuration, and maintenance oPerformance troubleshooting and database tuning oReplication and high availability Strong knowledge of SQL, PL/pgSQL and ability to analyze/debug stored procedures, functions & triggers. Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels Experience with database migration, preferably from Sybase to Postgres is desirable. Experience with Postgres Client interface drivers and installation Strong Unix/Linux knowledge and experience in Unix Shell scripting, Python programming is desirable. Keywords: database information technology procedural language Virginia |
| [email protected] View all |
| Thu Aug 03 18:28:00 UTC 2023 |