← Back to jobs

Q1 Technologies  Inc Logo
Amazon Aurora PostgreSQL Database Administrator

Q1 Technologies Inc

 

Aurora, IL, USA

Posted On: Just posted
Experience: 5+ years
Availability: Remote
Openings: 2
Category: PostgreSQL Database Administrator
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Job Description

Must Have Technical/Functional Skills
Technical Skills
• Strong expertise in PostgreSQL architecture, replication, backup and recovery.
• Deep knowledge of AWS database services, including:
o Amazon Aurora PostgreSQL
o Amazon RDS
o AWS DMS
o AWS SCT
o CloudWatch
o IAM
o KMS
• Experience with database performance tuning and troubleshooting.
• Proficiency in scripting languages such as Python, Bash, or PowerShell.
• Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation.
• Familiarity with CI/CD tools and DevOps practices.


Experience
• Minimum 5+ years of hands-on database administration experience.
• Strong experience administering PostgreSQL databases in AWS environments.
• Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services.
Roles & Responsibilities
Database Administration
• Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
• Perform database installation, upgrades, patching and lifecycle management.
• Monitor database health, capacity and performance metrics.


Performance Optimization
• Analyze and optimize SQL queries and database workloads.
• Implement indexing strategies and query tuning best practices.
• Manage connection pooling and resolve infrastructure bottlenecks.
• Troubleshoot and resolve database performance issues.
High Availability & Disaster Recovery
• Design and implement Multi-AZ deployments and cross-region replication.
• Develop, test, and maintain backup and disaster recovery processes.
• Ensure database availability and business continuity objectives are met.
Cloud Migration & Modernization
• Lead or support database migration initiatives to Aurora PostgreSQL.
• Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects.
• Perform migration assessments, validations and post-migration optimization.
Automation & Infrastructure as Code (IaC)
• Develop automation scripts for routine database administration activities.
• Manage infrastructure using Terraform, Ansible or AWS CloudFormation.
• Support CI/CD pipeline integration for database deployments and schema changes.


Security & Compliance
• Implement security controls, database encryption and access management.
• Apply database patches and vulnerability remediation activities.
• Ensure compliance with organizational and regulatory security standards.
• Perform periodic security reviews and audit support activities

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs