Responsible for:
The Senior Database Developer is responsible for designing, developing, and implementing sophisticated database solutions that drive our business forward.
Your expertise will not only contribute to the development of efficient, scalable, and reliable PL/SQL applications but will also help shape the future of our data management practices.
The Senior Database Developer is responsible for production support of all software and integrations developed by the Software Engineering teams, including but not limited to EDI, XML and flat file integrations, managed file transfers, and database integrations, web applications and APIs.
The Senior SQL Developer is also responsible for creating new integrations or making changes to existing integrations in accordance with the engineering teams' coding standards and best practices.
Key Skills and Capabilities:
Understanding of SDLC
Scrum, Agile Methodology
Strong proficiency in SQL (MS SQL and pgSQL) programming, including complex query writing and optimization.
Knowledge of data modeling techniques and database design principles.
Experience with ETL tools (SSIS, ADF, AWS Glue) and processes.
Expert understanding of SQL, query analysis, and performance tuning in PostgreSQL.
Strong grasp of database principles, backup and recovery techniques, and replication
Proficiency in managing database security, replication, and scalability issues.
Proficiency Data Access and Databases (Microservices, REST APIs, PostgreSQL, AWS Glue)
Familiarity with cloud services (e.g., AWS) and the ability to work with diverse database technologies (e.g., Postgre, MS SQL).
Knowledge of modern database monitoring tools and techniques.
Experience in infrastructure as code is an advantage
Familiarity with CI/CD tools (GitLab, Azure DevOps) and principles is a plus.
Knowledge of network architectures, cloud security, and compliance frameworks is a plus.
Strong Analytical skills
Strong interpersonal, organizational, problem-solving and conflict resolution skills
Excellent communication skills, both written and verbal, capable of conveying complex information in a straightforward, understandable manner.
Ability to build relationships & work collaboratively with clients and organizational peers
Attention to detail and ability to work in a fast-paced, evolving environment while maintaining high standards of accuracy and confidentiality.
Qualifications and Typical Experience:
Bachelor's degree in Programming, Computer science and other relevant degrees
5+ years experience within similar role with at least 3 years technical experience in PostgreSQL
Experience working directly with clients