DirectViz Solutions, LLC
  • Monterey, CA, USA
  • Salary
  • Full Time

DirectViz Solutions (DVS), is a high-level, strategic consulting services firm that meets mission IT needs for government clients. We are looking to hire a fulltime Database Administrator (DBA). The work location will be Monterey, California. This positions requires US citizenship.  

 

Responsibilities:

-Design, enhance and maintain databases. Monitor and improve database performance and capacity of existing enterprise database systems (Microsoft SQL Server, Oracle, and MySQL). Monitor database performance and plan for future expansion of database systems, as well as manage and maintain all production and non-production databases.

-Ensure that database systems are safeguarded and implement necessary security measures to ensure data integrity. The Contractor shall be responsible for controlling privileges and permissions to databases and for standards and design of physical data storage, maintenance, and access and security administration.

-Create or modify database objects and/or write SQL code in support of application developers as specified in the NPS JIRA issue tracking system.

-Perform data integration by creating or modifying Extract-Transform-Load (ETLs) of data using tools such as Microsoft SQL Server Integration Services (SSIS) and/or Pentaho Kettle.

-Perform fiscal year changeover activities in the financial management system database (i.e., the Kuali Financial System (KFS) database). The primary activities for fiscal year changeover shall be accomplished during the month of October. These activities primarily consist of taking data provided by the KFS functional team and performing data integration tasks.

-Assist with upgrading KFS database for one new version release. Specifically, the Contractor shall migrate the current KFS database to the new version, to include customizations NPS has made to the database.

-Perform database server migrations in order to replace outdated or under-performing database servers.

-Manage the configuration and automation of Amazon Web Services (AWS) database servers including the planning and coordination of migrating on premise database servers to AWS.

-Create a monthly report that provides update on status, work completed, work in progress, short-term goals, and other relevant project information.

 

Requirements:

At least eighteen (18) months of experience in all areas associated with this contract, including database administration of Oracle, Microsoft SQL Server, and MySQL,SQL programming, and technical documentation;

At least eighteen (18) months of experience with Subversion SVN;

At least eighteen (18) months of experience with Microsoft SQL Server Integration Services (SSIS);

At least eighteen (18) months of experience with Pentaho Kettle;

At least eighteen (18) months of experience with the Nagios monitoring system;

Moderate understanding and experience with T-SQL query development;

At least six (6) months of experience with administration of Amazon Web Services;

At least six (6) months of experience with writing AWS CloudFormation templates in JSON or YAML

 

Certifications: Security+ CE required

 

DirectViz Solutions, LLC provides equal employment opportunity to all individuals regardless of race, color, creed, religion, gender, age, sexual orientation, national origin or ancestry, disability, genetic information, veteran status, gender identification or any other characteristic protected by state, federal or local law.

DirectViz Solutions, LLC
  • Apply Now

    with our quick 3 minute Application!

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Follow Jobs:
  • Follow Our Jobs On Facebook
  • Share This Page
.
logo Home Solutions Clients Partners Contracts Careers About Us