AWS Cloud DBA / AWS Aurora PostgreSQL DBA

Unisoft Technology Inc

United States

7 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Amazon Elastic Compute Cloud Amazon S3 Cloud Database Databases Data Integrity Data Migration Data Normalization Data Security Database Design Database Queries Database Storage Structures

+16 more

Disaster Recovery PostgreSQL Microsoft SQL Server MongoDB Performance Tuning Shell Script SQL Stored Procedures SQL Databases Data Storage Management System Availability AWS Lambda Indexer Cloudformation Database Migration Amazon Relational Database Service Information Technology

Job description

Collaborate with application developers to design and optimize database structures for efficient data storage and retrieval.
Design and implement backup, recovery, and disaster recovery plans to protect critical data.
Implement AWS cloud solutions that effectively utilize PostgreSQL databases.
Manage AWS resources related to PostgreSQL databases, such as EC2 instances, RDS instances, and S3 storage.
Implement database scaling and high availability strategies in the AWS cloud environment.
Automate database tasks using AWS services like AWS Lambda, AWS CloudFormation, and AWS RDS/Aurora.
Plan and execute database migration projects, including schema migration, data migration, and application migration.
Develop and implement migration strategies to minimize downtime and ensure data consistency.
Plan & perform database upgrades, applying patches, and ensuring compatibility with new versions of PostgreSQL and AWS services.
Conduct thorough testing and validation of migrated databases to ensure data integrity and optimal performance.

Requirements

Bachelor’’'’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
12+ years of experience in Database
Proven experience as a Database Administrator .
In-depth knowledge of database management systems, primarily AWS PostgreSQL , SQL and MongoDB.
Familiarity with database design principles, data normalization, and indexing techniques.
Understanding of data security and access control principles.
Must have great experience in AWS RDS
Knowledge of cloud-based database services (e.g., AWS RDS, SCT, and DMS).
Strong knowledge of PostgreSQL replication, high availability, and disaster recovery mechanisms in AWS Cloud environment.
Experience with PostgreSQL monitoring and performance tuning tools.
Proficiency in SQL and experience with writing complex queries and stored procedures.
Strong analytical and problem-solving skills with an ability to troubleshoot database-related issues.
Familiarity with Linux/Unix operating systems and shell scripting.

Preferred Qualifications:

PostgreSQL (e.g., PostgreSQL Certified Professional).
AWS certifications (e.g. AWS Certified Database - Specialty)
SQL Server DBA, All our Information Technology professional positions required a minimum Bachelor degree in computer Science or Information Technology or related field.