Get the app Chrome extension Freelance ideasGigsSign inFind my gigs

ProfilePush / H1B jobs / Database Administrator - Expert

Database Administrator - Expert

Mindlance · Albany, NY · posted 29 days ago

$55.48–$60.48 an hourpay
Albany, NYlocation

Apply on Mindlance's siteCheck my AI Match score

Skills

About the job

Provide a short description of the Position: The consultant will work closely with business stakeholders, agency representatives, solution architects, project managers, developers, and quality assurance teams to design, implement, and maintain enterprise database solutions supporting HESC's strategic initiatives.

Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Daily Responsibilities • Build and maintain enterprise data architecture based on business and technical requirements. • Design and develop logical and physical data models using ER/Studio Data Architect. • Create and maintain DDL scripts for tables, views, indexes, constraints, triggers, and stored procedures. • Write, optimize, and maintain complex SQL and DML scripts against Microsoft SQL Server and IBM DB2 databases. • Support data conversion activities including data mapping, transformation, reconciliation, validation, and migration. • Collaborate with project managers, business analysts, application developers, solution architects, and QA teams to ensure database solutions meet project requirements. • Analyze and tune database performance through query optimization, indexing strategies, and execution plan analysis. • Work directly with NYS agency representatives to understand business rules, conduct gap analysis, and support data-related initiatives. • Provide technical guidance development support for QMF for Workstation reporting and query solutions. • Utilize SQL Server Management Studio (SSMS), SSIS, SSRS, Redgate SQL Compare, TSO, and related tools to support database administration and development activities. • Develop and maintain technical documentation, including data models, data dictionaries, source-to-target mapping documents, process flows, and database standards. • Support database deployment, version control, data quality initiatives, and change management activities. • Mentor junior team members and provide guidance on database design and development best practices.

Questions

Does Mindlance sponsor H1B for this job?

Mindlance is on record as an H1B sponsor. The posting doesn't say it won't sponsor. A past filing doesn't guarantee sponsorship for a particular role, so confirm with Mindlance.

How do I apply for this Database Administrator - Expert job?

Apply on Mindlance's own careers page with the Apply button. To see how well your resume fits first, ProfilePush's AI Match scores it 0 to 100 for free.

How well do you fit this job?

Upload your resume and AI scores this job, and every sponsor job like it, 0 to 100. Free to start.

Get my match score