Database Administrator II-3DKTM
Database Administrator II
Provide Relational Database Management System (RDBMS) (Oracle/SQL Server) support to applications supported by assigned department. Works with Application Teams, Team Leads and fellow Database Administrators to design and specify RDBMS solutions based on standard offerings to support the development of new or enhancement of existing applications. Acts as a principal RDBMS solution designer for small to medium (size/risk) RDBMS efforts of including business critical applications, effectively using analytical skills, technical skills, available technology and tools while developing stronger analytical skills, technical skills, and understanding of available technology and tools. Assists, under supervision, on larger (size/risk) projects.
Complete and oversee small to medium size/risk database analysis, design and development efforts.
Develop plans for database implementation, data source integration and data archiving and recovery.
Manage, direct, oversee and/or review execution of small to medium size and/or risk project plans on assigned applications and ensure complete understanding of tasks and dependencies and mitigation of issues.
Contribute to small to medium size/risk technical projects or business issues requiring state of the art technical or industry knowledge.
Maintain a functional understanding of supported applications. Maintain a current understanding of the business environment supported to provide expert guidance for technical, business and operational impacts associated with a project or production problem.
Recommend RDBMS designs based on business requirements, technology roadmap and RDBMS functionality knowledge of interfacing technology and clear understanding of customer expectations.
Evaluate and understand complex interrelationships and effects among RDBMS, interfacing applications and operating systems.
Prepare thorough and clear technical specifications and update systems, standards and RDBMS process documentation.
Prepare and review assessments to include required tasks, estimated time frames and effort for small to medium size/risk scope project.
Build positive client relationships by addressing client needs in a manner that safeguards their business and customers, with minimal complexity, risks and costs.
Build rapport within the organization and across other technical teams.
Maintain a current understanding of the business environment supported to provide expert guidance for technical, business and operational impacts associated with a project or production problem.
Assist with coordination of annual disaster recovery exercises and remediate issues.
Assist others on project execution and production support for all applications and project sizes.
Work with internal and external application and technology stakeholders to review status of initiatives, compliance/regulatory changes, planned or potential vendor changes and contractual and/or system maintenance changes.
Ensure identification and resolution of issues and concerns related to discretionary enhancement requests, application reliability changes and/or production problem resolution.
Provide functional feedback to internal application owners and technology stakeholders on current or proposed RDBMS to extent it supports predefined business needs.
Identify performance and effectiveness enhancement opportunities and recommend new policies and procedures that support improvement.
Participate in ADBS Center of Excellence teams’ goals and deliverables.
Understand and adhere to the Company’s risk and regulatory standards, policies and controls in accordance with the Company’s Risk Appetite. Identify risk-related issues needing escalation to management.
Promote an environment that supports diversity and reflects the M&T Bank brand.
Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.
Complete other related duties as assigned.
Nature & Scope:
The job holder works under supervision of a Technology Manger and is responsible for achieving a consistent and sound degree of technical RDMS knowledge and contributing to solution design and departmental strategies. Responsibilities of the position may include problem resolution, systems development and day-to-day activities. The position provides backup to more experienced personnel as required. The job holder may be called upon to serve as a technical representative on committees, ad-hoc projects, etc. The position interacts, on a regular basis with Technology staff and application teams.
Associate’s degree and a minimum of 4 years’ RDBMS experience, or in lieu of a degree, a combined minimum of 6 years’ higher education and/or work experience, including a minimum of 4 years’ RDBMS experience
Proficiency with RDBMS tools and functions
Prior experience working on multiple small to medium projects of low to medium complexity/risk
Experience contributing to system and RDBMS enhancements, conversions and production problem resolution
Experience working with leads and others to connect disparate ideas into cohesive solutions
Strong problem-solving skills
Good verbal and written communication skills
Strong analytical skills
Good decision-making skills
Good organizational and time management skills
Good lateral thinking skills
Good presentation skills
Minimum of 2 years’ experience with Bank applications, framework, business needs and RDBMS direction and framework
Exposure to the Bank’s standards, business plan and strategic objectives
Strong RDBMS project analysis, design, development, troubleshooting and tuning efforts
Proficient understanding of single RDBMS skills, tools and functions with strong knowledge of operating systems
Previous experience in banking RDBMS support
Ability to understand businesses supported and their terminology
Ability to encourage team work
Ability to understand technical, business and operational impacts of a project or problem
We encourage candidates with relevant military experience to apply.
Primary Location: New York-Cheektowaga-Appletree
Job Field: Information Technology
Job Posting Sep 21, 2018, 10:23:00 AM
Unposting Date Ongoing