Jr. Database Architect Job at Connvertex Technologies Inc., New York, NY

WGNrTWh5VEpkTEFxQUxOVFliZzNESjFrNkE9PQ==
  • Connvertex Technologies Inc.
  • New York, NY

Job Description

TECHNICAL SKILLS Must Have

  • 6 years of hands-on software development and systems integration experience
  • Ability to execute existing SQL queries
  • Ability to intrepid modify and write scripts and SQL queries
  • Database/ETL/BI expert

Nice To Have

  • Ability to present and explain information in a clear and concise manner to both technical and non-technical people

JOB DESCRIPTION The SQL Developer / Database Architect / Data Engineer is a senior technical role responsible for the design ETL/ELT administration optimization integration and governance of the Client Construction organization data.
This position combines database architecture and data engineering functions to support critical business applications analytics initiatives and digital transformation programs.
The successful candidate will create and support scalable secure and highly available database solutions while developing and supporting enterprise data pipelines integrations and reporting platforms. The role requires a balance of planning hands-on technical expertise operational support and cross-functional collaboration across many stakeholders.
Ability to prepare concise yet sufficiently detailed written communications including documentation deployment plans status reports and meeting notes for both technical and non-technical audiences



What You Will Be Doing

  • Develop maintain and optimize SQL Server stored procedures views functions and advanced T-SQL solutions.
  • Design develop and support ETL/ELT processes for enterprise data integration and transformation.
  • Build and maintain data ingestion incremental load reconciliation data validation and data quality processes.
  • Independently analyze solve and correct data ETL and database-related issues providing end-to-end problem resolution.
  • Maintain database objects schema changes and scripts using version control systems such as Azure DevOps and GitHub.
  • Follow established team standards. For any gap recommend new or updated standards and proactively identify areas for improvement.
  • Document and update technical documentation operational procedures and support runbooks when appropriate.
  • Take ownership support and follow-through of assigned deliverables adjusting well to changes in priority.
  • Demonstrate a willingness and commitment to learn Clients policies procedure and standards.
  • Develop accurate estimates of effort and timelines.
  • Ensure that all assignments are completed accurately and within approved delivery schedules.
  • Assist with query tuning performance optimization and schema refinement.
  • Assist with SQL Server database administration activities including monitoring maintenance security backup verification and troubleshooting.
  • Serve as a backup resource for database administration support during planned absences vacations and off-hours support rotations.
  • Work closely and effectively with business and technical teams in a cross-functional and cross-matrixed business and technical environment.
  • Support release deployment activities testing and production implementations as required.
  • Create document and execute test plans including white-box testing black-box testing positive and negative testing.
  • Other duties may be assigned directed or requested.

What You Will Need

  • Bachelors degree (Information Technology Computer Science or related field) or equivalent experience is required.
  • Five (5) to eight (8) years of MS SQL Server development experience is required.
  • Strong T-SQL programming experience including complex queries joins views stored procedures functions and query optimization are required.
  • Strong experience developing and supporting ETL/ELT processes and enterprise data integrations is required.
  • Experience with data ingestion incremental loading data validation and data quality processes is required.
  • Experience with enterprise data warehousing and dimensional modeling is required.
  • Strong to advanced experience in Microsoft Excel Word PowerPoint and Outlook is required.
  • Experience with SQL Server performance tuning indexes index management and optimization is requiredSC1 Experience with PowerShell scripting and automation is a plus
  • Experience with SQL Server administration security backup/recovery and maintenance is a plus
  • Excellent analytical critical-thinking and problem-solving skills with the ability to anticipate and proactively address issues required.
  • Must have excellent communication skills both written and verbal.
  • Ability to effectively present technical concepts and information to non-technical audiences.
  • Ability to prepare concise yet sufficiently detailed written communications including documentation deployment plans status reports and meeting notes for both technical and non-technical 2
  • A methodical and organized approach to problem-solving.

Job Tags

Full time

Similar Jobs

The H&K Group

Site Superintendent Job at The H&K Group

 ...technical aspects of the job, and experienced in leading and building teams. Why work for H&K Group, Inc.? ~ Competitive salary...  ...Confers with supervisory and engineering personnel and inspectors and suppliers of tools and materials to resolve construction problems... 

Northside Rehabilitation and Healthcare Center

Laundry Attendant Job at Northside Rehabilitation and Healthcare Center

 ...staff? We want to hear from you! We are seeking a reliable Laundry Attendant to join our team at Northside Rehabilitation and Healthcare...  ...sanitary. # Adhere to cleaning schedules and protocols for patient rooms, common areas, and restrooms. # Utilize cleaning chemicals... 

GPTech

Solar Energy Consultant Job at GPTech

 ...GPTech is a global energy and infrastructure consulting firm passionate about engineering and energizing a future for all. We are a...  ...money, enhance operations, protect the environment, and achieve sustainable impacts. We are a trusted partner for delivering solutions... 

GoPova

Public Relations Assistant Job at GoPova

 ...About the Role We are looking for a motivated and personable Public Relations Assistant to support customer engagement initiatives...  ...with people building relationships and presenting information in a confident and approachable way. Responsibilities... 

Greenville Utilities Commission

GIS Technician I/II Job at Greenville Utilities Commission

 ...Greenville, NC, USA GIS Technician I/II Salary Range: $58,801.60 - $101,108.80 Anticipated Hiring Range: $58,801.60 - $82,305.60...  ...applications; Importing GPS data points into the GIS system for map generation and updates. Location: Position requires on-site...