Sameer Jangale Email & Phone Number

Pune, Mh, In

Mumbai, Maharashtra, India

Installation and configuration of postgreSQL, MySQL database, creating cluster instance, connecting to server- Creating and Managing databases, schemas, roles and access control- Database schema creation and management, Ensuring data integrity- Implementation of postgresql procedure, triggers, using pgAdmin III for different administrative tasks as well as command line interface- Security Basics such as pg_hba.conf configuration, SSL configuration, LDAP authentication etc- Implementing backup/recovery strategies, Streaming Replication over TCP/IP and archiving database, Point-In-Time recovery, Replication using replication slots, Cascade replication- Logical replication: Using logical replication slot, PUBLICATION/SUBSCRIPTION model, pglogical- pg_dump, pg_dumpall, bacebackup, Database upgrade- Routine MaintenanceTasks: Vacuum, Vacuum Full, Reindex, Analyze- Performance tuning at sql level, hardware level, sql tuning, Analyzing EXPLAIN plan - Postgresql.conf parameters tuning like work_mem, maintenance_work_mem, effective_cache_size, shared_buffer, join_collapse_limit and from_collapse_limit, default_target_statistics, seq_page_cost, random_page_cost etc.- Postgresql Server monitoring- Database lock monitoring, active queries/long running sqls monitoring using pg_stat_activity,Database cluster (partition) size monitoring, disk read/write, server load monitoring- Database connection limit monitoring, handling issues like ran out of disk, connection limit reach - Postgresql Server monitoring toolsPgbadger : Log analyzerpgbench-tool : Postgres benchmarking pgbouncer/pgpool : Postgresql connection pooler- Backup Recovery Tool: BARMAN/Pgrestback- Replication manager: REPMGR- Writing shell scripts for various administrative tasks, scheduling cron jobs

Pune, Maharashtra, India

Experience in PostgreSQL Database Administration Maintenance backup installation configuration and Production Support of PostgreSQL Experience of working on HA Setup Backup & Recovery Involved in PostgreSQL Up-gradationChecking whether the daily backup generate reports for all servers perform installation configuration replication setup and maintenance tasks like vacuuming performance tuning reendexing

Noida, Uttar Pradesh, India

E-Ditiss, It Infrastructure, Systems And Security, 80%

Modules included -Network -Linux and Windows administration -Network Defense & Countermeasures -Information Security -Cyber Laws -Public.

Bachelor'S Degree, Computer Science