Senior SQL Server Database Administrator - Security Management
APTITUDE MANAGEMENT CONSULTING PTE. LTD.
AMC Founded in 2006, licensed by the Singapore Police Force, Police Licensing and Regulatory Department. offers custom security solutions suited to your demands. We work towards meeting the unique needs of every client, be it an enhancement to your current security set up or a complete overhaul that includes:
Job Summary:
We are looking for an experienced Senior SQL Server Database Administrator to join our Security Management System (SMS) project team. The role requires deep knowledge of Microsoft SQL Server in environments where data security, user access control, compliance, and audit integrity are critical. The ideal candidate will play a key role in managing and securing the back-end database infrastructure that supports identity management, access control, audit logging, encryption, and compliance reporting systems.
Key Responsibilities:
Required Qualifications:
- Virtual patrolling
- Facial recognition access control
- Remote vehicular access control
- License plate recognition technology
- Visitor Management System
Job Summary:
We are looking for an experienced Senior SQL Server Database Administrator to join our Security Management System (SMS) project team. The role requires deep knowledge of Microsoft SQL Server in environments where data security, user access control, compliance, and audit integrity are critical. The ideal candidate will play a key role in managing and securing the back-end database infrastructure that supports identity management, access control, audit logging, encryption, and compliance reporting systems.
Key Responsibilities:
- Install, configure, and maintain SQL Server instances (2008-2022) supporting security management applications.
- Ensure system uptime, performance, and reliability for mission-critical security systems.
- Implement and manage Transparent Data Encryption (TDE), row-level security, and auditing features.
- Work with CyberArk, Active Directory, and internal IAM teams to manage secure authentication and credential storage.
- Ensure GDPR, ISO 27001, and other compliance standards are supported through secure database design and audit logging.
- Configure secure user roles, logins, and permissions.
- Design and implement high availability (HA) and disaster recovery (DR) solutions using Always On, Log Shipping, Replication, Mirroring, and Cluste
- Schedule and manage backups (Full, Differential, Transaction Log) using LiteSpeed or native tools.
- Implement and manage security measures, user access control, encryption (TDE), and secure configurations using tools like CyberArk
- Perform database migrations and upgrades across environments (e.g., SQL 2012/2014/2016 to SQL 2019/2022).
- Design access controls based on least-privilege and need-to-know principles.
- Manage integration with centralized identity providers (e.g., LDAP, AD).
- Implement and monitor encrypted backups and automated restoration processes.
- Regularly test recovery strategies for resilience against data loss and cyber incidents.
- Deploy Always On Availability Groups, clustering, and log shipping to support zero-downtime requirements in critical security environments.
- Monitor and tune SQL queries and indexing strategies to ensure responsiveness of SMS dashboards, audit reports, and incident logs.
- Work with application security developers to ensure data is retrieved efficiently and securely.
- Set up real-time monitoring for intrusion detection anomalies at the database layer.
- Use tools such as Zabbix, SolarWinds, and Foglight for performance and event tracking.
- Ensure all changes to the security system's database architecture follow strict change control processes.
- Maintain detailed documentation of all configurations, procedures, and compliance audits.
Required Qualifications:
- Bachelor's or Master's in Information Technology, Computer Science, or related field.
- Minimum of 10 years of hands-on experience managing SQL Server databases in secure environments.
- Deep expertise in SQL Server 2008-2022, including Always On, Clustering, TDE, and Auditing.
- Demonstrated experience working on security-critical platforms such as Identity Management, SIEM, or Audit Logging Systems.
- Familiar with TLS encryption, certificate management, security patching, and SQL security features.
- Experience integrating databases with CyberArk, ServiceNow, or other ITSM/security tools.
- Knowledge of Oracle 11g or other secondary RDBMS platforms is a plus.
- Working knowledge of SSIS and SSRS.
- Familiarity with database tools: LiteSpeed, Foglight, Zabbix, SolarWinds.
- Experience supporting compliance audits (e.g., SOC2, PCI-DSS, HIPAA).
- Microsoft certifications related to data security or cloud security (e.g., MS Azure Database Security).
- Experience working on or integrating with Physical Security Systems, Access Control Systems, or IAM platforms.
JOB SUMMARY
Senior SQL Server Database Administrator - Security Management
APTITUDE MANAGEMENT CONSULTING PTE. LTD.
Singapore
a day ago
N/A
Full-time
Senior SQL Server Database Administrator - Security Management