Database Security Expert

Information technology

Location:	Cairo - EGYPT
Age:	25 - 45 years
Experience:	2 - 12 years
Gender:	All
Open vacancies:	20
Job description:	Basic Qualifications • Expert knowledge of open source SQL databases, in particular SQL Server / Mysql / Oracle , etc. • Significant production experience in high volume situations dealing with advanced replication schemes, sharing, performance optimization • Server management, maintenance and backup strategies • Experience running database servers on dedicated hardware and cloud instances • Extremely proficient with best security practices • Experience with common db tools such as Percona toolkit, Sysbench • Scripting (two or more of bash, python, go, ruby and/or perl) • Version control (gitlab, github, bitbucket, etc.) • Experience with docker and/or kubernetes • Experience with various proxies such as haproxy, proxysql • Open to work with other systems such as Postgres, Apache Kafka, Elasticsearch, Apache Druid, Presto, etc. • In depth knowledge of databases, including experience working with transactional replication, performance tuning and optimization. • Experience with database backup and restore, disaster recovery and security. • Advanced knowledge of database performance tuning and optimization, INNER OUTER/JOINS, CROSS/OUTER APPLIES, UNIONS etc. • Expert knowledge of database design concepts, stored procedures, triggers, views and SSIS/SSRS packages • Experience with monitoring tools and troubleshooting database performance issues. Ability to install and configure new server instances and upgrade existing ones. • Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO) • Test backups to ensure we can meet the business' Recovery Time Objectives (RTO) Manage DDL scripts for multiple environments DEV/UAT/PROD • General ability to support and optimize advanced and complex queries
Required skills:	• Monitor and maintain the security of the databases and database software (with other groups) • Manage database security patching and upgrades • Provide database backup and recovery services o Daily verification of database backups review and resolution of log and monitoring messages • Enhance and improve our high availability disaster recovery backup/recovery and monitoring solutions • Provide consulting support for use of database security features • Provide standards procedures and guidelines for the effective and secure use of the databases and database features • Provide problem resolution and troubleshooting services for database security related errors • Monitor and maintain production and non-production database environments o Provide migration services to oversee changes to the production environments o Troubleshoot various security / performance / availability issues o Installation upgrade and maintenance of enterprise database software including: Oracle and MS SQL Server. o Manage vendor interaction for database software related items and ensure license agreement compliance • When provided access to personal proprietary and/or otherwise confidential data maintains such data in the strictest confidence and follows procedures to ensure the privacy security and proper use of data • Provide database troubleshooting and problem resolution • Create and maintain physical database structures
Salary:	Negotiable

APPLY NOW