Aayla Solutions logo
Aayla Solutions

Redefine Your Construction Technology with Aayla Solutions

Senior SQL Database Architect – Team Lead

Database AdministratorDatabase AdministratorContractRemoteSeniorTeam 11-50Since 2000H1B No SponsorCompany SiteLinkedIn

Location

Oregon

Posted

65 days ago

Salary

0

Seniority

Senior

Bachelor Degree5 yrs expEnglishERPMS SQL ServerMySQLSQL

Job Description

Senior SQL Database Architect – Team Lead

Aayla Solutions

• Design and manage complex SQL queries, stored procedures, views, and functions to support data analysis, reporting, and business intelligence • Architect scalable and robust database schemas to support business data requirements • Apply expertise in SQL performance tuning to optimize database operations and enhance data retrieval and manipulation speed • Implement SQL database security measures, including robust access controls, encryption, and auditing policies • Lead data migration and integration projects • Develop strategies utilizing SQL expertise to ensure business continuity • Manage SQL databases across various platforms • Create comprehensive documentation for SQL database architectures and coding standards

Job Requirements

  • Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field
  • Minimum of 5 years of hands-on experience in SQL database development, management, and optimization
  • Demonstrated experience in leading data migration, integration projects, and database security implementations
  • Advanced knowledge of SQL and proficiency in database architecture design, performance tuning, and optimization
  • Experience with reporting and analytics tools such as SSRS and Crystal Reports, and familiarity with ERP systems like Vista by Viewpoint
  • Certifications in SQL database management, Microsoft SQL Server, MySQL, or similar technologies are highly regarded

Benefits

  • Equal Opportunity Employment
  • Fostering a diverse and inclusive workplace
  • Commitment to innovation and professional growth

Related Categories

Related Job Pages

More Database Administrator Jobs

Nimble logo

Database Administrator – Healthcare RCM

Nimble

The CRM for more than just salespeople. A relationship-focused CRM for your entire team.

Full TimeRemoteTeam 11-50H1B Sponsor

• Administer and maintain SQL Server databases in a cloud environment • Optimize database performance through index tuning, query optimization, and execution plan analysis • Ensure database high availability, replication, and disaster recovery strategies • Monitor database health and performance using SQL Profiler, Extended Events, and other monitoring tools • Work closely with developers to improve database design, query performance, and stored procedures • Manage database backups, restores, and security policies to ensure data integrity • Automate database maintenance tasks and improve efficiency • Collaborate with data engineers and analysts to support data pipeline workflows • Ensure compliance with HIPAA, HITRUST, and other healthcare data security standards • Troubleshoot database issues and provide timely resolutions

India
Jabil logo

Database Administrator

Jabil

Made Possible. Made Better.

Full TimeRemoteTeam 10,001+Since 1966H1B Sponsor

• Monitor, maintain, and support Microsoft SQL Server, PostgreSQL, aws Redshift environments (on‑premises and cloud‑hosted) • Ensure database availability, performance, and reliability in line with SLA and performance requirements • Design, implement, and maintain database maintenance jobs (backup, restore, patching, indexing, housekeeping) • Maintain Data lifecycle and introduce data archiving, purging process • Proactively identify opportunities for automation and standardization • Improve operational efficiency through scripting and tooling • Ensure Database security compliance, lead Database updates and migrations • Analyze and optimize database performance, including: o Query tuning o Index strategies o Resource utilization • Identify and resolve bottlenecks in high‑load environments • Support capacity planning and growth forecasting • Act as database subject‑matter expert for MES systems • Ensure MES databases have the required resources, performance, and stability • Work closely with application and MES teams to: o Optimize complex queries o Support application changes o Prevent production issues o Review Database changes • Enforce database best practices for security, backup, recovery, and compliance • Support audits and ensure adherence to corporate IT standards • Contribute to documentation, runbooks, and knowledge sharing • Co-work with product teams on Database design throughout on the SDLC process • Maintain Database projects in git repositories • Build and maintain CICD pipelines for the Database projects • Actively participate in Incident Management and Problem management within IT SLA

Ukraine
TMS logo

Database Administrator IV

TMS

Qualified, Reliable, Viable

ContractRemoteTeam 51-200H1B Sponsor

• Responsible for all aspects of the organizations database management strategy, integrity, and design • Lead discussions and mentor application and database development staff • Provide strong technical direction and guidance, project management skills • Facilitate and lead collaborative cross functional workgroups to resolve complex problems in real-time • Architect and develop ETL using Microsoft SQL server Integrations services • Install, configure, support, and troubleshoot Microsoft SQL Server • Ensure that routine or special database software upgrades, maintenance, security audits, and patches are performed • Provide leadership in the overall database designs and setup • Provide direction and methodology for the data warehouse design, creation, and maintenance

New Jersey
Job Closed
Harris Computer Systems logo

Database Administrator

Harris Computer Systems

Based in Ottawa, Ontario, Canada, Harris Computer Systems provides mission-critical software solutions for organizations across the United States and Canada, including healthcare c

Job Summary: Our ideal DBA is a self-starter who has a strong background in SQL Server and experience maintaining and administering very large databases (VLDB’s) in a production setting. Work Mode: Remote Shift Timings: 06:30pm to 03:30am IST Location: Mumbai – Remote Primary Functions: - Be responsible for administering production databases in SQL Server spanning up to terabytes in size, including ensuring availability, performance, recoverability and security of the data - Manage the frequent incoming data feeds that populate these databases via a custom ETL process - Provide high quality (tier-two) Production support for our clients and internal project teams - Deploy releases and apply patches to the production environment - Be an important part of a small-but-dedicated team of data experts - Participate in an on-call rotation with several other DBAs - Develop solutions for high quality monitoring and the above duties What We Are Looking For: - 4-5 years’ experience with SQL Server 2008 R2 and newer (2016 preferred) - 3+ years’ experience maintaining and administering databases in a production setting - A self-starting attitude and a strong desire to continuously learn - A strong understanding of T-SQL and query tuning experience - Ability to effectively manage competing priorities. What Would Make You Stand Out: - SQL Server BI (SSIS/SSAS/SSRS) - PowerShell scripting - PowerBI - Windows Server 2016 or 2019 administration - SQL Azure would be an added advantage - Oracle RDBMS - Oracle GoldenGate replication - Databricks Soft Skills/ Behavioural Skills: 1. Excellent Communication Skills (Written & Verbal) 2. Working Independently. 3. Critical Thinking Benefits: - Annual Public Holidays as applicable - 30 days total leave per calendar year - Mediclaim policy - Lifestyle Rewards Program - Group Term Life Insurance - Gratuity - ...and more!

India
Job Closed