Relational Database: Support Engineer

Role: - Relational Database: Support Engineer

Experience

Preference

Candidate Location

Role and Responsibilities:

• Database Administration:

  Install, configure, maintain and upgrade MSSQL, MYSQL, PostgreSQL and Mongo database servers.

• Performance Tuning:

  Monitor database performance, identify bottlenecks, and implement optimizations to improve query performance and overall system efficiency. This includes query analysis, index optimization, and server parameter tuning.

• High Availability & Disaster Recovery:

  Implement and maintain high availability and disaster recovery solutions, including replication, clustering, and backups. Develop and test failover procedures.

• Security Management:

  Implement and enforce database security policies, including user management, access control, and data encryption. Conduct regular security audits.

• Backup & Recovery:

  Develop and implement backup and recovery strategies to ensure data integrity and availability. Perform regular backups and test recovery procedures.  

• Troubleshooting:

  Diagnose and resolve database issues, including performance problems, connectivity issues, and data corruption.

• Automation:

  Automate routine DBA tasks using scripting languages (e.g., Bash, Python) and automation tools.

• Monitoring:

  Implement and maintain database monitoring tools to proactively identify and address potential issues.

• Capacity Planning:

  Participate in capacity planning to ensure database resources can meet future growth demands.

• Collaboration:

  Work closely with developers, system administrators and other teams to support application development and deployment.

• 24/7 Support:

  Participate in a 24/7 rotation to provide continuous support.

Requirements

• Bachelor's degree in Computer Science or a related field.
• Knowledge of MSSQL, MYSQL (Preferred), PostgreSQL and Mongo database.
• Good in SQL and database scripting.
• Knowledge of high availability and disaster recovery solutions (e.g., replication, Log shipping, clustering, master/slave replication).
• Knowledge understanding of database security best practices.
• Knowledge of database monitoring and performance analysis tools (e.g., Percona Monitoring Plugins, Prometheus, Grafana).
• Knowledge of scripting languages (e.g., Bash, Python).
• Good troubleshooting and problem-solving skills.
• Strong communication and collaboration skills.
• Experience with cloud-based database (AWS RDS, Azure Database, Google Cloud SQL) is a plus.  

Interested candidate can share updated profile on