Negotiable
Undetermined
Undetermined
London Area, United Kingdom
Summary: The Database Administrator role at an investment bank involves designing and developing database structures, optimizing performance, and ensuring security measures are in place. The position requires collaboration with IT and development teams to meet organizational data needs while managing backup and recovery procedures. The role also includes troubleshooting database issues and planning for future capacity requirements.
Key Responsibilities:
- Designing and implementing new database structures and optimizing existing ones.
- Monitoring database performance and implementing solutions for efficiency.
- Implementing and maintaining database security measures.
- Developing and executing backup and recovery procedures.
- Diagnosing and resolving database issues.
- Collaborating with IT and development teams for effective database integration.
- Regularly monitoring database systems and performing maintenance tasks.
- Planning and managing database capacity for future needs.
Key Skills:
- Extensive experience with various database management systems (DBMS) such as Oracle, SQL Server, MySQL, or PostgreSQL.
- Strong SQL skills for database querying and administration.
- Understanding of database design principles, including normalization and data modeling.
- Experience in identifying and addressing performance bottlenecks.
- Knowledge of database security best practices.
- Experience in implementing and managing backup and recovery procedures.
- Ability to diagnose and resolve complex database issues.
Salary (Rate): undetermined
City: London Area
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
Responsibilities
- Database Design and Development
- Designing and implementing new database structures, optimizing existing ones, and ensuring they meet organizational needs.
- Performance Tuning and Optimization
- Monitoring database performance, identifying bottlenecks, and implementing solutions to improve efficiency and speed.
- Security Management
- Implementing and maintaining database security measures, including access controls, encryption, and disaster recovery plans.
- Backup and Recovery
- Developing and executing backup and recovery procedures to ensure data integrity and minimize downtime in case of system failures.
- Troubleshooting and Problem Solving
- Diagnosing and resolving database issues, including performance problems, access errors, and security breaches.
- Collaboration and Communication
- Working closely with IT, development, and other teams to understand data requirements and ensure effective database integration.
- Monitoring and Maintenance
- Regularly monitoring database systems for performance, health, and security; performing routine maintenance tasks; and applying updates.
- Capacity Planning
- Planning and managing database capacity to meet current and future needs, ensuring the system can handle increasing data volumes and workloads.
Required Skills
- Advanced Knowledge of Database Systems
- Extensive experience with various database management systems (DBMS), such as Oracle, SQL Server, MySQL, or PostgreSQL, for both on-premises and cloud-hosted databases.
- SQL Proficiency
- Strong SQL skills for database querying, manipulation, and administration.
- Database Design and Modeling
- Understanding of database design principles, including normalization, data modeling, and data warehousing.
- Performance Tuning and Optimization
- Experience in identifying and addressing performance bottlenecks in database systems.
- Security Expertise
- Knowledge of database security best practices, including access controls, encryption, and auditing.
- Backup and Recovery
- Experience in implementing and managing backup and recovery procedures.
- Troubleshooting and Problem Solving
- Ability to diagnose and resolve complex database issues.