Position Title: Sr. Database Analyst
Department: Corporate Systems Support
Division: Information Technology
Group: Technical Services
SPECIFIC JOB CONTENT
Provide Basis application administration support to the Process Teams including on-going maintenance, troubleshooting, performance tuning and upgrade management, help manage the day to day activities from a support and maintenance perspective, and ensure that the production environment running SAP applications are stable. Develop, test and debug, and implement complex SAP operating components, software tools, and utilities required for the operation, maintenance, and control of the current and future Global SAP computer systems. Other duties include, installation of new releases and interim upgrades/fixes.
BASIC OBJECTIVE
Under general direction, designs and implements complex data bases with respect to the particular data base software product used. Install new releases and interim upgrades/fixes of data base software. Implement and use software monitors and processes to measure efficient online performance, processing workload, computer utilization, data storage growth and storage availability. Investigate inefficiencies and where possible implement changes to processes, programs, and parameters to restore effectiveness. Implement processes to assure comprehensive backups of data bases and a quick/efficient recovery method.
When working with SAP, additional technical competencies and knowledge is needed. This is because many of the data base performance software and monitoring is included in the SAP application software. The SAP application also includes some data base integrity functionality that is normally performed by the data base software independently of the application system.
There are more duties for this position related to SAP. Perform installation of new releases and interim upgrades/fixes. Perform changes to the SAP configuration, submitted by systems analysts using the SAP supplied CTS process (Change Transport System). Create and implement processes for batch interfaces such as data collection systems and other SAP systems.
The same SAP related duties are also performed for SAP add-on systems such as CRM and SCM.
Competent to work at the highest level of most phases of data base technology. Duties related to production problem resolution often require 24/7availablity. Position has wide latitude for unreviewed action in data base design and implementation.
SPECIFIC RESPONSIBILITIES
1. Design and implement complex data bases best suited to meet business application requirements and the technical infrastructure environment.
2. Implement and use software monitors and processes to measure efficient online performance, processing workload, computer utilization, data storage growth and storage availability. Measure against thresh-holds and targets and recommend action when needed.
3. Investigate processing inefficiencies and problems, and implement changes to processes, programs, and parameters to restore effectiveness.
4. Implement processes to assure comprehensive backups of data bases and a quick/efficient recovery method.
5. Monitors standards for data base related technology and methods for the enforcement of these standards.
6. Assists in formulation of standards and procedures relating to data base.
Competency Requirements:
1. Team Work
      Acts as an integral part of respective team.
      Assigned as a mentee to another team member for project leader work or as a mentor to other Systems Analysts
      Contributes ideas being respectful and understanding of individual experience and knowledge as compared to others
      Willingly takes direction from a variety of other team members
      Supports the team through meeting of commitments on assignments.
      Takes lead role for minor project work.
2. Professional Competence
      Seeks out information from other team members and alternative sources regarding industry trends relevant to functional assignments
      Pursues management recommended technical and industry training and certifications
      Detail oriented in work and analysis.
      High quality of work in support of team initiatives.
      Exhibits strong, diverse technical systems skills and a strong knowledge of CIT processes.
      Exhibits a solid knowledge of business processes for assigned functional team and a strong willingness to expand this knowledge.
      Demonstrates strengths in either technical skills or project leadership skills, shaping individual career path.
3. Focus on the End Customer
      During performance of assigned tasks, watch for any missed opportunities in defined business process, making adjustments as required. Communicates scope changes with other team members
      Challenge questionable business process changes to team management when experience raises questions/doubts.
4. Initiative/Taking Responsibility
      Takes ownership for assigned tasks, working to complete them on time with targeted results towards end objectives.
      Learns from assigned tasks and through mistakes made, keeping a positive attitude throughout.
      Strong initiative to learn and progress to next level in organization.
5. Communication
      Uses speaking and writing skills to effectively convey information, express opinions, and motivate others to act.
      Listens actively.
      Tailors presentations to the needs of the audience.
      Demonstrates mastery of information and is persuasive.
6. Builds Trust
      Successfully establishes and maintains partnership with others.
      Thoughtful consideration of others ideas and concerns (empathetic thinking).
      Sought after for team membership
7. Set High Standards of Performance
      Has achieved a level of contribution that includes a competence of the 2 skills relating to:
            1. Process knowledge.
            2. Functional expertise for either technology or business.
      Able to lead some minor projects or assist in leading a major project
      Process knowledge and functional expertise would apply to multiple areas.
8. Drive Continuous Improvement
      Develop practical systems scope that enhances the business function.
      When developing project scope, challenge obsolete practices, question accepted truths, and eliminate non-value-added processes.
RELATIONSHIPS AND CONTACTS
Supervisor Relationships:
1. Reports to Manager Data Base & Technical Software.
2. Gives direction and guidance to other personnel relating to data base practices.
Organization Relationships:
1. Frequent contact with the Systems Development and the IT Infrastructure staff.
External Business Relationships:
1. Contact with vendors of data base and SAP technology.
2. Contact with other organizations to discuss related processes and issues.
EDUCATION AND EXPERIENCE REQUIREMENTS
1. Bachelors degree in Information Technology or related field preferred. Under some circumstances Associate Degree in Information Technology and minimum 5 years experience will be accepted.
2. 4 – 5 years systems and/or programming experience.
3. The ability to read, write, and speak Mandarin, French or Mexican Spanish is a strong plus.