AWS Postgres DBA - Diverse Lynx
Chicago, IL
About the Job
Job title: AWS Postgres DBA
Chicago, IL
Contract Role
Top Qualifications:
1. Postgres Expertise & Performance tuning
2. AWS Expertise (AWS Aurora and other DB services)
3. DynamoDB
Primary Responsibilities:
1. 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.
2. The resource should examine the long-running queries and check the indexes, joins, and statistics.
3. The resource should scrutinize the current organization and work with the application teams on storage strategies such as partitions, segmentations, and split-merge tables.
4. The resource should estimate the instance size for optimal performance of application and how the size and config should change as DB grows to support performance.
Job summary:
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 No SQL 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
Responsibilities:
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 requirements with operations staff and external entities. 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.
Mandatory Requirements:
AWS Expertise (AWS Aurora and other DB services)
Postgres Expertise
Performance Tuning
DynamoDB
Years of Experience: 10.00 Years of Experience
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.