SysTechCorp Inc · 4 months ago
Database Architect (Database Modeler/Developer)
Hamilton, NJ
Contract
Onsite
Senior LevelSysTechCorp Inc is seeking a senior Database Architect to design, develop, and implement highly-complex, reliable, and scalable databases. The role involves collaborating with software developers and system administrators to ensure database performance and integrity while also consulting with clients to address their data needs.
Artificial Intelligence (AI)BlockchainSaaSSoftwareWeb Development
Responsibilities
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
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
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
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
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
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
Design the DB deployment strategy, DB maintenance across the environments Required
Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application Required
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
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
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 upto-date by implementing data quality and data validation rules. Nice to have
Automate regular processes, track issues, and document changes Nice to have
Qualification
Required
Immediate Interview for qualified resource
This is a development position for a Database Modeler/Developer
Designs, develops, and implements highly-complex, reliable, and scalable databases to meet the organization's objectives and requirements
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
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
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
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
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
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
Design the DB deployment strategy, DB maintenance across the environments
Experience with Windows server, including Active Directory
Should be able to manage users, user access strategies integrated with the application
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
Preferred
Experience in designing and implementing solutions for managing data in the cloud
Experience in working on AWS RDS will be an advantage
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 upto-date by implementing data quality and data validation rules
Automate regular processes, track issues, and document changes
Company
SysTechCorp Inc
SysTechCorp Inc provides leading-edge technology services that empower our clients to meet and exceed their strategic business objectives.
Founded in 2019
201-500 employees
H1B Sponsorship
SysTechCorp Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (45)
2024 (50)
2023 (71)
2022 (49)
2021 (60)
2020 (97)
Funding
Current Stage
Growth StageLeadership Team
Praveen Aleti
COO Global Operations
Company data provided by crunchbase