What are the responsibilities and job description for the SQL Database Administrator position at Cynet Systems?
Job Description:
Pay Range: $47hr - $53hr
SQL:
Pay Range: $47hr - $53hr
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.
- 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.
- 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.
Salary : $47 - $53
