This role will participate in technical discussions to share ideas and provide feedback in continuing the improvement of the Service Build Engineering team in areas such as Optimization, automation, cost savings, technology adoption & operational efficiency.
Responsibilities
§ Oracle/SQL/ MariaDB Database software installation, upgrades and maintenance
§ Resolve build issues with database or related third party products
§ Take initiatives to enhance current workflow and process
§ Maintain database security & compliance and ensure Database is Hardened
§ Manage project timeline and issue remediation efforts
§ Take care of DB Performance Tuning, Query Optimization during build phase
§ Monitor and troubleshoot Oracle & SQL Server related CPU, memory, I/O, disk space and other resource contention.
§ Strong experience of backups, restores, recovery models, database shrink operations, DBCC commands
§ Handle project queries promptly, meet deadlines and co-ordinate with multiple infra teams effectively
Should be willing to take up any role in the team when need comes without any
Requirements
§ Min. 5 years of experience in installation and setup from scratch of various versions of Oracle Database & Microsoft SQL Server is a MUST.
§ Strong understanding of Database architecture
§ Proven skills and experience in setting up HA/DR solution for Oracle (RAC, DG & ADG) and SQL Server (Always ON)
§ Knowledge in Operating Systems like windows and Unix
§ Experience in raising Technical SR with Oracle/ Microsoft in case of any issues/bug fixes
§ Strong Experience of RMAN, expdp/impdp
§ Experience in evaluating and installing new software releases and patches
§ Experience in developing and executing database security policies, procedures
§ Must take initiatives to automate manual Database work
§ Able to document all the process and checklists clearly and keep them up to date
§ Proven skills and experience in managing complex problem solving and incident management related to Oracle DB and Microsoft SQL Server
§ Ability to work in a team
§ Excellent communication and mail writing skills