PostreSql Admin

Job Title: PostreSql Admin
Duration: 612 months
Location: Onsite Princeton NJ
Work Type:
Rate: Pay range offered to a successful candidate will be based on several factors including the candidates education work experience work location specific job duties certifications etc.

Job Summary:
1. Postgres SQL with Migration

Job Description/ Responsibilities
7 years experience must have technical lead experience

Technical Skills:
Experienced with PostgreSQL & PostgreSQL Architecture.
Understanding of basic Database Fundamentals: Multiversion control Concurrency Transactions Indexing Locking.
Ability to Independently Monitor and Administer databases.
Creation & managing PostgreSQL Schema Tables Tablespaces and Users Roles & Groups.
PostgreSQL Index Management Partitioning and System Catalogs.
Performance tuning Query tuning by generating and explaining plan for SQL queries.
Expert in Backup & Recovery including Pg dump Setting up WAL archiving Point in time recovery.
knowledge on PG Admin and other PostgreSQL tools and utilities.
Knowledge on High Availability Streaming Replication Replication Failover Repmgr Barman PG bouncer and PG pathman.
Monitoring Alert Log Scheduled Jobs and Troubleshooting Database Problems
Roles & Responsibilities:
Oversee the daily operations of PostgreSQL databases to ensure optimal performance and reliability
Implement and maintain database security measures to protect sensitive information.
Collaborate with the asset management team to understand operational needs and tailor database solutions accordingly.
Monitor database performance implement changes and apply new patches and versions when required.
Excellent communication and teamwork skills with a focus on collaborative problemsolving
Database Space/ Storage Management
Handling Severity 1 to 4 Service Requests
System and Database Performance Monitoring
Backup Execution and Monitoring
Database Refresh
User Access Management
Hands on maintenance activities such as vacuum vacuum full analyse the database.
Analyse recommend and implement configuration for Optimized Performance.
Ability to plan hardware capacity requirements for Storage Memory and CPU Cycles.
Expert with setting and troubleshoot replication issues.
KT handling and SOP creation
Vendor Management
Implement HA DR
Practice Various Automation Techniques
Personal Attributes
Must be Analytical and possess good problemsolving capabilities

ABOUT Ztek:
Website:
Ztek Consulting Inc is a minority and womanowned business enterprise that leverages a unique blend of human talent machine learning algorithms and artificial intelligence to provide customized talent management solutions for clients. Zteks diversityfocused hiring models have proven successful particularly in hiring veterans. The companys veteranfocused hiring and deployment program ZV.E.T matches skilled veterans with clients needs in various areas.

Disclaimer:
Ztek is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Ztek is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race color religion or belief national origin citizenship social or ethnic origin sex age physical or mental disability veteran status marital status domestic partner status sexual orientation or any other status protected by the statutes rules and regulations in the locations where it operates.If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment please contact us at Please indicate the specifics of the assistance needed. Ztek encourages all interested and qualified candidates to apply for employment opportunities. Ztek does not discriminate against applicants based on citizenship status immigration status or national origin in accordance with 8 U.S.C. 1324b.