| Urgent Opening || SQL DBA with MarkLogic || Branchville NJ || Hybrid at Branchville, South Carolina, USA |
| Email: [email protected] |
| From: Abhishek Kumar, Appian Infotech [email protected] Reply to: [email protected] Hi, Greetings from Appian InfoTech, Hope you are doing great. I am Abhishek Kumar and I work as a Technical Recruiter at Appian InfoTech. We are currently looking for an SQL DBA with MarkLogic to work with one of our clients. Id love to tell you a little more about this position and learn a few things about you, as well. Position: SQL DBA with MarkLogic Location: Branchville, NJ (Hybrid) Duration: long term Contract Type: w2/c2c JD: 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%), 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. Thanks & Regards Abhishek Kumar (Technical Recruiter ) Appian Infotech Inc. Desk -276-910-0143 Ext.115 Skype Id- live:.cid.8a597d4ef61ab0f4 LinkedIn- https://www.linkedin.com/in/abhishek-k-947662133/ Website - www.appianin fotech.com Keywords: access management wtwo Idaho New Jersey Urgent Opening || SQL DBA with MarkLogic || Branchville NJ || Hybrid [email protected] |
| [email protected] View all |
| Tue Nov 05 02:28:00 UTC 2024 |