Senior Database Administrator

$117,500 - $139,500/Yr

AMN Healthcare - Dallas, TX

Full-time - Mid Level

Dallas, TX

Administrative and Support Services

About the position

The Senior Database Administrator at AMN Healthcare plays a crucial role in developing a modern data pipeline for the Language Services data lake. This position requires expertise in database management systems, data architecture, and data quality, with a focus on designing and maintaining effective data solutions. The successful candidate will collaborate closely with the Data Architect and be involved in all aspects of the Software Development Life Cycle, ensuring data integrity and performance optimization.

Responsibilities

• Deliver upon the technology road map in alignment with Language Services leadership to improve the underlying costs and capabilities of the AMN Language Services portfolio.
• Adhere to coding policies, technical documentation, and operational discipline as defined by software development policies.
• Communicate effectively for team leadership, software release documentation, client response, and leadership team updates.
• Participate in all aspects of the Software Development Life Cycle (i.e. Agile/Scrum) including technical requirements analysis, technical design, development, testing, code deployment, and production support.
• Identify and mitigate risks associated with software, ensuring alignment with AMN Information Security policies and procedures.
• Participate in on-call processes and events during application downtime and degraded performance.
• Mentor, coach, and train junior staff on integration methodologies.
• Engage in architecture discussions and design sessions to understand data requirements as provided by the Data Architect.
• Develop the data warehouse using PostgreSQL, SQL Server, Snowflake, Python, PySpark, Azure Data Factory, and SSIS.
• Implement best practices for database performance tuning, indexing, and data partitioning.
• Ensure data consistency and integrity through robust ETL processes using tools such as Python, PySpark, SSIS, and ADF.
• Monitor ETL job performance, troubleshoot issues, and optimize workflows for efficiency.
• Collaborate with Salesforce administrators and developers to design and implement data integration solutions between Salesforce and other systems.
• Utilize advanced SQL skills to create complex queries, stored procedures, functions, and triggers for data analysis and reporting.
• Leverage the capabilities of the Snowflake data platform to architect and implement scalable and efficient data solutions.
• Build ETL pipelines using Python and relevant frameworks and libraries.
• Collaborate with business analysts to design effective Power BI data models and integrate them with other data sources.

Requirements

• Bachelor's Degree plus 7-10 years of work experience OR High School Diploma/GED plus 11-14 years of work experience.
• Certifications in relevant technologies, such as Snowflake, Python, PySpark, Sql-Server, SSIS, and Power BI.
• Experience with cloud platforms, such as Azure and AWS.
• Knowledge of best practices in data governance and compliance.

Nice-to-haves

• Experience working with Snowflake.
• Experience working with Salesforce.

Benefits

• Competitive salary range of $117,500 - $139,500 based on experience, training, education, and location.