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)