What are the responsibilities and job description for the Postgre SQL Administrator position at Infosys Technologies Ltd?
A collaborative spirit and excellent communication skills. Ability to handle complex incidents and implement resolutions A knack for conducting IT infrastructure assessment and identifying key optimization opportunities Focused approach towards deployment management, system optimization, and process automation initiatives including sector specific focus The ability to work with cross-functional teams |
| Required Skills : |
| Experienced with Postgres SQL and Amazon Aurora Database Excellent Analytical and troubleshooting skills. Hands-on experience with: Database monitoring tools such as: Cloudwatch, Dynatrace, Zabbix, and Foglight. Proficient with Shell scripting with Linux is a plus Outstanding in verbal and written communication. Creative thinking in implementing Service improvements with: Automation, and Incident reduction. Well-Versed with running operations following ITIL processes. Practiced with leading geographically separated customers and onshore/offshore teams Building and supporting large-scale, high-transaction database environments. Database performance tuning, optimization, and deep-dive analysis. Configuring, supporting, and tuning PostgreSQL databases. Working Knowledge of database backup and recovery strategies. Ability to write and debug Shell and Python scripts. Excellent communication skills, with the ability to collaborate effectively with business teams, technical teams, and senior management. Manage database platforms to ensure high availability and performance, including start, stop, restart, failover operations, and replication-lag monitoring on replica nodes. Perform daily health checks for disk, CPU, memory utilization, and PostgreSQL logs, using AI-driven automation where applicable. Carry out on-demand backup and restoration activities, including table- and schema-level backups. Identify long-running and repetitive queries, run execution plans, and share findings with the development team for further analysis. Enact basic user and access management. Troubleshoot infrastructure, performance, and availability issues. Provide basic query and performance support. Monitor weekend job alerts, troubleshoot issues, and escalate to the Compass SME as per SOP. Execute database refresh activities during weekends. Participate in planned maintenance windows and outage activities and perform database tuning and optimization to meet SLA requirements. Handle incident management, change management, and service tasks in accordance with SLA requirements. |
| Preferred Skills : |
| DB2 LUW administration is a plus Database monitoring tools: CloudWatch, Zabbix, Dynatrace, Datadog, Fog light. |
Salary : $80,000 - $100,000