We have partnered with a large financial company in Wilmington, DE area to provide them with Oracle DBA . Te ideal candidates will be responsible for the ongoing support, administration, security and procedures for all enterprise database Oracle Servers used to support client and ensure that customer service, system availability targets, and service level agreements are established and met.
Please review the below description and if you are interested please contact Janender Kolisetti ASAP at jkolisetti @relevante.com or 215-259-5078 as our client is looking to fill this position immediately.
This position is responsible for the ongoing support, administration, security and procedures for all enterprise database Oracle Servers used to support client. This includes, but is not limited to controls and support of both data and code.
This professional will be responsible for Tier 2 support for Production issues and Helpdesk tickets, as well as, the deployment of Production and QA database releases in support of application development efforts. This role will ensure that customer service, system availability targets, and service level agreements are established and met.
Assisting in the design and development of pl/sql packages, functions or stored procedures to support the needs of application developers.
Analyzing and tuning pl/sql packages, functions, stored procedures and ad-hoc sql through the use of explain plans, sql trace, optimizer hints etc.
Proposing and implementing recommended physical object structures and their design, i.e. materialized views, indexes, partitioned tables, IOT, etc.
Reviewing, recommending and implementing appropriate statistical analysis for objects as needed, such as items relevant to histograms, ranges of data or frequency for CBO, outlined plans, etc.
Provides high-level application data support for both Data warehouse and OLTP applications.
Assist in the design, development, and support of relational and data warehouse database designs in a team oriented environment using data modeling tools, such as Erwin.
Reviewing and make architectural recommendations on all physical design layouts of logical models
Assists in the development of data migration plans through the use of pl/sql, data pump, sql*loader, and import/export utilities.
Recommends design and parameter changes that aid in the support of high performing code.
Data Modeling and Development team to assist in the review of relational and non-relational database models and their physical generation.
Data Modeler to develop solid physical structures
Production Database Administrators, Data Modelers and Development to enforce naming and coding standards.
Database Leads and Database Architects to develop standards in processes and infrastructure design, build and implementation.
Mentors Application team members in the development and tuning of packages and procedures.
Production Database Administrators and Application Support to communicate and coordinate production release plans.
Experience, Qualifications and Technical Skills and Abilities:
Service availability for all production systems.
Service performance relative to service requests and customer satisfaction.
Expense management relating to systems maintenance and equipment support.
Rele v ante is an accounting & technology resourcing and consulting firm, committed to meeting the dynamic business requirements of our clients. We provide accounting and technology consultants to Fortune 1000 and other industry leaders from our locations in the Greater Philadelphia area. Relevante has been consecutively ranked in the last few years, as one of the fastest growing privately held companies in the Philadelphia Region.
Join the Relevante Group on LinkedIn to find jobs and network with over 12,000 Accounting & Technology Professionals. http://www.linkedin.com/groups?mostPopular=&gid=2901 .
Relevante - 2 years ago