Database DBA - Diverse Linx
Chicago, IL
About the Job
Role:- Database DBA
Location:- Chicago IL or Washington DC (Remote)
Job Description:-
Responsibilities :
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.
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.
Source : Diverse Linx
