Job Seekers, Please send resumes to resumes@hireitpeople.comMust Have Skills:
- AWS PostgreSQL
- PL SQL
- DB and Cassandra
- 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
