We provide IT Staff Augmentation Services!

Solutions Architect/oracle Dba Resume

Tallahassee, FL

SUMMARY:

  • An accomplished Confidential Technical Manager/Administrator/Team Leader/Oracle DBA with 15 years of multiple Confidential ERP Implementations/Maintenance experience with a proven track record of successfully designing and implementing solutions that improve business functionality, reduce costs, and increase performance.
  • SQL, PL/SQL
  • Data migration using SQL Loader
  • Source Code management using Visual Source Safe/Subversion, CCC/Harvest/Mercurial/MS TFS
  • Crystal Reports versions 8,9,10,11 and 2011
  • ASP.Net using C# with Microsoft Visual Studio 2003, 2005, 2012
  • Ruby On Rails and .Net Basic Web Applications To Run Custom Apps on Confidential System
  • Integrate incoming and outgoing EDI Messages to Confidential System
  • SQL Server, T - SQL, SSIS Integrations with Confidential
  • Oracle Expertise
  • Oracle 11g OCP April 2011
  • Oracle Database 10g Administrator Certified Associate, May 15 th 2006
  • Program with PL/SQL Oracle 9i - Certified, October 23 rd 2006
  • Hands-on experience configuring and maintaining DR Solution for Confidential, including Manual Standby database
  • Hands-on experience installing, configuring and maintaining Oracle databases (24*7) on Windows
  • Hands-on experience implementing backup & recovery plan for a 24*7 production Oracle Database
  • Hands-on experience on performance tuning at SGA, Instance Level and using Cost Based Optimizer
  • Hands-on experience using Oracle Enterprise Manager(Grid Control) with Oracle Management Server and SQL Tuning tools such as Explain Plan, Autotrace, Statpack, AWR, ADDM
  • Create and manage Users, Roles & Profiles
  • Develop PL/SQL procedures, packages and triggers to implement business logic (Using TOAD and PL/SQL Developer).
  • Hands-on experience installing and utilizing Oracle Connection Manager for External Web Applications
  • Extensive knowledge of Export/Import, Offline and Online backups, Media Recoveries
  • Java Stored Procedures in Oracle for Integrations to SQL Server Databases.
  • Hyperion Star Schema Implementation to be used with Essbase Studio
EXPERIENCE:

Confidential, Tallahassee, FL

Solutions Architect/Oracle DBA

Database: Oracle 10g R2/Oracle 11gR2

Platform: Windows

Responsibilities:

  • Essential Duties and Responsibilities
  • Lead the Confidential Upgrade from App 7 to App 7.5 SP 7
  • Evaluating App 8 Upgrade
  • Lead the Oracle DB Upgrade 10g to 11gR2
  • Lead architect in DR Implementation
  • Lead Confidential Sales & Marketing Implementation.
  • IEE Administration with Print Server/Print Agent/PDF Archiving/Crystal Web Services etc.
  • Implement Backup and Recovery Plans for the Oracle Database
  • Implement and Maintain Oracle Standby database manually
  • Configure SAN/RAID storage for Oracle Database.
  • Communicating with Software vendors and 3rd party consultants

Confidential, Houston, TX

Technical Project Manager

Database: Oracle 10g R2

Platform: Windows/Mac OSX

Responsibilities:

  • Implemented Confidential in UK(Aberdeen), Malaysia, Brazil, Mexico, Norway
  • Hands - on team lead over the Confidential Development/Implementation
  • Lead Integration efforts to allow Confidential to communicate to other SQL Server Databases and exchange data seamlessly using Triggers and Java Stored Procedures.
  • Implement Web Apps using Ruby on Rails to fill the gaps in Confidential Functionality Manipulating data in Confidential for Custom Requirements.
  • Write T-SQL Code for Triggers and Procedures in SQL Server. Create and Schedule Jobs in SQL Server.
  • Lead Confidential Mobile Client Implementation.
  • Mentor, manage schedules and tasks as well as provide technical direction to PL/SQL developers to ensure high quality code is produced prior to deployment to production.
  • Ensure efficient and consistent (best practices) are being followed across multiple projects and daily tasks.
  • Develop the Star Schema for Hyperion Essbase Reporting
  • Provide technical expertise to end users.

Confidential, Yonkers, NY

Oracle Database Administrator/Senior Systems Analyst

Database: Oracle 9i & 10g

Platform: Windows

Responsibilities:

  • Hands - on team lead over three developers (C#, .NET, VB, PL/SQL, SQL and Crystal)
  • Ensure all systems\applications (PL/SQL or SQL) that are in production fall in-line with the design document and on schedule.
  • Rewrite or tune queries (PL/SQL) to run faster and more efficient.
  • Rewrite and tune Batch Allocation process in a data warehouse environment (PL/SQL, runs every 30 minutes) to use less resources and enhance performance significantly.
  • Led and manage full SDLC development project in PL/SQL within data warehouse environment to create Pick Ticket application for Back Orders.
  • Led, manage and develop PL/SQL packages within a data warehouse environment utilizing REF Cursors for Crystal Reports to improve the speed of the results from queries significantly.
  • Write and develop PL/SQL backend in a data warehouse environment for .NET program which creates distribution lists.
  • Manage, support, and implement backup and disaster recovery strategies for Oracle 9i (production system).
  • Led and manage data modelling for all application development at Confidential utilizing PL/SQL and SQL.
  • Ensure all QA standards are being met by developers, tested according to client standards, well documented, and entered into Source Code Management system (Source Safe)
  • Draw Business Flow Diagrams utilizing MS Visio

Confidential, Boston, MA

Technical Lead/Senior Software Engineer

Database: Oracle 9i

Platform: Windows

Responsibilities:

  • Hands - on proven leader with experience managing a team of developers or can work independently with minimal supervision depending on the scope, budget, and duration of the various projects.
  • Lead numerous full SDLC projects in which the scope of my responsibilities included (in addition to development) writing technical specifications in collaboration with Confidential Project Manager and Clients Project Manager.
  • Developed numerous PL/SQL applications (Oracle 9i) for clientele that ran on the data warehouse environment.
  • Lead and manage data modelling for all application development at Confidential utilizing PL/SQL and SQL.
  • Ensure all QA standards are being met by developers, tested according to client standards, well documented, and entered into Source Code Management system (CCC/Harvest)
  • Managed Source Code Management & Software programming
  • Managed tasks, timelines, and resources with Microsoft Project.
  • Managed technical issues for Clientele.
  • Reviewed Project Plan for Technical Tasks
  • Participated in Project Meetings as Technical Responsible from Confidential
  • Management of development projects for customers.
  • Programming of Modifications/Patches
  • Assigning technical resources where needed.
  • Conduct Confidential Technology classes for customers IT Departments.

Confidential

Project Manager/Team Leader

Responsibilities:

  • Managed, lead, and mentored 15+ developers (PL/SQL and Centura) one Systems Analyst and one QA tester.
  • Obtained and clarified functional specifications for all design documents.
  • Managed, lead, created and implemented functional specification according to design specs outlined in the design document with development team.
  • Estimated resources and requirements to complete the project and assembled a Project Team.
  • Mentor, manage schedules and tasks as well as provide technical direction to developers to ensure high quality code is produced prior to deployment to production.
  • Create the database environment, file structure, and, prepare groundwork for code management using CCC Harvest/Visual Source Safe
  • Manage and monitor time schedules and progress of the project against the baseline plan; use the information obtained to adjust schedule problems before they become critical, and to identify additional resource requirements (if needed).
  • Identified and solved problems immediately.
  • Provided technical and functional support to team members.
  • Reported directly to the Project Manager any information relevant to the project under his\her supervision.
  • Weekly builds - sending of files to Sweden.
  • Handle communication (file/e-mail/phone/fax) with Project Manager (in Sweden or elsewhere).
  • Merge Bug Releases.
  • Ensure all QA standards are being met by developers, tested according to client standards, well documented, and entered into Source Code Management system (CCC/Harvest)
  • Test the software to see if it meets specifications.

Confidential

Software Engineer

Responsibilities:

  • Design the data model using Rational Rose according to the Technical Specification
  • Development of Business Logic using PL/SQL.
  • Implement Packages, Triggers, Tables and Views
  • Mentor and being mentored by other team members
  • Write Test Scenario s and Unit test
  • General Business Application Expertise

Hire Now