Database Administrator # JN -012021-59228

Cleveland, Ohio
Industry: Database Developer
Job Number: JN -012021-59228

Top Must-Have Skills / Candidate Requirements:

  • MongoDB version 3.6+
  • Expert Experience utilizing MongoDB Ops Manager
  • Experience building and supporting a MongoDB Ops Manager environment
  • Advanced MMS configuration experience, configuring and monitoring replica sets, optimizing database/query performance
  • Expert Experience configuring sharding, monitoring, and identify the proper/optimal shard key
  • Experience Performing Security measures, backups and restore backups
  • User Management – creating users, assigning roles, managing permissions, etc.
  • Experience implementing and supporting LDAP authorization and authentication with MongoDB
  • Experience supporting MongoDB databases scaled across data centers
  • Experience supporting MongoDB Shards
  • Experience with Pearl, Bash and/or Java scripting
  • Experience with backup and restore of MongoDB databases using LVM snapshots and Ops Manager backups
  • In-depth understanding of MongoDB HA strategies, including replica sets
  • Experience in writing MongoDB Schema using Mongos
  • Experience with setting and tuning MongoDB system parameters


Degrees/Certifications/Years of Overall Experience Required:

  • 5-7+ years’ experience in design and implementation of complex distributed systems architectures
  • MongoDB experience is most importance
  • Experience is more important than degrees


Day to Day Responsibilities:

Typical work-related activities include:

  • Install, patch, upgrade, configure, tune and maintain
  • Ability to Support Production 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 MongoDB 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


Summary:

  • Responsible for coordinating changes to computer databases, test and implement the database applying knowledge of database management systems. Responsible for planning, coordinating and implementing security measures to safeguard the computer database


Education/Experience:

  • High School Degree and 2 year technical degree in computer programming or equivalent training required. Bachelor degree preferred. 8+ years experience required


Skills and Competencies:

  • Verbal and written communication skills, problem solving skills, customer service and interpersonal skills. Strong ability to work independently and manage one’s time. Strong knowledge of computer software, such as SQL, Visual Basic, Oracle, etc.


Major Job Duties and Responsibilities:

  • Direct programmers and analysts to make changes to existing databases and database management systems. Direct others in coding logical and physical database descriptions
  • Review project requests describing database user needs to estimate time and cost required to accomplish project. Review and approve database development and determine project scope and limitations. Approve, schedule, plan and supervise the installation and testing of new products and improvements to computer systems
  • Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information. Perform other duties as assigned



Apply Online Apply Later