Job Purpose
The candidature is requested for supporting and managing Postgres Database domain
and managing Database domain covering other databases like MS SQL and Oracle
DB environment in India. As part of IT Infrastructure Team, the role revolves to take
care of BAU support operations, project activities and risk & compliance activities
within database domain at country level.
Key Accountabilities
DB Administration for Postgres Database Domain, and maintain higher uptime &
manage Oracle, MS SQL and other Databases with respective support team.
Manage BAU activities like backup, capacity management, DB Performance
Tuning etc. and project activities like installation, migration etc.
Manage of vendors (onsite/Offshore) infra support professionals for support &
service delivery.Ensure that the defined processes (e.g. Incident, Change, Capacity
and Problem Management) are well applied & followed.
Job Duties & responsibilities
Experienced with PostgreSQL & PostgreSQL Architecture
Managing PostgreSQL schema, tables, tablespaces and users, roles & groups.
PostgreSQL Index Management, Partitioning and System Catalogs
Expert in Backup & Recovery including Pg dump, setting up WAL archiving,
Point in time recovery.
Experience working with complex data warehouse projects
Experience designing custom ETL processes to populate the data warehouse
High-level knowledge of various industry-leading data warehouse components
(databases,ETL tools, BI/reporting tools)
Lead efforts to develop and improve procedures for automated monitoring and
proactive intervention, reducing any need for downtime.
Participate in application development projects and be responsible for the database
architecture and design
Responsible for developer SQL code review to ensure queries are optimized and
tuned to perform efficiently prior to production release.
Knowledge on PGAdmin and other PostgreSQL tools and utilities.
Knowledge on High Availability, streaming replication, Replication Failover,
repmgr, barman, pgbouncer and pg_pathman.
Knowledge in maintenance activities such as vacuum, vacuum full, and analyze
the database.
Understanding of basic database fundamentals: multi-version control,
concurrency, transactions, indexing, locking.
Analyse, recommend, and implement configuration for Optimized Performance.
Ability to plan hardware capacity requirements for storage, memory, and CPU
Cycles.
Expert with setting and trouble shoot replication issues.
Understanding of UNIX environment with shell scripting.
Familiarity with Linux administration
Evaluate new database technologies and products and recommend to technical
management
Contribute to document company database standards, guidelines, and operational
procedures
Perform a variety of tasks relying on experience and judgment to manage time,
plan and accomplish goals on several client engagements
Provide 24 x 7 x 365 support through on-call rotation
Excellent communication and problem-solving skills