Designation: Database Admin Engineer | Experience: 5+ Years | Location: Guindy, Chennai
- Must understand technologies consisting of but not limited to MariaDB/MySQL, NoSQL, PostgreSQL (MongoDB, Cassandra etc…).
- Must have working and technical knowledge and experience with current Linux operating systems.
- Must have Strong problem-solving and analytical skills.
- Proficient in relational databases and backup and recovery.
- Comfortable with procedures such as shell scripting and scripting.
- Monitor the health of the DB servers through both automated and manual processes.
- Recommend and implement solutions for performance monitoring and tuning.
- Analyze problems, anticipate future problem areas, and implement solutions.
- Perform environment setup and configuration, proactive monitoring, and maintenance.
- Support the development of long- and short-term requirements for database administration and design.
- Participate in your change control process for all planned application and technical activities.
- Work with report writers to provide data needed for reports.
- Take on full roadmap items, work with other functional teams, and be able to deliver high quality results on time.
- Investigate and find the root cause for software problems reported by stakeholders.
- Direct organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, updates to existing queries.
- May perform database administration and maintenance, including database installation and configuration, backups, upgrades, patching.
- Review SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance.
- Evaluate performance of stored procedures and find time/resource consuming areas and give inputs to application developers to fix them.
- Create deployment and rollback scripts for all database objects manually or auto generated.
- Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.
- Proactively identifies technical opportunities and enhancements while addressing major incidents in a timely manner.
- Manages and ensures the integrity, security, and retention of data.
- Administers and maintains end user accounts, permissions, and access rights.
- Participate in an on-call rotation providing 24-hour, 7-day support, and off-hours maintenance windows.
Apply Here