Provide a quick, creative biography in 140 characters or less.
More bioHandling the team and taking care of all project deliverable.
o Handling the team of 5 members.
o Designing new processes according to business requirements.
o Development and customization of Database Triggers, Packages, Procedures, Functions.
o Performed Data analysis and validation.
o Management of schemas, objects & partitioning the tables & indexes.
o Integration between different new modules to the exiting project.
o Provided immediate resolution of any technical issues like in reports and interfaces In Production.
o Responsible for reviewing/approving all SQL code before deployment to Production. And also, involved in process design including cost Estimates of project or module.
o Requirement gathering, Analysis, Distribution of work in team.
o Designing new Service Improvement Plan (SIP) to rectify the common known errors and to develop new processes as per the client requirements.
o Managed projects from operations as well as development group based on business needs and priorities.
o Researched and recommended new technologies to achieve improved architectural performance while controlling the costs of IT operations across the enterprise.
o Introduced the Agile programming methodology which resulted in significant cost cutting.
o Developed/Automated process using Unix shell scripting.
o Developing and modifying the Oracle interfaces as per business requirement using PLSQL programming and D2k Forms on UNIX platform.
Performance Tuning of existing process.
• 10 + years of experience in IT Industry with different technologies.
• Currently working with Capgemini India PVT LTD, Bangalore location as a Team lead from July 2015.
• Extensive experience in ORACLE Database, PLSQL, SQL, performance tuning, Stored Procedures, Triggers, Functions, and Packages and involved in Query Optimization
• Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA; proficient in Oracle 8i/9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation.
• Perform ORACLE DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Knowledge of the OracleGoldenGate installation, configuration, troubleshooting GG issues
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Experience in Agile software development Methodology.
• Worked on developing applications using ASP.NET, C#, PLSQL, SQL Server, Web Services (SOAP/REST), XSD, XML, XSLT, HTML, CSS, AJAX, JSON, Java Script, Jenkin, Maven, Ant, MySQL.
• Expertise in using Web Service technologies like SOAP, WSDL, RESTAPI to implement Service Oriented Architecture (SOA).
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De Normalization Concepts.
• Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL.
Level Progress
-
Overall4
-
Query Syntax2
-
SQL2
-
Microsoft SQL Server2
-
Databases1
-
Visual Basic.NET1
-
Microsoft SQL Server 20081
-
Networking Hardware-Other1
-
.NET Programming1
-
Google1
-
Telecommunications1
-
PHP1
-
SAP1
-
Networking1
-
OS Deployment1
-
Windows 101