Mindlance · 2 weeks ago
Database Architect - Expert
Albany, NY
Full-time
Onsite
Senior Level
$61.80/hr - $66.80/hrMindlance is a company that provides staffing solutions, and they are seeking an Expert Database Architect to work with NYS Information Technology Services on behalf of the NYS Department of Transportation. The role involves designing data infrastructure, collaborating with subject matter experts, and managing the Secure Software Development Life Cycle to ensure quality and compliance in database solutions.
Human Resources
Responsibilities
Interact with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and IT teams to determine and design application and system requirements
Design data infrastructure to extract and organize data for authorized individuals to access
Identify internal and external data sources, collaborating with business subject matter experts to determine their data storage and organizational needs and use the information to create and maintain data infrastructure
Participate in the entire Secure Software Development Life Cycle (SSDLC) including debugging and configuring solution
Identify, recommend and implement ODI/ELT and ETL process and architecture improvements
Assist and verify design of solution and production of all design phase deliverables
Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture
Resolve difficult design and develop issues
Identify bugs when developers are not able to do so
Identify installation solutions for new databases
Determine the requirements for new databases
Publish and/or present design reports
Identifying areas for improvement in current systems
Coordinate with business, vendor and IT team members to reach project milestones and deadlines
Audit database regularly to maintain quality
Create systems to keep data secure
Design and document all components of approved application solutions including system integrations
Write clean, testable code using advanced analytical functions
Test and debug including, but not limited to: perform system testing and development of testing plans
Review and refactor code including, but not limited to: performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs
Deploy fully functional applications
Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment
Qualification
Required
Act as Expert Database Architect and L2 Technical Operational Support
Interact with Agency/business subject matter experts to understand business needs/requirements
Design data infrastructure to extract and organize data for authorized individuals to access
Identify internal and external data sources
Collaborate with business subject matter experts to determine their data storage and organizational needs
Participate in the entire Secure Software Development Life Cycle (SSDLC)
Identify, recommend and implement ODI/ELT and ETL process and architecture improvements
Assist and verify design of solution and production of all design phase deliverables
Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture
Resolve difficult design and develop issues
Identify bugs when developers are not able to do so
Identify installation solutions for new databases
Determine the requirements for new databases
Publish and/or present design reports
Identify areas for improvement in current systems
Coordinate with business, vendor and IT team members to reach project milestones and deadlines
Audit database regularly to maintain quality
Create systems to keep data secure
Design and document all components of approved application solutions including system integrations
Write clean, testable code using advanced analytical functions
Test and debug including, but not limited to: perform system testing and development of testing plans
Review and refactor code including, but not limited to: performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs
Deploy fully functional applications
Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment
Company
Mindlance
Mindlance is a Staffing and Recruiting company which provides multi-vertical staffing services
Founded in 1999
1001-5000 employees
H1B Sponsorship
Mindlance 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 (71)
2024 (53)
2023 (37)
2022 (72)
2021 (36)
2020 (40)
Funding
Current Stage
Late StageLeadership Team
R
Rajat Paul Dhall
Co-Founder & Managing Director
V
Vik Kalra
Co-Founder and Managing Director
Recent News
2025-11-19
Kelly Services, Inc.
2025-05-17
2025-04-14
Company data provided by crunchbase