Job Summary:
This position is responsible for the ongoing support, administration, security and procedures for all enterprise database Oracle Servers. 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.
Working Relationships:
Reports to:Database Team Lead
Manages:Specialized technical resources
Experience & Qualifications:
· 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
Education and/or Certifications:
· Four-year degree in related discipline with 7+ years experience in systems development
· Minimum of 5+ Years of working with Oracle Databases in an administrative and development support role.
· Work with database servers should consist of at least 80% of the candidate’s responsibilities.
· Service performance relative to service requests and customer satisfaction
· Continued training and study in Technology and Business Leadership.
· Technical training on UNIX, Windows platform design and support
Technical skills and abilities:
Strong technical knowledge of Oracle 9i/10g Enterprise Server.
Strong knowledge of Database Installation, setup, creation, tuning and maintenance processes.
Strong technical knowledge of Database Disaster Recovery and High Availability techniques and implementations.
Strong technical knowledge of Oracle Dataguard, Enterprise Manager, and RMAN.
Strong knowledge of PL/SQL development and SQL tuning.
Working knowledge of ORACLE RAC.
Working knowledge of Database Design and Modeling, along with familiarity and use of at least one Database Modeling tool.
Leadership in the deployment of world-class IT infrastructure.
Ability to quickly troubleshoot and conduct root cause analysis.
Ability to lead and motivate complex technical teams.
Ownership and accountability for production level issues.
Formal knowledge and practice of the Quality Process and Project Management philosophies and principles
Requirement for Oracle DBA - Wilmington, DE - GC / EAD / Citizens ONLY
| 0 comments » November 20, 2009 10:03 AM
Subscribe to:
Post Comments (Atom)
Skill Wise
.Net
ABAP
Accenture
Agriculture Industry
AIS
Amazon
AMD
Amdocs
ASP
Bally Technologies
Bangalore
BASIS
Birla Soft
BPO Hiring
BW
C
C#
C++
CAD
Call center
Capgemini
Citrix
Cognizant Technology
Consultant HR
Credit Analyst
crm
CSC
CTS
Data Warehousing Architects
Deloitte
Dot Net
Dupont
EDI
EP
FICO
FMCG
Food Technology
Freshers
Generalist HR
Government Jobs
Gurgaon
HCL
HCL Infosystem
HCL Technologies
Hewitt
HP
HR
HR/Administration and IR
HTC India
HTML
IBM
IBM Daksh
ICICI Bank
Infinera
Infosys
IT Jobs
J2EE
Java
Java/J2ee Requirements
Jindal Power Limited
John Deere
Mahindra Satyam
Mainframe
Marketing and Business Development
MBA Freshers
Netveawer XI
Newgen
Nucleus
Oracle
Oracle App
Others
People Soft
PES
PHP
PL/SQL
Project Manager-IT
Pune
QA
RBS India
Sales
SAP
SAP ABAP
SAP ABAP Developer
SAP FI
SAP HR
SAP Lab
SAP MDM
SAP SD
SAP Workflow
SAP XI
Sapient
SAS
SEM
Siemens
SQL
TCS
Team Lead/Technical Designer
Telecom domain
Testing
tibco
VC++
Walk In (Delhi NCR)
Walmart
Webdynpro
Wipro
XI
0 comments
Post a Comment