Database Administrator/it Infrastructure Delivery Job in Hsbc Group

Any Graduate

Role Purpose :(overall high level summary of the role) Primary responsibility is to provide support on the database and BI 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 (Weightage in %) 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 20 Service Delivery - 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 - Work with regions for MIRs and SIPs - Maintain support records such as incident resolutions 30 Leadership - 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 5

Customer service and problem resolution - 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. - Participate in crisis calls as applicable - 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.

15

Operations, Process Improvements and audit controls

- Suggest process enhancement - Adhere to process reviews by HSM/Group - Ensure the project documentation is up to date - Ensure strict adherence HSBC Group Compliance Policies.

10

Technology Database support to OLTP and Data warehousing for technology (Oracle/Sybase & MS SQL/ DB2 LUW/ DB2 zOS/ Cognos /Datastage/ Hyperion/ Business Object/ TM1, Teradata) in different environment (Production/ Application/ Infrastructure).

- Production Support - Production support of database environments - Release Management of database environments - Providing consulting on database Performance Monitoring, Tuning & Optimization - Infrastructure support for database environments - Disaster Consistency support - Metrics collection and analysis - Application Support - Release Management of database environments - Providing consulting on database Performance Monitoring, Tuning & Optimization - Database migrations services (technology migrations) - Create definitions of logical data structures, tables, views, indexes, and program specification blocks and define their relationships

- 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 - Define and Implement security rules and Access authority - Assist in Creating stored procedures/triggers and support development teams to incorporate the business requirements/rules - Infrastructure Support - Infrastructure support for database environments - Release Management of database environments - Providing consulting on database Performance Monitoring, Tuning & Optimization - Participate in POCs and other technical initiatives - Data Centre Migration services - Building and maintaining Disaster Consistency setups - Ever-greening database/BI environments - Implement database/BI audit trail - Interact with application teams and other infrastructure teams - Setup Disaster Recovery systems, configure, and maintain - Build and maintain High Availability setup, replication setups

20

Major Challenges (The challenges inherent in the role that require a continual test of the role holders abilities) - Should have worked on CS Windows technologies in a support capacity - Should have prior knowledge in production/infrastructure support - Should have very good knowledge on the underlying technologies/platforms as applicable - Should have good communication skills

Role Context :(Operational Risk / FIM requirements) 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 maximize 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 to work on activities / tasks within application packaging domain that would result into newer or improved processes, tools, automation & techniques within the team, improve overall turnaround times and quality, bring efficiencies & cost benefits and ensures customer satisfaction. Management & Leadership of Regulatory, Compliance & Operational Risk :(Operational Risk / FIM requirements) 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 or expenditure limits, size/volume of transactions, budget etc.) - 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: InDirect:

Total:

Dotted/functional reportees to this role, if any: Knowledge & Experience / Qualifications (For the role not the role holder. Minimum requirements of the role.) Bachelor-s degree in Computer Science, Management Information Systems, Engineering, related technical field or equivalent experience. 1. 2+ years of experience in IT infrastructure 2. Proven experience in technically guiding teams in productivity driven environment 3. Proven experience in managing and building relationship with business partners and customer service 4. Worked in a infrastructure critical environment and understands how technology adds value to the business and ultimately the end customer 5. Strong technical knowledge in respective technology 6. Communication and interpersonal skills 7. Working across cultures [ ] A. Secondary School [X] B. University (BA) or (BS) [ ] C. Post Graduate (Masters) [ ] A. Two years or less [X] B. Two to five years [ ] C. Five to ten years [ ] D. Over ten years Organizational Chart (Insert or attach the high level organization chart of the department plus the detailed sectional organization chart showing where this job sits in the overall structure, its reporting line, its peers and subordinates, if any, bearing job title and job code.)