P

SQL Database Developer - Batch Data_Buffalo

Photon Group
Full-time
On-site
United States
Description

Overview:


We are looking for a highly motivated Database Developer with a strong focus on automation to join our dynamic IT team. The ideal candidate will possess hands-on experience in SQL Database Administration, along with expertise in Python and/or PowerShell for developing infrastructure automation tools, and a commitment to mentoring and developing team members. Additionally, strong communication and interpersonal skills are essential for success in this position.


Primary Responsibilities:



  • Develop and Implement Solutions: Design, build, and maintain solutions to automate the deployment and management of SQL databases and related infrastructure.

  • Automate Routine Tasks: Lead initiatives to identify and automate repetitive tasks, improving the efficiency and reliability of IT operations.

  • SQL Database Administration: Manage and optimize SQL databases, ensuring high availability, performance, and security across various environments.

  • Infrastructure Automation: Utilize tools such as Python, PowerShell, or other relevant scripting languages to create and maintain automated workflows that streamline processes.

  • Mentor and Guide Team Members: Provide mentorship and guidance to junior team members, fostering a culture of continuous learning and development within the team.

  • Stay Current with Emerging Technologies: Continuously evaluate and integrate new technologies and methodologies to enhance the team’s capabilities and improve overall infrastructure management.

  • Collaborate with Cross-Functional Teams: Work closely with other IT teams and stakeholders to understand requirements, design solutions, and ensure the successful implementation of projects.

  • Troubleshoot and Resolve Issues: Proactively identify, diagnose, and resolve technical issues related to database and infrastructure automation to minimize downtime and service disruption.

  • Document Processes and Best Practices: Create and maintain comprehensive documentation of automation processes, IaC deployments, and SQL database management procedures.

  • Ensure Compliance and Security: Ensure that all automation and database management practices adhere to industry standards, security protocols, and regulatory requirements


Education and Experience Required:



  • Associate’s degree and a minimum of 6 years’ RDBMS experience,

  • OR in lieu of a degree, A combined minimum of 8 years’ higher education and/or work experience, including a minimum of 6 years’ RDBMS experience

  • Proficiency in SQL/Oracle, experience with relational database management systems (e.g., MySQL, SQL Server).

  • Hands-on experience with database automation tools and scripting languages (e.g., Python, PowerShell).