C1267
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