| Urgent requirements for :: SQL DBA with MarkLogic and Netezza :: Branchville, NJ (Hybrid) at Branchville, New Jersey, USA |
| Email: [email protected] |
| From: Nirbhay singh, Appian infotech Inc [email protected] Reply to: [email protected] Hi, We Have Urgent requirements for SQL DBA with MarkLogic and Netezza Job Title: SQL DBA with MarkLogic and Netezza Location: : Branchville, NJ (Hybrid) Job Type: Long Term Project Job Description: 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. -- Regards Nirbhay Singh Sr. Talent Acquisition Specialist Appian Infotech Inc Direct No- 276 910 0146 Ext. 128 Office no-(Only for Text)- 276-284-3289 Email- [email protected] LinkedIn:- https://www.linkedin.com/in/n-k-singh-430076245/ Keywords: New Jersey Urgent requirements for :: SQL DBA with MarkLogic and Netezza :: Branchville, NJ (Hybrid) [email protected] |
| [email protected] View all |
| Tue Nov 05 02:01:00 UTC 2024 |