Senior Database Administrator
Uni Systems
- Αθήνα
- Μόνιμη
- Πλήρης Απασχόληση
- Assess the current POC database architecture for scalability, performance, and security.
- Design a robust, scalable, and secure production-ready database architecture.
- Review and update the database schema to ensure it meets production requirements and industry best practices.
- Develop a comprehensive data migration plan from POC to production, ensuring data integrity and minimal downtime.
- Test the migration process in a staging environment to identify and resolve potential issues.
- Coordinate the actual data migration, ensuring all stakeholders are informed and prepared for the transition.
- Analyze and optimize database performance through indexing, query optimisation, and configuration adjustments.
- Implement monitoring tools to continually assess database performance and identify areas for improvement.
- Plan and execute capacity planning activities to ensure the database can scale with organizational growth.
- Ensure the database architecture complies with relevant data protection, privacy laws and security policies.
- Implement security measures, including encryption, access controls, and auditing, to protect sensitive information.
- Regularly review and update security protocols in response to emerging threats.
- Design and implement a disaster recovery plan to ensure data availability and continuity in the event of a failure.
- Set up and maintain regular backup procedures, including testing backups for integrity and recoverability.
- Develop and document procedures for restoring the database from backups in case of data loss.
- Create comprehensive documentation for the database architecture, including diagrams, data models, and flowcharts.
- Develop Standard Operating Procedures (SOPs) for database maintenance, updates, and troubleshooting.
- Ensure documentation and SOPs are easily accessible and understandable to both technical and non-technical staff.
- Have at least a Master degree
- Possess a minimum 9 years of IT professional experience.
- Have a minimum 6 years' experience in database or application management.
- Experience with MySQL, PostgreSQL, and NoSQL or in-memory technologies (such as Kvrocks and Redis)
- Competence in web frontend or user interface development (such as Html/Js/CSS/XML)
- Knowledge about application development and deployment
- Nice to Have:
- Experience with DevOps
- Experience with web application support (python, REST API)
- Experience with scripting and application administration on Linux server support
- Proficiency in English language knowledge at level B2 or higher.