Post Gre Sql DBA

krg technology inc; Raritan (NJ); On-site; Full time

Job summary

A technology company in Raritan, New Jersey, is seeking a Database Administrator with a strong understanding of database design principles, particularly with PostgreSQL. The role involves working closely with a senior DBA on schema changes, database maintenance, and performance tuning. Candidates should have at least 1 year of experience with PostgreSQL and possess strong SQL scripting skills. A Bachelor's degree is required, and prior experience with Internet companies is a plus. Join a fast-paced environment focused on best practices and database optimization.

Qualifications

• Minimum 1 year experience with PostgreSQL 8.3, 8.4.
• Solid understanding of query execution plans.
• Experience in replication; Slony is a plus.

Responsibilities

• Work with senior DBA on database design and implementation enhancements.
• Assist in defining and implementing maintenance plan for the database systems.
• Help developers optimize queries and stored procedures.

Skills

Database design principles

PostgreSQL (1 year)

SQL scripting skills

Performance tuning

Problem-solving skills

Education

Bachelor's degree

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 system 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

All your information will be kept confidential according to EEO guidelines.