Senior DBA (MongoDB & MS SQL) - 3629

MSI is seeking a Senior DBA (MongoDB & MS SQL) to support our government client in Bethesda, MD


Job Description:

 Our government client has an opportunity for a Sr. Database Administrator (Sr. DBA w/ MongoDB and MS SQL) to join our program in support of the NIH’s Clinical Center.  We are open to selecting resources who understands the importance of high productivity development and production DBA responsibilities, delivering top quality service that our NIH client has come to expect.  On this program, our government client helps support the data warehouse that contains clinical research data collected as far back as 1976 on over 500,000 patients.  

This is a full time position and will be based at the NIH customer site off Democracy Blvd.  Work schedule is flexible Monday through Friday around core business hours.

Sr. DBA w/ MongoDB and MS SQL whom administers database technologies and systems is responsible for backup, recovery, server architecture, performance tuning, security, auditing, metadata management, optimization, statistics, capacity planning, connectivity and other data solutions of mission critical database systems. Develops databases with SQL, stored procedures, triggers, applying transactional modeling, dimensional modeling, normalization, indexing methods, constraints and object usage in both relational and NoSQL databases.

Responsibilities for this Position:

  • Strong experience in Database Administration in MS SQL Server (2014 - 2016)
  • Strong experience in Database Administration in MongoDB
  • Experience in troubleshooting and resolving the following: database integrity issues, performance issues, blocking and deadlocking issues, replication and log shipping issues, connectivity issues, and security issues.
  • Strong knowledge of backups, restores, database mirroring, replication, Change Data Capture
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Effective designing of databases including: logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types
  • Experience with transactional, EAV and Dimensional modeling types
  • SQL Development - ability to write, troubleshoot and optimize SQL code and design ( stored procedures, functions, views, triggers, indexes, constraints )
  • Strong knowledge of how indexes and statistics affect database performance and storage requirements. Including how to create and manage them effectively.
  • Establish query coding standards, naming conventions, & data access policies.
  • Document the client's database environment, processes, & procedures
  • Collaborate with other team members and stakeholders

Additional Responsibilities:

  • Proactive, self-starter, who takes initiative on projects
  • Ability to articulate challenges and creatively solve problems (should be able to give examples of complex projects)
  • Knowledge of encryption at rest and in motion a plus
  • Experience with large database migrations between platforms

Must Have:

  • Bachelor’s degree and 7+ years of professional DBA experience (or equivalent)
  • Experience with transactional, EAV and Dimensional modeling types
  • Extensive experience setting up and administering relational (MS SQL Server) and NoSQL (MongoDB) databases

Nice to Have: 

  • Some Netezza background
  • Experience working in Agile development and operations environment.

 

 MSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin.