C267
Key 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 hesitation
Key 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
Added Advantage
§ Knowledge and Experience in MariaDB is an added advantage
§ Experience and Knowledge in PowerShell/Shell scripting is a plus
§ Experience and Knowledge in Server Virtualization is a plus
§ Cloud knowledge is preferred
