[Close] 

Database Administration Manager, Senior IT Lead

Company Summary
Join our team! As a global leader in providing title insurance, settlement services and risk solutions for real estate transactions, First American Title Insurance Company (NYSE: FAF) is an ideal place to build your career. We have been entrusted with helping our customers achieve and protect their dream of homeownership since 1889. First American Title?s Mortgage Solutions division provides lenders with solutions to originate, close and service quality loans. We believe that our people are the key to the company?s continued success. Because our employees enable our future, we invest in theirs by supporting their careers and promoting their overall wellbeing. First American has created an award-winning culture and has been named to the Fortune 100 Best Companies to Work For? 2018 list for the third consecutive year and to more than 50 regional Best Places to Work lists. For more information, visit www.firstam.com/mortgagesolutions/.
Job Summary

We are looking for an experienced, talented and motivated Sr. Database Administration Lead/Manager to join our Mortgage Solutions division to deliver and support relational, NoSQL and flat-file persistence layers. Successful candidates will have 8+ years of progressive success/experience with SQL server mirroring/replication/log-shipping/clustering/AlwaysOn, architecture and Windows server OS


Database platforms running on Linux or in the Cloud (e.g. AWS RDS) experience is a plus. Working knowledge of server HW, SAN Storage and network configurations are also required.


Responsibilities include:



  • Planning, coordinating, and administering database systems, including base definition, structure, documentation, requirements, operational guidelines and protection

  • Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation

  • Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure

  • Act as liaison to DevOps and App Dev teams

  • Tests designed applications, analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities

  • Research and evaluate alternatives and recommend solutions for business issues

  • Create ad-hoc reports utilizing various data sources

  • Maintain current knowledge of relevant technologies

  • Maintain and monitor database backups and rotating archives of backup files.

  • Monitor and profile production database servers for load and performance bottlenecks.

  • Participates in continuous improvement efforts in enhancing performance and providing increased functionality

  • Create knowledge base articles for alerts/issues for internal project team and affiliated groups to resolve.

  • Respond to tickets within team defined Service Level Objectives Requirements, Skills, and Education

  • Responsible for database server upgrades and SQL server configuration standards; strong understanding of MS Windows Server 2008 and up and SQL Server 2008 and up.

  • Collaborate with team resources to analyze, prioritize and test upgrades/patches.

  • Participate in future-state infrastructure planning (storage capacity planning, server SKU recommendations, newest SQL Server features, etc.)

  • Define/implement/refine SQL monitoring tools/scripts for server health checks (backups/jobs/mirroring/replication/etc.); ensure SQL Errors are proactively captured.

  • Participate in on-call rotation


Requirements:



  • Bachelor?s Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, or work experience

  • Experience in lead or management role while acting in a technical capacity

  • Experience running and maintaining a 24x7 production computing environment

  • Experience in the design, maintenance, and administration of relational databases.

  • Experience with developing software at the data layer in a SQL server environment using

  • Transact-SQL Software development skills in object oriented programming including C# .net.

  • SQL Server database administration experience, experience with mission critical, OLTP applications preferred

  • Knowledge of SQL Server performance tuning, backup and recovery methods.



  • Thorough understanding of relational database design and concepts.

  • Hands-on experience driving improvements in product performance via changes in database schema, logical and physical data organization (partitioning), tuning and configuration.

  • Experience implementing/maintaining database failover mechanism (mirroring, log-shipping, clustering, etc.) and perform disaster recovery exercises for mission-critical databases.

  • Strong SQL/T-SQL skills with hands-on experience in successful database design, schema design, SQL performance tuning and optimization.

  • Strong skills in SSRS report development and SSIS/ETL.

  • ETL using modern tools and patterns for massaging and moving data to the Cloud.

  • Experience with maintaining and optimizing MongoDB is preferred.

  • Experience with AWS services is a plus.

  • Experience with data profiling/metadata analysis/data modeling and relational schema design in object oriented or component based projects is a plus.

  • Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.

  • Strong customer service, leadership, organizational, communication and interface skills.

  • 10+ years of experience


First American invests in its employee?s development and well-being, empowers them to provide superior customer service and encourages them to serve the communities where they live and work. First American is committed to diversity and inclusion. We are an equal opportunity employer. For more information about our Company and our dedication to putting People First, check out firstam.com/careers.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.