Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 20th Nov 2020
Day to Day Responsibilities:
The Senior MySQL DBA will have responsibility primarily for MySQL database technologies (current version 5.7.26 and some older ones at 5.7.18).
Typical work-related activities include:
Install, patch, upgrade, configure, tune, and maintain MySQL and Oracle databases
Ability to Support Production (24x7) in an on-call environment, as well as non-production systems
Ability to review and implement changes in accordance with PNC Policy and Industry Best Practice
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 cross-platform
Top Must-Have Skills / Candidate Requirements:
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
Hands on experience in Requirement Analysis, Architecture Design, and hardware planning of MySQL database
Strong knowledge of ODBC/JDBC client/server communication
Experience with Monyog / OEM MySQL Monitoring and Compliance is a Plus
Automation experience with ‘shell’ and ‘SQL’ scripting
Experience in high availability and disaster recovery solutions
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
Highly specialized in Performance Tuning, Database Refreshes from Prod to Lower Envs, Oracle Enterprise Manager 12/13c with installation and configuration of emails and alerts.
Experience with implementing Oracle Golden Gate for Oracle 12c/18c as Active/Active configuration. Experience with Oracle 12c, Oracle 18c, and GoldenGate 13.X.
Work experience with OLTP, OLAP, Staging, and Data warehouse configuration.