Role: AWS PostgreSQL DBA
Location: San Diego CA Charlotte NC Florham Park NJ (3 Days Onsite)
Experience: 10 years.
Role Description:
We are looking for a skilled PostgreSQL Database Developer to join our team for a highimpact project. The ideal candidate should have worked in AWS for at least 5 years and hold extensive experience in designing and developing database applications with a strong background in both serverless and managed instances of PostgreSQL. This role requires expertise in AWS Aurora PostgreSQL including proficiency with DDL DML SQL and a strong focus on performance tuning for missioncritical applications.
Must Have:
- Experience with Liquibase
- Experience in Python
- Experience with replication and load balancing for PostgreSQL
- Familiarity with database migration tools and techniques.
Key Responsibilities:
- Design develop and optimize PostgreSQL database applications.
- Work with AWS Aurora PostgreSQL (both serverless and managed instances) to ensure high availability
- and scalability.
- Create and manage database schemas DDL and DML operations. Strong SQL knowledge.
- Perform performance tuning and optimization of database systems to support missioncritical
- workloads.
- Manage PostgreSQL databases through multiple product lifecycle environments from development to
- missioncritical production systems.
- Perform regular system monitoring verifying the integrity and availability of all hardware database
- server resources systems and key processes.
- Apply experience with Liquibase to operationalize database changes ensuring smooth version control
- and deployment of database updates.
- Leverage knowledge of advanced data structures like JSON to enable smooth and efficient egress
- processing ensuring data integrity and performance.
- Collaborate with application developers to create optimized queries and schemas to meet the project needs.
Required Skills and Experience:
- 5 years of experience working in AWS cloud and PostgreSQL database.
- Proven experience with PostgreSQL development including performance tuning.
- Handson experience with AWS Aurora PostgreSQL including serverless architecture.
- Strong knowledge of database design DDL DML and SQL.
- Ability to troubleshoot and resolve complex database performance issues
- Expertise in performance tuning and query optimization. Strong problemsolving skills a proactive attitude and the ability to work in a fastpaced environment.
Tekhire Solutions is a worldclass technology focused on customerdriven solutions and has a deep dive knowledge of client requirements. Tekhire is best in connecting a bridge between highly skilled workers and the Fortune 500. Always thrives to be up with the technology trends Innovation and transforms our trusted clients with certified and enterprise solutions that makes difference in the business.