SQL DBA with MarkLogic C2C jobs and Netezza (Must have)

Title                   : SQL DBA with MarkLogic and Netezza (Must have)

Location           : Branchville, NJ (Hybrid)

 

An L3 role typically involves advanced-level responsibilities, including resolving complex issues, overseeing system stability, and providing expert guidance. Here's 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 document-based data structures, indexing, and retrieval, ensuring the system handles large-scale data efficiently.

 

Troubleshooting and Maintenance: Handling escalated MarkLogic-specific 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 Netezza-specific 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.

 

 

 

 

 

 

 

——————– US STAFFING ESSENTIALS ————————————–
For daily US JOBS / Updated Hotlist / Post hotlist / Vendor Lists from the trusted sources 

For Everything in US Staffing JusSearch on google ” C2C HOTLIST ” for daily 5000+ US JOBS and Updated 10000+ Hotlists.

Have you Checked this No.1 US Staffing Whatsapp Channel for Daily C2C Jobs/ Hotlists and Top US staffing Telegram Channel of 50k American vendors


About Author

JOHN KARY graduated from Princeton University in New Jersey and backed by over a decade, I am Digital marketing manager and voyage content writer with publishing and marketing excellency, I specialize in providing a wide range of writing services. My expertise encompasses creating engaging and informative blog posts and articles.
I am committed to delivering high-quality, impactful content that drives results. Let's work together to bring your content vision to life.

Leave a Reply

Your email address will not be published. Required fields are marked *