Database/Database Administrator/IT Infrastructure Delivery

Job description

Primary responsibility is to provide support on the database technology, ensuring customer delight as per the defined size, effort and schedule confirming to quality standards and best practices. Maintain and improve SLA's and ensure compliance to HSBC policies at all times. Actively participate to achieve organization objectives for efficiency.

Perform pro-active analysis on day-to-day work to obtain automation on deliveries thereby reducing repetitive and standardized tasks/processes.

Principal Accountabilities: Key activities and decision making areas

Typical Targets and Measures

Impact on Business/ Function

Financial
· Participate in process improvements and cost efficiency initiatives
· Ensure leave planning is done as per HR policies and any anomalies reported well in advance
· Ensure booking Clarity timesheets regularly as defined for the project

Non-Financial


· Provide the technical support within the agreed Service Levels
· Meet the delivery standards as per the agreement that includes quality
of deliverables, documentation
· Status communication and timely reporting
· Interact with application teams and other infrastructure teams
· Maintain support records such as incident resolutions
· Brainstorm with team leaders and peers on emerging technology
· trends, constantly question, clarify from teams and ensure that critical
· technology issues are surfaced and considered
· Act as a buddy to the new joiners and junior colleagues to help them
settle and take up work in the project

Weightage – 20%

Weightage – 20%

Customers / Stakeholders

· Actively participate towards ITO strategic initiative to Run ITO as a
Globally Managed Function
· Understanding of functional requirements and translation of business
Requirements into technical specifications.
· Proactively identify problem situations and resolve to give maximum
Customer satisfaction.
· Escalation used only where necessary, appropriate measures are taken to
Improve and sustain high quality and prevent recurrence.
· Demonstrate analytical and problem management skills
· Solve problems laterally with in-time information to line manager.

Weightage – 20%

Operational Effectiveness & Control
· Adhere to process reviews by HSM/Group
· Suggest process enhancement
· Ensure the project documentation is up to date
· Ensure strict adherence HSBC Group Compliance Policies.

Weightage – 10%

Technology

Database Production support for DB2 ZOS technology.
· Production support of database environments
· Release Management of database environments
· Providing consulting on database Performance Monitoring, Tuning & Optimization
· Infrastructure support for database environments
· Metrics collection and analysis
· Define the physical database Design
· Data conversion/migration assistance
· Facilitation, planning, and coordination with the development teams
· Build, review, QA, implement, and support application database
releases
· Implement RACF/ACF2 DB2 security rules and Access authority
· Assist in Creating stored procedures/triggers and support development
teams to incorporate the business requirements/rules
· Participate in technical initiatives
· Support in data Centre migrations
· Participate in ever-greening database environments
· Interact with application teams and other infrastructure teams
· Build and maintain High Availability setup, replication setups

Weightage – 30%

Major Challenges (The challenges inherent in the role that require a continual test of the role holder's abilities)

Being global team ensure best practices are used to support the diverse customer group. Have thorough understanding of the environments to provide best service quality. Should have very good hands-on experience in the underlying technology/infrastructure. Work closely with the stakeholders to avail/impart all necessary training from time to time to ensure enhanced service delivery.

Role Context (The environment and operating conditions of the role including the extent of guidance and authority)

HTS – GLT is the off shoring arm of the HSBC Group. It is fully owned subsidiary of the HSBC Group with resources dedicated to the development of software solutions for the HSBC Group. It has presence in 4 locations spread across the Globe, in Pune and Hyderabad in India, Guangzhou in China, and Curitiba in Brazil and Kuala Lampur in Malayasia. There is a possibility of setting up similar structures in other low cost locations, depending of demand. The business model of HTS - GLT is that of a dedicated captive software arm. It services IT which in turn services the business needs of the HSBC Group. With over 9400 resources spread across multiple locations, it has a top-down view of the HSBC Group's Software Footprint. The services it offers are Software Engineering, Engineering Analysis and Design, IT Operations, IT Security, Business Analysis, Test Execution and Analysis. The HSBC Group has embarked on a strategy of moving to common systems and processes globally, to further leverage it's global reach, and to reduce IT and Operating costs and maximise shareholder return. HTS – GLT has traditionally been at the heart of development and support of HSBC systems and is now called upon to leverage its engineering talent in the engineering of new systems, re-engineering of legacy applications and the deployment thereof.

The job holder is responsible for Technical Ownership of Engineering & Support of core products for Database and BI. The responsibilities entail areas such as execution of projects and support services providing technical support, creating knowledge base, and producing relevant data for trending & analysis purpose. Specialists are also primarily responsible to drive process improvements & standardization in the respective areas to ensure improved quality and efficient services. The specialists are required to support to Management in delivery planning by technical & process related inputs for schedules, effort estimation and risk analysis and in identifying emerging technology trends.

Management & Leadership of Regulatory, Compliance & Operational Risk (Operational Risk / FIM requirements)

Demonstrate leadership on Regulatory & Compliance matters. Maintain awareness of operational risk and minimize the likelihood of it occurring including its identification, assessment, mitigation and control, loss identification and reporting in accordance with section B.1.2 of the Group Operations FIM.

Observation of Internal Controls (Compliance Policy / FIM requirements)

Maintain and observe HSBC internal control standards, implement and observe Group Compliance Policy, including the timely implementation of recommendations made by internal/external auditors and external regulators. Foster a compliance culture and implement Group Compliance Policy by managing compliance risk in liaison with the Head of Group Compliance, Regional Compliance Officer, Area Compliance Officer or Local Compliance Officer, ensuring adequate compliance resources are in place and training is provided, and optimising relations with regulators

Role Dimensions (e.g. balance sheet size, lending/expenditure limits, size/volume of transactions, budget. in USD'000 )

· This role does not have any financial responsibilities (budget/expenditure limits, etc.)

Headcount reporting to this role
(All staff in the dept/section, including direct & indirect subordinates. Do not include dotted/functional reportees headcount here.)

Direct:

Nil

Indirect:

Nil

Total:

Nil

Dotted/functional reportees to this role, if any (state title of the job) :

Nil

Knowledge & Experience / Qualifications ( For the role – not the role holder. Minimum requirements of the role.)

A. Secondary School B. University (BA) or (BS) C. Post Graduate (Masters)

A. Two years or less B. Two to five years C. Five to ten years D. Over ten years

Bachelor's degree in Computer Science, Management Information Systems, Engineering, related technical field or equivalent experience.
· 4+ years of experience in DB2 ZOS administration
· Good knowledge of DB2 ZOS concepts
· Good working knowledge of Mainframes platforms
· Knowledge of JCL and REXX is desirable
· Strong technical knowledge in DB2 ZOS Administration
· Experience in Performance tuning
· Communication and interpersonal skills
· Working across cultures

Hour of work / Shifts

· 9 hour shifts with 30 minute lunch / dinner break
· This role involves working in a rotating shift pattern
· Shift timings are as below (might change in future depending on business need)
· Morning Shift : 06:30am-15:30pm IST
· Evening Shift : 13:30pm-22:30pm IST
· Night Shift : 22:00pm-07:00am IST
· Support is required 24 hrs x 7 days in week x 365 days from office or on-call depending on business needs.
· Resource will get compensatory off for holiday as per HR guidelines
· Required to work on weekends also. Resource will get compensatory off for as per HR guidelines

Desired profile

Qualifications :

na