Dear Professional, Hope you are doing well. Please go through the Job Description and send me your updated resume with contact information *@ **[email protected]*<[email protected]> * * *Position : Oracle DBA Location : Wilmington, DE Duration : 6+ Months Contract* *Rate : $45/Hour on C2C or 1099*
*Job Summary: *This position is responsible for the ongoing support, administration, security and procedures for all enterprise database Oracle Servers used to support the 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. *Essential Functions Responsible for: *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 add-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, datapump, sql*loader, and import/export utilities. Recommends design and parameter changes that aid in the support of high performing code. *Collaborates with: *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: Measurements: *Service availability for all production systems Service performance relative to service requests and customer satisfaction Expense management relating to systems maintenance and equipment support ________________________ Warm Regards, Emraaz Khan• Sr Technical Recruiter • Panzer Solutions 45 Stuart Ave • K Unit • Norwalk, CT • 06850 Office: 203-813-2723 • Email: [email protected] -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.
