What are the responsibilities and job description for the Database Administrator with Postgres position at Conrelv Solutions Inc?
Position : Database Administrator with Postgres
Location : Alpharetta, GA
Duration : Long Term
Required Qualification :
- 10-12 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version, preferably AWS, with expertise in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.
- Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS.
- Hands on experience with managing EDB, and AWS Day to Day operations including 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 in 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 from on-prem to AWS and vice versa, estimating it, and technically managing it.
- 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
