Postgresql dba

Chicago 23 months agoFull-time External
Negotiable
From Collabera : Excellent Job Opportunity for PostgreSQL DBA / IMMEDIATE NEED Job Details Industry : Banking / Finance Job Title : PostgreSQL DBA Location : Addison TX, Chicago IL Duration : 12 months with possible extension Pay Rate : $75 per hour Please call me directly at 201-309-3578 or email me at pawan.younghang@collabera.com to speak in detail about the job Job Description : • Participates in design, development and implementation of systems engineering activities, to include technical support, systems programming, and data center capabilities. • Responsible for components of complex engineering and / or analytical tasks and activities. • Assists in establishment of input / output processes and working parameters for hardware compatibility and coordination of subsystems design and integration of total system. • Serves as a fully seasoned / proficient technical resource; provides tech knowledge and capabilities as team member and individual contributor. Initial assignment will be implementation of PostgreSQL. Responsibilities : • Install, configure, and administer PostgreSQL, including dependencies, in a Linux environment, in a highly available, clustered configuration. • Build and maintain scripting / tooling / configuration to integrate PostgreSQL with internal auth and logging services. • Maintain documentation, scripting and / or tooling supporting environment synchronization. • Act as a consultant on a range of related technologies in a subject matter expert role. • Develop software or system scripts to simplify or eliminate the dependence on human intervention for recurring tasks. • Provide documentation to support configuration processes and procedures. • Engage as a subject matter expert (SME) in Incident triage efforts, failure scenario modelling and work with Problem Manager to diagnose root causes for incident / problem management investigations. • Work with Production Support teams to perform knowledge transfer, playbook updates and training for new monitoring capabilities. Mandatory skills : • Production engineering / operations experience (minimum 5-7 years) • Experience in supporting infrastructure in a large enterprise environment. • Need experience Linux Prefered RED Hat with the ability to troubleshoot and perform root-cause analysis • Strong experience PostgreSQL DBA installation, configuration, and administration in a multi-datacenter environment. • Experience in PostgreSQL multiside cluster enviroment. • Strong data background in terms of schema design (tables, indexes, 3rd normal form, denormalization to optimize for performance, etc.) • Experience working in a DevOps and CI / CD environment. • Understanding of load balancing, clustering, and other never down strategies and techniques • Good understanding of various protocols such as http / tcp / smtp / snmp / dns • Good verbal and written communication skills • Excellent attention to detail • Experience with patching of servers and hosted applications • Strong problem-solving skills • Aptitude to independently learn new technologies. • Good understanding of Change and Incident Management processes • Good understanding of Splunk SOAR or other centralized logging tools. Desired skills : • Experience with installation, configuration, and administration of PostGress • Experience with installation, configuration, and administration of Security Information and Event Management (SIEM) and / or Security Orchestration, Automation, and Response (SOAR) platforms • Experience with cyber security related workflows PostgreSQL / Database admin / Cluster / installation / configuration About the Company : Collabera Collabera Since 1991, Collabera has been a leading provider of IT staffing solutions and services. We are known for providing the best staffing experience and taking great care of our clients and employees. Our client-centric model provides focus, commitment and a dedicated team to help our clients achieve their business objectives. For consultants and employees, we offer an enriching experience that promotes career growth and lifelong learning. The Collabera Way represents our fundamentals beliefs and is founded on the following building blocks : Company Size : 10,000 employees or more Industry : Banking Banking Founded : 1991 1991 Website : http : / / www.collabera.com Last updated : 2023-12-23