PROFESSIONAL SUMMARY:

• IT Experience of 8 Years, seeking an assignment as a Database Developer
• Over 8+ Years of extensive experience in data architecture, data management, data visualization, Data Integration, team management and vendor management using RDMS databases Oracle, PostgreSQL in UNIX / Linux and Window platforms / environments spanning domains like Retail,Document Management,Content Management, and Infrastructure.
• Knowledge of Information lifecycle management and experience working/managing large size datasets.
• Involved in all phases of SDLC from analysis, design, development and integration. Advance knowledge of Oracle SQL, PL/SQL.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience on object - orientedprogramming and concept in oracle.
• Experienced in creating application logical architecture models and documenting the current state architecture for 24X7 business applications.
• Excellent technical and analytical skills with clear understanding of design of ER modeling for OLTP and dimension modeling for OLAP.
• Good knowledge on logical and physical data modeling using normalizing techniques.
• Developed various mappings using Mapping Designer and worked with Aggregator, Filter, Router, joiner, Source Qualifier, Lookup, Expression, Stored Procedure, Sorter and Sequence Generator, Transaction Control, Update Strategy transformations.
• Excellent experience in analysis, developing, bug fixing of Procedure, package, function, trigger and PLSQL Objects and Oracle advance concepts collections Records, nested tablesand Varray.
• Excellent experience on large objects like CLOB andOracle Text search.
• Experienced in phased, Agile/Scrum development methodology, handling multiple projects at any given time.
• Experienced in end to end data flow in an enterprise environment, data movement/transformation / integration, Metadata, data management, Master data Management and information assurance/security.
• Sequence Diagrams, Data Flow Diagrams (DFD), EIE / UML Modeling and Enterprise Application Integrationtechnologies.
• Created Shell Scripts for invoking SQL scripts and scheduled them using CRONTAB.
• Setup of new databases in RDS and Azure.
• Experience in Experience Cloud Database RDS PostgreSQL.
• Proficient knowledge of Unix/Linux/Windows operating system platforms for Oracle.
• Familiar with NoSQL database Mongo DB.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Retail, Document Management, Content Management, and Infrastructure.

PROFICIENCY:

OracleSQL,PL/SQL,Performance Tuning, Development DBA, ETL, Shell Scripting, Batch Scripting, PowerShell Scripting

TECHNICAL SKILLS:

Primary Skills: Oracle SQL, PL/SQL, Performance Tuning, ETL, MDM, Development/Application DBA

Secondary Skills: Shell Scripting, Windows Batch Scripting, PowerShell Scripting, Core Java, JSP, HTML, XML, XSD, JSON.

RDBMS: Oracle 8i / 9i / 10g / 11g / 12c /18c,Oracle (AWS),Oracle Exadata X5,X7, SQL Server 2012/2017, Azure SQL,PostgreSQL 9.2/9.6/10 (Azure, AWS Aurora/ RDS, Community Ed, EDB)Tools Used Toad, SQL Developer, ERwin, SQL Data Modeler, PL/SQL Developer, SSH Client, Putty, WinSCP / FTP, CVS, Clearcase, SVN, Git, TFS, VersionOne, Oracle Reports Builder.

Platforms: Linux, Unix, Windows 2016 Data Centre, MS-Windows 2000 / XP / / 7 / 8 /10

Others: HTML, TCP/IP, OSI Layers, LAN Setup & Network Topologies.

PROFESSIONAL EXPERIENCE:

Senior Oracle Developer

Confidential, Washington, DC

Responsibilities:

• All the databases across the enterprise were reverse engineered; data models were created using CA ERwin Data Modeler and associated with the respective application.
• Database module development for JAVA based applications.
• Document management application development using Oracle 12c/18c.
• Modelled, designed and build the contractors timesheet processing for Integration to Mobile approvals.
• Data services feed to Enterprise search on MarkLogic platform.
• Designed and developed the ETL process in Informatica to load data from Composite to Oracle.
• Business process models were created and linked to business applications, database and associated infrastructure etc.
• EA Repository with all the information and its relationship were created part of the project effort.
• All the linking between database-application-business functions- business process was established.
• Analyzing AWR and ADDM reports to determine the root cause for database performance issues.
• Worked on optimization of Oracle Database I/O by focusing into segment tuning and instance parameters tuning in Oracle 11g database
• Mentored development and quality assessment team members on techniques of writing efficient SQL and application tracing.
• Revisited the indexing and partitioning strategy to fine tune the application performance.
• Developed Java code to capture the performance metrics for databases hosted on AWS PDMZ/Non-PDMZ.

Confidential

Team Member

Technology: Oracle Reports 10g, Oracle Database 10g SQL& PL/SQL

Responsibilities:

• Understanding the components and architecture of the existing application.
• Developed and made enhancement in reports.
• Prepared Low-Level Design Documents.
• Involved in Unit testing and Bug fixing.
• Created stored procedures, Functions, packages.
• Maintaining failure/defect log and conducting Root cause Analysis.
• Effectively coordinated with the Onsite Team and client to ensure Quality deliverables.
• Performing Unit Test for the software components before the release.
• Prepared Technical Design and Unit Test Case Documents.