Database Developer

Position Overview:

The Database Developer is responsible for designing, implementing, and managing the database systems that support our company's applications and services. This role involves ensuring the performance, integrity, and security of databases, as well as troubleshooting any issues on behalf of the users. The Database Developer works closely with developers, system administrators, and other stakeholders to deliver robust and scalable database solutions.

The ability to review queries, stored procedures and functions to extract underlying business rules is of paramount importance.

Key Responsibilities:

• Design, develop, and maintain robust database architectures, including data models, schema designs, and metadata.
• Implement and optimize database systems for performance, scalability, and reliability.
• Monitor database performance, perform tuning, and troubleshoot performance issues.
• Ensure database security, including data encryption, user access control, and regular security assessments.
• Develop, implement, and maintain backup and recovery strategies to ensure data integrity and availability.
• Automate routine database management tasks to improve efficiency and reduce manual effort.
• Work with application developers to design and optimize SQL queries, stored procedures, and indexing strategies.
• Maintain database documentation, including data dictionaries, ER diagrams, and configuration documents.
• Stay updated with the latest database technologies, trends, and best practices to recommend and implement improvements.
• Collaborate with cross-functional teams to support database-related activities and projects.
• Reverse engineer complex Microsoft SQL Server databases to identify database relationships, dependencies, and undocumented business rules.
• Assess the impact of database changes on existing applications, integrations, reports, and processes before implementation.
• Develop and maintain controlled database migration, deployment, and rollback scripts.

Primary Internal and External Contacts:

Internal : IS Manager, IS Team and end users.

External : Clients, Software Consultants.

Minimum Qualifications:

• Bachelor’s Degree in Computer Science or related field
• 5+ years of experience as a Database Engineer, Database Developer, Database Administrator (DBA), or similar role with a focus on Microsoft SQL Server
• Strong understanding of database design principles, normalization, and indexing
• Advanced Transact SQL Skills
• Experience with database performance tuning and optimization techniques
• Knowledge of data backup, recovery, and security practices
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Ability to learn complex business rules
• Excellent problem-solving skills
• Demonstrated ability to handle confidential information appropriately

Additional Qualifications Desired:

• Master’s Degree in Computer Science or related field
• Certification in database management
• Experience with database replication, clustering, and high-availability solutions
• Proficiency in programming languages (e.g., C#, JavaScript)
• Familiarity with cloud database solutions (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL) is a plus
• Experience leveraging AI