CDW
true

Sr. Database Administrator MongoDBat CDW Careers

Sales Support image

Job ID: 21000097
Updated: Jan 12, 2021
Location: Vernon Hills, IL, United States

The Senior Information Administrator deploys and maintains high performing database environments. This role collaborates with infrastructure, IT development, and business partners to design, build, and tune databases that support CDW business objectives. In addition, the Sr. IBA serves as the subject matter expert for junior members of the team and shares best practices and design. This role is guided by relational data modeling design and implementation methodology.


The Senior Database Administrator (MongoDB) deploys and maintains high performing database environments. This role collaborates with infrastructure, IT development, and business partners to design, build, and tune databases that support CDW business objectives. In addition, the Sr. DBA serves as the subject matter expert for junior members of the team and shares best practices and design.



Key Areas of Responsibility

  • Review database code and objects for standards as part of application code reviews.
  • Collaborate with application teams to develop and document database standards.
  • Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support.
  • 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.
  • Lead Data Modeling tasks on large, complex projects as well as review and support application development on designs of data models for other medium size projects.
  • Create and maintain backup plans using various backup toolsets. Collaborate with infrastructure teams and the Database Architect on determining and documenting the optimal backup policies and strategies.
  • 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 the security policies and procedures and ensures that the databases are in compliance with IT Audit policies. This includes any data cleansing routines or managing any 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.
  • Capacity planning of server hardware with assistance from 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.
  • Serve as the lead contributor to the development and maintenance of internal process and policy documentation.
  • Mentor and coach junior team members.
  • Identify areas of opportunity and recommend appropriate improvement suggestions.

Other Responsibilities

  • 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

  • 5 years experience in database maintenance, design, SQL coding/tuning, NoSQL document database administration.
  • 1 year experience with structured methodologies and participation in design and development of large-scale applications in a distributed computing environment.
  • Bachelor of Science in Computer Science, or equivalent working knowledge/experience.

Required Qualifications

  • Excellent written and verbal communication skills with the ability to effectively interact with all stakeholders.
  • 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.
  • 3+ years of daily, hands on experience with MongoDB as a DBA
  • Proficiency with Ops Mgr, Compass, Studio3T
  • Stood up at least one MongoDB ecosystem from scratch
  • Led at least one successful upgrade of a production MongoDB platform

Preferred Qualifications

  • Understanding of object-oriented design and programming techniques.
  • Background in leading medium to large size projects and implementation.
  • Microsoft SQL Server administration
  • Oracle database administration
  • 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

Rev 03162020

Job Category: Corporate IT
Job Type: Full-Time

Connect with