$100K - $150K(Ladders Estimates)
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.
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.
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.
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.
Valid Through: 2019-10-17