CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth.
You can learn more about us at: http://www.cesltd.com/
Key Responsibilities:
- Strong proficiency with T-SQL, SSIS.
- Strong experience with Microsoft SQL Server.
- Knowledge of ETL processes and tools.
- Skilled at creating and optimizing complicated SQL statements, stored procedures, and views.
- Knowledge of best practices when dealing with relational databases.
- Ability to plan resource requirements from high-level specifications.
- Capable of troubleshooting common database issues.
- Familiar with tools that can aid with profiling server resource usage.
- Proficient understanding of code versioning tools such as Git.
- Excellent problem solving and analytical skills.
- Strong communication and collaboration skills.
- Proficiency in T-SQL and Microsoft SQL Server.
- Database Design & Schema Development.
- Design efficient, normalized relational schemas for new applications and analyse/refactor legacy models.
- SQL Development & Query Optimization
- Write, optimize, and support complex SQL (SELECT, INSERT, UPDATE, DELETE), stored procedures, functions, views, triggers. Use execution plans, DMVs, profiling tools for tuning
- Performance Tuning & Troubleshooting
- Identify and resolve bottlenecks (deadlocks, long-running queries). Tune TempDB, indexes, partitioning on heavy workloads.
- Security, Backup & Recovery
- Set up role-based access, encryption, auditing. Perform backups, disaster recovery drills, and restore operations.
- Data Warehousing & Reporting Support
- Collaborate to meet data business needs.
- Database Lifecycle Management
- Oversee upgrades, migrations, version control.
Collaboration:
Review code and drive cross-functional efforts with application teams, DBAs, and business stakeholders.
Role:
- Help write and optimize in-application SQL statements and ETL processes.
- Ensure performance, security, and availability of databases.
- Prepare documentation of existing and new database structures
- Profile server resource usage and optimize and tweak as necessary.
- Collaborate with other team members and stakeholders.
- Identify and implement optimizations to improve database performance, such as index tuning and query optimization.
- Maintain documentation of database configurations, procedures, and troubleshooting steps.
- Apply patches and updates to SQL Server instances in a timely manner to address security vulnerabilities and ensure compliance.
- Good understanding of database design – physical and logical schemas, and database modelling.
- Collaborate with developers to design and optimize database schemas
- Experience in query optimization and writing complex SQL queries.
- Experience in troubleshooting and resolving database integrity issues, blocking, and deadlocking issues, as well as performance issues.
- Strong knowledge of indexes, index management, and configuration management.
- Work on projects as needed in close coordination with Architects, Project Managers, Application Architects, and Development teams.
- Ensure team collaboration using Jira, Confluence, and other tools.
- Good to Have: ETL / Data Integration
- Design, implement, and optimize ETL pipelines (SSIS, Azure Data Factory, Informatica, Python scripts) ensuring clean data movement.
- The essential scope of the role is balancing hands-on SQL expertise, database operations, performance tuning, and cross-team collaboration.