Skip to content
Lead Business Systems Analyst – Database Management
| Company | First American |
|---|
| Location | Irving, TX, USA |
|---|
| Salary | $99675 – $132875 |
|---|
| Type | Full-Time |
|---|
| Degrees | |
|---|
| Experience Level | Senior, Expert or higher |
|---|
Requirements
- Must have experience with SQL Server, PostgreSQL, Oracle, and Snowflake
- Proficient in SQL, T-SQL, PL/SQL, Python, and JavaScript
- Experience with tools like SSMS and pgAdmin
- Ability to design and implement relational database structures, stored procedures, views, and functions
- Experience in developing and optimizing complex SQL queries for reporting use
- Knowledge of ETL processes for data ingestion and transformation
- Experience in monitoring and tuning database performance, including indexing and query optimization
- Ability to ensure data quality, consistency, and security across environments
- Experience in documenting database schemas, processes, and best practices
- Knowledge of data migration, backup, and recovery strategies
Responsibilities
- Design and implement relational database structures, stored procedures, views, and functions
- Develop and optimize complex SQL queries for reporting use
- Collaborate with application developers and product managers to integrate backend data solutions
- Provide guidance for creating effective ETL processes for data ingestion and transformation
- Monitor and provide guidance to DBA Team to tune database performance, including indexing and query optimization
- Ensure data quality, consistency, and security across environments
- Document database schemas, processes, and best practices
- Support data migration, backup, and recovery strategies
Preferred Qualifications
- Problem Solving
- Attention to Detail
- Communication
- Collaboration
- Documentation
