Oracle Database Developer Resume Profile
5.00/5 (Submit Your Rating)
Summary:
- Insightful, results driven IT Professional with 17 years of hands-on experience in areas such as application development, database development, database administration, team lead, trainer and briefer with excellent communication skills.
- 7 years' experience developing custom enterprise web-based applications utilizing Classic .NET, MySQL, ASP.NET, Oracle 11g and all related technologies.
- Involved in all phases of the SDLC from conception to product release including design, configuration, and back end development of Oracle 11G databases for ASP.NET web applications.
- Experience acting as technical team lead and sr. developer for an enterprise web application, which was release worldwide and still in use by customer today.
- Full SDLC experience including phases of conception, prototype development, prototype presentation, product development, product testing, product release and product support.
- SME level knowledge and experience of multiple software development tools including Classic .NET, ASP.NET, MySQL, Oracle, and relative tools.
Experience:
Confidential
Lead Developer / Database Architect
- Design, configuration, support and deployment of an enterprise ASP.NET web application on Oracle 11G database.
- Responsible for advanced SQL and PL/SQL development.
- Performed all DBA responsibilities including setting up fine grained access control VPD , Single sign-on, security and auditing procedures.
- Performed data migration from Sybase SQLAnywhere RDBMS to Oracle RDBMS.
Continued responsibilities for product / web application mentioned below including:
- Continuous development of an Enterprise Web Application used worldwide including all phases of the SDLC from conception to world wide release.
- Daily use and development including tools such as Classic .NET, ASP.NET, MySQL and Oracle 11g on the backend.
- Acted as Technical Lead of development team including up to 7 developers specializing in Classic .NET, ASP.NET, MySQL and Oracle 11g.
- Development and maintenance of application written in ASP.NET 4.0 on Oracle 11g database.
- Continued development utilizing .NET/ASP.NET and all included parts like Visual Studio on Oracle 11g database.
- From scratch development of Custom Web-based Application which started as CI collection tool then added multiple parts like accounting, time sheet function, calendar, etc .
- Application / product mentioned offered numerous capabilities that are still in use today by the Government worldwide.
- From scratch development including building data model, developing database prototype, developing application to application release.
- Acting technical lead for all application development decisions pertaining to mentioned product.
- Led from scratch development of an enterprise application using .NET, ASP.NET, MySQL, and Oracle 11g, presented and selected by the customer.
- Led data analysis including verifying or helping to verify data integrity and data model.
Software/Tools: SQL Developer, PowerDesigner, DBArtisan, ASP.NET, Visual Studio, Oracle 11g, ISQL.
Confidential
Developer / Database Administrator
- Led data analysis including verifying or helping to verify data integrity and data model.
- Defined and/or implemented access controls to the data for guaranteed maximum security.
- Ensured maximum performance given budgetary constraints.
- Tuning Queries to ensure maximum I/O efficiency.
- Development and testing support including helping programmers and engineers to efficiently utilize the database.
- Management of Oracle and Sybase Adaptive Server Anywhere databases for development, test, and production.
- Assist with Windows Network Administration activities including server builds, IP configuration, domain controller.
- Supported Oracle and Sybase Relational Data Management Systems RDBMS's
Software/Tools: Oracle 11g, Sybase Adaptive Server Anywhere 5.5.05, Sybase PowerDesigner, Sybase Central, ISQL.
Lead Developer / Data Architect
- Responsible for data architecture, and design utilizing Scenario Based Engineering software development methodology in Service Oriented Architecture.
- Data Architecture, Metadata Integration, Data Modeling, Relational Database Design, Reverse Engineering, Object Modeling, Data Administration.
- Produce data models, business process diagrams, data dictionary, metadata repository, core data entities, Data Synchronization Documents Extract, Transform, and Load scripts.
- Design/capacity planning support for Very Large Database VLDB .
Design Tools: ERwin Data Modeler, Sybase Power Designer, Oracle Designer, Popkin System Architect.
Oracle Database Developer
- Design, develop, and implement Oracle databases for J2EE implementation.
- Responsible for managing data conversion effort for legacy Sybase database.
- Develop ETL Extract, Transform, and Load scripts.
- Provide SQL and PL/SQL support to Java developers.
- Create UNIX shell scripts for database migration.
- Oracle Database installation on Windows and Solaris 9 platforms.
- Management of Sybase Adaptive Server Anywhere databases for development, test, and production.
- Installation and configuration of WebLogic 8.1 and 9.1 platforms including single sign-on.
- Assisted with Windows Network Administration activities including server builds, IP configuration, domain controller.
Software/Tools: Sybase PowerDesigner, Oracle SQLLoader Utility, Oracle Designer, Popkin System Architect, Solaris 9, VI editor.
Technical Skills:
- Programming Languages: .NET, SQL, ASP.NET, PL/SQL, T-SQL, Watcom SQL, Java, PERL, HTML, PHP, UNIX shell
- Databases: Oracle 8i/9i/10G/11G, Sybase Adaptive Server 5.5.05, MS Access
- Tools: SQL Developer, MySQL, DBartisan, Sybase Power Designer, Popkin System Architect, ERwin Data Modeler
- Oracle Utilities: SQL loader, DataPump
- Operating Systems: Windows, Unix/Linux
- Hardware experience: Windows server and Workstation, Network Adapters, Network equipment and cables