| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Oracle Database DeveloperContact Number: PHONE NUMBER AVAILABLEEMAIL AVAILABLEQualification Summary:Senior Database Developer /Lead Professional having over 12+ years of experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications.Extensive experience in Database development, Datawarehouse Architecture, ETL/Datawarehoursing technologies extensively worked in Production, Test & development databases.Code Development and Production support for different applications.Extensive experience with SQL Server and T-SQL in constructing triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries.Database Development: Deep understanding and proficiency in Oracle 12c PL/SQL programming language, including stored procedures, functions, triggers, and packages. Focus on writing efficient, optimized, and maintainable code.Database Design and Modeling: Expertise in designing and modeling Oracle databases, including creating tables, indexes, and constraints. Knowledge of normalization techniques and data modeling concepts to ensure data integrity and optimal performance.Performance Tuning: Ability to identify and resolve performance bottlenecks in Oracle databases by analyzing query execution plans, optimizing SQL statements, indexing strategies, and utilizing performance tuning tools such as SQL Tuning Advisor and AWR reports.Requirement gathering and Maintenance.Performed Query Optimization using SQL Trace, SQL Server Profiler, and SQL Server Extended EventsInvolved in all phases of the SDLC (Software Development Life Cycle) from requirements gathering, design/analysis, technical specifications, code, implementation, and support with timely delivery against aggressive deadlines.Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.Experience with Data flow diagrams, Data dictionaries, Database normalization theory techniques, Entity relation modeling, and design techniques. Expertise in Client-Server application developmentDeveloping and executing database queries to generate reports and aid in data analysis.Learning different technologies.Develop test scenarios, test plans, and SQL scripts for data validation.Expertise in Client-Server application development using Oracle 12c, PL-SQL, Oracle Forms10g, SQL Developer, TOAD, and SQL*LOADER,SSRS,SSIS.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.Created Tables, Views, Constraints, Indexes.Experience in using Jira system for resolving different issues.Developed materialized views for data replication in distributed environments.Loaded Data into Oracle Tables using SQL Loader.Used GIT,GITHUB for version controlling in code changes as part of change requests.Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.Worked extensively on Ref Cursor, External Tables and Collections.Expertise in Dynamic SQL, Collections and Exception handling.Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.Experience in SQL performance tuning using Cost-Based Optimization, Profiler, Explain-plan and has sufficient knowledge on AWRPerformed Query Optimization using SQL Trace, SQL Server Profiler, and SQL Server Extended EventsDevelop SQL queries and stored procedures to migrate data through ingestion, aggregation, and presentation layers.Using ETL techniques data extracted from source sytems to destination systems.Organised raw data into structured data by using ETL data transferred manner .Highly organized with analytical and reasoning skills to troubleshoot and solve problemsCreated Shell Scripts for invoking SQL scripts and scheduled them using crontab.Experience of working in Telecome, Insurance Life Science, Health care Domain.Experience of working in onshore- offshore model for many projects.Experience of leading a team of five members, assigning work, status report, mentoring and evaluation.Using Incident Management techniques for tracking any issue, resolving issue, updating tickets and closing them.Participate in the delivery of changes within an Agile development environment in collaboration with Developers, Testers and Users.Streamlined the communication process to avoid the hiccups in project with prioritization of important aspects as per customer acceptance.Technical skills:Operating Systems : Unix, WindowsProgramming Languages : SQL, PL/SQL,JIRA,GIT,SSRS,SSISDatabases : Oracle 12c, Oracle, MS SQL ServerEducation:Bachelor of Science from Nagarjun University, Hyderabad in 2007MCA from JNTU,India in 2010Professional Experience:Client : Honeywell Feb 2023 Till DateRole: Sr. Oracle Databae Developer,MS SQL DeveloperGather requirements for change requests with the Business team and create design documents.Provide User Access to Business End Users to the Front-end tools after getting the required approvals.Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries, and SQL Statements with Analytical Functions.Performed SQL and tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.Extensively used Oracle Hints to direct the optimizer to choose an optimum query Execution Plan.Handled errors using Exception Handling extensively for debugging and maintainability.Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment.Responsible for writing Unix Shell scripts for loading data using SQL*Loader. The Control Files for the tables were created and automated through UNIX shell scripts to perform data load into Oraclables. Used SQL Loader and SQL scripts to load data into the system application.Performed Data Cleansing to weed out erroneous Orders from the DWH tables.Create Procedures and Functions in SQL Server to migrate data from Legacy servers to Oracle Datawarehouse tables.Experience with GIT,GitHub in version control system used for tracking the changes in application requirements in coding.Experience on working with XML,JSON,PYTHON technologies.Create Informatica workflows (7.0 for Flat Roll/9.0 for Tubular implementations) for implementing business logic.Worked on Sessions & workflows for variety of loads starting from Source to Target.Developed the Informatica Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router Transformation.Developed reusable Workflows, Worklets, Mappings and Mapplets using transformations including Router, Aggregator, Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union.Experience in handling Jiras with different issues.Create Shell scripts for automating the business logic.Develop test scenarios, test plans, and SQL scripts for data validation.Worked on AWR reports to analyse the queries.Create ABPP (Agile Business Process Platform) workflows which sequences the execution of MS Packages, Informatica workflows, Shell scripts as per the business logic.Deploy the code across the environments to main code consistency and update the same in Clear Case for version control.Create Test Cases for verification and validation of the Change Requests.Environment: Oracle 10g / 11g/12c, SQL, Oracle 19c, PL/SQL, SQL*PLUS, MS SQL, SQL*Loader, GIT,GitHub,TOAD, UNIX, Shell scripting,Jira.Client : Kaiser, Jan 2020 Sept 2022Role : Database DeveloperResponsibilities:Performed senior-level responsibilities for the overall database architecture, design, installation, configuration, technical support, and maintenance of the Oracle 12c databases.Assisted in the definition of database requirements, analyzed existing data models and reports.Understand the business requirement and involving the Analysis, Design, Development, and Testing phases.Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.Used CRON JOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.Experience on working with XML,JSON,PYTHON technologies.Worked on AWR reports to analyse the queries.Develop SQL queries and stored procedures to migrate data through ingestion, aggregation, and presentation layers.Experience with GIT,GitHub in version control system used for tracking the changes in application requirements in coding.Write complex SQL queries with sub-queries, analytical functions, and inline viewsPerformance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.Writing Unix scripts to purging the files older than 90days, and connect to MS SQL database and execute the queries to generate reports.Experience in handling Jiras with different issues.Preparing documentation for new requirement to get UAT approvals.Implementation of MBE claims process.Analyzed and developed the code related to region variation of the CORE membership systemsOperational support systems.Environment: Oracle 19c,MS SQL, Exadata, Autosys,SSRS, Windows 10,Jira,GIT,XML,PYTHON,JSON.Client : Humana Aug 2018 Dec 2019Role: PLSQL DeveloperResponsibilities:Performed senior-level responsibilities for the overall database architecture, design, installation, configuration, technical support, and maintenance of the Oracle databases.Designed data mapping document, which is a guideline to ETL Coding.Created Schedule jobs on Autosys tool.Worked with Business team for changing requirement on business requirement and its subject areas, updated data model, extracted DDLs from the data model and did the development work.Worked with features like change data capture, policy-based management, data compression, Implementation of Starmount claim intake process.Troubleshooted issues with MongoDB databases and applications, including diagnosing performance issues and resolving errors and conflicts.Develop SQL queries and stored procedures to migrate data through ingestion, aggregation, and presentation layers.Design and develop Oracle database applications using SQL language.Authorized the data coming from dental and vision claims scanned through tool(ABBY) .Worked on AWR reports for tining the application.Implemented different claims like Paper, electronic and email claims.Implemented automation process like Database audit track.Conducting awareness sessions to customer teams whenever any Process module was deployed.Environment: Oracle 12c, ETL/ Informatica,Windows 10,PYTHON.Client : Tata Docomo Sep 2015 Aug 2017Role : Module LeadResponsibilities:Implementation of ITIL process (Operational Dashboard, EventManagement) in TTL account.Handled the Team of 5 members.Managed end to end Delivery and Operations support issues.Worked in Agile methodology to migrate into modern technology for Application re-architecture projects.Responsible for design and development, testing and implementation of database objects.Automated few jobs which reduced manual effort and improved quality of work.Used CRON JOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.Develop SQL queries and stored procedures to migrate data through ingestion, aggregation, and presentation layers.Wrote complex SQL queries with sub-queries, analytical functions, and inline viewsParticipated / Assisted in Integration Testing and UAT in the Signoff and Handover process.Performed Query Optimization using SQL Trace, SQL Server Profiler, and SQL Server Extended EventsWorking in Agile methodology to migrate into modern technology for Application re-architecture projects.As a team member, was responsible for Analysis of the specifications provided by the client.Responsible for Coding/Changing numerous packages, procedures and functions.Coordinated with various teams and raising support ticket for all issues, analyzing root cause and assisting in efficient resolution of all production processes.Automated few jobs which reduced manual effort and improved quality of work.Develop test scenarios, test plans, and SQL scripts for data validation.Develop SQL queries and stored procedures to migrate data through ingestion, aggregation, and presentation layers.Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.Developed the module operational dashboard, by using ETL extracted data from different source systems and load the data into destination systems.Wrote complex SQL queries with sub-queries, analytical functions, and inline viewsPerformance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.Environment: Oracle 12c, Autosys, Jira,Windows 10,GIT.Client : Tata Docomo Aug 2011 Sept 2015Role : Oracle Database DeveloperResponsibilities:Handled the BRs successfully.Streamlined the Incident management reports (SLA calculations).Converted the huge queries into dynamic functionsPerformed day to day activities within the time lines.Analyze project or Business Requirement Documents (BRDs)Working in Client Place for more than 1 Year to fix the live issues and requirement gathering.Customizing and developing the Oracle Forms as per client requirement.Customizing and developing the Oracle Reports as per client requirement.Involved in premia product Instance level setups.Developed procedures, functions, packages and triggers.Worked on Performance tuning using Oracle Enterprise Manager.Worked on writing unit test cases and testing the application. |
