Infrastructure Engineer Senior in Columbus, OH

$100K - $150K(Ladders Estimates)

The PNC Financial Services Group, Inc   •  

Columbus, OH 43085

Industry: Finance & Insurance

  •  

5 - 7 years

Posted 56 days ago

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. As an Infrastructure Engineer Senior within PNC's Technology Infrastructure Services organization, you will be based in Pittsburgh, PA, Cleveland, OH, Columbus, OH or anywhere in the PNC footprint.

Job Description

Typical work-related activities include:


Install, patch, upgrade, configure, tune and maintain MySQL databases (current version 5.7.23 and some older ones at 5.7.18)

Troubleshoot critical performance bottlenecks for MySQL databases

Review and assess the impact of database design changes prior to their implementation

Collaborate with other IT teams and Vendors to resolve complex and multi-disciplinary issues

Work independently and represent database group in various projects

Ensure that databases are monitored, maintained, backed up, and available as appropriate.

Manage database security with an adherence to PNC's security policy

Review stress testing results and provide recommendations to development teams

Automate management tasks, streamline processes, and perform standard administrative functions

Mentor, assist, encourage, and serve as a backup to other team members

KNOWLEDGE, SKILLS AND ABILITIES:


Understanding of MySQL's underlying storage engines

Knowledge of de-facto standards and best practices in MySQL

Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Strong knowledge of ODBC/JDBC client/server communication

Automation experience with 'shell' and 'SQL' scripting

Analytical skills necessary to perform troubleshooting of errors and performance issues

Strong verbal and written communication skills

Results-oriented and able to work across the organization as an individual contributor

Ability to work in a rapidly transforming organization

Excellent customer service skills

Interpersonal skills to deal effectively with all business contacts

Technically proficient in assigned IT discipline(s)

Ability to deliver consistent, high quality, cost effective service by handling routine, as well as some non-routine, systems issues

Experience with Oracle 11g, 12c and GoldenGate 13.X a plus.

Work experience with OLTP, OLAP, Staging, and Data warehouse configuration.

Provides expertise on platform engineering, while overseeing the team's effort and meeting customer needs. Uses technical knowledge and industry experience to design, build and maintain technology solutions.

Develops software components and hardware for complex projects; aligns these with business strategies and objectives.

Provides expertise on best practices, standards, engineering approaches and complex technical resolutions for processes.

Places emphasis on quality improvement efforts; ensures that deliverables are secure, scalable and reliable through estimation and correction.

Communicates with customers and integrates their needs with development, to meet business objectives.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:


Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.

Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Competencies

Application Delivery Process – Knowledge of major tasks, deliverables, and formal application delivery methodologies; ability to utilize these in order to deliver new or enhanced applications.

Consulting – Knowledge of techniques, roles, and responsibilities in providing technical or business guidance to clients, both internal and external; ability to apply this knowledge appropriately to diverse situations.

Effectiveness Measurement – Ability to measure the quality and quantity of work effort for the purpose of improvement.

Industry Knowledge – Knowledge of the organization's industry group, trends, directions, major issues, regulatory considerations, and trendsetters; ability to apply this knowledge appropriately to diverse situations.

IT Industry: Trends & Directions – Knowledge of and ability to analyze marketplace experiences, developments and trends related to the function of Information Technology (IT).

IT Standards, Procedures & Policies – Knowledge of and the ability to utilize a variety of administrative skill sets and technical knowledge to manage organizational IT policies, standards, and procedures.

Planning: Tactical, Strategic – Ability to contribute to operational (short term), tactical (1-2 years) and strategic (3-5 years) planning in support of the overall business plan.

Problem Solving – Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply this knowledge appropriately to diverse situations.

Work Experience

Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors (Required)

Valid Through: 2019-10-17