Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Database Architect Junior

Donnelly & Moore Corporation

Job Description

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 hybrid 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 Client s 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















  • Bachelor's 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 required [SC1] 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 audiences. [SC2]




  • A methodical and organized approach to problem-solving.
















Job Sumary:
SQL Developer




Shift: ['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']




Start: ['Ability to present and explain information in a clear and concise manner to both technical and non-technical people']

Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Database Architect Junior in New York, NY vacancy
  • SQL Developer / Database Architect / Data Engineer 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 Con Edison Construction organization... 
    Junior

    Randstad

    New York, NY
    2 days ago
  • ONLY W2 ROLE JD- · Requirements Gathering, · Stakeholder Communication, · SQL/ETL knowledge, ·70% data governance /management with 30% SQL/ETL activities  
    Junior
    Contract work

    Long Finch Technologies

    New York, NY
    1 day ago
  •  ...About the job Data Entry Assistant (Junior / Remote) CHECK YOUR EMAIL, INCLUDING YOUR SPAM FOLDER, FOR INSTRUCTIONS AFTER APPLYING Are you ready to embark on a career that offers endless opportunities for growth and development? Do you have a passion for precision... 
    Junior
    Remote work

    Only Data Entry

    New York, NY
    19 hours ago
  • A data management firm is seeking a Remote Data Entry Assistant. This entry-level position will allow you to play a crucial role in maintaining and ensuring the accuracy of essential data. Ideal candidates are detail-oriented and possess a passion for precise work. You ...
    Junior
    Remote work

    Only Data Entry

    New York, NY
    19 hours ago
  •  ...our team. This role is perfect for someone eager to start a career in marketing and sales. As a part of our marketing team, the Junior Marketing Trainee would be responsible for providing sales, marketing, and customer service experience intended to improve the profitability... 
    Junior
    Full time
    Traineeship

    Cornerstone Sales Group Inc.

    New York, NY
    3 days ago
  •  ...Junior Paralegal- Hybrid 55k NYC Entry level Junior Paralegal for top tier law firm. Must have a bachelor's degree with a min 3.2 GPA. Assist senior partner and group of paralegals with researching and general administrative duties. Must be able to commit to 2 years... 
    Junior

    Experis

    New York, NY
    4 days ago
  •  ...Job Description Junior Account Executive High-Growth AI SaaS Startup | New York City Location: New York City, NY Industry: AI | B2B SaaS | Recruitment Technology Employment Type: Full-Time Compensation: Competitive Base + Double OTE + Equity... 
    Junior
    Full time
    Relocation

    3Search

    New York, NY
    2 days ago
  • $80k - $85k

    An executive search firm is seeking a recruiting associate to support high-profile searches and gain hands-on exposure to executive recruiting. The ideal candidate should have 2+ years of experience in a professional services environment, strong research and analytical ...
    Junior
    Full time

    Beacon Hill Staffing Group

    New York, NY
    4 days ago
  • Earthbound LLC is seeking an Associate Designer, Cook & Dine in New York for an early‑career design role focused on cookware, bakeware, GCLH and luggage across Walmart private label programs. You will translate concepts into production files and support supplier development...
    Junior

    Earthbound LLC

    New York, NY
    19 hours ago
  • $60k

     ...Skyline Consulting is looking for Junior Marketing Associates to join our growing team. This is an entry-level opportunity, and no direct marketing experience is required. We’re looking for people with a strong work ethic, a willingness to learn, and great communication... 
    Junior
    Full time
    Local area
    Immediate start

    Skyline Consulting

    New York, NY
    3 days ago
  •  ...About the job Data Entry Coordinator Junior (Remote) Important: You Will Receive An Email Within Next 2 Minutes After Applying , Check...  ...input, update, and maintain large volumes of data into our database systems. Verify and cross-reference data to ensure its accuracy... 
    Junior
    Remote work

    Only Data Entry

    New York, NY
    19 hours ago
  • $235k - $270k

     ...Role: Junior Real Estate & Finance Associate Location: New York Salary: $235,000 – $270,000 About the Practice Hawkstone Search is partnering with a Global AM100 law firm looking for a junior associate to join its Real Estate Investment and Finance group... 
    Junior
    Full time

    Hawkstone Search

    New York, NY
    2 days ago
  • Junior Data Entry Specialist - RemoteNew York, New York, United States Job Openings Junior Data Entry Specialist - RemoteAbout the Job Junior Data Entry Specialist - RemoteCheck your email, including your spam folder, for instructions after applyingAre you ready to embark... 
    Junior
    Remote job

    Only Data Entry

    New York, NY
    2 days ago
  • Licensed Apparel Co. in New York, NY, seeks a Junior Graphic Designer to support the development of licensed sleepwear, loungewear, and intimate apparel for entertainment properties. You will create original graphics using Illustrator, assist with tech packs and packaging... 
    Junior
    Overseas

    Workforce Recruiter

    New York, NY
    4 days ago
  • $35 per hour

     ...Do mobile apps and games shape your mornings, commutes, and wind-down moments? Step into a Junior Application QA Specialist role and turn that daily curiosity into hands-on testing—swiping through fresh builds, stress-testing features, logging crisp bug reports, and validating... 
    Junior
    Hourly pay
    Full time
    Contract work
    Fixed term contract
    Remote work
    Worldwide
    Flexible hours
    Day shift

    Review Pays

    New York, NY
    4 days ago
  • Norm AI in New York City is seeking an entry-level Junior Counsel to draft, summarize, and check rules with precision. You will collaborate with engineers and operations staff to translate complex regulations into actionable guidance and support AI-enabled compliance.... 
    Junior

    present of AI

    New York, NY
    4 days ago
  • A progressive law firm in Pennsylvania is looking for a motivated Associate Attorney to join its team. This position is ideal for recent law school graduates or entry-level attorneys eager to learn and grow in a collaborative environment. Responsibilities include conducting...
    Junior

    Austin Community College

    New York, NY
    4 days ago
  • Tenex is looking for an entry-level Recruiter to own the top of the funnel and screening process. You will source candidates from top firms and AI-native companies, craft personalized outreach, and determine who moves forward in the process. You will conduct first-round...
    Junior

    tenexlabs

    New York, NY
    1 day ago
  • Goldin Solutions in New York City is seeking an Account Coordinator to support client work and business operations. This entry-level role is ideal for recent graduates who are proactive, collaborative and eager to learn. You will assist with research, drafting materials...
    Junior

    Goldin Solutions

    New York, NY
    1 day ago
  • Avenue Z, Inc. in New York is seeking a detail-oriented Junior Associate to join our Public Relations team. This entry-level role offers hands-on experience on innovative campaigns for a diverse client roster. You will support development of communications strategies,... 
    Junior

    Avenue Z

    New York, NY
    4 days ago
  • $50k - $70k

    A consulting firm in New York, NY is seeking a Sales Associate to develop and execute sales strategies while maintaining strong client relationships. This full-time, entry-level position does not require previous experience and offers comprehensive training. The ideal candidate...
    Junior
    Full time
    Immediate start

    Barker Consulting

    New York, NY
    2 days ago
  • Frankfurt Kurnit Klein & Selz invites applications for an entry-level paralegal role within the Estate Planning & Administration Group. You will gain hands-on experience assisting attorneys, handling clerical tasks, and contributing to document preparation in a busy team...
    Junior

    Austincc

    New York, NY
    2 days ago
  •  ...Mid-sized architecture firm seeking junior and intermediate architects for hire. Eligible candidates must have between 2-5 years experience within an architectural firm, a strong knowledge of preparing design and construction documents, as well as having excellent organizational... 
    Junior

    C3d Architecture

    New York, NY
    4 days ago
  • A global recruitment firm is seeking a Junior Delivery Recruitment Consultant based in Midtown Manhattan, New York. This role is ideal for candidates early in their careers with sales or customer service experience. Responsibilities include sourcing candidates, building... 
    Junior
    Remote work

    Talent

    New York, NY
    1 day ago
  • $70k - $80k

    Job Description Job Description Primary responsibilities will include: Prepare for client meetings, consult with clients, create strategies and guide clients to provide necessary information and documentation to build strong cases Prepare and file a wide range...
    Junior

    Cammisa Markel PLLC

    New York, NY
    21 days ago
  •  ...Fradkin Cooper Architects is a small architecture and design firm located in midtown NYC. We practice an unusually wide range of work for...  ...Please see examples of our work at our website, We are seeking a Junior Designer to join our team. Requirements as follows: 4-year... 
    Junior
    Work experience placement
    Work at office

    Fradkin Cooper Architects

    New York, NY
    1 day ago
  • Our client, a home decor supplier that develops product for major off-price retailersThis is a small, entrepreneurial team in NYC with lots of hands-on exposure and room to grow. What you'll be doing • Support the sales team with day-to-day management of off-price...
    Junior

    Fourth Floor

    New York, NY
    2 days ago
  • $55k - $65k

     ...Archinect is looking for a motivated Junior Designer to join their NYC studio. The ideal candidate should have a professional degree in architecture and at least one year of experience working on residential projects. Proficiency in AutoCAD, Rhino, and Enscape is required... 
    Junior

    Archinect

    New York, NY
    2 days ago
  • Financial Advisor (Training Provided) About the role At National Financial Network, you’ll run your own advisory practice with a network behind you. Based in Stamford and NYC, you’ll have access to diverse, affluent neighborhoods and easy connections to New York City—ideal...
    Junior
    Local area

    National Financial Network

    New York, NY
    1 hour ago
  • Bask Health is seeking a Junior Product Marketing Specialist to support product marketing for our software platform. This early-career role focuses on creating customer-facing content, messaging, and educational materials. You will work across product, engineering, design... 
    Junior

    Bask Health

    New York, NY
    19 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Architect Junior. Be the first to apply!