Postgres Database Administrator

3 weeks ago


Irvine, United States Authority Partners Full time
Job Description:
We are currently seeking a Database Administrator to collaborate with our team in our latest endeavor: migrating a PostgreSQL EC2 instance to RDS PostgreSQL 15 or higher. The ideal candidate has a demonstrated ability to handle complex migrations to AWS.

Interested? Read on and apply with us

Responsibilities: Lead the migration project from PostgreSQL on EC2 to RDS PostgreSQL 15 or higher. Analyze existing database architecture and propose improvements for the migration process Develop and implement data deletion strategies for removing outdated data Collaborate with the tech leads to address challenges Ensure data integrity and security throughout the migration process Provide guidance and support to the team during the migration and post-migration phases
Key Requirements: Extensive AWS Experience: Proven track record with AWS platform, RDS, EC2, and storage requirements. Must be able to hit the ground running without a learning curve. Familiarity with older PostgreSQL versions, particularly understanding index management changes that may impact migration. Ability to work independently and collaborate effectively with our team. Capable of analyzing the database environment and recommending optimal solutions during migration. Strong understanding of database backup planning and familiarity with AWS storage options within RDS. Previous experience upgrading databases with large datasets is advantageous.
Education: Bachelor's degree in Computer Science, Software Engineering or a related field would be of great value, but if you’re passionate and have the experience that backs up your abilities, for us, talent outweighs degree every time.
AP Perks: Remote work  Opportunity to work with people who are at the top of their field  Great culture and environment  Career growth  Collaborative learning environment  Mentorship programs  Professional training 
About Authority Partners: 
Authority Partners is a leading and global IT services company with over 25 years of experience, serving clients within the financial, healthcare, insurance, mortgage and technology sectors among many others. We are committed to building relationships with IT professionals who possess integrity, dedication, teamwork, and the desire to learn and grow with us. We specialize in placement for long-term contract and permanent opportunities and helping our consultants achieve their career success.

AP Testimony:
"I started out as an intern at Authority Partners during my last semester of college and immediately felt welcomed and accepted as a family member. Upon graduating, I found myself in my first full-time opportunity working in a healthy environment with amazing people from whom I learn a lot. I am very grateful to be able to do something I enjoy while progressing professionally and personally."

- Emina Hadzic, QA Engineer

If you want to learn more about Authority Partners’ selection and interviewing process, as well as our culture, we invite you to listen to our podcasts and watch our corporate video:

• By Zerina Sulejmanovic Terzic, Head of Talent Acquisition Department


Authority Partners is an equal opportunity employer and is committed to providing a workplace that is free from all types of discrimination, as well as from abusive or offensive behavior and harassment.


  • Irvine, United States Global Financial Data, Inc Full time

    As a Database Administrator, you will be a vital part of our team responsible for managing and optimizing our database systems. Your premium skills in MySQL, performance tuning, and scripting will be valuable in maintaining high availability and enhancing database performance. Additionally, your relevant skill in database design will contribute to the...


  • Irvine, United States CuraPatient Inc. Full time

    Job DescriptionJob DescriptionSalary: $125,000+Who We AreCuraPatient, based in Irvine, California, is an award-winning AI platform revolutionizing the healthcare industry. Our generative AI tools, backed by a secure FEDRAMP HIGH-certification (in-progress) system, streamlines tasks and optimizes patient encounters. Committed to the Federal Government Sector,...


  • Irvine, United States CuraPatient Inc. Full time

    Job DescriptionJob DescriptionSalary: $125,000+Who We AreCuraPatient, based in Irvine, California, is an award-winning AI platform revolutionizing the healthcare industry. Our generative AI tools, backed by a secure FEDRAMP HIGH-certification (in-progress) system, streamlines tasks and optimizes patient encounters. Committed to the Federal Government Sector,...


  • Irvine, United States Council On Aging Full time

    Job DescriptionJob DescriptionDescription:DESCRIPTION: Do you like helping people? Are you interested in making a difference in the lives of local seniors? Would you like to broaden your expertise by working for a non-profit that provides programs and services for seniors in Southern California? Consider joining the Council on Aging – Southern California....


  • Irvine, United States Council On Aging Full time

    Job DescriptionJob DescriptionDescription:DESCRIPTION: Do you like helping people? Are you interested in making a difference in the lives of local seniors? Would you like to broaden your expertise by working for a non-profit that provides programs and services for seniors in Southern California? Consider joining the Council on Aging – Southern California....


  • Irvine, United States Council On Aging Full time

    Job DescriptionJob DescriptionDescription:DESCRIPTION: Do you like helping people? Are you interested in making a difference in the lives of local seniors? Would you like to broaden your expertise by working for a non-profit that provides programs and services for seniors in Southern California? Consider joining the Council on Aging – Southern California....


  • Irvine, United States Teknosys Full time

    We are looking for PL/SQL Developer with Postgre SQLExperience : 8 to 10 yearsLocation: Pleasanton, CA Work mode: onsiteNeed candidates on Teknosys W2Skills requiredOracle T-SQL SSRSSSASSSISETLPL/SQLPostgre SQL Database objects


  • Irvine, United States Teknosys Full time

    We are looking for a PL/SQL Developer with Postgre SQLExperience: 8 to 10 yearsLocation: Pleasanton, CA Work mode: onsiteNeed candidates on Teknosys W2Skills required:Oracle T-SQL SSRSSSASSSISETLPL/SQLPostgre SQL Database objects


  • Irvine, United States Lorven technologies Full time

    Job DescriptionJob DescriptionJob Title: Lead Python Data EngnieerLocation: Irvine, CA/ Los Angeles CAJob Description:Should have a strong Python experience, including relevant libraries such as PySpark and Pandas.Expert SQL/database knowledge.Experience with ETL tools.Cloud experience, preferably AWS.Basic knowledge of financial products, previous...


  • Irvine, United States Lorven technologies Full time

    Job DescriptionJob DescriptionJob Title: Lead Python Data EngnieerLocation: Irvine, CA/ Los Angeles CAJob Description:Should have a strong Python experience, including relevant libraries such as PySpark and Pandas.Expert SQL/database knowledge.Experience with ETL tools.Cloud experience, preferably AWS.Basic knowledge of financial products, previous...


  • Irvine, United States EV Mode Full time

    Job DescriptionJob DescriptionSalary: Systems Admin Job Description We are looking for a System Administrator to maintain, upgrade and manage our software, hardware and networks. Resourcefulness is a necessary skill in this role. You should be able to diagnose and resolve problems quickly. You should also have the patience to communicate with a variety of...


  • Irvine, United States Brown & Streza LLP Full time

    Job DescriptionJob DescriptionAt Brown & Streza, we offer a collaborative work environment with many opportunities for career growth along with a variety of perks and benefits to support and enhance our team’s experience. In addition to health and wellness benefits, we offer weekly lunches, monthly birthday celebrations, monthly in-office massages, and an...


  • Irvine, United States Bridge Housing Corporation Full time

    **Summary** The Resident Administrator is responsible for administrative duties to support the needs of our high-profile apartment communities. This position requires high attention to detail and excellent customer service skills.**R**esponsibilities** - Schedule and complete applicant certifications and resident re-certifications - Maintain computer...


  • Irvine, United States Russian School Of Mathematics Full time

    The Russian School of Mathematics is looking to hire a part-time Office Administrator in our Arlington, MA location. The school operates from 3:30 pm to 8:30 pm on weekdays 9:00 am to 6:00 pm on weekends. The primary responsibility of this position is to provide exceptional customer service, front desk coverage and administrative support to the RSM office...

  • Office Administrator

    4 weeks ago


    Irvine, United States Simplicity Group Holdings Full time

    Job DescriptionJob DescriptionPosition Title:   Office AdministratorReports to:        Principal PartnerDepartment:      AdministrationLocation:           19000 Macarthur Blvd. #450, Irvine, CA 92612; In-OfficeClassification:   Part-time, NonExemptSummary / Job Objective:  General Office Admin duties include supporting the general...


  • Irvine, United States PrideStaff Full time

    Job DescriptionJob DescriptionAdministrative Assistant for an international leasing start-up company located in Irvine CA.Temporary to Hire opportunity. Pay range is $25-28/hr, depending on experience. Hours are 9:00 AM - 6:00 PM, Monday - Friday.Key Responsibilities:Assist in the recruitment process by scheduling interviews, posting job ads, and...


  • Irvine, United States Iris Technology Corp Full time

    **About Us**: Iris Technology Corporation is a dynamic engineering company dedicated to our people first moto. Our team is committed to excellence, innovation, and making a positive impact in Aerospace and DoD industries. **Position Overview**: We are seeking a proactive and organized Administrative Assistant to provide comprehensive support to the Director...


  • Irvine, United States Iris Technology Corp Full time

    **About Us**: Iris Technology Corporation is a dynamic engineering company dedicated to our people first moto. Our team is committed to excellence, innovation, and making a positive impact in Aerospace and DoD industries. **Position Overview**: Temp to Hire Position. We are seeking a proactive and organized Administrative Assistant to provide comprehensive...


  • Irvine, United States Free Wheelchair Mission Full time

    Free Wheelchair Mission (FWM) is a humanitarian, faith-based, non-profit organization based in Irvine, California, USA. Our mission is to provide the transforming gift of mobility to people with a disability living in developing nations as motivated by Jesus Christ.There are an estimated 80 million people around the world today in need of a wheelchair. We...


  • Irvine, United States Free Wheelchair Mission Full time

    Free Wheelchair Mission (FWM) is a humanitarian, faith-based, non-profit organization based in Irvine, California, USA. Our mission is to provide the transforming gift of mobility to people with a disability living in developing nations as motivated by Jesus Christ.There are an estimated 80 million people around the world today in need of a wheelchair. We...