Senior Database Administrator

$117,500 - $139,500/Yr

Pharmacy Choice - Dallas, TX

Full-time - Mid Level

Dallas, TX

Health and Personal Care Retailers

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 data warehouses and integrating data from various systems. The successful candidate will collaborate closely with the Data Architect and will be responsible for 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 the 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
• 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
• Develop, implement, and maintain robust ETL processes using Python, PySpark, SSIS, and ADF
• Monitor ETL job performance, troubleshoot issues, and optimize workflows for efficiency
• Implement security measures to protect information at rest
• Collaborate with Salesforce administrators to design and implement data integration solutions
• Utilize advanced SQL skills for data analysis and reporting
• Leverage Snowflake for scalable and efficient data solutions
• Build ETL pipelines using Python and relevant frameworks
• Collaborate with business analysts to design effective Power BI data models.

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
• Reasonable accommodations for qualified individuals with disabilities