+1 (415) 644 5123
+44 1253 335595
+91 9875 492266
B prit
Bengaluru
,
India
Oracle SQL/PLSQL experience with knowledge in Hadoop/Hive
21428.5 USD / Year
-
Notice Period: Days
7 Years
About Me
- Around 6.11 Years of experience in PL/SQL ProductionSupport and Development of web-based applications using Oracle 10g / 11g
- Good experience in writing co...
- Good experience in writing complex SQL queries, PL/SQL stored procedures, functions, packages, cursors, views and triggers
- Knowledge in writing codes for Performance Tuning
- Good work experience in tools like Control-M, Autosys, Aqua Data Studio, SQL Server Management Tool, TOAD, SQL Developer, MITTS, BMC Remedy, Putty, WinSCP
- Extensive experience in Production Support Environment
- Proactively and Independently working on resolving issues
- Providing support to clients on 24/7 basis
- Proactively resolving batch job failures
- Possessing good project team work, communication and interpersonal skills
- Holding Business (B1) Visa
Skills
Positions
Portfolio Projects
Description
- Worked on Oracle Tables, Views, Constraints, Synonym, Sequence, Procedures, Functions, Packages, Cursors and Performance Tuning
- Providing Support in L2 & L3 levels
- To meet Client's SLA depending on priority of issues
- Monitoring loading of feeds and matching logs till completion of breaksheets
- Responsible for Holiday Processing of feeds and swifts on any region holiday
- Investigating true/false breaks participating in breaksheet(s)
- Monitoring Control - M jobs, SRS tickets & Job and System Alerts
- Providing permanent or temporary fixes for job failures
- Providing support on 24/7 basis
- Responsible for working on SRS tickets and completing it on SLAs defined
- Performing testing of new feed-breaksheet mapping and prepare test cases
Description
- Worked on Oracle Tables, Views, Constraints, Synonym, Sequence, Procedures, Functions, Packages, Cursors and Performance Tuning
- Worked on Hive queries and transferring files using Sqoop
- Providing Support in L2 & L3 levels
- To meet Client's SLA depending on priority of issues
- Responsible for scheduling jobs and monitoring the log files
- Monitoring Control - M jobs, Jira tickets and Job Alerts
- Providing permanent or temporary fixes for job failures
- Writing batch scripts for generating reports and sending to end users through jobs
- Providing support on 24/7 basis
- Responsible for working on Jira tickets and completing it on SLAs defined
- Implementing ITSM for Production Code fixes and Control - M deployment
- Performing Unit Testing and preparing documents for the same
- Syncing the lower environments with the current Production scripts
- Responsible for completing EOM activities spanning from BD-2 to BD+8
Description
- Worked on Oracle Tables, Views, Constraints, Synonym, Sequence, Procedures, Functions, Packages, Cursors and Performance Tuning
- Providing Support in L1& L2 levels
- To meet Client's SLA depending on priority of issues
- Responsible for scheduling jobs and monitoring the log files
- Monitoring Control - M jobs, MITTS tickets and Job Alerts
- Providing permanent or temporary fixes for job failures
- Writing batch files for transfer of files through jobs
- Providing support to clients on 24/7 basis
- Providing On-Call support in Weekends
- Performing Unit Testing and preparing documents for the same
- Refreshing the test environment with the current Production data
Verifications
-
Profile Verified
-
Phone Verified
Preferred Language
-
English - Fluent
-
Hindi - Fluent
Available Timezones
BROWSE SIMILAR DEVELOPER
-
Sriraman C
R&D Centre head, Head - Delivery head , Product management, Agile Specialist, Embedded , CTO
-
Kuljit S
A technology management professional with 38 yrs. of exp.in strategic plng., prog. mgmt., HR, Legal
-
Douglas P
Infrastructure & Sr Systems Engineer, Puppet/Ansible DevOps
-
Michael G
Highly Experienced in Cybersecurity, Information Assurance, Information Technology, Risk Management
-
Deborah H
Senior Program/Project Manager
-
Richard M
Mainframe developer
-
Harry G
Experienced Java Architect and Team Lead with 30+ years experience across a variety of Domains.
-
Gabriel V
Experienced project / program / portfolio manager and IT development / support groups.
-
Terry L
Software Developer with varied languages, specializing in SAS Data Integration Studio
-
Jamie W
Quality Assurance Verification and Validation Leader