Senior Database Engineer – Operations

Backend EngineerSoftware EngineerFull TimeRemoteSeniorTeam 1,001-5,000H1B SponsorCompany SiteLinkedIn

Location

Colombia

Posted

121 days ago

Salary

0

Seniority

Senior

Bachelor Degree5 yrs expEnglishAzureETLMicrosoft SQL ServerSQLSSIS.NET

Job Description

Senior Database Engineer – Operations

Ansira

• Own day-to-day operations of job feeds and ETL processes, with a strong focus on SSIS. • Triage and resolve operational tickets related to jobs, data anomalies, and performance enhancements in a timely and structured manner. • Develop and maintain notification/alerting strategies within SSIS and related workflows to detect and surface failures or performance degradation. • Collaborate with project teams to ensure new or updated feeds adhere to defined architectural and operational standards. • Analyze existing database structures (tables, views, stored procedures) and associated business rules to understand how data flows through transactional and reporting processes. • Design and execute targeted SQL scripts to implement business rule-driven updates when needed. • Ensure all operational data updates are accurate, auditable, and aligned with business rules. • Configure and manage backups and restores, including regular environment refreshes in coordination with engineering and QA teams. • Perform index and statistics maintenance to address fragmentation and support consistent query performance. • Monitor and maintain database health, including capacity management, log growth, etc.

Job Requirements

  • 5+ years working with Microsoft SQL Server 2016 or above in a production environment.
  • Hands-on experience providing operational support for SQL Server, including: Backups and restores (especially environment refreshes) Index and statistics maintenance Disk configuration and maintenance Query and workload performance tuning
  • Strong experience with ETL tools, particularly SSIS building and maintaining production pipelines and job feeds.
  • Proven ability to analyze existing schemas and stored procedures and design targeted SQL scripts for safe, auditable operational data updates and exception handling.
  • Familiarity with Git-based source control and CI/CD tooling for database and ETL deployments.
  • Experience with VB Script, C#, .NET, Azure Data Factory and Azure Cloud is a plus but not required.

Benefits

  • Participate in an on-call or after-hours support rotation (as required) for critical production systems, helping ensure availability for key clients/projects.
  • Perform other duties and responsibilities as assigned to support broader Data Platforms and client needs.

Related Job Pages

More Backend Engineer Jobs

First American (India) logo

Staff Engineer – Python, React/Typescript, Cloud

First American (India)

First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation!

Backend Engineer121 days ago
Full TimeRemoteTeam 1,001-5,000Since 1994H1B No Sponsor

• Define and communicate the technical vision and strategy for projects. • Lead the adoption and integration of new technologies and best practices. • Provide mentorship and technical guidance to junior engineers. • Conduct technical workshops and training sessions to upskill the team. • Develop comprehensive project plans, timelines, and milestones. • Coordinate with project managers to ensure timely and successful project delivery. • Review code for quality, performance, security, and adherence to standards. • Resolve complex technical challenges and bottlenecks using advanced techniques. • Perform root cause analysis to identify and address underlying issues. • Collaborate with product managers, designers, and other stakeholders to align technical solutions with business goals. • Communicate technical updates and progress to non-technical stakeholders effectively. • Identify opportunities for innovation and develop prototypes and proof-of-concept projects. • Implement continuous process improvements and best practices. • Create and maintain comprehensive technical documentation, including system architecture and design decisions. • Analyze and optimize system performance, implementing tuning and scaling strategies.

India
First American (India) logo

Senior Software Engineer – .NET Production Support

First American (India)

First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation!

Backend Engineer121 days ago
Full TimeRemoteTeam 1,001-5,000Since 1994H1B No Sponsor

• Reporting to the Development Manager for the Development Team, the Application Support Engineer will be responsible for implementing, maintaining, and supporting .NET applications and processes used to support the Business. • This is an L3 support role. • Part of the development team which addresses the technical issues. • The candidate will handle the most difficult problems, do the code changes, research and develop the solution for challenging new or unknown issues. • Support the application in production, attend to requests/issues received via email or phone call from the customers on a priority basis • Tracking, reporting, and building up of knowledge base for various types of incidents. • Tracking and checking for pending issue status and taking action accordingly • Attend each mail received from the customer and revert with functional or technical resolution • Handling support of production systems with the ability to communicate/interact with the customers and quick troubleshooting. • Triage and direct issues to appropriate stakeholders when needed • Test and deploy application fixes. • Resolve production related issues • Debugging and provide root cause analysis for the issues reported.

India
Job Closed
First American (India) logo

Principal Software Engineer – .Net Fullstack Developer

First American (India)

First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation!

Backend Engineer121 days ago
Full TimeRemoteTeam 1,001-5,000Since 1994H1B No Sponsor

• As a Principal Software Engineer, you'll drive innovation and excellence by delivering high-quality work, collaborating with your manager to advance team goals, and prioritizing effectively. • You'll participate in core processes, recommend improvements, and invigorate the team by questioning the status quo. • You'll respond urgently to operational issues, contribute to the software development lifecycle, and improve team processes. • Engaging in code reviews, building cross-team relationships, and clarifying technical ambiguities will be key to your role, ensuring the team's success and shaping our technology's future. • Acts with urgency and delivers high-quality work that adds value to the business, stakeholders, and customers. • Works with the manager to focus on advancing team goals. • Prioritizes effectively and proposes scope adjustments when necessary. • Participates in core team processes and recommends improvements. • Questions the status quo to invigorate the team. • Responds urgently to operational issues and owns resolution within scope. • Is resilient, detail-oriented, and takes initiative, especially in crises. • Contributes significantly to the full software development lifecycle. • Improves team processes, code, and work items. • Asks questions, learns from others, and receives feedback humbly. • Seeks help when stuck and needs decision support. • Actively participates in code reviews, providing meaningful feedback. • Builds relationships across teams to achieve positive outcomes. • Communicates and coordinates team requirements with other groups. • Identifies technical blind spots and clarifies ambiguity in ideas.

India
Xebia logo

Lead Node.js Developer

Xebia

Creating Digital Leaders. Digital Transformation Consultancy Services and Solutions

Backend Engineer121 days ago
Full TimeRemoteTeam 5,001-10,000H1B Sponsor

• Designing, developing, and maintaining scalable backend services and APIs using Node.js and TypeScript • Ensuring high performance and reliability • Collaborating closely with cross-functional teams • Optimizing database schemas and queries • Supporting DevOps initiatives

Bulgaria
Job Closed