Role & responsibilities
Job Overview:
We are seeking a highly skilled Senior Database Specialist 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 / Hana 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 / Hana Database Administration:
Database Management:
Database Architecture & Strategy, Multi-cloud database architecture design, Database consolidation strategies, Administer and maintain SQL Server databases, including installation, configuration, migration (Database migration planning (on-prem to cloud, cloud-to-cloud)) and upgrading (Version upgrade strategies with minimal downtime) 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.
Qualifications:
Education:
Bachelors degree in Computer Science, Information Technology, or a related field. Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, or Certified Information Systems Auditor (CISA) are a plus.Experience:
Minimum of 12-15 years of experience as a SQL Database Administrator, with a strong focus on audit trail management and ITGC controls.Certifications :
Microsoft and SAP certifications for Database management.Skills:
SQL Server:
Proficiency in SQL Server administration, performance tuning, and security management. Must have supported applications like SAP ECC SQL Clusters, SharePoint running on MS Sql, SAP Analytics Cloud with HANA DB.Audit Management:
Expertise in implementing and managing audit trails and compliance with regulatory requirements.ITGC Controls:
Strong understanding of IT General Controls and risk management practices.Troubleshooting:
Advanced problem-solving skills for database issues and performance optimization.Communication:
Excellent communication skills for documenting processes, reporting findings, and collaborating with cross-functional teams.
Preferred candidate profile
Attention to Detail:
Meticulous attention to detail in managing audit trails and implementing controls.Adaptability:
Ability to adapt to changing technologies and regulatory requirements.Continuous Learning:
Commitment to staying current with advancements in SQL Server technologies and auditing practices.