We provide IT Staff Augmentation Services!

Senior Database Developer Resume

0/5 (Submit Your Rating)

New, YorK

SUMMARY

  • Accomplished and result - driven Senior Database Developer with 11+ years of experience in Design, Development, Implementation and Support of N-tier Client Server applications. Expertise in SQL, Advanced Oracle PL/SQL, Database Performance Tuning & Optimization of SQL, ETL,UNIX & Shell Scripting, Vast experience working in Object Oriented Programming, Client/Server and Web based applications using Oracle, SQL Server,Microsoft .NET Framework & JavaScript.
  • Excellent communication and interpersonal skills and team player. Flexible and capable to work in cross platform environments.
  • Proficient in Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
  • Expertise in creating and maintain stored procedures, Packages, Triggers, Functions, writing complex SQL queries with sub-queries and inline views .
  • Proficient in oracle cursor management & Exception handling, error logs, SQL Jobs & Health checkup Management on transaction Data.
  • Expertise in Database Performance Tuning & Optimization of SQL statements using SQL, PL/SQL Best practices techniques, bulk collect, Oracle Hints, Explain Plan, Tkprof, SQL*Trace & Table Partitioning.
  • Strong knowledge in Identified the several SQL and PL/SQL bottlenecks using Automatic Workload Repository(AWR) report, explain plan, auto trace, PL/SQL profiler(package DBMS PROFILER)& SQL Profiler(T-SQL).
  • Experience in as export, import, retrieving data from external data files or sources & loaded into oracle tables using tools like ETL(IBM Data stage, SSIS and Informatica ), SQL* Loader and UTL FILE.
  • Familiarity with process and Python software development. Working Knowledge on UNIX, Windows and Shell Scripting.
  • Experience in design and development of window & web based applications using Oracle, SQL-Server, Oracle Forms and Reports 10 g, Microsoft .NET Framework (ASP.NET, ADO.NET with C#, VB.NET), Web Services (WCF, SOAP and REST), Python, Perl & JavaScript.
  • Experience in developed the complex & interactive reports in Business Objects14.0-Crystal Reports, IBM Cognos &, Oracle BI (OBIEE).
  • Experience in trouble suiting the security vulnerabilities the Window/Web based Application developed in Oracle, Microsoft .NET Framework & Java Script.
  • Vast experience working in all stages of the project lifecycle from requirements, to development, to implementation in production environments & Production support.
  • Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications.
  • Troubleshooting and resolved production support issues escalated from end users. Opened and documented defect tickets & Complete root cause analysis of defects.
  • Experience in trouble suiting & Debugging the Windows/Web based Application developed in Oracle, Java/Microsoft .NET Framework, SQL Server/ Oracle/Sybase & on other environments .
  • Working knowledge of others relational data bases such as SQL Server, IBM DB2, PostgreSQL.
  • Experience in using various code repository software like (Concurrent Versions System) CVS, Apache Subversion (SVN) & Microsoft Visual Source Safe (VSS)
  • Experience in using different software methodologies e.g. Waterfall, Iterative and Agile.
  • Self-motivated, able to set effective priority to achieve immediate and long-term goals and meet deadlines.
  • Ability to learn new skills and take on greater responsibilities, excellent organizational, interpersonal, and communications skills with the flexibility and experience required to adjust to rapidly changing schedules and shifting priorities.
  • Experience working as Lead with the onshore and offshore team.

TECHNICAL SKILLS

Programming Language: SQL,PL/SQL,T-SQL,SQL fine-tuning, Asp.Net 2.0/3.5/4.0,Ado.Net, VB.Net & C#, Python,Perl, JavaScript, HTML, CSS,UNIX Shell Scripting, XML, Web Services (WCF, SOAP and REST)

Database and Programming: Oracle 8i/11g/12c, SQL Server2005/2014, IBM DB2, PostgreSQL, SQL, PL/SQL, T-SQL

Software Engineering: UML, Design Patterns, Object Oriented Methodologies, Service Oriented Architecture, Test Driven Development, Waterfall, Agile

IDEs & Tools: Microsoft .NET Framework 2.0/3.5/4.0/4.5 , Business Objects 14.0-Crystal Reports, SQL Plus, Toad, PL/SQL Developer, SQL Developer, Burp suite, SQL Server Management studio, SQL Profiler, SQL*Loader, UTL FILE, FileZilla, Microsoft Visual Source Safe(VSS), (Concurrent Versions System) CVS, Apache Subversion (SVN), Autosys,ETL- IBM Data Stage, SSIS & Informatica, Oracle Forms and Reports 10 g

Web/Application Servers: Window Server 2003/2008/2012 , Web logic, SQL Server 2014,NEC Cluster, Windows Server 2012

Domain: Insurance, Banking, Aviation -Security, Parking & Revenue, Energy -Power Distribution

Operating System: Win NT/2008/12/16, Win XP/Vista/7/8/10, Unix, Linux, Android OS, Solaris8/9/11

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior Database Developer

Responsibilities:

  • Designed, developed & implementation of IT Solutions using Oracle PL/SQL, Python, Perl & Microsoft .NET Framework and Web Services (WCF, SOAP and REST).
  • Designed, developed & managed the Database objects (SQL Jobs, Stored Procedures, Functions, triggers & etc) for Parking & Parking and revenue control system (PRCS) & Computer Security System (CSS).
  • Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications.
  • Troubleshooting and resolved production support issues escalated from end users.
  • Working on Database Performance Tuning & Optimization of SQL statements using SQL, PL/SQL Best practices techniques, bulk collect, Oracle Hints, Explain Plan, SQL*Trace & Table Partitioning.
  • Identified the several SQL and PL/SQL bottlenecks using explain plan, auto trace, PL/SQL profiler (package DBMS PROFILER).
  • Developed the process for Data archive & purging for Parking and revenue control system (PRCS) in Oracle Database.
  • Developed the Health Checkup(Basic checks on daily transaction data) jobs for Parking & Parking and revenue control system(PRCS) & Computer Security System(CSS).
  • Developed the complex, interactive, presentation-quality reports in Business Objects 14.0 -Crystal Reports.
  • Generating analysis report for diagnose & manage in various implementations in Parking & Parking and revenue control system (PRCS) & Computer Security System (CSS).
  • Developed the details documentation for all the application activities being performed in the project.

Confidential

Senior Database Developer/Team Leader

Responsibilities:

  • Designed and implemented software solutions for Non life Fire insurance module in the project(All Phases of Policy like Proposal, Quotation, Accounting, Policy generation, Masters Data & reports ) using Microsoft .net framework3.5, Web Services (WCF, SOAP and REST), & Oracle 11g(Oracle PL/SQL,ASP.NET3.5,JavaScript) .
  • Designed the data model and architecture of the application as class diagrams.
  • Designed, developed & managed the Database objects (SQL Jobs, Stored Procedures, functions, triggers, jobs etc) for all Applications.
  • Worked on Database Performance Tuning & Optimization of SQL statements using SQL, PL/SQL Best practices techniques, Oracle Hints, Indexes, Explain Plan, SQL*Trace & Table Partitioning.
  • Identified the several SQL and PL/SQL bottlenecks using Automatic Workload Repository (AWR), explain plan, auto trace, PL/SQL profiler (package DBMS PROFILER).
  • Developed the Health Checkup(Basic checks on daily transaction data) jobs for Pathfinder Project
  • Developed the (Insurance Regulatory and Development Authority of India)IRDA reports & scheduled the jobs in Production environments.
  • Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications.
  • Troubleshooting and resolved production support issues escalated from end users.
  • Monitor data processing quality assurance and development activities.
  • Opened and documented defect tickets & Complete root cause analysis of defects.
  • Implemented the several highly complex business requirements process in Motor & other module providing the transaction data to third parties application for Accounting and report purpose using database Links, SQL Jobs, & Views .
  • Fine-tuned the performance of application by Automatic Workload Repository (AWR), improving SQL queries, adding appropriate indexes.
  • Implements the review process & check list for all new developed /existing database objects.
  • Implemented the several security vulnerabilities solutions for the Application, used the Brup suite tool for trouble suiting.
  • Worked as Tech Lead and managed a small team in waterfall development mode efficiently and helped team to deliver enhancements and defect fixes to client on extremely challenging deadlines.

Confidential

Database Developer

Responsibilities:

  • Worked with Business Architect in collaboration sessions to capture business requirements in the form of Use Cases.
  • Worked as Database Developer and developed & implemented Export module in waterfall development mode using PL/SQL, Aps.net 2.0 and helped Team to deliver the product enhancements on time and in cost effective way.
  • Interaction with client for requirement gathering, scoping, designing and function/technical support.
  • Designed the data model and architecture of the application as class diagrams.
  • Designed, developed & managed the Database objects (Stored Procedures, functions, triggers, sql jobs etc) for all modules.
  • Provided production support by providing emergency bug fixes and data fixes.

Confidential

Database Developer

Responsibilities:

  • Worked with Business Architect in collaboration sessions to capture business requirements in the form of Use Cases.
  • Worked as Database Developer and developed & implemented several business forms(Screen) in waterfall development mode using SQL Server,Aps.net 2.0 and helped Team to deliver the product enhancements on time and in cost effective way.
  • Interaction with client for requirement gathering, scoping, designing and function/technical support.
  • Designed the data model and architecture of the application as class diagrams.
  • Designed, developed & managed the Database objects (Stored Procedures, functions, triggers, SQL jobs etc) for all modules.
  • Provided production support by providing emergency bug fixes and data fixes.

We'd love your feedback!