SQL Developer

This is a fully remote position, open to applicants in India.

📋 Description

• Develop, test, and maintain intricate SQL queries, stored procedures, functions, triggers, cursors, and views.

• Design and execute transactional SQL scripts to facilitate data processing, automation, and system integrations.

• Create and uphold scalable database solutions for business applications and reporting needs.

• Implement data validation, error handling, and logging mechanisms within SQL processes.

• Enhance database performance through query tuning, indexing strategies, and execution plan analysis.

• Analyze and resolve database bottlenecks, locking issues, and performance decline.

• Monitor database performance and proactively identify enhancement opportunities.

• Conduct database maintenance activities including backups, restores, archiving, and integrity checks.

• Monitor database health to ensure high availability, reliability, and security.

• Troubleshoot database-related issues and provide prompt resolutions to minimize downtime.

• Support ETL processes, data migration, and system integration activities.

• Collaborate with development and integration teams to facilitate data movement and transformation needs.

• Validate data accuracy and integrity during migration and integration processes.

• Maintain database documentation, technical specifications, standards, and best practices.

• Ensure adherence to data governance, security, and company policies.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and experience.

• At least 5 years of experience as a SQL Developer, Database Developer, or in a comparable role.

• Strong practical experience with:

• SQL Server, MySQL, PostgreSQL, and/or Oracle databases

• T-SQL and/or PL/SQL scripting

• Stored procedures, triggers, functions, and cursors

• Transactional SQL scripting

• Database optimization and performance tuning

• Query execution plans and indexing strategies

• Database backup, recovery, and maintenance procedures

• Experience with database monitoring and troubleshooting tools.

• Knowledge of ETL processes, data integration, and migration concepts.

• Familiarity with version control systems such as Git.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Excellent verbal and written communication skills.

• Ability to manage multiple priorities and collaborate effectively in a team setting.

🏝️ Benefits

• Health insurance

• Paid time off

• Flexible work hours