Issue Resolution: Monitor production systems for issues, respond promptly to incidents, and troubleshoot problems to restore normal operations.
SQL Queries: Write and optimize SQL queries to investigate and resolve data-related issues, ensuring data integrity and accuracy.
Performance Monitoring: Use monitoring tools to track system performance, identify bottlenecks, and recommend enhancements.
Database Maintenance: Perform regular database maintenance tasks, including backups, indexing, and data archiving, to ensure system reliability and performance.
Documentation: Maintain detailed documentation of production issues, resolutions, and standard operating procedures.
Collaboration: Work closely with development, QA, and infrastructure teams to ensure smooth deployments and system integration.
User Support: Provide technical support and guidance to internal users regarding database-related queries and issues.
Change Management: Participate in change management processes, ensuring all changes are tested and documented appropriately.
Incident Management: Track and manage incidents using ticketing systems, ensuring timely resolution and communication with stakeholders.
Continuous Improvement: Identify areas for process improvement and implement best practices to enhance system reliability and efficiency.
Preferred Skills
Familiarity with ETL processes and data warehousing concepts.
Experience with monitoring and alerting tools (e.g., Nagios, Grafana).
Knowledge of scripting languages (e.g., Python, PowerShell) for automation.
