See more Collapse

SQL Database Administrator

2 months ago


Buffalo, United States ValiantiQ Inc Full time

Client: M&T Bank

Job Title: SQL Database Administrator (DBA) III

Location: Remote (EST or CST open to working EST only)

Duration: 12+-Month Contract



NOTES FROM MANAGER:

1). In the main we’re looking for well-rounded SQL Database Admins – preferably with some exposure/capability in PowerShell or Ansible, though these particular roles will be more focused on providing BAU support.

2). They should have good to excellent understanding of base database concepts like recovery, HA (AlwaysOn in particular, both the building and the debugging of) Solid basic understanding of core infrastructure concepts.

3). Basic understanding of performance debugging, though this isn’t a focus of the role.

4). Always a plus if they have experience with Azure SQL or other commercial RDBMS software (we run/support Oracle, DataStax Cassandra, Azure PostGres, Azure SQL, Azure Cosmos Cassandra).



DESCRIPTION/OVERVIEW:
Provides Relational Database Management System (RDBMS) support to applications supported by assigned department. Works with Application Teams, Team Leads and other Database Administrators to design and specify RDBMS solutions based on standard offerings to support development of new or enhancements of existing applications. Serves as principal RDBMS solution designer for small to large/complex (size/risk) application projects, including business critical applications, using analytical skills, technical skills, available technology and tools. Serves as Subject Matter Expert (SME) for RDBMS-related initiatives, discretionary projects, compliance/regulatory requirements and system changes for Application Database Services (ADBS) supported applications and department-wide initiatives.

PRIMARY RESPONSIBILITIES:
Provide technical leadership.
Complete and oversee basic to complex 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 large size/risk project plans on assigned applications and ensure complete understanding of tasks and dependencies and mitigation of issues.
Contribute to advanced, complex technical projects or business issues requiring state-of-the-art technical or industry knowledge.
Maintain a strong 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, 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.
Provide highly analytical consulting and leadership in identifying and implementing new uses of database technologies to assist business units in meeting strategic objectives.
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 large 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.
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.
Identify new technology that increases technical support efficiency and effectiveness.
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.

SCOPE OF RESPONSIBILITIES:
The job holder works under supervision of a Technology Manager and is responsible for maintaining a strong degree of technical RDMS knowledge and contributing to solution design, departmental strategies and resource allocations of the department. Responsibilities of the position may include problem resolution, systems development and day-to-day activities. This position assumes responsibility for contributing to the growth and development of less experienced personnel. The position delivers small group training/brown bag to increase team proficiency and technical development and 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 and leadership, as well as vendors.

EDUCATION AND EXPERIENCE REQUIRED:
Associates degree and 6 years RDBMS experience, or in lieu of a degree, a combined minimum of 8 years higher education and/or work experience, including a minimum of 6 years RDBMS experience.
Proficiency with RDBMS tools and functions.
Prior experience working on multiple small to large projects of low to high complexity.
Experience working with large system and RDBMS enhancements, conversions and production problem resolution.
Experience working with others to connect disparate ideas into cohesive solutions.
Excellent problem-solving skills to assist in issue resolution.
Strong verbal and written communication skills.
Excellent analytical skills.
Excellent decision-making skills.
Strong organizational and time management skills.
Strong lateral thinking skills.
Good presentation skills.

EDUCATION AND EXPERIENCE PREFERRED:
Bachelor’s degree.
Minimum of 3 years’ experience with Bank applications, framework, business needs and RDBMS direction and framework.
Exposure to the Bank's standards, business plan and strategic objectives.
Capable of mentoring and leading RDBMS project analysis, design, development, troubleshooting and tuning efforts.
Mastery level understanding of single RDBMS skills, tools and functions with strong knowledge of operating systems.
Previous experience in banking RDBMS support.
CAPPM experience.
Ability to understand businesses supported and their terminology.
Ability to encourage team work and serve as role model.
Ability to understand technical, business and operational impacts of a project or problem.

***For immediate response please send resume to agautam@valiantiq.com***


We have other current jobs related to this field that you can find below


  • Buffalo, United States Imagine Staffing Technology Full time

    Job DescriptionJob DescriptionJob ProfileJob TitleSQL Database AdministratorLocationBuffalo, NY/RemoteHire TypeContingent Hourly$40.92 - $68.19 Work ModelRemoteContact Phone(716) 256-1267Contact Emailbfesmire@imaginestaffing.net Nature & Scope:Positional OverviewAre you a meticulous Database Administrator looking for your next exciting challenge? Join...

  • Salesforce Developer

    2 weeks ago


    Buffalo, United States Virtusa Full time

    Description Salesforce Developer / Admin Mandatory Skills Salesforce SQL or SOQL or related Database Experience and APEX Apex Certified Salesforce Administrator and or Certified App Builder Javascript Bachelor Degree in Information Systems or Computer Science or Information Technology or Related Field Visualforce Experience with the Salesforce Platform,...


  • Buffalo, United States SaveonSP Full time

    Summary: The Senior Salesforce Administrator will provide support to the organization through the customization and configuration of the Salesforce platform and assist in the ongoing development of our Salesforce.com deployment. The Salesforce Administrator will work closely with departmental leaders, organizational units, and subject matter experts to...


  • Buffalo, United States SaveonSP Full time

    Summary: The Senior Salesforce Administrator will provide support to the organization through the customization and configuration of the Salesforce platform and assist in the ongoing development of our Salesforce.com deployment. The Salesforce Administrator will work closely with departmental leaders, organizational units, and subject matter experts to...


  • Buffalo, United States GCR Technical Staffing Full time

    Job DescriptionJob DescriptionThis role may be remote if the selected candidate is on the East Coast, must be within driving distant of the client. Some onsite work may be required in the future.Work hours are typical 8:00 a.m. to 5:00 p.m.As the Atlassian /JIRA Administrator, you will be part of a tight-knit administration team that provides administration...


  • Buffalo, United States GCR Technical Staffing Full time

    Job DescriptionJob DescriptionThis role may be remote if the selected candidate is on the East Coast, must be within driving distant of the client. Work hours are typical 8:00 a.m. to 5:00 p.m.As the Atlassian /JIRA Administrator, you will be part of a tight-knit administration team that provides administration and support for Data Center Bamboo, Bitbucket,...


  • Buffalo, United States The Prevention Council of Erie County Full time

    Job DescriptionJob DescriptionSummary of Duties: The Fiscal and Administration Manager is responsible for services and activities related to bookkeeping and accounting management, including but not limited to maintaining accounts payable/accounts receivable, and financial reporting. Additionally, responsible for the agency’s human resources and program...


  • Buffalo, United States Adbakx Full time

    Role: Production Support SpecialistLocation: Buffalo, NYType of Employment: Full TimeJob Description: We are seeking a skilled Production Support Engineer with expertise in PHP to join our dynamic team. In this role, you will be responsible for maintaining and supporting production environments, ensuring the smooth operation of our web applications, and...


  • Buffalo, United States Adbakx Full time

    Role: Production Support SpecialistLocation: Buffalo, NYType of Employment: Full TimeJob Description: We are seeking a skilled Production Support Engineer with expertise in PHP to join our dynamic team. In this role, you will be responsible for maintaining and supporting production environments, ensuring the smooth operation of our web applications, and...


  • Buffalo, United States Mirion Technologies (Conax Nuclear), Inc Full time

    Job DescriptionJob DescriptionThe Administrative Assistant will provide comprehensive support to the Management Team while also taking on specific duties related to quality control and engineering documentation. This role requires a detail-oriented individual who can manage office tasks and contribute to the maintenance of quality standards and engineering...


  • Buffalo, United States Mirion Technologies (Conax Nuclear), Inc Full time

    Job DescriptionJob DescriptionThe Administrative Assistant will provide comprehensive support to the Management Team while also taking on specific duties related to quality control and engineering documentation. This role requires a detail-oriented individual who can manage office tasks and contribute to the maintenance of quality standards and engineering...


  • Buffalo, United States Mirion Technologies (Conax Nuclear), Inc Full time

    Job DescriptionJob DescriptionThe Administrative Assistant will provide comprehensive support to the Management Team while also taking on specific duties related to quality control and engineering documentation. This role requires a detail-oriented individual who can manage office tasks and contribute to the maintenance of quality standards and engineering...


  • Buffalo, United States The Prevention Council of Erie County Full time

    Job DescriptionJob DescriptionBenefits:Dental insuranceHealth insurancePaid time offSummary of Duties:The Fiscal and Administration Manager is responsible for services and activities related to bookkeeping and accounting management, including but not limited to maintaining accounts payable/accounts receivable, and financial reporting. Additionally,...


  • Buffalo, United States The Prevention Council of Erie County Full time

    Job DescriptionJob DescriptionBenefits:Dental insuranceHealth insurancePaid time offSummary of Duties:The Fiscal and Administration Manager is responsible for services and activities related to bookkeeping and accounting management, including but not limited to maintaining accounts payable/accounts receivable, and financial reporting. Additionally,...


  • Buffalo, United States Community Foundation for Greater Buffalo Full time

    Job DescriptionJob DescriptionPOSITION SUMMARYThe Giving Strategies Administrative Assistant is a member of the Giving Strategies team. This position is supervised by and primarily provides administrative support to the Associate Vice President, Client Relations and Communications. They also support the Giving Strategies and Communications Teams.A successful...

  • IT Engineer

    2 weeks ago


    Buffalo, United States DCM Staffing Full time

    Play a contributing role in a growing WNY law firm’s innovation technology solutions and enhance its robust IT infrastructure. In this role, you will be responsible for the administration, maintenance, and troubleshooting of Windows Servers, specifically Citrix and VMware platforms. Prior experience with cloud technologies such as Microsoft Azure, Entra,...


  • Buffalo, United States JMS Technical Solutions, Inc. Full time

    Our client Buffalo, NY, is seeking a highly skilled Power Platform Developer to join their team on a 3-month consulting project. This is a remote/ full-time/3-month contract positionHourly based on experience: Up to $80/hrJob Description:Power Automate: Proficiency in creating, managing, and optimizing automated workflows and processes.Power Platform:...


  • Buffalo, United States JMS Technical Solutions, Inc. Full time

    Our client Buffalo, NY, is seeking a highly skilled Power Platform Developer to join their team on a 3-month consulting project. This is a remote/ full-time/3-month contract positionHourly based on experience: Up to $80/hrJob Description:Power Automate: Proficiency in creating, managing, and optimizing automated workflows and processes.Power Platform:...


  • Buffalo, United States Christian Career Full time

    Job DescriptionJob DescriptionAdministrative Coordinator - MissionGOJob Title: Administrative CoordinatorDepartment: Communications and Administrative ServicesReports to: Director, Communications and Administrative ServicesSalary Range: Salary Commensurate with ExperienceLocation: Buffalo, New YorkMinistry FocusSince MissionGO is a Christian mission...


  • Buffalo, United States Child & Family Services of Erie County Full time

    Job DescriptionJob DescriptionPosition Summary: The Administrative Supervisor coordinates and performs administrative support services for the Family Preservation and Foster Care programs and is responsible for the overall smooth functioning of Child and Family Services 844 Delaware site. Family Preservation programs help families navigate behavioral...