Database Administrator

$140,000 - $150,000/Yr

Ecco Select - Dallas, TX

Full-time - Mid Level

Dallas, TX

Professional, Scientific, and Technical Services

About the position

The Database Administrator/Engineer at ECCO Select is responsible for managing and optimizing all aspects of data processing, including database management, architecture, and ETL processing. This role involves collaborating with various teams to develop analytical solutions, implement CI/CD pipelines, and ensure data integrity and security. The position requires a strong technical background in SQL, Python, and data engineering practices, with a focus on continuous improvement and best practices in data management.

Responsibilities

• Handle the development of all aspects of data processing, including database management, architecture/modeling, and ETL processing.
• Create and deliver analytical solutions using various tools.
• Collaborate with corporate data analytics team and business stakeholders to collect requirements and translate them into technical specifications and process documentation.
• Work on the architecture and development of an event-driven data warehouse, streaming, batch, data modeling, and storage.
• Provide technical guidance and review code and test results.
• Review pull requests and scripts for production development.
• Write and optimize SQL queries, stored procedures, functions, and partition data.
• Write and debug Python/PySpark scripts for data extraction and cleaning.
• Implement ETL architecture, data profiling, process flow, metric logic, and error handling.
• Support continuous improvement by exploring and presenting alternatives to processes and technologies.
• Design, develop, and maintain scalable and efficient data pipelines and workflows using Azure Synapse or similar tools.
• Implement and manage CI/CD pipelines using Azure DevOps to automate deployment, testing, and monitoring of data engineering solutions.
• Optimize and tune data pipelines and process workflows for performance, scalability, and reliability.
• Collaborate with data architects, engineers, and analysts to design, develop, and maintain data pipelines and ETL processes.
• Utilize Azure Data Studio to design and optimize database schemas, stored procedures, and SQL queries.
• Monitor and troubleshoot data pipeline health and performance issues, proactively identifying and resolving issues.
• Create and maintain comprehensive documentation for data pipelines, workflows, and system configurations.
• Conduct data profiling, cleansing, and validation activities to ensure data quality and integrity.
• Participate in code review, testing, and debugging activities to ensure reliability and maintainability of data engineering solutions.
• Provide technical guidance, mentorship, and support to team members.
• Troubleshoot and resolve data-related issues reported by end-users or detected through monitoring systems.
• Design and implement a mature data lifecycle, including backups and restore of data.
• Assist ServiceNow admins with creating workflows relevant to the data lifecycle.
• Ensure compliance with Role-Based Access and other regulatory requirements.
• Develop and implement data governance policies and procedures.

Requirements

• Mid-level experience in SQL and database management.
• Proficiency in Python and PySpark for data processing.
• Experience with CI/CD and DevOps practices.
• Strong understanding of ETL processes and data architecture.
• Ability to collaborate with cross-functional teams and translate requirements into technical solutions.

Nice-to-haves

• Experience with Azure Synapse or similar data tools.
• Familiarity with ServiceNow for workflow creation.
• Knowledge of data governance policies and procedures.

Benefits

• Health insurance
• Dental insurance
• 401(k)
• Paid time off
• Vision insurance