Match score not available

Database DBA

Remote:

Full Remote

Work from:

Illinois (USA), United States

Offer summary

Qualifications:

Experience with PostgreSQL DB Administration, Strong skills in database performance tuning, Familiar with AWS Aurora and Dynamo DB, Knowledge of AWS CloudWatch.

Key responsabilities:

Estimate instance size for AWS Aurora performance
Analyze instances and clusters for optimization

Diverse Lynx Large https://www.diverselynx.com/

1001 - 5000 Employees

See more Diverse Lynx offers

Job description

Role:- Database DBA
Location:- Chicago IL or Washington DC (Remote)

Job Description:-

Act as the PostgreSQL technical leader, providing strategic recommendations for database solutions to ensure the scalability, integrity and security of the database infrastructure. Administer and proactively monitor SQL and NoSQL database servers to ensure uptime and availability across multiple data centers. Troubleshoot and perform performance tuning on the data engine to ensure optimal operation and efficiency. Communicate and review database solutions, technical issues, and application resolution.
Required Skills: PostgreSQL DB Administration, Database Performance Tuning, AWS Aurora, AWS Dynamo DB, AWS CloudWatch
Nice to have skills: Data Modeling,

Responsibilities :

AWS Aurora on PostgreSQL- The resource should estimate the instance size for optimal performance of the application and how the size and config should change as DB grows to support performance
The resource should analyze the instance and cluster of AWS Aurora and decide whether the extent and sizes defined and used for tables and indexes are optimal.
The resource should examine the long-running queries and check the indexes, joins, and statistics.
The resource should scrutinize the current organization and work with the application teams on storage strategies such as partitions, segmentations, and split-merge tables.
The resource should have worked on performance tuning, root cause analysis, and maintenance of database and tables on AWS Aurora-PostgreSQL.
The resource should also analyze, tune, and check the performance and working of Dynamo DB tables

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.