PostgresSQL DBA at Remote, Remote, USA |
Email: [email protected] |
From: Venkat Gayam, iTech US Inc [email protected] Reply to: [email protected] Greetings from iTech US Inc.! We have an urgent requirement for you and the details are as follows Job Title: PostgresSQL DBA Location: Atlanta/ Springfield GA ( Day1 onsite) Duration: 6+ Months (Implementation/Prime Vendor Partner: TCS) Job Details: Need Strong profile on PostgresSQL DBA with 8+yrs IT exp. Job Description: Should possess More than 4+years of experience as a dedicated Postgresql DBA and Developers. Designing and developing Postgresql Schema user and role with user security management Design and develop stored procedures, functions, views and triggers Debug and tune Postgresql query and Postgresql SQL Performance engineering Design, implement and maintain database objects (tables, views, indexes, and database security Experience working with Pg_dump/PSQL/Pg_Ctl/Pg_repack/Vacume and Analyse process/Index and partition implementation Experience Monitoring Database with PG_Admin Experience Monitoring Postgresql Jobs and fixing the Job failure if any Experience in Postgresql Performance Improvement by tuning stored procedures, functions or Jobs or tune postgresql.conf configuration parameter setting to improve overall DB performance tuning. Monitor and administration of Postgresql Db server in Linux and windows platforms Knowledge on Postgresql DB Installatoin and Upgrades of DBs Analyze and develop strategies and approaches to import and transfer data between source, staging, and destinations server Test and prepare ETL processes for deployment to production and non-production environments Testing, Continuous Deployment, Automated Testing, etc. Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts. Provide day to day direction to the offshore team and regular status to the clients. Excellent interpersonal skills and an ability to work with diverse personality types across geographies Essential Skills: Experience working with Pg_dump/PSQL/Pg_Ctl/Pg_repack/Vacume and Analyse process/Index and partition implementation Experience Monitoring Database with PG_Admin Experience Monitoring Postgresql Jobs and fixing the Job failure if any The responsibilities of a DBRE include designing and implementing solutions to enhance the reliability and performance of databases, identifying and fixing issues within the DBMS, and developing and deploying process automation solutions. Experience in Postgresql Performance Improvement by tuning stored procedures, functions or Jobs or tune postgresql.conf configuration parameter setting to improve overall DB performance tuning. Monitor and administration of Postgresql Db server in Linux and windows platforms Knowledge on Postgresql DB Installatoin and Upgrades of DBs Kindly fill the below details as it is required while submitting it to the client: Full Name (Legal): Contact No: Alternate Contact No: E-mail ID: Work Authorization: Current Location: Former Employee of TCS (Yes/NO): Relocation (Y/N): LinkedIn URL: Education Details (Specialization/University/Passed out year) Bachelor's Degree: Master's Degree: Keywords: database information technology Georgia Idaho PostgresSQL DBA [email protected] |
[email protected] View all |
Thu Sep 26 03:05:00 UTC 2024 |