Rosemallow Technologies - Database Administrator - MySQL/PostgreSQL (6-10 yrs)

Job Summary :

The Database Administrator is responsible for the planning, implementation, maintenance, and performance of critical database systems. This includes ensuring data availability, security, and integrity, as well as troubleshooting database issues and implementing performance optimizations. The DBA will work closely with developers, system administrators, and other stakeholders to support the organization's data needs.

Responsibilities :

- Database Installation and Configuration : Install, configure, and upgrade database software and related tools.

- Performance Monitoring and Tuning : Proactively monitor database performance, identify bottlenecks, and implement performance tuning strategies to optimize database responsiveness and scalability.

- Backup and Recovery : Develop and implement robust backup and recovery procedures to ensure business continuity in case of system failures or data loss. Regularly test recovery procedures.

- Security Management : Implement and maintain database security measures, including user access control, data encryption, and vulnerability patching, to protect sensitive data.

- Data Integrity : Ensure data integrity through the implementation of constraints, triggers, and other database features.

- Troubleshooting and Problem Solving : Diagnose and resolve database issues, including performance problems, connectivity issues, and data corruption.

- Capacity Planning : Forecast database growth and plan for future capacity needs to ensure adequate resources are available.

- Documentation : Maintain accurate and up-to-date documentation of database configurations, procedures, and best practices.

- Collaboration : Work closely with developers, system administrators, and other stakeholders to understand their data requirements and provide support.

- Automation : Automate routine database tasks, such as backups, monitoring, and maintenance, using scripting languages and automation tools.

- Staying Current : Keep up-to-date with the latest database technologies, trends, and best practices.

- On-Call Support : Participate in an on-call rotation to provide support for critical database issues outside of normal business hours. (If applicable)

Required Skills and Experience :

Education : Bachelor's degree in Computer Science or a related field preferred.

Experience : [Number] years of experience as a Database Administrator.

- Database Platforms : Proficiency in one or more of the following database platforms : [List specific databases - e.g., MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, etc.]

- Operating Systems : Experience with [List specific operating systems - e.g., Linux, Windows Server]

- Scripting Languages : Familiarity with scripting languages like [List specific languages - e.g., SQL, Python, Bash, PowerShell]

- Performance Tuning : Strong understanding of database performance tuning techniques and tools.

- Backup and Recovery : Experience with implementing and testing database backup and recovery strategies.

- Security : Knowledge of database security best practices and techniques.

- Troubleshooting : Excellent problem-solving and troubleshooting skills.

- Communication : Strong communication and collaboration skills.

Preferred Skills and Experience :

- Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL).

- Knowledge of database replication technologies.

- Experience with database monitoring tools.

- Certification in relevant database technologies.

- Experience with Agile development methodologies.