AWS Postgres DBA

2 months ago


Chicago, United States Diverse Lynx Full time
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.
  • AWS Database Expert

    4 weeks ago


    Chicago, Illinois, United States Diverse Lynx Full time

    About the RoleDiverse Lynx LLC is an Equal Employment Opportunity employer seeking a talented Postgres DBA Lead to join our team. As a key member of our technical staff, you will be responsible for designing and implementing database solutions to ensure the scalability, integrity, and security of our database infrastructure.The ideal candidate will have...


  • Chicago, Illinois, United States Diverse Lynx Full time

    About the PositionWe are seeking an experienced AWS Postgres DBA to join our team at Diverse Lynx LLC. The successful candidate will have expertise in AWS Aurora and other DB services, as well as strong knowledge of Postgres and performance tuning.The ideal candidate will have experience working with application teams to design and implement storage...

  • Oracle DBA

    1 week ago


    Chicago, United States Levi Ray & Shoup Inc Full time

    LRS Primary Navigation Who We Are History (https://www.lrs.com/who-we-are/history/) Company Overview Leadership (https://www.lrs.com/who-we-are/leadership/) A Message from Our CEO What We Believe (https://www.lrs.com/what-we-believe/) Our Mission LRS Philosophy & Values (https://www.lrs.com/what-we-believe/lrs-philosophy-values/) Community...


  • Chicago, United States Saxon Global Full time

    Job Title: AWS Redshift DBA Work Location: Required to be onsite 2 days a week Travel Expenses: Can't Pay Travel Expenses at this time United Airlines is seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration along with...


  • Chicago, United States eTek IT Services, Inc. Full time

    Job DescriptionJob Description& We are having urgent requirement for below position for "W2 Contract". Please go through the requirement share me your updated resume to shravan@etekit.com& Role : Java AWS EngineersLocation:& Hybrid 3x a week in Plano, Chicago, NYC, or Wilmington DEExperience : 8+ yearsW2 Contract& & Required Skills:Core software development...

  • Cockroach DBA

    2 months ago


    Chicago, United States Saxon Global Full time

    Location: Onsite every other week (5x per week, 2 weeks per month) in one of the following locations: Dallas, TX Boston, MA Smithfield, RI Merrimack, NH Jersey City, NJ Chicago, IL Covington, KY / Cincinnati, OH Salt Lake City, UT Required Skills & Experience - 5+ years of experience as a DBA - 2+ years of experience with Cockroach DB (experience building...


  • Chicago, Illinois, United States Saxon Global Full time

    Job RequirementsTo be successful in this role, you will need to possess the following skills and qualifications:Key Skills:AWS CloudAWS RedshiftAWS RDSQualifications:Bachelor's degree required8-10 years of DBA experienceAdditional Skills:Python scripting and automationData replication, data sharing, and data modeling


  • Chicago, United States Inficare Full time

    Position : Java Developer with AWS and Terraform Location : Chicago IL (Onsite) Mode: Contract Experience : 10+ Required qualifications, capabilities, and skills Formal training or certification on software engineering concepts and 10+ years applied experience Hands-on practical experience delivering system design, application development, testing, and...

  • Oracle EBS DBA

    2 weeks ago


    Chicago, United States Saxon Global Full time

    Location: Downtown Chicago - 2 days onsite/week Duration: Contract until end of year with extension/conversion possibility Job Summary The Senior Oracle Applications DBA's role is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems. The position is responsible for researching and troubleshooting...

  • Oracle DBA

    1 month ago


    Chicago, United States Diverse Lynx Full time

    Role name: Database Administrator Role Description: Oracle & Postgres DB Competencies: Oracle DB Experience (Years): 4-6 Essential Skills: Oracle & Postgres DB 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...

  • Senior Oracle EBS DBA

    7 months ago


    Chicago, United States CyberTec Full time

    Only USC/GC USG Corporation Senior Oracle EBS DBA Chicago, IL- Hybrid 6+ Month Contract Phone then Video $57-60/hr on C2C Job Description: The Senior Oracle Applications DBA's role is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems. The position is responsible for researching and troubleshooting...


  • Chicago, Illinois, United States Diverse Lynx Full time

    Job SummaryWe are seeking an experienced Java and AWS developer to join our team. The ideal candidate will have a strong background in software development and a proven track record of delivering high-quality solutions using Java, Spring, and AWS. The role involves designing and developing software, troubleshooting, debugging, and upgrading software, testing...


  • Chicago, Illinois, United States Saxon Global Full time

    Job DescriptionSaxon Global is seeking an experienced Senior Database Architect to join our team in Chicago. This is a 12-month contract position that requires 8-10 years of DBA experience.About the RoleWe are looking for a skilled professional to help with our Data-warehouse workload migration into AWS Redshift. The ideal candidate will have extensive...


  • Chicago, United States Saxon Global Full time

    Work Location: Required to be onsite 2 days a week Length: 12-month contract Our client is seeking an AWS Redshift DBA who will help with their Data-warehouse workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration along with Query Tuning. Responsibilities • Experience: 8 to 10 years as a...


  • Chicago, United States Saxon Global Full time

    Job Title: AWS Redshift DBA Work Location: Required to be onsite 2 days a week Seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration along with Query Tuning. Responsibilities • Experience: 8 to 10 years as a DBA that...

  • MS SQL DBA

    1 week ago


    Chicago, United States Tekfortune Inc Full time

    Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world's leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the future of work. To support the active project demands and skills gaps, our...


  • Chicago, United States CyberTec Full time

    No H1B/CPT/TN United Airlines Database Administrator V Chicago, IL- Day 1 On-Site 12 Month Contract Phone then Video $80-85/hr on C2CJob Description: The Client is seeking for an AWS Redshift DBA who will help with our data warehouse workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration...


  • Chicago, United States VDart Full time

    Job Title: Lead Full Stack Java Developer Location: Chicago, IL Duration /Term: 12+ Months/Long Term Contract We need Tech Leads with hands on experience with cloud relation migration and client interaction managing expectations, it's client facing role Job Description Looking for full stack engineers who can build and release reliable software systems at...


  • Chicago, Illinois, United States National Board of Osteopathic Medical Examiners (NBOME) Full time

    Job Summary:The National Board of Osteopathic Medical Examiners (NBOME) is seeking a skilled Cloud Database Administrator to play a critical role in managing and optimizing its database infrastructure. This includes overseeing the migration of Oracle databases to AWS, providing ongoing support for SQL-Server and open-source databases, troubleshooting and...


  • Chicago, Illinois, United States Prairie Consulting Services Full time

    Required Skills and QualificationsTo succeed in this role, you should have strong communication, leadership, and project management skills.Absolutely essential is hands-on experience with DevOps, DataOps, MLOps, and automation (Terraform, Ansible).You should also have experience with cloud services (AWS, Azure), database technologies (Oracle, Postgres, SQL...