Overview
The Database Engineer position specializing in SQL and T-SQL plays a crucial role in managing and optimizing the organizations data infrastructure. As a key member of the IT team the Database Engineer will be responsible for the design development and administration of complex database systems ensuring their performance security and reliability. With a minimum of 5 years of experience the ideal candidate will possess in-depth knowledge of database technologies and will be tasked with implementing best practices for data management.
In todays data-driven landscape the need for efficient data handling and insightful analytics has never been greater. This role is integral to maintaining the integrity of the organizations data enabling informed decision-making and supporting operational effectiveness. The Database Engineer will work closely with developers data analysts and stakeholders to understand data needs optimize database functions and deliver high-quality results that align with the organizations strategic objectives.
Key Responsibilities
- Design and implement database architectures.
- Develop complex SQL queries and stored procedures using T-SQL.
- Optimize database performance through tuning and indexing.
- Monitor database health and troubleshoot issues promptly.
- Ensure data integrity security and compliance with industry standards.
- Manage backup and recovery procedures to safeguard data.
- Conduct data migrations and transformations as needed.
- Collaborate with software developers to integrate database functionality.
- Create and maintain comprehensive database documentation.
- Set up and manage ETL processes for efficient data handling.
- Analyze and improve existing database systems.
- Train staff on database management practices and policies.
- Implement database changes and enhancements through change management practices.
- Participate in capacity planning and scalability assessments.
- Support data-related projects through technical guidance and expertise.
Required Qualifications
- Bachelors degree in Computer Science or related field.
- Minimum of 5 years of experience with SQL and T-SQL.
- Strong knowledge of relational database management systems (RDBMS).
- Experience with database design and data modeling techniques.
- Proficiency in performance tuning and query optimization.
- Hands-on experience with backup and recovery solutions.
- Knowledge of ETL tools and processes.
- Familiarity with cloud-based database services (e.g. AWS Azure).
- Excellent problem-solving and analytical skills.
- Ability to work independently and in a team environment.
- Strong communication skills both verbal and written.
- Experience in Agile software development methodologies is a plus.
- Certification in SQL or database management is preferred.
- Understanding of data governance and compliance regulations.
- Adaptability to rapidly changing technology and data environments.
sql,performance tuning,communication skills,analytical skills,cloud-based database services (aws, azure),t-sql,team collaboration,data modeling,etl tools,database,database design,problem-solving,relational database management systems (rdbms),query optimization,backup and recovery solutions,data migration