Job Description

Job Overview: We are seeking a highly skilled SQL Database Administrator (DBA) with strong expertise in audit trail management and IT General Controls (ITGC). The ideal candidate will be responsible for the administration, performance tuning, and security of SQL databases, while also ensuring compliance with audit requirements and implementing effective ITGC controls. This role requires a keen eye for detail and a thorough understanding of database auditing practices. Key Responsibilities: 1. SQL Database Administration: Database Management: Administer and maintain SQL Server databases, including installation, configuration, and upgrading of database servers. Performance Tuning: Optimize database performance through query tuning, index optimization, and performance monitoring. Backup and Recovery: Implement and manage database backup and recovery procedures to ensure data integrity and availability. Security: Apply and manage database security measures, including user access control, encryption, and compliance with security policies. 2. Audit Trail Management: Audit Trail Implementation: Develop and maintain audit trails to track database activities, including changes to data and schema, user access, and system events. Audit Logs: Configure and manage audit logging mechanisms, ensuring that logs are comprehensive, secure, and retained according to regulatory and organizational policies. Compliance: Ensure that audit trails meet industry standards and regulatory requirements (e.g., GDPR, 11G, ISO). 3. IT General Controls (ITGC) Implementation: ITGC Controls: Design, implement, and monitor IT General Controls related to database management, including access controls, change management, and data integrity. Risk Management: Identify and mitigate risks associated with database systems and ensure controls are effective in preventing unauthorized access and data breaches. Audit Support: Provide support during internal and external audits by preparing documentation, responding to audit inquiries, and addressing any findings. 4. Incident and Problem Management: Issue Resolution: Troubleshoot and resolve database-related issues and performance problems in a timely manner. Problem Analysis: Conduct root cause analysis for recurring issues and implement preventive measures to avoid future occurrences. 5. Documentation and Reporting: Documentation: Maintain detailed documentation of database configurations, changes, and audit trails. Reporting: Generate and review regular reports on database performance, audit logs, and ITGC compliance. 6. Collaboration and Communication: Cross-Functional Teams: Collaborate with development teams, IT support, and other stakeholders to ensure database systems meet business requirements. Training and Support: Provide training and support to team members and end-users regarding database management and auditing best practices.