-
관심 있으시면 연락주세요. wjin@ikon.com
US-PA-Malvern-SR DBA – Oracle
Ranked by Selling Power magazine as “One of the 50 best companies to sell for,” IKON Office Solutions is a leading provider of products and services that help businesses manage document workflow and increase efficiency.IKON believes that its people are its most important differentiator, and as a result IKON offers competitive total compensation packages and extensive development opportunities. Through IKON University, which was recently named to Training magazine뭩 Top 100 list, IKON offers world-class learning programs – from consultative sales training to management and leadership seminars. In fact, IKON has been named “One of America뭩 Most Admired Companies” by Fortune magazine for the past two years.
POSITION PROFILE
Responsible for overseeing administration of application databases and database management systems for both OLTP and OLAP systems to ensure that production databases and Oracle applications perform to IKON’s business requirements.JOB DUTIES AND RESPONSIBILITIES
-Develops policies and procedures designed to ensure the integrity of all ORACLE environment.
-Oversees, prioritizes and coordinates all the DBA related activities (clones, application of patches, installations/upgrades) within the DBA team members and assists them in analysis and problem resolutions pertaining to all instances.
-Identifies and resolves database performance problems; develops and deploys methods for continual system monitoring to ensure a proactive approach to fix performance issues.
-Develops and maintains the database management plan and models consistent with the needs of individual business units and corporate entities.
-Reviews and tunes initialization parameters, memory structures and physical data layout for optimal performance.
-Develops performance testing planning and strategies; responsible for Capacity planning strategies for all Oracle systems.
-Documents standards and policies for the installations, upgrades and DBA procedures for applying patches and clones.
-Responsible for end-to-end application performance tuning; identifies and analyzes offending SQL statements; investigates ways to tune and improve performance at the system level.
-Ensures effective application database and database management system recovery through the development and maintenance of backup and recovery procedures.
-Ensures that all Remedy tickets are assigned and resolved in a timely fashion.
-Ensures that all instances are backed up and available at the advertised times.
-Maintains and supports all existing ORACLE instances.
-Works with the DBA team to ensure that the daily database activities are carried out on all ORACLE instances (production, testing, acceptance, development and other support instances)
-Ensures that DBA support is provided for escalated TARs with ORACLE support.
-Monitors database space issues, database object extents growth and reviews existing database initialization parameters and adjusts when necessary.
-Works with Functional end users to fix any issues related to Applications.
-Identifies problems and resolves database performance-related issues.
-Works with DBA team to identify all performance related issues and resolves.
-Works with DBA team to trace expensive SQL statements and investigates ways to tune them.
-Utilizes and configures various performance monitoring tools.
-Monitors and reviews Statspack reports involving CPU, I/O Activity, memory and resource utilization.
-Ensures performance related database activities are performed on all instances such as gathering schema statistics, rebuilding indexes and reorganizing database objects.
-Performs trouble-shooting activities on production servers during off-hours (nights or weekends) if required to minimize impact to operations.
-Ensures that the databases are designed properly to perform optimally for OLTP and BATCH mode.
-Coordinates and prioritizes activities/tasks for DBA team.Qualifications:
Technical degree, certification or equivalent experienc
7+years IT experience with relational databases, Oracle Technologies, 11i Applications
Thorough knowledge of UNIX, mainly AIX.2 and higher based systems
RAC server configurations
Knowledge of copier and office solutin industry a plus.
To help you succeed we provide:Competitive compensation
401K, retirement savings plan, stock purchase, vacation, medical, dental, life, disability
World-class training and professional growth development programs
Career path and growth opportunity for successful performersIKON is proud to be an equal opportunity/Affirmative Action employer. Our goal is to have a diverse workforce that is reflective of the communities where we do business.
For additional information on IKON Careers visit us online at: http://www.ikon.com/about/careers/
Additional Information
Position Type: Full Time, Permanent
Ref Code: INMB-JDS-MAL-DATAD2
Contact Information
IKON Office Solutions