Blog

Hello Recruiter,

Greetings!!!!

This is Yatika from SAGE IT Inc. I am reaching you out for an exciting position with one of our clients.

Title: SQL DBA with MarkLogic and Netezza

Location: Branchville, NJ (Hybrid)

Client: HCL

Contract role

GC/USC/OPT/CPT visa would not work

Please don’t share resume without MarkLogic/Netezza experience

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.

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 up-to-date with evolving technologies

‘This e-mail and any attachments to this e-mail are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, please immediately delete or destroy all copies or versions you have of this e-mail, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately at [email protected] in order that we may take steps to prevent any further inadvertent disclosures. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.sageitinc.com‘