SQL Server DBA

Designation SQL Database Administrator

LocationMohali, Chandigarh,

Job Description & Responsibilities

• Provide database monitoring and support of multiple 24/7 enterprise SQL Server always on availability groups.
• Troubleshoot issues as they occur, working with the Operations team during incidents, and resolving problems quickly and to a high standard.
• Maintain database performance by identifying and resolving production and application development problems, calculating optimum parameter values, evaluating
• new release code, answering developer questions and advising on code changes.
• Develop and configure database solutions, configuration of new systems, defining database structure, improving security, ensuring back-ups and restores meet audit requirements.
• Ensure all database systems meet RPO & RTO policies.
• Work with the Engineering Team to design and optimize SQL solutions.
• Work with the Operations Team to manage, install and configure servers in multiple data centres around the world.
• Update job knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations.
• Ability to work closely with developers to resolve issues and improve systems.
• High level knowledge of Windows and Windows security and how they affect SQL Server.
• Knowledge of PowerShell scripting.
• Excellent analytical and problem-solving skills.
• Excellent written and verbal communication skills.

Education

• BE, B. Tech, M. Tech in Computer Science or equivalent.

Certifications

• Knowledge of Clustering.
• Knowledge of Database Migration.
• Knowledge of Database Mirroring.
• Knowledge of Log Shipping.
• Knowledge of Mirroring.
• Knowledge of Replication.
• Knowledge of SQL DBA.

Work Experience

• 05 to 08 years of experience as a SQL Database Administrator.
• Experience in Airlines or travel domain is a plus.

Skills

• Responsible for installation and configuration of SQL Server 2016/2017/2019.
• Scheduling jobs and job monitoring.
• Performing SQL Server upgrades, applying patches, and monitoring status.
• Manage user and role level security.
• Understanding and modifying existing stored procedures.
• Configured always On, log shipping and replication.
• Creating databases and logins with permissions in SQL Servers as developer's request.
• Implemented database standards and naming conventions for the database objects.
• Monitoring the databases as per the daily schedule tasks to check the health of databases using DBCC commands.
• Monitoring jobs like backup and restore check the error log for daily running batch jobs.
• Performance tuning high-level understanding.
• Troubleshooting issues high-level understanding.

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile

2

Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.

3

Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.

4

Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.

5

Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.

6

Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.

7

Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.

8

Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.

9

Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.

10

Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.

Location - Remote (India)

Key Responsibilities 

• Design, develop, and maintain database schemas, stored procedures, views, and queries in SQL Server and MySQL. 

• Identify and resolve query performance bottlenecks using execution plans, indexing strategies, and tuning techniques. 

• Conduct regular database health checks and performance reviews to ensure optimal operation. 

• Collaborate with development and operations teams to support application data requirements. 

• Write and optimize complex SQL scripts to meet business and operational needs. 

• Support the DBA Team Lead with day-to-day database operations and incident resolution. 

• Assist in monitoring database availability, integrity, and backups. 

• Document database structures, procedures, and changes in a clear and organized manner. 

• Implement best practices for data storage, retrieval, and processing efficiency. 

• Contribute to the continuous improvement of database standards and internal processes. 

• Identify and effectively prioritize situations requiring urgent attention. 

• Stay current with system information, database technologies, changes, and updates. 

• Experience with cloud-managed databases (e.g., Microsoft Azure SQL Database, Amazon RDS) and understanding of scaling, cost optimization, and high availability in cloud environments. 

• Hands-on exposure to database automation and CI/CD practices (schema versioning, deployment pipelines, Infrastructure as Code). 

• Strong knowledge of high availability and disaster recovery design, including replication, failover, and defined RPO/RTO ownership. 

• Familiarity with database security best practices (encryption, access control, auditing, and protection of sensitive/regulated data). 

• Experience with monitoring and observability tools, with a proactive approach to performance tuning and alerting. 

• Scripting ability (PowerShell, Python, or Bash) to automate routine database operations and reduce manual effort. 

• Experience with database migrations, version upgrades, or modernization initiatives (on-prem to cloud or legacy to current platforms). 

• Ability to operate in a DevOps-oriented environment, partnering closely with engineering teams and owning database performance tied to application SLA. 

• Proficiency in T-SQL and/or standard SQL. 

• Ability to multi-task and adjust priorities quickly in a fast-paced environment. 

• Ability to research and implement solutions using available technical resources. 

• Strong analytical and problem-solving skills with attention to detail. 

• Ability to clearly communicate technical concepts to non-technical stakeholders. 

• Advanced knowledge of database performance tuning and query optimization. 

• Familiarity with cloud database platforms such as Microsoft Azure SQL, AWS   RDS, or equivalent. 

• Experience with database deployment automation and CI/CD pipelines. 

• Understanding of high availability, disaster recovery, and data protection strategies. 

• Working knowledge of database monitoring and performance management tools. 

• Basic scripting skills (PowerShell, Python, or Bash) for automation. 

• Awareness of data security and compliance considerations in regulated environments. 

Required Skills 

• Proven working experience as a Database Administrator or in a similar role. 

• Working knowledge of Microsoft SQL Server (SSIS, T-SQL, DDL, SML) 

• Working knowledge of MySQL or MariaDB. 

• A minimum of 5 years of experience in database administration. 

• Understanding of database normalization and data modeling principles. 

Nice to Have 

• MacOS, iOS, Android, Linux OS beneficial but not required. 

• ETL processes or data warehouse experience beneficial but not required. 

• Microsoft Certified: Azure Database Administrator Associate or equivalent SQL Server certification preferred but not required. 

• MySQL certification preferred but not required. 

Senior Software Engineer – SQL Server / T-SQL

Chennai | IIT Madras Research Park | Full-Time

About Novacis Digital

Novacis Digital is a product-first technology company building AI-driven platforms and large-scale data systems. Our products process complex, high-volume data to power real-time analytics and GenAI-driven experiences.

We don’t see SQL as “just a database layer” - we treat it as a core compute engine. If you love writing efficient SQL and solving performance problems, this is the role for you.

What You Will Do

·      Design and build complex T-SQL stored procedures involving Dynamic SQL, along with views, functions, and triggers

·      Implement flexible, metadata-driven query frameworks using sp_executesql and parameterized Dynamic SQL

·      Engineer high-performance, set-based queries using CTEs, window functions, temp tables and table variables

·      Optimize queries using execution plans, statistics and DMVs

·      Refactor inefficient queries and redesign schemas for performance and scalability

·      Solve real-world challenges related to locks, blocking, deadlocks and transaction isolation

·      Collaborate with application engineers to build reliable, high-performance data access layers

What We’re Looking For

We’re looking for true SQL engineers — people who think in execution flow, logic and data behavior rather than just syntax.

You should have:

·      4+ years of deep hands-on experience with Microsoft SQL Server & T-SQL

·      Strong expertise in:

o  Stored Procedures (with Dynamic SQL)

o  Views

o  Functions

o  Triggers

·      Strong experience with:

o  Dynamic SQL best practices and secure execution patterns

o  Indexing strategies and query plan optimization

o  Handling parameter sniffing and plan instability

·      Strong knowledge of:

o  Temp tables vs table variables

o  Cardinality estimation

o  Cost-based optimization concepts

Nice to Have

·      Exposure to GenAI data pipelines or analytical architectures

·      Exposure to Graph, Vector and No SQL Databases

How We Work

·      We write production-grade T-SQL

·      We value performance, clarity, and correctness

·      We invest heavily in query readability and maintainability

·      Engineering quality is non-negotiable

Apply Now

If you enjoy designing complex Dynamic SQL-powered stored procedures and tuning systems at scale, we’d like to talk.

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

Hiring for Data Analyst

Exp : 5 - 7 yrs

Edu : BE/B.Tech

Work Location : Noida WFO

Skills :

Expertise in SQL Server, including database design, performance tuning, query optimization, and security.

Hands-on experience developing ETL solutions using SSIS, Azure Data Factory (ADF), and Python.

Data & BI Support Specialist - JD

Professional Work Experience

• Microsoft SQL Server skills including SSIS, SSAS, DW and Power BI

• ADF, Databricks and Azure synpase skills will be preffered

• Excellent E-Mail and phone communication skills

• Experience in guiding BI Support Engineers

• Experience in global environment

• Ability to read code and support applications, reports and processes

• Excellent analytical and problem-solving skills

• Ability to contribute both independently and as part of a team

• Excellent listening, communication, interperson

• Excellent analytical and problem-solving skills

Looking for a strong Microsoft SQL Server + SSIS resource with L1, L2, L3 (mix) Production Support experience. Role is 75% support and 25% development. Candidate should be able to troubleshoot existing SQL code, ETL jobs, incidents, and perform RCA. Power BI is only 10%. Please prioritize SQL Support Engineers, SSIS Developers, and SQL Developers with production support exposure

Job Summary

We are seeking a motivated Data Engineer with strong skills in SQL, Python, and Linux to design, build, and maintain scalable data pipelines and support data-driven decision-making. The ideal candidate should have experience working with large datasets, ETL processes, and relational databases while ensuring data quality and performance.

Key Responsibilities

• Design, develop, and maintain ETL/ELT data pipelines.
• Write optimized SQL queries, stored procedures, and database objects.
• Develop Python scripts for data extraction, transformation, and automation.
• Work in Linux environments to manage scripts, cron jobs, and system processes.
• Monitor and troubleshoot data pipeline failures.
• Ensure data integrity, consistency, and quality across systems.
• Collaborate with data analysts, software engineers, and business stakeholders.
• Optimize database performance and query execution.
• Participate in code reviews and follow best engineering practices.

Required Skills

• Strong proficiency in SQL (joins, subqueries, window functions, CTEs, indexing, query optimization).
• Good programming experience in Python.
• Hands-on experience with Linux commands and shell scripting.
• Understanding of ETL/ELT concepts and data warehousing.
• Knowledge of relational databases such as PostgreSQL, MySQL, Oracle, or SQL Server.
• Familiarity with Git for version control.
• Strong problem-solving and analytical skills.

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!