Passionate Database Engineer with 2.5+ years of experience, seeking to leverage proven Oracle, Ms SQL and Oracle PL/SQL skills to grow efficiency both technically focused and customer oriented. Hardworking and committed to meeting corporate objectives.
Having 2.5+ years of experience in Application Software development using Oracle 9i/10g.
Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
Strong understanding of business processes with good experience in development.
Used Dialogue-mapping to gather requirements to customer satisfaction.
Used Oracle data modeling to boost productivity and production costs.
Quick-learner and self-directed.
Good experience of coordinating with various teams like Deployment, Testing Team to speed up development process.
Currently working as a Senior Systems Engineer in Infosys Limited, Bangalore from May 2016 to till date.
Oracle Database Management 12c
Microsoft Sequel Server 2012 (Ms SQL)
UNIX Shell Scripting
Relational Database Management System (RDBMS)
12/2017 to Till Senior Systems Engineer
Infosys Pvt. Ltd – Bangalore, Karnataka
Oracle, Ms SQL, Oracle PL/SQL
Convert the Business need in to Technical complex queries.
Designing databases and ensuring their stability, reliability, and performance, Monitor system performance and ensure system availability and reliability.
Experience in data migration/conversation using SQL*Loader.
Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules
Expertise in writing procedures, functions, views, materialized views as required
Experience in Data migration using import and export.
Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
Responsible for performance tuning activities in the project.
12/2016 to 11/2017 Systems Engineer
Infosys Pvt. Ltd – Hyderabad, Karnataka
Requirement gathering from the Business Team.
Convert the functional requirements into technical document as per the business standards.
Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
Worked as per the CR Raised from the end user.
Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.
Perform DML, DDL Operations as per the Business requirement.
Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
Involved in peer-to-peer code reviews.
05/2016 to 11/2016 System Engineer Trainee
Infosys Pvt. Ltd – Mysore, Karnataka
Acquired all my skills in the IT field at Infosys during that period.
Trained in the field of Python basics, RDBMS, Oracle PL/SQL, Oracle 12c/11g, MS-SQL, UNIX Shell Scripting.
Duration of Program
Sri Krishna College of Engineering and Technology, Coimbatore
2012 – 2016