DHS - DFD - Database Architect

Designs, develops, and implements highly-complex, reliable, and scalable databases to meet the organization s objectives and requirements. This is a development position for a Database modeler / developer.

The Database Architect is responsible for designing, developing, and implementing infrastructure to provide highly-complex, reliable, and scalable databases to meet the organization s objectives and requirements. Familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks with minimal or no direct supervision. Assists in defining system and application architecture and provides vision, problem anticipation, and problem-solving ability to an organization. Consults with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.

PREFERRED QUALIFICATIONS : Extensive knowledge of specific database systems and capable of hands-on work in all phases of database design and management. Experience in various technologies and roles including database systems of any type and size.

• PLEASE INCLUDE JOB DETAILS, TASKS, AND RESPONSIBILITIES SPECIFIC TO THIS REQUISITION

LEASE note : This position will continue for an extended period of time well beyond the end date.

Only submit candidates that will interview round one in person only.

1 Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes Required

2 Work closely with software developers, system administrators to ensure that databases meet performance and scalability requirements. Analyzing an organization's data needs, identifying the most appropriate database systems, designing and implementing database structures, and ensuring data security and integrity. Required

3 Analyst should have experience in Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development, and performance tuning with the Reporting tool Microsoft Power Bl Stack experience Required

4 Experience in DB migration project (Oracle to SQL) with Understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options for SQL Server Required

5 Design the DB deployment strategy, DB maintenance across the environments Required

6 Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application Required

7 Focus on designing and maintaining data warehouses, with large-scale repositories of data used for analysis and reporting. Work closely with data analysts and business intelligence professionals to design data models and create efficient queries for extracting data. Required

8 Associate should have experience in designing and implementing solutions for managing data in the cloud. Experience in working on AWS RDS will be an advantage Nice to have

9 Ensuring data security and integrity, associate should be able to ensure that the data is secure and protected from unauthorized access or modification. Able to implement security protocols such as encryption, access controls, and data backup and recovery procedures. Also ensure that the data is accurate, consistent, and up to-date by implementing data quality and data validation rules. Nice to have

10 Automate regular processes, track issues, and document changes Nice to have

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

Ensure databases are production- Required ready with rigorous testing, performance validation, and best practices for high availability and disaster

Required

Years

Work independently, with minimal Required support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance

Required

Years

Designand develop database systems that are efficient, scalable, and secure.Hands-on experience in building new relational data models, tables, views

Required

Years

Design the DB deployment strategy, DB maintenance of all environments

Required

Years

DB migration project (Oracle to SQLSerrver) with understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options

Required

Months

Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development

Required

Years

Knowledge / Experience in developing, hosting & managing databases on AWS RDS.

Required

Years

Implements security protocols such as encryption, access controls, and data backup and recovery procedures.

Required

Years

Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application

Required

Years

Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application

Required

Years

Design DB deployment strategy across the environments, experience with version control systems and Cl / CD pipelines for DB changes

Required

Years

Questions

Question

Question1

Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement?

Question2

What is your candidate's email address?

Question3

Where does your candidate currently reside (City & State)?

Question4

If your candidate resides more than 1 hour from the Client site, will your candidate relocate for the position?

Question5

Is your candidate available for a Round 1, in-person interview?

Question6

Do you agree to the maximum hourly Vendor Rate of $$$(excluding the Efficiency Fee)?

Question7

Is the candidate available to work onsite immediately upon start?

Question8

All candidates must reside within commutable distance to the client site in Hamilton, NJ - is that understood?