Database Architect

job
  • ECCO Select
Job Summary
Location
Addison ,TX 75001
Job Type
Contract
Visa
Any Valid Visa
Salary
PayRate
Qualification
BCA
Experience
2Years - 10Years
Posted
15 Jan 2025
Share
Job Description

About Us

ECCO Select is certified as a Women-owned, Minority-owned, Small Business Enterprise. Through best-in-class talent acquisition, IT program management, and being an established government contractor, ECCO Select specializes in providing people, process, and technology solutions for our clients’ needs. ECCO Select has experience in assisting our commercial and government clients successfully manage projects and programs that transform their business operations through a variety of IT solutions. We’re the talent behind the technology. To find out more about ECCO visit .


Position Overview:

Position Title: Database Architect

Location Information: Hybrid - Dallas, TX

Duration: Full Time Employment

Compensation: Up to $140K + annual bonus


Job Description:

The Database Architect is responsible for ensuring data assets are of proper quality and highly available to our business decision process. This role will build and architect MS SQL database systems/servers while collaborating closely with integration and reporting teams to deliver the best possible solutions. The role requires hands-on experience in optimizing databases for scalability and performance, leading projects, and providing technical guidance to other developers.


ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Build and oversee the data architecture design and manage database systems
  • Create databases and provide access to users while meeting security requirements
  • Ensure optimal performance and scalability for SQL Servers in Azure – either on VM, Managed Instances, or SQL DBs
  • Identify system bottlenecks and optimize performance to ensure timely deliverables
  • Work with developers on indexing and query-tuning and provide guidance in building optimal code
  • Work with IT team to review and refine procedures for disaster recovery and high availability
  • Monitor SQL Servers, disk space, resource utilization, and ensure capacity needs are met
  • Leverage SQL and Azure tools to monitor jobs, optimize processes, and build better solutions
  • Work closely with offshore/onshore developers and users and coordinate on deliverables
  • Take ownership to maintain a high level of uptime and performance for all databases and services
  • Assist with managing source code and deployments and implement best practices
  • Develop and implement database/reporting policies and procedures, including those for architecture, security, disaster recovery, performance, and service provision
  • Assist with streamlining data integration processes, improving efficiencies, reducing effort related to development and support, while providing security, flexibility, and scalability
  • Build and maintain a strong relationship between different business units and onshore/offshore teams
  • Research and evaluate new tools/features in Azure (Data Lake, Databricks, Purview, Fabric, etc.) and assist in building Proof-of-Concepts
  • Assist with other analysis, development, and QA as needed


SKILLS/REQUIREMENTS

  • 10+ years of experience in Data Architecture, database development, integration, and related areas
  • 5+ years of hands-on experience optimizing SQL Server databases for scalability and performance
  • 3+ years of working experience with SQL Server in Azure – either on VM or Managed Instance
  • 3+ years of working experience with offshore teams
  • Exceptional knowledge of Microsoft SQL Server internals and optimization on a VM/Azure
  • Ability to quickly grasp and articulate dependencies between processes and data
  • Strong ability to analyze systems and data and pay attention to detail
  • Excellent communication, organizational, and time management skills
  • Takes initiative and can manage and complete multiple concurrent projects in a timely manner


QUALIFICATIONS

  • Bachelor’s degree or equivalent combinations of education and experience (preferred)
  • Experience leading projects (preferred)
  • Experience working with Snowflake, Databricks, Azure Data Factory, Power BI (preferred)


Our Commitment

We would love to have you join our team! ECCO Select is committed to hiring and retaining a diverse workforce. ECCO Select’s policy is to provide equal opportunity to all people without regard to race, color, religion, national origin, ancestry, marital status, veteran status, age, disability, pregnancy, genetic information, citizenship status, sex, sexual orientation, gender identity or any other legally protected category.


Equal Employment Opportunity is The Law

This Organization Participates in E-Verify

Other Smiliar Jobs
 
  • Arlington, VA
  • 1 Days ago