← Back to jobs
Aurora, IL, USA
No related jobs found
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
Any Graduate
No related jobs found
← Back to jobs