Organization: SMC Square
Location: Bangalore
Shift: Rotational shift
Top Skill: Oracle and Qlik
Experience: 8 years and 10 years
Responsibilities:
- This role be working in 3 PM to 12:00 AM IST working hours. The working hours could change in future based on business need.
- Perform standard Oracle or SQL Server database administration tasks, such as database monitoring, installation, configuration and patching, backups and recovery, high availability configuration, database refresh, data replication, code reviews, and SQL tuning.
- Diagnose and resolve database problems.
- Provide support to application developers and collaborate with other teams.
- Participate in project planning and technical design.
- Mentor junior team members on regular basis.
- Participate in Oracle or SQL server 24x7 on-call rotation after 3 months.
- Learn and support MongoDB and QLIK replication within 6 months.
- Participate in MongoDB and QLIK replication on-call rotation 6 months.
Required Knowledge, Skills, Abilities, and Experience
- Undergraduate degree and 8+ years of experience with a relational database platform (Oracle or MS SQL Server).
- Advanced knowledge of relational database management system and principles, and database security.
- Advanced knowledge of Oracle or SQL Server Internals.
- Advanced proficiency with SQL and SQL tuning.
- Advanced experience with standard Oracle or MS SQL Server database administration tasks.
- Solid knowledge of Linux and shell scripting.
- Demonstrate ability to acquire knowledge of new database technologies while on the job.
