SQL DBA with MarkLogic and Netezza

Hi

Hope you are doing Good!!

This is Priya from S2SSoft LLC we are looking for SQL DBA with MarkLogic and Netezza Find the below mentioned job description. Kindly forward me your resume Rate and contact details for further process.

Title : SQL DBA with MarkLogic and Netezza

Location : Branchville NJ (Hybrid)

Type : Contract

Job Description:

An L3 role typically involves advancedlevel responsibilities including resolving complex issues overseeing system stability and providing expert guidance. Heres a breakdown based on specifications for SQL (70%) MarkLogic (20%) and Netezza (10%):

1. SQL

Database Design and Optimization: Designing efficient database schemas indexing strategies and query optimization to improve performance.

Performance Tuning: Monitoring and optimizing the performance of SQL queries stored procedures and overall database health.

Troubleshooting: Handling escalated issues from L2 support including complex SQL errors deadlocks and data inconsistencies.

Data Integrity and Security: Implementing security measures such as access controls and encryption ensuring data integrity and compliance with standards.

Backup and Recovery: Managing and maintaining database backups ensuring disaster recovery processes are in place.

Automation: Creating and maintaining scripts for database tasks including backups monitoring and alerts.

Collaboration: Working with development teams to optimize database interactions and provide guidance on best practices.

2. MarkLogic

Database Administration: Managing the MarkLogic NoSQL database including installation configuration and upgrading.

Query Optimization: Optimizing XQuery and search performance in MarkLogic ensuring efficient data retrieval.

Data Management: Managing documentbased data structures indexing and retrieval ensuring the system handles largescale data efficiently.

Troubleshooting and Maintenance: Handling escalated MarkLogicspecific issues including performance bottlenecks and system failures.

Security: Managing security features like user roles permissions and encryption in MarkLogic.

3. Netezza

System Administration: Administering the Netezza appliance including system health checks upgrades and maintenance.

Performance Tuning: Optimizing Netezzaspecific SQL queries particularly those involving large datasets.

Troubleshooting: Handling escalated issues specific to the Netezza environment such as performance lags or database errors.

Data Load Management: Overseeing data load processes to ensure efficient ETL operations

Across these platforms L3 support will involve advanced troubleshooting handling escalations and ensuring overall system performance reliability and security. Additionally the L3 professional would likely be responsible for mentoring junior team members and staying uptodate with evolving technologies