• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 8th Aug 2024

·SQL and PostgreSQL fundamentals: SQL syntax and querying - PostgreSQL data types, tables, indexes, and constraints - Understanding of PostgreSQL architecture and internals

·Database design and modelling: Data modeling concepts (entity-relationship diagrams, normalization) - Database schema design and optimization

·Performance tuning and optimization: Query optimization techniques - Indexing strategies - Understanding of execution plans and query analysis

·Backup and recovery: Backup and recovery concepts (full, incremental, differential) - Understanding of PostgreSQL backup tools (pg_dump, pg_basebackup)

·Security and access control: User management and authentication - Role-based access control (RBAC) - Understanding of PostgreSQL security features (SSL, encryption)

·Replication and high availability: Understanding of replication concepts (master-slave, multi-master) Setting up and managing replication - High-availability solutions (failover, load balancing)

·Monitoring and troubleshooting:  Understanding of PostgreSQL logs and monitoring tools (pg_stat_statements) - Troubleshooting techniques for performance, connectivity, and data issues

·Scripting and automation:  Familiarity with scripting languages (Bash, Python, Perl) - Automating tasks using cron jobs, scripts, and tools (pg_agent)