Sr Senior AWS RDS PostgreSQL Database Administrator

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

AWS RDS Database Engineer
Postgres databases
cloud version preferably AWS
databases as RDS services in AWS
security policy
IAM
database administration in AWS.
Open-source Database platforms Databases like PostgreSQL
and AWS RDS.
EDB
Oracle
SQL Server and AWS Day to Day operation on S3 EC2
Postgres SQL performance improvement
partitioning database
AWS environment management
Linux OS
Jira
GitHub
Ansible & Terraform.
CI/CD using GitLab
Batch process
Job scheduling automation
database design principles
query optimization
AWS RDS hands-on experience
Postgres/SQL Server DB administration
complex RDS Databases in AWS environment
leveraging Aurora Read replicas & Global Database
managing multiple RDS
database versions on large systems
reporting and query tools and practices
RDS KPI design and management.
Lambda
Python
PgBouncer
PgPool

Job Details

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Senior AWS RDS PostgreSQL Database Administrator , Onsite

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

Job Description:

The AWS RDS Database Engineer performs independently or as a key multi-functional team member in identifying, planning, developing, and deploying database applications and other technology solutions that can involve multiple physical locations and business units. Acts as the single point of contact for AWS database administration and escalations for the Banking Industry project.
Summary Of Essential Job Functions
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 Linux OS, use SSH to connect to remote systems with password & public/private keys Ability to efficiently write database code without compromising data quality, privacy, or security. Hands-on Experience in Jira, GitHub, Ansible & Terraform. Good understanding of CI/CD using GitLab Good understanding of the Batch process and Job scheduling automation Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical, and interpersonal communication skills

Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience

Proficient in identifying, analyzing, and solving problems and Client facing experience


Position Requirements

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 systems

Practical experience in monitoring

Knowledge of reporting and query tools and practices

Experience in using Performance Insights, RDS KPI design and management.

Working knowledge of Lambda, Python

Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries.

Physical Requirements

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

Educational background: Grad from CS/ EE or Eng. Equivalent

DIA SOFTWARE SOLUTIONS LLC.

Austin, TX 78727| Direct:

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Diasoft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Dia Software Solutions