Database Developer - Jr. Level

Chantilly, VA
Oct 23, 2021
Oct 25, 2021
Full Time
Peraton Overview Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the worlds leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our 22,000 employees do the cant be done, solving the most daunting challenges facing our customers. Responsibilities Designs, develops, builds, analyzes, evaluates and installs database management systems to include database modeling and design, relational database architecture, metadata and repository creation and configuration management. Defines and oversees database organizations, standards, controls, procedures, and documentation. Provides technical consulting in the definition, design, and creation of a data base environment. Advises applications development staff and users on data-based solutions to business problems, data architectures, data base management system facilities and capabilities, and the operation and tuning of data bases. Ensures economic and efficient availability of data within adequate safeguards. Designs and implements databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Uses data mapping, data mining and data transformational analysis tools to design and develop databases. Determines data storage and optimum storage requirements. Prepares system requirements, source analysis and process analyses and design throughout the database implementation.Duties: Identifies business requirements, develops data models, performs data analysis, writes SQL queries, designs and codes stored procedures and performance tunes existing database processes. Designs and develops database objects, stored procedures, views, functions, tables, triggers and SSIS packages; ensures their stability, reliability, and performance. Writes and optimizes SQL statements for data access and retention. Performs regular database management duties including backups and audits to ensure that SQL databases remain accessible, secure, and stable. Tests databases for performance, fine-tune when necessary. Collaborates with developers on database design, query tuning, and schema refinement. Develops business rules that will be implemented in the services layer.Database Developer Tools: PostgreSQL, MongoDB, S3, SCT, DMS, Apache NiFi Qualifications Bachelors degree plus 3 years experience in large migrations, migrating Data Warehouse from multiple locations in existing form, PostgreSQL experience, AWS, Data Modeling, creating proper Data Models and ETL

Similar jobs