Oracle IT Consulting

MrDek Consulting services the Minneapolis, St. Paul metro area. Specializing in Oracle IT Consulting in the following areas: Core DBA (Database Administration), Development DBA, Apps DBA (Oracle Applications Database Administration), Oracle Development (SQL/PLUS, custom inferfaces, standard Oracle application framework), Design, Data Modeling, Project Management, Business Analysts (gathering requirements), and Business Issue Resolvement.

Overall DBA duties would include:

• Installation, configuration and upgrading of Database server software and related products.
• Evaluate Database features and Database related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation.
• Implement and maintain database security (users and roles, assign privileges).
• Database tuning and performance monitoring.
• Application tuning and performance monitoring.
• Setup and maintain documentation and standards, per client specifications.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7x24 support when required.
• Do general technical trouble shooting and give consultation to development teams.
• Interface with Oracle for technical support and problem resolution.

Core DBAs usually...

• focus on the physical aspects of database administration such as DBMS installation, configuration, patching, upgrades, backups, restores, refreshes, performance optimization, maintenance and disaster recovery.

Development DBAs usually

• focus on the logical and development aspects of database administration such as data model design and maintenance, DDL (data definition language) generation, SQL writing and tuning, coding stored procedures, collaborating with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities.

Application DBAs are usually...

• found in organizations that have application software such as ERP (enterprise resource planning) and CRM (customer relationship management) systems - Oracle Applications, Siebel and PeopleSoft. Application DBAs straddle the fence between the DBMS and the application software and are responsible for ensuring that the application is fully optimized for the database and vice versa. They usually manage all the application components that interact with the database and carry out activities such as application installation and patching, application upgrades, database cloning, building and running data cleanup routines, data load process management, etc.

Oracle Development, Design, Data Modeling, Business Analyst...

• SQL/PLUS, Oracle Forms, Oracle Reports
• Able to design, data model, gather technical requirements
• Custom inferfaces from Legacy to Oracle Applications
• Standard Oracle application framework

Project Management...

• Able to responsibly deliver a project on budget, on time
• Communication to all parties involved
• Able to listen

Business Issue Resolvement...

• All businesses encounter challenging issues in their operations
• MrDek serves as an advocate to understand and effectively find a winning solution for it's clients
• A trusted ally to your business