Developer - SQL FarShore

About FarShore

Job Description

Farshore Software Development (P) Ltd is looking for Developer - SQL to join our dynamic team and embark on a rewarding career journey

• Database Design and Modeling: Create and maintain database schema designs, including tables, indexes, and relationships, using tools like ER diagrams
• SQL Query Development: Write complex SQL queries, stored procedures, and triggers to extract, manipulate, and manage data efficiently
• Database Optimization: Identify and resolve performance bottlenecks by optimizing SQL queries, indexing, and database configurations
• Data Integration: Develop ETL (Extract, Transform, Load) processes to move data between different systems and databases
• Data Security: Implement and maintain database security measures, including user access control, encryption, and data masking as necessary
• Backup and Recovery: Establish and manage database backup and recovery procedures to ensure data integrity and availability
• Performance Monitoring: Monitor database performance using tools like performance counters and query execution plans, and make necessary adjustments
• Data Validation and Testing: Verify data accuracy through validation checks and perform unit testing and integration testing of SQL scripts
• Documentation: Maintain comprehensive documentation of database schemas, processes, and code changes
• Collaboration: Collaborate with other teams, such as software developers and data analysts, to understand their data needs and provide necessary support
• Version Control: Use version control systems to manage database code changes and collaborate effectively with team members
• Troubleshooting: Diagnose and resolve database-related issues and provide technical support when needed