Post Gre Sql DBA

Company Description Thanks & Regards Kumar.T | Resourcing Executive KRG Technologies, Inc., 25000 Avenue Stanford, Suite #243, Valencia, CA 91355 Direct : 661-367-8000 Ext : 303 | www.krgtech.com Job Description Job description :

Responsibilities

• Work with senior DBA on database design and implementation enhancements
• Primary on day to day schema changes and database maintenance
• Help developers to optimize 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

Requirements

• Solid understanding of database design principals
• Minimum 1 year experience with PostgreSQL 8.3, 8.4
• 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, Slony is a plus
• Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments
• Problem-solving skills
• Ability to thrive in a fast-paced, deadline-sensitive environment
• Bachelor's degree
• Prior experience with Internet Companies is a plus Additional Information Client - CTS Hiring Mode : Full Time