Netezza DBA

TechDigital Group; Providence (RI); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Netezza Database Administrator to manage and optimize database solutions. In this role, you will ensure the availability, performance, and security of Netezza databases while implementing best practices and collaborating with developers. Your expertise will be crucial in troubleshooting, optimizing queries, and maintaining high availability and disaster recovery solutions. If you thrive in a dynamic environment and are ready to take on critical challenges, this opportunity is perfect for you to make a significant impact.

Qualifications

• 6-8 years of experience as a Netezza DBA or similar role.
• Strong understanding of database concepts and best practices.

Responsibilities

• Manage and maintain Netezza databases for optimal performance and security.
• Implement database backup and recovery strategies to safeguard data integrity.
• Collaborate with developers to design and optimize database schemas.

Skills

Netezza DBA

Scripting

Query Optimization

Analytical Skills

Communication Skills

Job description

Mandatory Skill: Netezza DBA

Good to have skill: SNOW Flake DBA.

Proven experience (6-8 years) as a Netezza Database Administrator (DBA) or similar role.

Expertise in Netezza database administration, including installation, configuration, maintenance, and troubleshooting.

Strong understanding of database concepts, architecture, and best practices.

Proficiency in scripting and query optimization.

Experience with Netezza high availability and disaster recovery solutions.

Knowledge of database security principles and practices.

Excellent analytical and problem-solving skills.

Effective communication and collaboration skills.

Should be flexible to work in Shift and on-call support on any critical situations.

Responsibilities

As a Technical Specialist, you will be responsible for managing and maintaining our Netezza databases, ensuring their availability, performance, and security. You will play a crucial role in designing, implementing, and optimizing database solutions to meet the needs of our organization.

1. Manage, monitor, and maintain Netezza databases to ensure optimal performance, availability, and security.
2. Identify and resolve performance issues, optimize queries, and fine-tune database configurations to improve efficiency and response times.
3. Implement and maintain database backup and recovery strategies to safeguard data integrity and minimize downtime in case of failures or disasters.
4. Implement and enforce database security policies, roles, and permissions to protect sensitive data from unauthorized access or breaches.
5. Configure and manage high availability (HA) and disaster recovery (DR) solutions, such as clustering on Openshift.
6. Collaborate with developers and architects to design and optimize database schemas, indexes, and data structures for performance and scalability.
7. Apply patches, service packs, and updates on IBM Netezza ensuring compliance with security and regulatory requirements.
8. Set up and configure database monitoring tools to proactively monitor performance metrics, disk space, and other vital parameters. Respond to alerts and incidents promptly to prevent service disruptions.
9. Create and maintain technical documentation for database, schemas, tables, configurations, and procedures.
10. Perform capacity planning and forecasting to ensure scalability and efficient utilization of database server resources.