Back to search

DATABASE ANALYST

The Database Developer is responsible for analyzing agency operations, applications, programming, and objectives to determine database structural requirements; Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure in an Agile environment.

  • Fairfax, Virginia, United States
  • Full-time
  • Posted May 20, 2022
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics

Responsibilities

  • Design database applications
  • Develop database design and architecture documentation
  • Plan and install upgrades of database management system software
  • Identify and correct deviations from database development standards
  • Identify and resolve production and application development problems
  • Create and enforce database development standards in an Agile environment
  • Develop or maintain archived procedures, procedural codes, or queries for applications
  • Develop load-balancing processes to eliminate down time for backup processes
  • Develop data models for applications, metadata tables, views or related database structures
  • Develop modeling strategies to ensure that the database is secure, scalable and performs reliably
  • Constantly monitor the database and immediately address database issues and problems

Requirements

  • Bachelors Degree in Computer Science
  • Experience in a Case Management
  • Experience in a State governments

Nice to have: DevOps, CiCD environment, Child Welfare domain

Skills

SQL ServerETLSQLDatabase MigrationData analysisRelational database management systems (RDBMS)Distributed systemsEnterprise data warehouseOLAPOLTPRESTful APIAgile environmentsSQL ServerDB2Oracle

More jobs nearby

Full description

Consideration: 8+ years experience Database Migration experience ETL SQL Server experience Title Sr Database Developer / SQL Developer Location Fairfax, VA Description/Role The Database Developer is responsible for analyzing agency operations, applications, programming, and objectives to determine database structural requirements; Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure in an Agile environment; Should have extensive experience SQL Development Develop database design and architecture documentation for the management and executive teams; Extensive Experience with ETL Extensive experience with Database migrations Plan and install upgrades of database management system software to enhance database performance; Identify and correct deviations from database development standards; Identify and resolve production and application development problems; Create and enforce database development standards in an Agile environment; Develop or maintain archived procedures, procedural codes, or queries for applications; Develop load-balancing processes to eliminate down time for backup processes; Develop data models for applications, metadata tables, views or related database structures; Develop modeling strategies to ensure that the database is secure, scalable and performs reliably; The Database Developer will be responsible for constantly monitoring the database and immediately addressing database issues and problems; " Minimum Qualifications 7-10+ years’ experience Bachelors Degree in Computer Science Five (5) years of experience in data analysis or the design and development of relational database management systems (RDBMS) such as SQL, DB2, and Oracle on projects related to Case Management; 2+ years of Database Migration experience Must have extensive experience in ETL Must have proven ability to work in distributed systems; Must have a minimum of 2 years of experience in developing and implementing an enterprise data warehouse; Must have a minimum of 2 years of experience with OLAP and OLTP; Must have experience developing and implementing a RESTful API for a relational database; Two (2) years of experience in developing and implementing software in Agile environments. " Preferred Skills 2/3 years working with State governments Experience in DevOps and CiCD environment Experience in Child Welfare domain

DATABASE ANALYST at Creative Information Technology, Inc. | Referso Jobs