Isac K Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Pune, Maharashtra, India

Bangalore Urban, Karnataka, India

Working as database Architect & Migration consultant for one of the largest telecom providers of UK. Helping customers to come out of from the Legacy databases and refactoring application to a low cost cloud platforms. Hands on experience in migrating Oracle to PostgreSQL database on AWS and AWS DB Migration Services. Database migration, the process of moving definitions, data, and stored procedures from one platform to another, and making application changes. Moving data involves selecting, preparing, extracting, transforming, and applying that data from one database to another. By moving the onprem databases to cloud helps customers to minimise the operational cost and helps them to shutdown the data centres. Provide feasible solutions for migrating large scale database to AWS on Aurora PostgreSQL database.Advantages of PostgreSQL over Oracle as a database system and the benefits of adopting PostgreSQL, namely cost, flexibility, and customizability. It then breaks the migration process down into individual phases such as Assessment, Schema migration, Functional testing, Performance testing, and Data migration and provides step-by-step instruction on each one. Key differences and incompatibilities between the two database systems are itemized, to help customers avoid common mistakes.

Whitefield, Banglore

Worked as database development & administration for one of the Insurance giants in UK. My key responsibilities are, Design, develop and implement database systems based on customer requirements.Optimize database systems for performance efficiency.Prepare design specifications and functional documentations for assigned database projects.Perform space management and capacity planning for database systems.Develop database tables and dictionaries.Ensure data quality and integrity in databases. Identify any issues related to database performance and provide corrective measures.Create complex functions, scripts, stored procedures and triggers to support application development. Participate in database design and architecture to support application development projects. Perform data back-up and archival on regular basis.Test databases and perform bug fixes.Troubleshoot database related issues in a timely fashion. Develop security procedures to protect databases from unauthorized usage. Evaluate existing database and recommend improvements for performance efficiency. Develop best practices for database design and development activities.As a DBA, I was responsible for Software installation and Maintenance, Data Extraction, Transformation, and Loading,Specialised Data Handling, Database Backup, Recovery and Replications, DB performance monitoring, database tuning, database security and authentication.

Bangaluru

dWise solution was a product based start up, based out of Banglore, majorly building Electronic Health Records (EHR) solution for everything a hospital needs. Such as Out-patient management (OP), In-patient management (IP), ER/Daycare, operations, Finance, MIS-Reports, dashboard and analytics, and so on.I had played a key role in developing an EHR application from the scratch using postgreSQL database and PHP with Symfony2 framework, creating RESTful web services using the database functionalities and providing JSON result to UI. My roles include design database objects based on requirements. Mainly involved in the development of MIS-Reports, Out Patients (op), Pharmacy and inventory (ledgers) modules. Developed chat module using XMPP - Ejabird. Build automated email for stakeholders for daily, weekly, monthly, half yearly & yearly revenue reports using SMTP and RabbitMQ. Implementation of HAProxy to improve the performance and reliability of a server environment by distributing the workload across multiple servers (e.g. web, application, database). Developed business intelligence reports on Kibana with elastic search and logstash and hands on experience in building and integrating APIs (payment gateways)