Senior Postgres and REDIS Admin at Vennote Technologies Limited

Key Responsibilities :

• Actively engage in Technical investigations & restoration of DB related issues
• Ensuring PostgreSQL DB's are running 24/7
• Monitoring DB Events, Incidents & Request Queries
• Prepare status reports, technical documents, SOP's, Knowledge Bases.
• Support Management teams in Technology decisions, identify impacts and risks
• PostgreSQL onpremise & cloud hands-on experience
• Database Tablespace management
• Primary operational support for the management & maintenance of Redis
• Responsible for database and system performance, including database monitoring, problem analysis, and tuning activities to ensure optimum database performance
• After-hours support for application release and change management activities
• Participate in on-call rotation and respond to critical database incidents
• Work with application development groups and system administrators to determine the best storage, access, and distribution methods for data
• Participate as a project team member providing vital information regarding database tools, structure, physical design and implementation

Technical Experience:

• Experience with troubleshooting and debugging complex SQL queries & problem solving skills
• Experience with relational databases (PostgreSQL) Architecture & Internals,
• Monitoring database health and security, implement table redesigns.
• Update data in support of operations and SQL query design.
• Knowledge in developing and designing databases and data models
• Hands-On with Installation, configuration, HA, Replication, OS Cluster Active-Passive installation & configuration
• PostgreSQL onpremise & cloud hands-on experience
• Database Tablespace management
• Hands-on experience with PostgreSql DB version upgrade & migrations
• Database management experience on Linux & Windows Platform
• Proficient in support and maintenance of Redis, MySQL, MongoDB management, NoSQL management, data backup and optimization
• Proficient in MySQL DB engine,
• Hands-on experience in the concepts, Architecture and administration of NoSQL, MongoDB / REDIS / Cassandra type DB's.
• Exposure to Big Data technologies like Hadoop.
• Exposure to how Map-Reduce/Hive/Pig jobs can run on Cassandra.
• Experience with Unix/Linux including basic commands and shell scripting.
• Good working knowledge of DB performing monitoring tools.
• Experience with RDBMS is a plus. RDBMS such as Oracle, MySql, PostgreSQL and use of Hibernate, ORMs and/or jdbc

REQUIREMENTS

• 8 Years plus experience in PostgreSQL
• Proven work experience as a PostgreSQL administrator or similar role
• Positive attitude and a strong commitment to delivering quality work.
• Excellent knowledge of cloud computing technologies and current computing trends
• Effective communication skills (written and verbal) to properly articulate complicated cloud reports to management and other IT development partners
• Relevant training and/or certifications as a PostgresSQL DBA.

Benefits

• Private Health Insurance
• Pension Plan
• Training & Development
• Performance Bonus
• Hybrid work plan