SUMMARY

• More than 14 years of experience in Software Development on Oracle database, worked in large projects on different domain.
• Extensive experience of coding PL/SQL stored procedures, functions, triggers and packages using Oracle 12c, Oracle 11g, Oracle 10g & 9i.
• Have effectively handled Oracle DBA activities.
• Very good understanding of data warehouse principles like fact tables, dimension tables, star and snowflake schema modeling.
• Extensively worked on Data Conversion/Migration in various projects to migrate data from different source systems (Flat Files, Ms. Excel, Ms. Access, SQL Server, and Oracle etc) to target Oracle database.
• Good experience and understanding of System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database
• Implemented PL/SQL advanced topics like Bulk Collect, Ref Cursors, Dynamic SQL, Collections, UTL FILE to read and write the flat file.
• Strong knowledge in Exception Handling and also experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, AWR, ADDM, ASH,DBMS PROFILER,Indexing and Hints.
• Good knowledge and hand on experience of Oracle table partition and sub - partition implementation (Range, List and Hash)
• Oracle Ad-hoq search performance.
• Experience in Oracle supplied packages and Dynamic SQL.
• Created Shell scripts for invoking SQL script and scheduled them.
• Experience in data modeling using ERWIN.
• Experience with Data Flow diagram, Data dictionary, normalization and denormalization.
• Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate adhoc reports, Functions and Procedures
• Expertise in Gathering requirements from business users, understanding the Business requirements, product demonstrations and providing product support
• Experienced in data analysis, data modeling, development, testing and documentation of projects
• Support and Maintenance on Crystal Reports, Oracle developer Reports, Power BI and Jasper Reports.
• Effectively handled Analysis of business requirements.
• Worked on data modeling using Oracle Designer 6i.
• Oracle 10g, 11g Installation and configurations on Red hat Enterprise Linux 6.4
• Configuration of Oracle database for email sending.
• Working Knowledge on UNIX, Windows and shell scripting.
• Oracle Backup and recovery using RMAN.
• SQL Server Backup and Recovery models.
• Link Oracle database and SQL Database with heterogeneous databases
• Database Performance monitor using enterprise manager
• Building ADF Business Component
• Development of Oracle ADF 11g Web Application
• Deployment of Oracle ADF 11g Web Application on WebLogic server 10.3
• Oracle Fine Grained Auditing
• Oracle RAC
• Good knowledge and implement experience of Oracle golden gate.
• Implementation of Oracle Physical stand by Databases and Replication.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of them.

TECHNICAL SKILLS

Primary Skills: Oracle 8, Oracle 9i, Oracle 10g, 11g, 12c,PLSQL, SQL Server

Domain: School, College and University Management System, Financial system, Payroll, Inventory Management system, Data Warehouse, ERP Implementation.

Operating Systems: Windows 98,2000,XP, Linux,Windows7, Windows 8, Windows Server 2003 and 2008, Oracle Linux 6.4

Languages: SQL, PL/SQL, VB, JAVA, T-SQL

Databases: Certified Oracle 9i(DBA), Oracle 10g, Oracle 11g, SQL Server, MS Access

Utility: SQL *Loader, External tables

Front End Tools: PLSQL Developer, (Toad 7.1,7.3,9.5), Oracle SQL Developer

Designing Tools: Erwin

Configuration Tools: Visual Source Safe, SVN, GIT

Reporting Tools: Crystal Report, Oracle Developer Report, Power BI, Jasper Reports

Others: Data Conversion/Migration, Data Were housing, SQL Tuning, Physical Standby Database, Stream Replication, Customize Replication

Documentation: Visio Diagram, MS Word and Excel

PROFESSIONAL EXPERIENCE

Confidential

Database Technical lead

Environment: Oracle 11g, Windows, Linux

Responsibilities:

• Verify the structure, accuracy, or quality of FCIP system.
• Coding stored procedures, functions, triggers and packages in Oracle 11g
• Performing tuning of SQL queries and Database procedure
• Database structure design such as table creation, maintaining relation with other table and Index creation
• Deploy code on GIT
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Monitoring and tuning performance using Explain Plan, TkProf, AWR, ADDM, ASH,DBMS PROFILER, Indexing and Hints.
• Data Quality issue and cleansing
• Requirement gathering and Bug fixing using jira and HP ALM.
• Deployment code on various DB in order to synchronization.
• Provide optimal solution to developer queries.
• Implementation of advance performance and tuning techniques.
• Implementation of Physical and logical data model using Erwin.
• ETL Database procedures.
• AD-hoq queries support to java developer team
• Data Extraction from source and mapping to Target DB

Confidential

Sr Database Developer

Environment: SQL server management studio 2014, Windows

Responsibilities:

• Requirement gathering.
• Prepare functional or technical documentation for FDACS.
• Verify the structure, accuracy, or quality of FDACS system.
• Coding stored procedures, functions in SQL server
• Performing tuning of SQL queries and Database procedure
• Database structure design such as table creation, maintaining relation with other table and Index creation
• Deploy code on SVN
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Monitoring and tuning performance
• Data Extraction from source and mapping to Target DB
• Data Quality issue and cleansing
• Load data from source Databases, Text files and Excel to Target Database using Accela Tool
• Mapping of source system to Target Database
• Requirement gathering and Bug fixing using jira.
• Backup and Recovery plan of SQL Server Database.
• DBA Activities such as user creation, Linked Server Restore Database and etc.

Confidential

Software Engineer Contractor

Environment: Oracle 12c, Windows

Responsibilities:

• Review designs, codes, test plans, or documentation to ensure quality.
• Prepare functional or technical documentation for data Jobrow.
• Verify the structure, accuracy, or quality of Jobrow system.
• Coding stored procedures, functions, triggers and packages in PL/SQL
• Performing tuning of SQL queries and PL/SQL code
• Deploy code on SVN
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Monitoring and tuning performance using Explain Plan, TkProf, AWR, ADDM, ASH,DBMS PROFILER, Indexing and Hints.
• Created Shell scripts for invoking SQL script and scheduled them.
• Load Data into Database using SQL Loader and External tables.
• Enhance the performance of ETL process using enable the DML Parallel processing.
• Worked on different types partition and sub-partition(Range and List)

Confidential

Sr. Software Engineer

Environment: Oracle 10g, Windows

Responsibilities:

• Team Lead
• Design and implement warehouse database structures such as star schema, Fact table, Dimension.
• Review designs, codes, test plans, or documentation to ensure quality.
• Prepare functional or technical documentation for data warehouses.
• Verify the structure, accuracy, or quality of warehouse data.
• Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
• Coding stored procedures, functions, triggers and packages in PL/SQL.
• Developed custom scripts for data conversion and migration purposes to load the data from flat files and Ms. Excel files in the target database, also scheduled jobs on daily basis to perform the data conversion process.
• Performing tuning of SQL queries and PL/SQL code.
• Used Bulk Collection and Forall insert to enhance the data migration script performance.
• Managing the database’s storage structure.
• Making database backups and performing recovery when necessary.
• Proactively monitoring the database's health and taking preventive or corrective action as required.
• Monitoring and tuning performance.
• Managing users, roles and security.
• Worked on different types partition and sub-partition(Range and List)