CDW
true

Database Administrator-Mongo DBat CDW Careers

Sales Support image

Job ID: 21000699
Updated: Feb 20, 2021
Location: , United States

The Database Administrator designs, deploys and maintains high performing, high availability, secure database environments of varying types including relational and NoSQL that support CDW business objectives.

The Database Administrator (Mongo DB) deploys and maintains high performing environments. This role collaborates with infrastructure, IT development, and business partners to design, build, and tune databases that support CDW business objectives.

 

Key Areas of Responsibility

  • Monitor and resolve database system alerts and issues in a timely manner including during on-call support duty outside regular business hours. 
  • Review database code and objects submitted by developers to ensure standards are met and make recommendations to improve overall performance, quality, and stability. 
  • Deploy database code and objects through non-production (development, quality assurance, etc.) and production systems, troubleshoot deployment problems, and rollback if needed. 
  • Perform server/database health checks, make recommendation, coordinate and implement changes. 
  • Database related troubleshooting, configuration, and performance tuning. 
  • atch and upgrade database software, databases, and tools. 
  • Migrate data or databases to new databases, servers or database platforms. 
  • Refresh non-production data sets with production data for application development and testing purposes. 
  • Perform database backups and restorations. Create and maintain backup plans using various backup toolsets. Work directly with infrastructure teams on backup policies and strategies. 
  • Maintain strong database security in line with security policies and procedures. Ensure that database systems are in compliance with IT security and audit policies. This includes any data cleansing routines or managing any 3rd party encryption toolsets on the various database platforms. 
  • Use database vendor provided tools as well as 3rd party applications. 
  • Contribute to development and maintenance of internal database services processes, policies, standards and best practices in close collaboration with application development, architects and other stakeholders. 
  • Help research and recommend proper architecture, database types, server design, database design, and other specifications for applications. 
  • Create and maintain technical diagrams, work flows, documentation, etc. 
  • Communicate with stakeholders to keep them well informed, understand their perspectives/requirements and allow them to participate in the decision-making process. 
  • Teach others and share knowledge in a positive, effective way. 

Other Responsibilities

  • Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support. 
  • Review and deploy database objects via scripts provided by development.  This includes tables, procedures, triggers, indexes and data manipulation statements. 
  • Collaborate with the Database Architect on determining security policies and procedures and ensures that the databases are in compliance with IT Audit policies.  This includes any data cleansing routines or managing 3rd party encryption toolsets on the various database platforms. 
  • Install and test database software and support tools as well as service packs and support patches.  Develop and maintain standard procedures for installs and work to automate the process. 
  • Participate in capacity planning of server hardware with assistance form System Engineering based on project specifications and documented best practices.  Collaborate with storage engineers on disk capacity projects to ensure proper purging and space allocation metrics are met. 
  • With the database architect, help evaluate and decide the applicability of MongoDB or other database technologies for newly proposed applications/solutions. 
  • With the database architect, help design and right-size database environments. 
  • Collaborate with the database architect and application developers to develop and maintain modern database code and operational standards. 
  • Install and configure database software in multi-node environments. 
  • Design and implement proper security, monitoring and alerting to optimize performance and minimize outages. 
  • Deploy database objects across various environments (i.e., DEV, QA, PROD). 
  • Use database vendor provided tools as well as 3rd party applications to performance tune an entire database system, specific queries and, applications scenarios as presented by the application teams. 
  • Restore/refresh database objects and data from backup as needed

Education and/or Experience Qualifications

  • Bachelor's degree in Computer Science, or equivalent knowledge or experience 
  • 3 years of IT experience in an application administration or software support role 

Required Qualifications

  • 2+ years of daily, hands on experience using MongoDB in a DBA role.
  • Proficiency with Ops Mgr, Compass, and Studio3T.
  • Experience architecting/standing up at least one MongoDB ecosystem from scratch.
  • Experience upgrading of a multi-environment, multi-node Mongo DB ecosystem.
  • Strong communication skills, both written and verbal. Ability to target messages to different stakeholders and distill complex technical concepts in a way that is simple and easy to understand.
  • Linux/Unix knowledge including management and commands related to memory, CPU, performance, disks, file structure/size, user/group security, searching files/sizes/dates/ownerships, systemmctl, log rotation, install/update packages, crontab for scheduling jobs.
  • Bash scripting for automation, administration, reporting, monitoring.
  • Strong organizational and creative problem-solving skills with the demonstrated ability to be resourceful.
  • History of balancing priorities with the ability to adapt to the changing needs of the business while meeting deadlines.
  • Advanced working knowledge of the software development life cycle.
  • Demonstrated ability to build and maintain productive cross-functional working relationships.
  • Strong analytical skills with critical attention to detail.
  • Proficient in Microsoft Office applications.

Preferred Qualifications

  • Experience or knowledge of other database platforms, particularly SQL Server, Oracle, MySQL, or PostgreSQL.
  • MongoDB schema design.
  • Application Development experience (preferably using .NET) and writing database scripts.
  • Good understanding of DevOps and the role of database administration teams in DevOps.
  • Cloud based technologies as related to database technologies (Mongo Atlas, Azure, etc.).
  • Understanding of object-oriented design and programming techniques.
  • Background in leading medium to large size projects and implementation.
Job Category: Corporate IT
Job Type: Full-Time

Connect with