The purpose of this job is to provide all aspects of database administration and technical guidance and support to junior (L1) database administrators (when applicable); vulnerability remediation would be the primary task. This position will also handle escalated incidents and perform root cause analysis of any problems that may arise out of IRs and proactive needs for business. The main responsibilities include vulnerability remediation which would be the primary task.
Responsibilities
- Should work on configuration, implementation, support of Sybase Database Production servers, and technical guidance of junior team members.
- Understand business requirements and design solutions accordingly.
- Ensure quality standards in release implementation, especially in DML/DCL/DDL & Data Fixes of any form.
- Resolve incidents, and escalate to Client management and Sybase Vendor as necessary.
- Create SOPs
- Perform root cause analysis for P1/P2/P3 and P4 incidents and/or proactively based on business needs.
- Work with the Genpact, or 3rd party teams for the implementation of changes
- Follow the required policies and procedures for the incident, problem and change management.
- Ensure service performance expectations are met with service levels and quality.
- Raise/escalate any service-related issues and risks to track lead and/or ITS lead.
- Technical guidance of junior team members (when applicable)
Required Skills
- Knowledgeable about Oracle; Sybase and SQL Database architecture
- Hands-on experience with installation, configuration, and disaster recovery procedures
- Worked on multiple Database releases.
- Perform DB installs and refreshes.
- Knowledge of shell scripts
- UNIX – Solaris/Linux – all current releases
- Database user creation
- Hands-on with backup recovery
- Adding of datafiles and space management
- Well-versed in indexing and Reorganization of database objects
- Change management and apply data fixes.
- Well-versed in audit concepts
- Analysis and implementation of CPU patching on the production system independently
- Understanding of database concept as an SME and ability to provide solutions.
- Good Understanding of Patch concepts
- Well-versed in the performance & tuning of database
- Experience of database upgrades
- Good understanding of reports
- Sound experience of Database export/import functions
- Experience in database character set conversion
- Knowledge of Database monitoring tools
- Capital Markets Domain knowledge is preferred.
- Knowledge of Information Technology Infrastructure Library (ITIL), integration across Incident, Problem & Change (IPC) Management.
Minimum Qualifications
- Graduate or postgraduate in Technology with Computers or IT stream
- Graduate or postgraduate in any stream with a course in Computers or IT stream
- Four to five years (4-5) of relevant experience.