What are the responsibilities and job description for the Database Engineer position at Apex Systems?
Job Details
Job#: 2066118
Job Description:
Description
The Database Engineer will be responsible for understanding of the Consular Systems Modernization (CSM) program technical requirements, architecture of the system, data model, interfaces and applications. As part of the modernization program, the Database Engineer will be responsible for the design, development, installation, and maintenance of database management systems to include data definition, data modeling, design and implementation, security, and monitoring. The Database Engineer will participate in development and solution enhancement activities as part of an Agile development team.
Roles and Responsibilities:
Basic Qualifications:
Bachelors degree and nine (9) years' experience.
At least 5 years of experience with developing relational database management systems (RDBMS) using Oracle, PostgreSQL, MySQL, or Microsoft SQL Server in a production environment.
Proficiency in data analysis tools and programming languages (e.g., SQL, Python, R, etc.).
Strong analytical and problem-solving skills with attention to detail.
Experience with data visualization tools (e.g., Tableau, Power BI, etc.) is a plus.
Experience in software development and maintenance projects with involvement in requirements management, technical design/development, and deployment steps within SDLC.
Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment.
Experience designing database solutions using conceptual, logical, and physical diagrams.
Experience with developing database solutions involving storage of structured and unstructured data, data ingestion via batch and streaming, and ETL processes.
Excellent communication skills, both verbally and in writing.
Ability to work independently and collaboratively in a fast-paced environment.
Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment.
Must have a current, active Secret (or higher) clearance. Interim clearances are acceptable.
Preferred Qualifications:
Experience with enterprise software system modernization efforts.
Experience developing database solutions in an incremental manner using the Agile methodology.
Experience in cloud-based environments including the development of database solutions that are based on a hybrid-cloud architecture.
Experience developing database solutions for high volume, highly available, and secure software system.
Knowledge of machine learning and data mining techniques.
Experience developing database solutions in a secure environment that are required to meet DISA STIG and NIST specifications (security controls).
Knowledge of software development methodologies, practices, and tools.
Ability to work independently and in a team environment.
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Job Description:
Description
The Database Engineer will be responsible for understanding of the Consular Systems Modernization (CSM) program technical requirements, architecture of the system, data model, interfaces and applications. As part of the modernization program, the Database Engineer will be responsible for the design, development, installation, and maintenance of database management systems to include data definition, data modeling, design and implementation, security, and monitoring. The Database Engineer will participate in development and solution enhancement activities as part of an Agile development team.
Roles and Responsibilities:
- Work with the system engineering team to understand customer business needs and priorities.
- Define system and technical requirements, including both functional and non-functional, to support database management system development within the Agile methodology.
- Develop conceptual, logical, and physical designs for database solutions.
- Develop and maintain database solutions for managing structured and unstructured data.
- Develop and maintain database solutions for data ingestion (batch and streaming).
- Develop and maintain database scripts supporting ETL processes and functions.
- Monitor and tune database solutions for optimal performance.
- Develop and maintain secure database solutions that are compliant with DISA STIG and NIST specifications (security controls).
- Develop automated tests that can be incorporated into CI/CD pipeline.
- Support CI/CD initiatives and utilize static code analyzers to ensure high quality source code.
- Author clear documentation for database solutions, including data dictionaries, data catalogs, and design artifacts.
- Integrate database solutions with the software applications and/or platforms.
- Support software testing activities, including IV&V, and provide timely software defect resolutions.
- Monitor production and non-production database solutions for performance and troubleshoot issues as required.
- Provide production and operational support, as needed, to ensure deployed database solutions meet functional and non-functional requirements.
- Develop and maintain backup/restore solutions to support production and non-production database solutions.
Basic Qualifications:
Bachelors degree and nine (9) years' experience.
At least 5 years of experience with developing relational database management systems (RDBMS) using Oracle, PostgreSQL, MySQL, or Microsoft SQL Server in a production environment.
Proficiency in data analysis tools and programming languages (e.g., SQL, Python, R, etc.).
Strong analytical and problem-solving skills with attention to detail.
Experience with data visualization tools (e.g., Tableau, Power BI, etc.) is a plus.
Experience in software development and maintenance projects with involvement in requirements management, technical design/development, and deployment steps within SDLC.
Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment.
Experience designing database solutions using conceptual, logical, and physical diagrams.
Experience with developing database solutions involving storage of structured and unstructured data, data ingestion via batch and streaming, and ETL processes.
Excellent communication skills, both verbally and in writing.
Ability to work independently and collaboratively in a fast-paced environment.
Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment.
Must have a current, active Secret (or higher) clearance. Interim clearances are acceptable.
Preferred Qualifications:
Experience with enterprise software system modernization efforts.
Experience developing database solutions in an incremental manner using the Agile methodology.
Experience in cloud-based environments including the development of database solutions that are based on a hybrid-cloud architecture.
Experience developing database solutions for high volume, highly available, and secure software system.
Knowledge of machine learning and data mining techniques.
- Experience with Git and Jenkins.
- Experience with Docker, Kubernetes, and OpenShift.
- Experience with DevOps and orchestration tools.
- Experience with data preparation frameworks, such as Informatica, Alteryx, Cloudera, MapR, DataBricks.
- Experience with scalable processing frameworks, such as Cloudera, MapR, DataBricks, Spark, Hadoop, RStudio Server.
- Experience with data ingest and orchestration products, such as Informatica BDM and Apache NiFi.
- Experience with data governance frameworks, such as Collibra Data Governance Data Catalog.
Experience developing database solutions in a secure environment that are required to meet DISA STIG and NIST specifications (security controls).
Knowledge of software development methodologies, practices, and tools.
Ability to work independently and in a team environment.
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
