What are the responsibilities and job description for the Senior AWS RDS and PostgreSQL Database Administrator position at Artmac Soft LLC?
Who we are
Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to Customers.
Job Description :
Job Title : Senior AWS RDS and PostgreSQL Database Administrator
Job Type : W2
Experience : 7 to 15 years
Location : Las Vegas, Nevada
Responsibilities :
- 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.
- 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
- Proficient in identifying, analyzing, and solving problems and has client-facing experience.
Position Requirements :
Physical Requirements :
Qualification :
