Job Seekers, Please send resumes to resumes@hireitpeople.com Must Have Skills: AWS PostgreSQL PL SQL DB and Cassandra Detailed Job Description: A minimum of 5 - 7 years experience in database engineering. Expertise in configuring and installation of AWS PostgreSQL RDS/Aurora, Aurora Global Database Performed successful data migrations from on premise Sybase, Oracle or MS SQL server to Cloud/AWS Postgres. Hands on experience multi-region replication and Disaster Recovery Scenarios. In-depth knowledge of Structured Query Language (SQL). Extensive experience with PL/PgSQL writing functions, procedures, triggers, and sequences. Expertise in database performance diagnostics in both development and production systems. Well versed in Design and Management of PostgreSQL database schemas. Experience designing database structures, indexes, views, and partitioning. Knowledge in Setup and maintenance of Postgres master - slave clusters utilizing streaming replication. Experience in security access control, testing, configuration management, version control, highly available web applications. Ability to implement database change controls, as well as development, staging & production PostgreSQL databases. Experience creating PostgreSQL databases backup, recovery & upgrades. Experience monitoring lock files, backup and performance issues. Familiar with the pg dump and pg restore scripts using parallel dump and restore methods for automation. Proven skills communicating effectively with various levels of technical, non-technical, business & executive audiences. Knowledge on NoSQL databases like Mongo dB and Cassandra

Minimum years of experience: 8-10 years

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

Experience creating PostgreSQL databases backup, recovery upgrades Expertise in database performance diagnostics in both development and production systems Experience monitoring lock files, backup and performance issues

Interview Process (Is face to face required?) No

Does this position require Visa independent candidates only? No