AmerisourceBergen Corporation Technical Lead in FRISCO, Texas
Title: Technical Lead Location: United States-Texas-Frisco Job Number: 00001LTU
POSITION SUMMARY :
Reports to (reports to). Individuals within the Database Administration role design, install, maintain and upgrade the enterprise’s databases (development, testing, and production). They provide technical expertise in the use of database technology and are accountable for the overall performance of the enterprise’s database environment. Database Administrators work closely with business and system analysts and solution developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases. Database Administrators develop databases across multiple platforms. They support the transformation of business requirements into database solutions. Once a database is in place, they monitor and analyze performance metrics and then allocate database resources to achieve optimum database performance. Individuals implement and perform backup and recovery procedures for the enterprise’s databases and help develop the tools and techniques that allow customers to access data in a secure environment. Lastly, they support and help develop a common set of standards, the methods and procedures used for all database administration development work and recommend software and hardware upgrade paths.
Works on multiple projects as a team member or sometimes as a technical lead.
Supports multiple databases of medium to high complexity (complexity defined by database size, technology used, and system feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of the data.
PRIMARY DUTIES AND RESPONSIBILITIES:
PRIMARY DUTIES AND RESPONSIBILITIES:
Plans and organizes database activities regarding reliability, performance monitoring and tuning, security, backup and disaster recovery.
Works with analysts, to understand business needs.
Translates logical data models into physical database designs.
Develops physical databases.
Assists in the establishment of database system flows.
Develops and maintains enterprise data documentation and metadata models.
Develops and provides database requirements to system administrators.
Codes, edits, installs and verifies stored procedures and functions for accessing, maintaining, and populating databases.
Recommends and implements database solutions to support data integrity efforts.
Implements required security controls are designed around data and databases.
Participates in projects that require testing and produces metrics and samples for further analysis.
Ensures optimal database performance and availability.
Monitors utilization for capacity planning.
Troubleshoots and resolves applications (ex., SQL) performance issues.
Monitors, analyzes and calibrates DBMS parameters so that the database is tuned for optimal performance.
Maintains development, production, and multiple testing environments
Performs upgrades of databases, adding new structures or elements.
Plans and manages the migration of databases.
Installs, configures and maintains the database management systems software.
Builds scripts automating the daily operations of database management.
Monitors transactions between application systems and the database for the purpose of identifying and improving inefficiencies.
Implements database backup and recovery procedures.
Controls privileges and permissions to database users.
Assures that appropriate information security is applied in all tasks.
Provides production support/ database access 24 hrs x 7 days a week.
Conducts Level 2 and 3 support.
Troubleshoots databases accessibility, availability or operability problems.
Determines the appropriate course of actions for fixing problems, identifies and mitigates risks, and implements solutions.
Escalates/communicates issues when necessary.
Policies, Processes, and Standards
Adheres to enterprise policies, processes, and standards.
Service Level Agreements
Is aware of service level agreement levels.
Takes steps to meet or exceed requirements.
May coach team members. Qualifications:
EXPERIENCE AND EDUCATIONAL REQUIREMENTS:
Bachelor’s degree in programming/systems or computer science, information systems, specialized training, certification, or equivalent work experience.
Typically requires 3-5 years of database administration experience working with various database management systems.
Has a broad level of understanding surrounding information systems and application and/or Web standards.
Exposure to IBM Power 8 servers technology would be helpful with integration to windows SQL products.
Experience with WMS application, specifically Inbound, Outbound, Pick pack and ship processes.
Responsible for identifying development tasks in support of project planning, estimation, and troubleshooting issues during and after implementations.
MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:
CORE CAPABILITY REQUIREMENTS:
Intermediate (I): Handles multiple projects and duties simultaneously, prioritizing as needed. Devises flexible approaches that are easily adopted by all levels and types of people. Works creatively to respond to a specific situation. Quickly resolves new challenges in a changing environment. Interprets the spirit of a policy to meet business goals and client needs. Respects and responds sensitively to others’ reluctance to change. Fosters flexibility through cross-training and developmental work assignments.
Basic (B): Collates and reports information. Solicits guidance to define criteria and assign values of importance and urgency. Sorts information in order of importance. Investigates to define problems more accurately. Identifies trends and exceptions. Identifies relationships and linkages between components. Identifies variable potential causes and effects. Escalates issues of an exceptional nature.
Communication for Results
Intermediate (I): Conducts discussions with and writes memoranda to all levels of colleagues and peer groups in ways that support troubleshooting and problem solving. Seeks and shares relevant information, opinions, and judgments. Handles conflict empathetically. Explains the context of inter-related situations, asks probing questions, and solicits multiple sources of advice prior to taking action.
Basic (B): Seeks information on both formal and informal processes. Uses appropriate tools, techniques and sources to gather, update and monitor information. Checks for accuracy of interpretation. Seeks out the appropriate people for guidance when needed depending on the type of issue.
Basic (B): Volunteers to undertake tasks that stretch his or her capability. Identifies who can provide support and procures their input. Identifies problems and acts to prevent and solve them.
Basic (B): Investigates defined issues with uncertain but limited cause. Solicits input in gathering data that help identify and differentiate the symptoms and root causes of defined problems. Suggests alternative approaches that meet the needs of the organization, the situation, and those involved. Escalates issues with suggestions for further investigation and options for consideration.
Intermediate (I): Actively solicits ideas and opinions from others to quickly accomplish specific objectives targeted at defined business outcomes. Openly encourages other team members to voice their ideas and concerns. Shows respect for differences and diversity, and disagrees without personalizing issues. Utilizes strengths of team members to achieve optimal performance.
Intermediate (I): Demonstrates operational agility. Uses organizational systems that result in multiple critical activities to be identified and completed on time. Renegotiates priorities as necessary. Puts systems in place and uses them to monitor and detect errors and problems. Tests and inspects outputs, and applies quality checks prior to work submission.
*Explanation of Proficiency Level Definitions Proficiency scale definitions are provided to help determine an individual’s proficiency level in a specific competency. The rating scale below was created as a foundation for the development of proficiency level definitions used for assessments.
Being Developed: (BD)
Demonstrates minimal use of this competency; limited knowledge of subject matter area; needs frequent assistance and close supervision for direction. Currently developing competency.
Demonstrates limited use of this competency; basic familiarity of subject matter area; needs additional training to apply without assistance or with frequent supervision.
Demonstrates working or functional proficiency level sufficient to apply this competency effectively without assistance and with minimal supervision; working/functional knowledge of subject matter area.
Demonstrates in -depth proficiency level sufficient to assist, consult to, or lead others in the application of this competency; in-depth knowledge in subject matter area.
Demonstrates broad, in-depth proficiency sufficient to be recognized as an authority or master performer in the applications of this competency; recognized authority/expert in subject matter area. Job: Information Technology Jobs