Our client, a leading company in the fintech industry is looking for an experienced individual for the role of a SENIOR DATABASE ADMINISTRATOR to support the company’s operations.

ROLE PROFILE

The successful candidate will provide enterprise-wide Oracle Database infrastructure support for complex systems and interconnected technologies that require day-to-day support and administration in order to maintain optimum performance and utilization of the firm throughout the year. He or she will provide support in the following areas: Oracle Database 12c & 19c on Oracle Solaris 10, 11 and Linux platform

He or she would undertake the following duties as well:

DUTIES/ RESPONSIBILITIES

• Manage acceptable level of performance of all DBs(Database Systems) across the organisation
• Proactively support systems, and analyze existing/potential issues that happened with a deep dive into RDBMS (Relational Database Management System) and/or related SW (Solid works) (GI, ASM, os)
• Understand the layer b/w rdbms/asm (Application Service Management) and storage/os (operating system) in order to be able to identify layers of performance glitches or small degradation
• Automation of BAU DBA tasks with sh (Segment Header) /bash scripting
• Understanding core concepts of Oracle optimizer, statistics, and tracing related to performance
• PL(Product Line) SQL (Structured Query Language) coding ability for admin purposes, able to read/understand the code written by others
• Mw (Megawatt) (oracle forms and reports) knowledge above basic
• Understand oracle net / OCI (Oracle Cloud Infrastructure) / JBDC (Java Database Connectivity) related issues troubleshooting

 SYSTEMS AVAILABILITY

• Ensure that the availability of services exceeds the defined service levels.
• Maintain Database environment during business hours and off-hours
• Install, configure and maintain a highly optimized Database environment with Oracle RAC (Real Application Cluster) /CDB (Central Database)

TESTING PROPOSED CHANGES BY DEVELOPERS / VENDORS OF APPLICATION  

• Collaboration with dev/app support/vendor regarding the changes at DB layer/code which impact RDBMS layer
• Analyze current DB proactively in order to avoid performance degradation/breach of SLA (Service Level Agreement) for processes using RDBMS
• Reactively included into R&D if required (related to DB area)

CHANGES IN PRODUCTION

• Raise changes and follow the business processes for delivering those in prod systems
• Ensure inventory with configuration across the organization are up to date and all changes done reflected there without exclusions
• For internal changes collaborate with other involved teams, and make changes to existing business processes for its optimization if required

INCIDENTS / PLANNED/UNPLANNED DR SCENARIOS

• Involved in technical discussions with vendors/developers/app support
• Periodically do/plan DR activity for core PROD systems, automate such BAU activities
• Provide support for critical incidents in PROD systems during non-office hours in case of service breaches for external clients

 EDUCATION AND EXPERIENCE

• Bachelor’s Degree in computer science or relevant subject in technology or degree in Engineering.
• At least 4 years of experience in a Technology / IT function in a recognized international organization.

 REQUIREMENTS

• Should have experience in the financial services industry.
• Excellent knowledge of Solaris technology, designing and database availability, preferably multiple platforms.
• Working knowledge of defining operational processes and procedures
• Must be able to skilfully prioritize and manage concurrent projects and issuescases.
• Should have excellent written and verbal communication, analytical and problem-solving skills

To apply kindly send your CV to: sda.pjkt@gmail.com