Postgres With AWS RDS

Job Title - Postgres With AWS RDS

US Onsite Location: Las Vegas, NV

Contract Tenure: 12+ months (Long term)

Job Description -

10-12 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.

Mandatory Skills -

aws rds, postgresql, terraform, ansible, linux, shell scripting

• Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS.

• Working Knowledge of EDB, Oracle, SQL Server and AWS Day to Day operation on S3 EC2 etc

• Should be able to implement effective and maintainable database coding practices that form an architectural foundation.

• Experience in Postgres SQL performance improvement, indexing/other approaches

• Good experience on partitioning database

• Experience with message queuing, full-text indexing, and other high-performance data concepts.

• Experience in AWS environment management and knowledge of different tools for the same.

• Experience in Postgres SQL migration approach, estimating it, and technically managing it.

• Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys

• Ability to efficiently write database code without compromising data quality, privacy, or security.

• Hands-on Experience in Jira, GitHub, Ansible & Terraform.

• Good understanding of CI/CD using GitLab

• Good understanding of the Batch process and Job scheduling automation

• Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels

• Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical, and interpersonal communication skills

• Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience