Database Administrator III

Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today! Job Details WORK COMPLEXITY: Works on multiple projects as a team member or sometimes as a technical lead or advisor. Supports multiple databases of highly complex (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 Project/Work Planning Plans and organizes database activities regarding reliability, performance monitoring and tuning, security, backup and disaster recovery. Participate in long term planning for software and hardware upgrades. Works with Project Managers to allocate DBA resources. Design/Develop Works with analysts to understand business needs. Participates in cross-team and cross-project implementations. Translates logical data models into physical database designs. Develops physical databases. Assists system engineer in the design of highly available and redundant storage area networks. Establishes information flows. Develops and maintains enterprise data documentation and metadata models. Develops and provides database requirements to system administrators. Designs, monitors and maintains data replication primary and secondary databases. Develops, tests, maintains, and exercises procedures for backup, restoration and disaster recovery for high availability, high volume mission critical databases. Designs, codes, edits, installs and verifies stored procedures and functions for accessing, maintaining, and populating databases. Recommends and implements db solutions to support data integrity efforts. Designs and implements required security controls are designed around data and databases. Testing Participates in projects that require testing and produces metrics and samples for further analysis. Performance Management Ensures optimal database performance and availability. Monitors utilization for capacity planning. Troubleshoots and resolves applications (ex., SQL) performance issues. Forecasts utilization patterns and recommends modifications or upgrades. Proposes and implements enhancements to improve system performance and reliability. Conducts application transaction volume and traffic analysis, and interprets the impact on database performance. Database Administration Maintains development, production, and multiple testing environments Oversees the upgrades of databases, adding new structures or elements. Provides, evaluates and develops data access tools and techniques. Directs the scheduling of DBMS software installs. 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. Database Security Maintains and monitors database security, integrity and access controls. Controls privileges and permissions to database users. Provides audit trails to detect potential security violations. Makes recommendations to improve security. Participates in security investigations as needed. Assures that appropriate information security is applied in all tasks. Database Support Provides production support/ database access 24 hrs x 7 days a week and ensures high availability. Conducts Level 2 and 3 support. Troubleshoots databases accessibility, availability or operability problems. Determines the appropriate course of actions for problems, identifies and mitigates risks, and implements solutions. Escalates/communicates issues when necessary. Policies, Processes, and Standards Assists in establishing and supporting enterprise policies, processes, and standards. Ensures standards are adhered to. Service Level Agreements Monitors performance against service agreement levels. Participates in the developing SLAs. Ensures that operating level agreements are met with internal/external customers. Coaching/Mentoring Coaches and mentors team members. Provides performance feedback to managers. Research/Evaluation Evaluates future technologies and makes recommendations for software and hardware upgrades and technology solutions. EXPERIENCE AND EDUCATIONAL REQUIREMENTS: Bachelor’s degree in programming/systems or computer science, information systems, specialized training, certification, or equivalent work experience. Typically requires 5 or more years of database administration experience working with various database management systems. Has a broad level of understanding surrounding information systems, application and/or Web standards and database licensing. Thorough understanding of performance monitoring, analysis and tuning. MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS: CORE CAPABILITY REQUIREMENTS: Adaptability Advanced (A): Calmly takes control of high-pressure situations. Maximizes the output of limited resources. Shifts tactics and redefines organizational priorities. Implements new practices when original approach and assumptions are no longer valid. Conducts transition planning and fosters employee involvement. Manages high-level milestone accomplishments across multiple change activities. Recommends large-scale change interventions. Analytical Thinking Intermediate (I): Coordinates the information gathering and reporting process. Reviews trends and compares to expectations. Conducts research to define problems and prepares responses to anticipated questions. Prioritizes multiple issues and opportunities. Identifies relationships and linkages within several information sources. Anticipates issues that are not readily apparent on the surface. Identifies root causes and effects. Defines priorities within performance objectives. Reports and identifies areas that need guidance in order to resolve complex issues. Anticipates the possible outcome of potential solutions. 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. Information Seeking Intermediate (I): Utilizes a variety of information and data sources pertaining to organizational and professional trends. Checks the source for omission and accuracy. Identifies the sources that are appropriate for specific types of information. Checks for bias and omission. Seeks out the appropriate people to approach for guidance either formally or informally depending on the type of issue. Links information in a lateral as well as linear manner. Finds hidden data. Relates and manipulates data from various sources to create a fuller picture. Investigates and uncovers root causes of a problem or issue. Initiative Intermediate (I): Seeks out new challenges that require risk taking. Determines the resources, team support, and technical needs necessary to enable success and procures them. Keeps responding to the challenge in spite of obstacles and setbacks. Problem Solving Intermediate (I): Applies simple problem-solving methodologies to diagnose and solve operational and interpersonal problems. Determines the potential causes of the problem and devises testing methodologies for validation. Shows empathy and objectivity toward individuals involved in the issue. Analyzes multiple alternatives, risks and benefits for a range of potential solutions. Recommends resource requirements and collaborates with impacted stakeholders. Teamwork Advanced (A): Consistently fosters collaboration and respect among team members by addressing elements of the group process that impedes, or could impede, the group from reaching its goal. Engages the “right people”, despite location or functional specialty, in the team by matching individual capabilities and skills to the team’s goals. Works with a wide range of teams and readily shares lessons learned. Thoroughness Advanced (A): Identifies potential areas of conflicting priorities and vulnerability in achieving standards. Reviews department's progress against established goals, objectives, service level targets and project milestones. Supports others in achieving deliverables by efficiently allocating resources and providing common organizing systems, techniques and disciplines. Maintains a proactive work review and approval process prior to assignment completion. Solicits internal and external customer evaluation of performance and devises measures for improvement What Cencora offers We provide compensation, benefits, and resources that enable a highly inclusive culture and support our team members’ ability to live with purpose every day. In addition to traditional offerings like medical, dental, and vision care, we also provide a comprehensive suite of benefits that focus on the physical, emotional, financial, and social aspects of wellness. This encompasses support for working families, which may include backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, and paid caregiver leave. To encourage your personal growth, we also offer a variety of training programs, professional development resources, and opportunities to participate in mentorship programs, employee resource groups, volunteer activities, and much more. For details, visit https://www.virtualfairhub.com/cencora Full time Equal Employment Opportunity Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law. The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory. Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email hrsc@cencora.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned Affiliated Companies Affiliated Companies: AmerisourceBergen Services Corporation Cencora is a leading global pharmaceutical solutions company that is committed to improving the lives of people and animals everywhere. We connect manufacturers, providers, and patients to ensure that anyone can get the therapies they need, where and when they need them. We’re a purpose-driven organization, where all of our team members around the world are united in our responsibility to create healthier futures. We work together every day to help our partners bring their innovations to patients worldwide, creating unparalleled access and impact at the center of health. Recruitment scams are on the rise and the intent is to target individuals looking for employment opportunities. To protect yourself, we urge you to be vigilant and follow these guidelines. 1.) Research the Company: Thoroughly research any company before applying or sharing personal information, check their website, read reviews, and verify their legitimacy. 2.) Be Wary of Unrealistic Promises: Exercise caution If a job posting offers high salaries and minimal qualifications. Legitimate jobs will have realistic expectations and provide detailed job requirements. Jobs at Cencora can be found on Cencora.com/careers 3.) Guard Your Personal Information: Only share sensitive information after vetting the employer’s credibility. Avoid sharing your Social Security number, bank account details, or identification documents during the application process. Cencora does not request this information as part of the employment application. 4.) Avoid Upfront Payments: Legitimate employers do not require payment during the hiring process. Be suspicious if you are asked to pay for training materials, processing fees, or background checks before securing a job offer. Cencora will never ask you for payment information during the hiring or onboarding process. 5.) Verify Communication Channels: Scammers often use free email services or chat platforms without providing an official company contact information. Cencora recruiters will have an email address ending in @cencora.com, @alliance-healthcare.net, @alliance-healthcare.co.uk, alliance-healthcare.fr or alliance-healthcare.ro Remember to stay vigilant and informed about common scam tactics to reduce the risk of falling victim to fraudulent employment schemes. If you believe you have encountered a job scam posing as a Cencora opportunity, please report it immediately to: GlobalTalentAcquisition@Cencora.com