Database Administrator at Rose Avenue Group

Job Description

RACG is submitting a proposal for Developing a comprehensive Web-Based Stakeholder Engagement and Membership Management Platform requires a multidisciplinary team with expertise in various areas.

We extend a warm invitation to qualified and experienced technology and software engineering consultants to express their interest in developing an organizational platform. The selected consultants will play a crucial role in shaping and implementing innovative solutions for our current and future clients.

We appreciate your interest in being part of this exciting venture and look forward to receiving your valuable contributions.

Their primary responsibilities include designing the overall structure and ensuring that the solution meets the business and technical requirements.

Job Responsibilities

As a Database Administrator (DBA), you will be responsible for ensuring the integrity, security, and performance of databases within an organization. Your role involves designing, implementing, and maintaining database systems, as well as troubleshooting issues, optimizing performance, and collaborating with cross-functional teams to support the organization's data management needs.

Database Design and Architecture:

• Design, implement, and maintain database architectures that meet organizational needs.
• Collaborate with development teams to optimize database structures for performance.

Data Security:

• Implement and enforce security measures to protect sensitive data.
• Manage user access and permissions to ensure data integrity and confidentiality.

Performance Monitoring and Tuning:

• Monitor database performance and identify opportunities for optimization.
• Conduct performance tuning to enhance query efficiency and overall system performance.

Backup and Recovery:

• Develop and implement backup and recovery strategies to safeguard data.
• Test and validate backup and recovery processes regularly.

Database Installation and Configuration:

• Install, configure, and upgrade database management systems (DBMS).
• Ensure proper configuration for optimal performance and reliability.

Database Maintenance:

• Perform routine database maintenance tasks, including updates and patches.
• Monitor and manage database storage to prevent capacity issues.

Troubleshooting and Issue Resolution:

• Diagnose and resolve database-related issues promptly.
• Collaborate with development and IT teams to address complex problems.

Data Migration:

• Plan and execute data migration projects, ensuring data integrity and minimal downtime.
• Validate and document data migration processes.

Documentation:

• Maintain accurate and up-to-date documentation of database configurations, procedures, and guidelines.
• Create documentation for troubleshooting and issue resolution.

Collaboration:

• Collaborate with cross-functional teams, including developers, system administrators, and IT support teams.
• Provide expertise and support for database-related aspects of projects.

Security Audits and Compliance:

• Conduct security audits on a regular basis to identify and address vulnerabilities.
• Ensure compliance with data protection regulations and industry standards.

Capacity Planning:

• Analyze current and future data requirements to plan for database capacity.
• Recommend hardware and software upgrades as needed.

Other Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Administrator with a strong understanding of database management systems.
• Proficiency in database languages (SQL, PL/SQL) and experience with popular relational database systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server).
• Knowledge of NoSQL databases is a plus.
• Familiarity with database security, backup and recovery, and performance optimization techniques.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration abilities.