Oracle SQL Database Developer Resume

SUMMARY:

3+ years of IT working experience in Oracle 8i,9i,10g,11g,12c SQL and PL/SQL.
Experienced in DDL, DML, DCL Scripts and established relationships between tables using Primary Keys & Foreign Keys.
Good experience in DOTNET(C#,VB.NET),Visual Studio 2008,Java.
Worked with different domains like Health Care, Data Warehouse, e - Commerce Web Sites.
Good experience in MS Excel.
Good understanding of the oracle database, related utilities and Tools.
Good experience in writing stored procedures, functions and views.
Good experience in writing and tuning complex sub queries, correlated queries, SQL, PL/SQL stored procedures, functions, packages, cursors, collections and triggers.
Created Oracle objects Tables, Views, Constrains, Synonyms, Sequences.
Experience in Pivot and Unpivot data.
Experience in Database design using Normalization and E/R Diagrams
Experience in Oracle Forms and Reports.
Experience in SQL Server 2005/2008.
Experience developing and supporting Crystal Reports XI and Crystal Reports 8.
Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.
Used partitioning and sub partitioning of tables to improve performance.
Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
Experience in Data flow Diagram, ER Diagrams using Oracle designer.
Expertise preparing report specifications and database designs to support reporting requirements
Worked with team on customizing the abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.
Created Crystal Reports sourced from the Oracle database and flat files.
Good knowledge in Basic DBA activity- Creating and Managing Oracle Database server, Proactive Monitoring,Database security (User & Resources, User Privileges & Roles).
Good Knowledge in Software Development Life Cycle.
Ability to learn new concepts, tools and environments.
Took training in Bigdata and Hadoop.
Good knowledge in Bigdata and Hadoop Architecture.
Worked with cloudera.
Worked with Large Datasets.
Good knowledge in Bigdata and Hadoop tools like Pig, Hive, Hbase Scoop, Flume.
Good experience in HDFS commands.
Good knowledge in R-Programming.

TECHNICAL SKILLS:

Programming languages: C,C++, Java, R Programming, Python, Linux shell script, HTML, CSS, C#, .NET

Tools: Visual Studio, NetBeans, Toad, Tableau

Database: SQL Server, Oracle 8i,9i,10g,11g,12c MySQL, PL/SQL, MS Access

Hadoop/Big Data: Hadoop Architecture, Pig, Hive, Hbase, Sqoop, Flume

Operating Systems: Windows Server 2016, 2012, 2008R2, 2005,LINUX/UNIX,Ubuntu.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle SQL Database Developer

Responsibilities:

Coordinate with Managers, Architects and Analysts to develop Oracle database systems.
Design and deploy data table structures, forms, reports, and queries.
Created DDL, DML, DCL Scripts and established relationships between tables using Primary Keys & Foreign Keys.
Understand business requirements and accordingly develop database models.
Created lots of Triggers for validation.
Created lots of procedure, functions, views, cursors, collections.
Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
Used partitioning and sub partitioning of tables to improve performance.
Exported the database and imported the same into development and test environment whenever required.
Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
Created Oracle Materialized Views.
Worked with Large Datasets.
Used the inner join, outer join, cross join while writing the complex SQL Queries.
Used Collection objects, ref cursor, aggregate functions while Writing SQL Queries.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship