Position: Senior Oracle Applications DBA
Location: Southern California
Employment Type: Contract to Hire or FTE
Salary: DOE
Position Responsibilities
The Oracle Database Administrator is responsible for the administration, management, and security of database applications to ensure integrity and user access. The Oracle Database Administrator reports to the DBA Manager.
1. Performs database administration and management activities in a safe, recoverable, and professional manner that ensures the optimal operation of all database environments by: (50%)
• Designing, implementing, and monitoring database functionality to ensure a stable environment that supports business continuity;
• Maintaining the production, test, and development database environments associated with the daily operations and support of the Oracle database administration;
• Addressing Oracle Financials database upgrade challenges and issues related to customization to ensure a smooth and successful transition upgrade;
• Upholding enterprise policy guidelines and recommending new and improved guidelines to ensure compatibility and better service for end-users; and
• Staying abreast of the most current release of Oracle, including compatibility issues with operating systems, third-party software and utilities.
2. Provides support for database security and SOX audits to ensure database integrity and user access by: (10%)
• Assisting in the application and implementation of procedures for data standards and guidelines on data ownership, coding structures, and data replication to ensure access to, and integrity of data sets;
• Managing user security and access to databases to provide controlled access environment;
• Investigating, reviewing, applying, and testing all patches and bug fixes in the database environment;
• Maintaining security according to best practices and generating security solutions that balance auditor requirements with user requirements; and
• Maintaining up-to-date plans for disaster recovery and fail over capabilities and testing as required.
3. Monitors system/application performance in a large 24x7 environment and provides suggestion for system performance improvement to ensure optimal system/application performance by: (20%)
• Identifying and initiating resolutions to user problems/concerns associated with database server equipment (hardware and software);
• Identifying potential service level problems before they occur and notifying appropriate parties;
• Performance tuning;
• Performing proactive maintenance activities including index rebuilds, capacity planning efforts, table re-orgs, partitions, and purging data;
• Troubleshooting database/system related issues and creating Oracle SRs to resolve them; and
4. Reviews custom code and perform custom code migration to all non-production instances and provides suggestions for custom code performance improvement. (10%)
5. Ensures successful reporting of data/information and processing of business critical jobs by: (10%)
• Performing database administration activities and analysis of results through careful methodology and accountability of standardized reporting processes;
• Providing support for application system setups and Batch/Concurrent Manager jobs/scheduling; and
• Providing support for Oracle Discoverer, ADI, Noetix and Vista Plus tools.
The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.
Quantitative Dimensions
(Provide a brief paragraph summarizing this position's overall accountability. Be sure to include: budget responsibility; impact ($) to the organization; decision-making authority; and other important job criteria)
Decision Making:
The Database Administrator makes decisions based on plans as outlined in the overall IT plan by the DBA Manager. The incumbent has the responsibility to recommend while advising and defining the database activities that are in the process of working toward the desired database model. The Database Administrator must use his/her experiences to confidently make decisions that influence the Company's businesses and processes. The data managed is very important to the success of the IT function, making accuracy paramount.
Supervisory/Lead Responsibilities:
The Oracle Applications Database Administrator has no direct reports.
Scope of Position:
The incumbent spends the majority of his/her time performing database management, troubleshooting, support, administration and problem resolution.
Position Requirements
(Provide a brief paragraph summarizing this position's specific job requirements. Be sure to include: years of experience necessary to perform job responsibilities; educational requirements; credentials; special skill sets; travel requirements, etc. Add job competencies if known.)
Knowledge, Skills, and Abilities:
Required:
• Demonstrated expertise installing and configuring oracle Applications databases
• Demonstrated expertise to perform day-to-day database administration on existing databases.
• Knowledge of performance monitoring processes and procedures.
• Proven expertise in being able to design, test and implement oracle database solutions.
• Ability to perform database tuning for optimal performance.
• Experience with Cloning 11.5.9 and R12 applications
• Proven expertise to maintain documentation of systems and standard operating policies and procedures.
• Expertise in developing, testing, and implementation of the appropriate backup procedures.
• Proven expertise to interact with various levels of staff and management.
• Willingness and ability to travel up to 10% as necessary.
• SOA Suite, Weblogic Hyperion, and Oracle GRC desirable
Education/Experience:
Required:
• Bachelor´s Degree in Information Science, Data Management, Computer Science, or related field.
• 5+ years of experience with Oracle Financial Applications including 11i, R12 with database release 10g and 11g.
• Experience working with industry standards, regulations, and guidelines in database warehousing and other relevant systems.
• Experience working with domain structures, user authentication, and digital signatures.
• Experience working with relational databases.
Competencies:
• Decision Making: Identifying and understanding issues; problems, and opportunities; comparing data from different sources to draw conclusions; using effective approaches for choosing a course of action or developing appropriate solutions; taking action that is consistent with available facts, constraints, and probable consequences.
• Building Trust: Interacting with others in a way that gives them confidence in one's intentions and those of the organization.
• Building Partnerships: Identifying opportunities and taking action to build strategic relationships between one's area and other areas, teams, departments, units, or organizations to help achieve business goals.
• Initiating Action: Taking prompt action to accomplish objectives; taking action to achieve goals beyond what is required; being proactive.
• Information Monitoring: Setting up ongoing procedures to collect and review information needed to manage an organization or ongoing activities within it.
• Continuous Learning: Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application.
• Stress Tolerance: Maintaining stable performance under pressure or opposition (such as time pressure, or job ambiguity); handling stress in a manner that is acceptable to others and to the organization.
• Initiating Action: Taking prompt action to accomplish objectives; taking action to achieve goals beyond what is required; being proactive.
• Gaining Commitment: Using appropriate interpersonal styles and techniques to gain acceptance of ideas or plans; modifying one's own behavior to accommodate tasks, situations and individuals involved.
• Formal Presentation: Presenting ideas effectively to individuals or groups when given time to prepare; delivering presentations suited to the characteristics and needs of the audience.
Candidates who are interested, may forward the updated resume in a word doc. to pmadhusudhanan@us-buxton.com with all the below details:
Name:
Contact Number:
Email Address:
Current Location:
Rate (Hourly)
Availability:
Visa Status:
For maximum efficiency, including an informal summary of "RELEVANT" qualifications may improve response time.
Thank you for your interest in Buxton Consulting.
Preethi Madhusudhanan
Buxton Consulting
Ph: (925) 467 0723/ (925) 918 3725
pmadhusudhanan@us-buxton.com
------------------------------------
********************************************************************
Read the new KIT List blog at www.kitlist.wordpress.com for job tips and to connect to our community!
Please go to www.KITlist.org to join, post jobs, or get answers to common questions. If you have any comments or questions, you can reach us directly at KITtechmoderator@KITlist.org.
By using the KIT List you agree to comply with the Terms of Use on the site, and will not use discriminatory employment practices. The KIT List is a service of Connelly Communications, Inc.
TO UNSUBSCRIBE:
Replying to KIT emails with an "unsubscribe" request does not work.
Instead, just send an email (from the same account you used to subscribe) to KITlist-Tech-unsubscribe@yahoogroups.com. If you are still receiving emails after a few days, please email us at KITtechmoderator@KITlist.org and we will manually remove you. Thanks!
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/KITlist-Tech/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/KITlist-Tech/join
(Yahoo! ID required)
<*> To change settings via email:
KITlist-Tech-digest@yahoogroups.com
KITlist-Tech-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
KITlist-Tech-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
No comments:
Post a Comment