Overall Responsibilities : Assists and participate for bank all database.


Key Areas of Accountability:

• Participate in daily Database server health check
• Installs Service Packs and Security updates for SQL Servers
• Implements, monitors and reports on SQL Server Backup and Restore procedures
• Responds to and resolves database access and performance issues in a timely manner.
• Reviews database objects, including views, triggers, stored procedures and execution time, and suggests efficiency improvements.
• Monitors, optimizes and allocates physical data storage for database systems.

Skills and Competencies Requirements:

• Knowledge on Oracle middleware service bus, web logic server
• Knowledge on JSON/XML/ISO8583 message formats
• Ability to read, write, and understand complex SQL queries and to utilize other SQL artifacts (such as Stored Procedures and Views); Performance tuning skills (SQL Query tuning) are a plus
• Proficiency in Microsoft Office product suite
• Experience with data transformation and ETL
• Excellent written and oral communications skills, and willingness to document departmental standards and procedures
• Ability to work independently as well as in a cross-functional team environment by collaborating with others and sharing tools, skills, and knowledge
• Minimum diploma in IT, Computer Science or equivalent
• 2+ year working technical experience with designing, building, installing, configuring and supporting Oracle Middleware service bus servers and web logic servers
• Experience in creating supporting tickets to Oracle support

Experiences and Educational Requirements:

• Minimum diploma in IT, Computer Science or equivalent
• 1+ year working technical experience with designing, building, installing, configuring and supporting Microsoft SQL Server and Oracle database servers.
• experience in creating SQL statements, triggers, and procedures with relational databases (MS SQL Server or Oracle)
• Experience in setting up RDBMS and tuning up skill. Crystal report server setting up and SAP BI report developing skill