PostgreSQL DBA

Chicago 22 months agoFull-time External
Negotiable
Trident Consulting is seeking "PostgreSQL DBA” for one of our clients in “Riverwoods, IL - Onsite”. A global leader in business and technology services. Role: PostgreSQL DBA Location: Riverwoods, IL - Onsite Type: Contract Job Description: • Create the objects in the database, such as triggers, indexes, etc. • Monitor the performance of the database and ensure optimum performance. • Identify potential issues in the database to solve them early. • Maintain backups and perform disaster recovery in case a disaster destroys the database , who can be consultant , train and act as advise the teams as a consultant DBA • He need to define the training topics and train the application teams and Act as an enterprise level DBA who can define and coach the teams within the enterprise. • He needs to provide guidance and address technical challenges and define strategy for migration approach. • Ensure the performance, availability, security, and integrity of the databases while providing support to application teams and other stakeholder • Proven migration experience with integration from oracle to Postgres . • Monitor security and prevent any unauthorized access to the database and Schedule consistent maintenance on the server • Maintain database schema, Manage database availability, Give best practice guidance to the development team and Resolve any production data issues • Table space management, Role management, Develop automation technologies to accelerate the process of data loading. • Develop relational databases, Ensure data integrity, Manage user access and permissions by adding and removing users as required and Maintain the database using different utilities. This includes using like pg_ctl and psql. About Trident: Trident Consulting is an award-winning IT/engineering staffing company founded in 2005 and headquartered in San Ramon, CA. We specialize in placing high-quality vetted technology and engineering professionals in contract and full-time roles. Trident's commitment is to deliver the best and brightest individuals in the industry for our clients' toughest requirements. Some of our recent awards include: • 2022, 2021, 2020 Inc. 5000 fastest-growing private companies in America • 2022, 2021 SF Business Times 100 fastest-growing private companies in Bay Area