info@triangleglobal.com +91 9773942225
Jobs
Job Details
 Job Title:
Open Source L2 & L3
 Job Description:
A good knowledge of the physical database design A good understanding of the underlying operating system (Unix(RHEL)) CONFIGURATION, ADMINISTRATION AND MANAGEMENT OF POSTGRESQL/MYSQL/MongoDB Databases PERFORMANCE TUNING AND DB MAINTENANCE AT DATABASE LEVEL. PERFORM DB UPGRADATION/ PATCHING. Partitioning (Partition Tables and it’s type understanding Range, Hash etc) Indexing (Local and Global Index, its benefits and drawbacks) Worked on Heavy databases 100+ TB PERFORMING BACKUP AND RECOVERY, REPLICATION, DR-DRILL. Establish and maintain sound backup and recovery policies and procedures PERFORMING AND MANAGING LOGICAL AND PHYSICAL BACKUPS IN POSTGRESQL AND MYSQL. Different backup and recovery scenarios understanding Restoration backup (point in time recovery, datafile restoration) Implement and maintain Database security (create and maintain users and roles, assign privileges) Perform database tuning and performance monitoring – Plan changing understanding, how to fix plan Perform application tuning and performance monitoring TROUBLESHOOTING ON A DAILY BASIS FOR PREVENTING ISSUES AND PROVIDING CAPACITY PLANNING. MONITORING THE PRODUCTION POSTGRESQL ALERT LOGS FOR DATABASE ERRORS. MONITOR THE CLIENT CONNECTIVITY USING PG_HBA.CONF FILES. Work as part of a team and provide 24x7 support when required (Weekend supports)
 Job Code:
 Job Location:
Mumbai
 Experience:
8+
 Skill: