Home
Jobs

Senior Database Specialist

13 - 20 years

18 - 27 Lacs

Posted:4 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Niit Learning Systems
Niit Learning Systems

Education Administration Programs

Gurgaon Haryana

RecommendedJobs for You