CTC Undisclosed Job Location Mumbai Experience 0 - 3 yrs
ZEDO (India) Pvt. Ltd., a leading global ad platform, is seeking a Postgresql DBA to work in a fast paced environment. Ideal candidates must be enthused about database administration, quick learning and self starting. This is a demanding role that will require hands-on experience with database management, Ubuntu, hardware, networking and security. You will be responsible for the day to day operation of Zedo system... including maintain of databases for corporate and development environments. We are seeking a candidate with good skills in database tuning, maintenance, PSQL and Linux who is passionate about database administration. This position includes production support.
Database uptime, availability and backups.
Database design Primary on day to day schema changes.
Help developers to optimize and tune queries, stored procedure and database design.
Assists in developing and implementing best practices for DR and Backups.
Assists in evaluating and selecting equipment, services and vendors.
Assist in Defining and implementing maintenance plan for the database systems.
Desired Skills and Experience:
Solid understanding of database design principals.
Experience with Postgresql 8.4, 9.x or similar DB.
Solid understanding of query execution plans.
Good SQL scripts skill including SPs, PSQL scripting.
Good performance tuning skills.
Ability to proactively identify, troubleshoot and resolve live database systems issues.
Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore.
Experience in replication, PG Pool is a plus.
Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
Ability to thrive in a fast-paced, deadline-sensitive environmentRead more