Responsibilities:
- Develop, implement, and maintain SQL queries, stored procedures, and scripts to support business requirements.
- Collaborate with software developers, database administrators, and business analysts to understand data requirements and implement solutions.
- Design and optimize database schemas, indexes, and queries for performance and scalability.
- Troubleshoot and debug SQL code to resolve data-related issues.
- Ensure data integrity and security by implementing access controls, data encryption, and auditing.
- Document database design, data models, and technical specifications.
- Stay updated with emerging technologies and best practices in database development and administration.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Proficiency in SQL programming and database management systems (e.g., MySQL, PostgreSQL, SQL Server, Oracle).
- Experience with database design principles, normalization, and data modeling.
- Strong understanding of indexing, query optimization, and performance tuning techniques.
- Familiarity with version control systems (e.g., Git) and agile software development methodologies.
- Excellent problem-solving and analytical skills.
- Effective communication and collaboration skills to work in a team environment.
- Optional: Experience with NoSQL databases (e.g., MongoDB, Cassandra) and cloud platforms (e.g., AWS, Azure, Google Cloud Platform).
- This description may vary depending on the specific requirements and preferences of the hiring company.
