Company Summary

First American (India) is a GCC (Global Capability Center) of the First American Financial Corporation (NYSE: FAF) family of companies. FAI is a proud member of the FORTUNE 500 companies and has been amongst the Fortune 100 Best Companies to Work For® list for eight consecutive years. First American Financial Corporation provides comprehensive title insurance, closing/settlement, property data and technology solutions. First American (India) creates quality solutions for its customers by combining software, back office, and knowledge processing operations to fulfill First American's business requirements. Our priorities are our employees, customers, and shareholders - in that order. First American (India) has been ranked amongst India's Best Companies To Work For™ 2023: Listed amongst the Top 100 by Great Place To Work® India, FAI is also certified Best Workplaces for Women and Workplace with Inclusive Practices. Software Services helps build First American's product suite that encompasses the best in class Title Insurance, Settlement and Mortgage solutions platforms. Leverages technology product stack across Microsoft platform predominantly to develop, enhance and maintain the best in class applications. The R & D division delivers solutions for the title insurance industry leveraging the best of NLP, AI and ML.

Job Summary

Senior Database Administrator

The role would be to support one or more databases of Medium to very high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data. Developing and maintaining enterprise data documentation and metadata models along with coding, editing, and installing stored procedures and functions for accessing, maintaining, and populating databases. The Database Administrator will be involved in coding, editing, and installing stored procedures and functions for accessing, maintaining, and populating databases. Implementation of database backup and recovery procedures also maintaining development, production, and multiple testing environments. Understanding the process of resolving a query or incidents. Assisting in configuring and monitoring the back-up processes on all the servers and determining the appropriate course of actions for fixing problems, identifies and mitigates risks, and implements solutions. Troubleshooting databases accessibility, availability or operability problems and conducting Level 2 support. Communicate important information regarding incidents and service requests to concerned stakeholders. This role requires deep technical expertise in both database development and administration, with leadership capabilities in database architecture, optimization, system management, and data governance.

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.
• Deliver across teams to ensure long-term goals on time and with a high standard of quality
• 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.
• Has ability to take technical decisions on critical design aspects
• Simplify code system design across the application stack and between multiple systems.
• Build tools and produce technical documentation to improve developer efficiency and drive alignment across multiple teams.
• 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 person’s views by asking the right questions at the right time.
• Excellent problem solving, collaboration, and communication skills.
• Strategic thinking in database technology selection and implementation
• Actively coach or mentor multiple other engineers across domains and across the organization.
• Apply AI-assisted tools, automation, and AI-enabled database capabilities to improve monitoring, incident detection, root-cause analysis, query optimization, anomaly detection, predictive capacity planning, operational alerting, and overall efficiency.
• Support and optimize databases used for AI, analytics, machine learning, reporting, feature stores, vector search, and high-volume data processing, while ensuring performance, data quality, security, scalability, and effective collaboration with data engineering, analytics, and AI teams.

Technical Skills:

• Advanced proficiency in Microsoft SQL Server - 8+ years in Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
• Comprehensive experience with PostgreSQL / Microsoft Azure SQL Database/Amazon RDSAI
• In-depth understanding of database architecture, design, and optimization
• Deep understanding of query execution optimization, including cost-based optimizer strategies, performance tuning
• Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
• Install troubleshoot and resolve the SQL Servers/SSRS/SSIS/SSAS and related software to ensure a working interface 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.
• Advanced 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.
• Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
• High availability and disaster recovery implementation
• 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.
• Database migration and upgrade planning
• Creation & maintenance of Databases in AWS.
• Comprehensive knowledge of database security implementation
• Understanding of data partitioning and sharding strategies
• Rich Experience with database replication and synchronization technologies

FAI is committed to create an environment that respects, supports and inspires all individuals. We do not discriminate on the basis of color, religion, sex, gender identity, sexual orientation and age. At FAI, we celebrate diversity and believe that an inclusive workforce benefits employees, the organization and our community. We are an Equal Opportunity Employer. For more information about our company and dedication to putting People First, check out https://firstam.wd1.myworkdayjobs.com/faicareers.