Senior Database Engineer – Operations
Location
Colombia
Posted
121 days ago
Salary
0
Seniority
Senior
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 Guides
Related Job Pages
More Backend Engineer Jobs
Staff Engineer – Python, React/Typescript, Cloud
First American (India)First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation!
• 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.
Senior Software Engineer – .NET Production Support
First American (India)First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation!
• 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.
Principal Software Engineer – .Net Fullstack Developer
First American (India)First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation!
• 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.
Lead Node.js Developer
XebiaCreating Digital Leaders. Digital Transformation Consultancy Services and Solutions
• 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


