20 Oct
|
Systel
|
Navi Mumbai
20 Oct
Systel
Navi Mumbai
Job Title: Sr. SQL Developer : Duties and Responsibilities : Database Design & Development :
- Design, develop, and maintain PostgreSQL database schemas, tables, indexes, views, materialized views, functions, and stored procedures.
- Develop and maintain SQL Server database objects including stored procedures, triggers, functions, and views.
- Design scalable database structures following normalization and database best practices.
- Create reusable SQL scripts, utilities, and database migration scripts.
- Collaborate with software developers and architects to build efficient and scalable database solutions.
- Support database migration activities between SQL Server and PostgreSQL.
Database Performance & Optimization :
- Optimize PostgreSQL and SQL Server queries for maximum performance and scalability.
- Analyze execution plans, indexing strategies, and database performance metrics.
- Identify and resolve performance bottlenecks proactively.
- Review SQL code and database changes to ensure coding standards and best practices.
- Ensure database reliability, integrity, and compliance with organizational standards.
Database Integration & Data Management :
- Develop scripts for data migration, synchronization, import/export, and bulk data processing.
- Maintain data accuracy, consistency, and security across environments.
Monitoring & Troubleshooting :
- Monitor database health and troubleshoot database-related issues.
- Implement logging, monitoring, and error-handling mechanisms.
- Ensure database availability and high performance across development, testing, and production environments.
DevOps & Database Deployment :
- Support database version control using Git and Azure DevOps.
- Participate in CI/CD pipelines for automated database deployments.
- Collaborate with DevOps teams to manage cloud and on-premises database deployments.
Reporting & Collaboration :
- Develop SQL queries and reports to support business intelligence and operational requirements.
- Collaborate with business analysts and stakeholders to understand data requirements.
- Maintain database documentation and contribute to continuous process improvements.
Knowledge and Skills required : Education and Experience :
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- 5+ years of qualified experience as a SQL Developer or Database Developer.
- Strong hands-on experience with PostgreSQL and SQL Server.
Knowledge and Skills :
- Strong expertise in PostgreSQL, including PL/pgSQL, query optimization, indexing, partitioning, views, materialized views, and performance tuning.
- Hands-on experience with SQL Server, T-SQL, stored procedures, functions, triggers, and database optimization.
- Experience in database migration between SQL Server and PostgreSQL.
- Strong understanding of relational database design, normalization, indexing strategies, execution plans, and transaction management.
- Experience with Azure Database for PostgreSQL and Azure SQL Database is preferred.
- Familiarity with Azure DevOps, Git, and CI/CD pipelines.
- Knowledge of SSRS, ETL tools, Power BI, and NoSQL databases is an advantage.
- Experience with AI-assisted development tools such as GitHub Copilot, Claude, or similar tools is a plus. Behavioral Competencies :
- Fanatical Customer Service: Ensure high-quality product delivery aligned with customer expectations.
- Absolute Ownership: Take full responsibility for QA deliverables and outcomes.
- Passion for Improvement: Continuously enhance testing practices and product quality.
- Uncompromising Integrity: Maintain transparency and accountability in all QA processes.
- Strong teamwork and adaptability in a dynamic environment.
Benefits :
- Collaborative and innovative work environment.
- Room for professional growth and continuous learning.
- Competitive compensation package.
Additional Information : This is a full-time Work from Office position located in Navi Mumbai.
jwF5DOKwPw
📌 Senior SQL Developer (PostgreSQL) (Navi Mumbai)
🏢 Systel
📍 Navi Mumbai