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

Subscribe to get Job Opening Information on Email


For Stock Market SureShot Tips Subscribe just @Rs.170 per day cost.