Database Programmer

Job Title: Database Programmer

We are seeking a skilled and experienced Database Programmer with expertise in MS SQL Server to support our travel technology solutions. As a Database Programmer, you will play a vital role in designing, developing, and maintaining our database systems.

Responsibilities:

• Collaborate with cross-functional teams to understand database requirements and translate them into efficient and scalable database designs.
• Design and develop database solutions using MS SQL Server, adhering to industry best practices and coding standards.
• Write complex SQL queries, stored procedures, functions, and triggers to support data manipulation, retrieval, and reporting needs.
• Optimize database performance by fine-tuning SQL queries, indexing strategies, and query execution plans.
• Ensure data integrity and security by implementing appropriate data validation, encryption, and access control measures.
• Perform database maintenance activities such as backups, restores, and database performance monitoring.
• Troubleshoot and resolve database-related issues in a timely manner, collaborating with the development team and stakeholders as needed.
• Implement and maintain database-related documentation, including data dictionaries, schema diagrams, and technical specifications.
• Keep abreast of the latest trends and advancements in database technologies and SQL Server to recommend and implement improvements.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Programmer or similar role, with expertise in MS SQL Server.
• Strong proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• In-depth knowledge of relational database concepts and database design principles.
• Experience in optimizing database performance, including query optimization and index management.
• Solid understanding of data integrity, security, and backup and recovery mechanisms.
• Familiarity with ETL (Extract, Transform, Load) processes and data integration concepts.
• Strong problem-solving and analytical skills, with the ability to troubleshoot and resolve database-related issues.
• Excellent attention to detail and ability to work independently and in a team-oriented environment.
• Good communication and collaboration skills to effectively work with cross-functional teams.

Note: This job description serves as a general overview. Actual responsibilities and requirements may vary depending on the specific needs of the company.