First American - Database/DevOps Engineer

Competencies:- Understands and meets stated needs & requirements of the stakeholders and work output to truly partner with all concerned stakeholders.- Takes responsibility for development of self and team; creates long-term development plans and monitors their progress.- Proactively seeks and supports new ideas and options generated by others.- Modifies and adapts current methods and approaches to better meet needs.- Adapts to diverse cultures and ideas to ensure success of projects.- Acts and responds quickly to stated business, people or stakeholder challenges.- Identifies problems and draws conclusions by gathering, analyzing, and interpreting quantitative and qualitative information.- Chooses the best course of action by establishing decision criteria and evaluating alternatives.- Proactively shares concern for meeting defined goals related to time, quality and budget and takes corrective measures.- Demonstrates an astute understanding of the other persons views by asking the right questions at the right time.- Has ability to take technical decisions on critical design aspects.- Excellent problem solving, collaboration, and communication skills.Technical Skills:- 8+ years in Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2022 or earlier.- 5+ years of Python development experience, including scripting, automation, and building production-grade applications.- 2+ years in Cloud Database services like AWS Dynamo DB / RDS.- 3+ years of PowerShell scripting for Windows administration.- Experience designing and implementing Azure DevOps (ADO)/Git Actions pipelines for CI/CD, including build, test, and deployment automation.- Experience with Agentic AI frameworks and development, including building autonomous AI agents, prompt engineering, and integrating LLM-based solutions into enterprise applications.- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance, backups, recovery, Capacity planning and performance monitoring.- High availability like clustering, log shipping, mirroring, replication.- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.- Establishing backup and recovery or replication plans to minimize data loss and system downtime.- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.- Maintaining data integrity and security (manage roles and permissions of database users).- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.- Ensures optimal database performance and availability. (ref:hirist.tech)