We are seeking a highly skilled and experienced Senior SQL Developer to join our dynamic team. The ideal candidate will have a strong background in SQL, database architecture, and query optimization. This role involves working closely with cross-functional teams to support development efforts, understanding Java code, and ensuring efficient database designs. The successful candidate will be a proactive problem solver with a keen eye for detail and a passion for optimizing SQL queries to enhance system performance.
Key Responsibilities:
- Develop, maintain, and optimize database schemas, tables, and relationships to ensure robust and scalable database solutions.
- Write, debug, and optimize complex SQL queries, stored procedures, triggers, and scripts to support application development and data processing requirements.
- Analyze and enhance SQL queries to improve performance and reduce execution times.
- Implement best practices for query optimization and indexing.
- Review and understand Java code to ensure seamless integration between the application and database layers.
- Collaborate with Java developers to troubleshoot and resolve database-related issues.
- Work closely with software developers, QA engineers, and other stakeholders to support the overall development effort.
- Participate in code reviews, design discussions, and project planning sessions.
- Monitor database performance, implement changes, and apply patches and upgrades as necessary.
- Ensure data integrity, security, and availability.
- Investigate and resolve database-related issues, providing timely and effective support to the development team and other stakeholders.
- Create and maintain comprehensive documentation for database designs, processes, and best practices.
Required Qualifications:
- Minimum of 5 years of experience as an SQL Developer, with a focus on database design and query optimization.
- Proficiency in SQL and experience with major relational database management systems (RDBMS) such as Microsoft SQL Server, MySQL, or PostgreSQL.
- Strong understanding of database architecture, normalization, and indexing strategies.
- Experience with query optimization techniques and performance tuning.
- Ability to read and understand Java code for database interaction.
- Familiarity with version control systems like Git.
Preferred Qualifications:
- Experience with data warehousing, ETL processes, and business intelligence tools.
- Knowledge of NoSQL databases and big data technologies.
- Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database).
- Certification in SQL or database management.
To apply please click the Apply button or send us your updated profile to [email protected]
EA Licence No.:18S9405 / EA Reg. No.:R1330864
Percept Solutions is undergoing a growth phase and are on the lookout for talent. Applicants are encouraged to follow Percept Solutions on LinkedIn @ https://www.linkedin.com/company/percept-solutions/ to stay up to date on our upcoming roles and events.