What are the responsibilities and job description for the SQL Database Administrator (ETL, Python) position at Delviom LLC?
Job Details
Job Description:
Job Summary
We are seeking a dynamic and detail-oriented SQL Database Administrator with expertise in ETL processes and Python scripting to join our data management team. In this role, you will be responsible for designing, implementing, and maintaining robust database systems that support high availability, performance tuning, and efficient data integration. Your technical proficiency will ensure seamless data flow across multiple platforms, enabling our organization to leverage data-driven insights effectively. This position offers an exciting opportunity to work with diverse database technologies and contribute to the stability and scalability of our enterprise data environment.
Responsibilities
- Manage and optimize multiple database systems including MySQL, Oracle, Microsoft SQL Server, and other relational databases to ensure high availability and reliability.
- Develop, implement, and maintain ETL (Extract, Transform, Load) pipelines using tools like SSIS (SQL Server Integration Services) and custom scripting solutions in Python, Bash (Unix shell), or Shell Scripting.
- Perform performance tuning and query optimization to enhance database efficiency and reduce latency.
- Design scalable database architectures and perform database design tasks to support evolving business needs.
- Conduct regular backups, disaster recovery planning, and security audits to safeguard data integrity and confidentiality.
- Automate routine administrative tasks through scripting and shell scripting to streamline operations.
- Collaborate with cross-functional teams to troubleshoot issues, implement new features, and improve existing database functionalities.
Qualifications
- Proven experience managing databases such as MySQL, Oracle, Microsoft SQL Server, with a focus on high availability configurations.
- Strong knowledge of ETL processes, including experience with SSIS or similar tools.
- Proficiency in scripting languages such as Python, Bash (Unix shell), or Shell Scripting for automation purposes.
- Expertise in performance tuning techniques for SQL queries and overall database optimization.
- Solid understanding of database design principles and best practices for scalable architecture.
- Familiarity with Linux environments for server management and scripting tasks.
- Experience with PL/SQL programming language for Oracle databases is highly desirable.
- Knowledge of Linux system administration including shell scripting for system monitoring and automation. Join us to be part of a vibrant team dedicated to harnessing the power of data! Your expertise will directly impact our ability to deliver reliable, high-performance database solutions that drive strategic decisions across the organization. We value innovation, collaboration, and continuous learning empowering you to grow your skills while making a meaningful difference every day!