What are the responsibilities and job description for the Senior SQL Developer position at Cordia Resources by Cherry Bekaert?
This is a fully remote opportunity
Position Summary:
The Senior SQL Developer will design relational databases and data warehouses on Microsoft SQL server and Microsoft Azure SQL databases; develop ETLs to update the data warehouse; and write T-SQL queries and stored procedures to perform data analysis and to support reporting.
This role will involve collaborating with developers in the Business Intelligence team to provide the best practice suggestions for application development and the data system upgrade. This role will also take DBA responsibilities to create user accounts, to grant permissions, and to implement database security policies.
Responsibilities:
- Leading the design, development, and optimization of complex SQL database designs, SQL queries, and SQL stored procedures to meet business requirements.
- Proactively identifying and addressing database performance issues, and data quality concerns to ensure scalability and responsiveness.
- Designing and executing data migration projects by using SSIS and Azure Data Factory to ensure seamless transitions and minimal downtime.
- Implementing robust security protocols and compliance measures to protect sensitive data and ensure regulatory adherence
- Investigating and resolving data quality issues and query problems for the data warehouse and the internally developed applications.
- Providing technical leadership on database projects to guide the team in best practices and innovative solutions
- Collaborating with cross-functional teams to align database solutions with organizational goals and the latest new technologies.
- Maintaining comprehensive documentation of database architectures, processes, and best practices.
- Monitoring the logs and notification messages of the data warehouse ETL processes. Resolving the ETL issues effectively and in a timely manner.
Required skills & experience:
- An advanced Microsoft T-SQL programming, including complex query optimization and database management skills.
- In-depth knowledge of the relational data modeling techniques, including normalization and denormalization, for efficient database designs.
- A proven track record of successful database project management from inception to completion.
- Skills to effectively communicate with technical and nontechnical stakeholders, translating technical concepts into actionable tasks.
- Problem-solving and decision-making abilities, especially in high-pressure situations.
- Ability to stay up-to-date with the latest trends and technologies in the database and data warehouse field and adapt to the evolving industry standards.
- Design and Program ETLs with SSIS, SQL stored procedures and Azure Data Factory.
- DBA skills to create user accounts, to grant permissions, and to implement database security policies.
- Have skills to create ODBC connections on users’ computer.
- Have knowledge and skills of using data comparison tools, such as Red-Gate SQL Data Compare, and Microsoft Visual Studio.
