Postgre DBA
- Teamware Solutions
102 Days Ago
50-53 per Hourly
NA
Las Vegas-NV
10-15 Years
Required Skills: PostgreSQL
Job Description
Role name: Postgre DBA
Role Description:
Role Description:
- Sitting for extended periods of time
- Dexterity of hands and fingers to operate a computer keyboard and mouse
- Physically able to participate and lead training sessions, presentations and/or meetings.
- Reasoning and analyzing complex information
- Regularly required to talk and hear
- Overtime may be required to meet deadlines
Experience (Years): 10 & Above
Essential Skills:
- 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.
- 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
- AWS RDS hands-on experience
- Capacity planning, performance assessment of AWS RDSs
- Strong Postgres/SQL Server DB administration experience in production environments
- Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database
- Experience in managing multiple RDS, database versions on large system
- Practical experience in monitoring
- Knowledge of reporting and query tools and practices
