563 Query Optimization Jobs - Page 21

Job Title: React + Node.js frontend Developer Job Location: Jaipur About the Project: We require a highly skilled Node Js / NPM Developer with deep expertise in configuring, optimizing, and maintaining a TypeScript-based React + Node.js application , managing, setting up PostgreSQL connections, and ensuring best practices across the entire stack. Key Responsibilities: Configure and optimize the full-stack project structure (frontend + backend) using npm and Vite . Efficiently work with TypeScript (.tsx, .ts) files in both frontend and backend. Handle complete npm package management for frontend and backend (installations, conflict resolution, updates). Setup and configure PostgreSQL databases for local development and production use. Troubleshoot and optimize build processes with Vite for frontend. Assist in creating and maintaining scalable component-based architecture and service layers . Implement secure API integrations, manage environment variables, and follow deployment best practices. Technical Skills Required: React.js (Functional Components, Hooks/props) Node.js (Backend Development using TypeScript) TypeScript (Advanced level: type safety, interfaces, generics) PostgreSQL (Database setup, schema design, query optimization) Vite.js (Frontend bundling, configuration, optimization) Axios /Fast (API communication handling) Tailwind CSS / SCSS (Frontend styling basics) Good to Have (Bonus Points): Experience with authentication (JWT, OAuth2). Knowledge of database migrations (like using Prisma, Knex.js, or Sequelize). Basic understanding of local hosting servers , PM2 process manager, OS . Experience Level: Minimum 2+ years of professional experience in Full-Stack Development. Must have worked on at least 2 large-scale React + Node.js projects using TypeScript. Real project experience configuring Vite for production frontend builds is mandatory . Soft Skills: Strong ownership and positive mindset. Clear written and verbal communication skills. Problem-solving attitude with a focus on delivering solutions. Ability to independently manage tasks and collaborate with other team members.

experience in SQL and PL SQL Strong proficiency with SQL (Structured Query Language) and its variation among popular databases Develop, implement and optimize stored procedures and functions using T-SQL Required Candidate profile Analyze existing SQL queries for performance improvements Good verbal and written communication skills in English Experience in SQL & PLSQL

Job Title: .NET Developer (2 Years Experience) Experience: Minimum 2 years Location: Wagle Estate, Thane (W) Job Summary: We are seeking a skilled .NET Developer with 2 years of experience to join our dynamic team. The ideal candidate should have hands-on experience in C#, .NET Framework/Core, and API development. You will be responsible for developing, maintaining, and optimizing web applications while collaborating with cross-functional teams. Key Responsibilities: Develop, test, and maintain .NET applications using C# and ASP.NET Core/.NET Framework. Design and implement RESTful APIs for seamless data integration. Collaborate with database teams to optimize SQL queries and stored procedures. Debug, troubleshoot, and optimize existing applications. Ensure code quality, maintainability, and scalability. Stay updated with emerging technologies and best practices in .NET development. Required Skills & Qualifications: 2+ years of experience in .NET development. Strong proficiency in C# and ASP.NET Core/.NET Framework. Hands-on experience in API development and integration. Expertise in LINQ for data manipulation. Good understanding of OOP principles, SOLID design patterns, and best coding practices. Familiarity with SQL databases and query optimization. Experience with Git or other version control systems. Strong problem-solving and debugging skills. Good communication and teamwork abilities.

Ensure the data refreshes are running efficiently, performing regular updates and backups Involve in production support and maintenance, troubleshooting issues, and communicating Design and implement dimensional models (star/snowflake) for efficient querying and reporting Implement data validation and cleansing procedures to maintain high data quality and integrity Optimize database performance through indexing, query optimization, and other techniques Gather business requirements, review the feasibility, document, and provide technical solutions Maintain technical design documents as well as comprehensive documentation of procedures Prepare estimates based upon the custom requirement and prepare a project schedule Responsible for providing standard solution sets as well as customized solutions Work closely with vendors through service requests as and when required for business-critical issues Should be able to redefine and make technical/strategic changes to enhance existing BI systems Ensure the change management process is followed

Job Description: As a Data Scientist, you will play a critical role in building and refining AI-driven solutions. You ll develop machine learning algorithms, analyze complex datasets, and deliver actionable insights to our stakeholders. This position is ideal for individuals who are passionate about working in a dynamic, cross-functional team environment and eager to solve challenging analytical problems. Key Responsibilities: Take ownership of design, development and deployment of advanced algorithms and machine learning models to solve business-critical analytical challenges. Develop, refine, and optimize Machine Learning (ML) algorithms from large datasets. Represent data-driven outcomes in an intuitive and meaningful manner for stakeholders. Write robust, efficient programs integrating offline or online ML models with other modules. Collaborate with team members to design and implement scalable AI-powered solutions. Identify opportunities for automation and optimization in existing workflows and develop solutions accordingly. Mentor and provide technical guidance to junior data scientists and analysts. Proactively contribute to product roadmap by identifying opportunities for AI and data science innovation. Stay updated with the latest developments in data science and machine learning technologies. Skills Required Education: B.Tech / MS / Ph.D. in Computer Science, Data Science, or a related field. Experience: 4-6 years of hands-on experience in data science, machine learning, or analytics. Proficient in Python, with strong skills in libraries such as pandas, NumPy, and scikit-learn. Solid understanding of Machine Learning techniques, algorithms, and best practices. Strong knowledge of SQL, data structures, and efficient query optimization. Experience with data visualization tools like Power BI, Tableau, or Google Data Studio. A grasp of generative AI concepts and their practical applications is desirable. Prior experience in advertising technology or programmatic media buying is highly advantageous. Personality & Work Ethic A strategic thinker who can align technical solutions with business objectives Proactive and self-driven, with a proven ability to manage multiple priorities and deliver results under tight deadlines. Excellent communication skills, with the ability to articulate complex concepts to technical and non-technical audiences. Strong mentorship qualities, with experience in guiding and developing junior team members. Driven, detail-oriented, and committed to delivering high-quality solutions.

Job Title:MS SQL Server & MongoDB Database Administrator (AWS Cloud) Experience:Years Location:Bangalore : Key Responsibilities: Hands-on expertise in data migration between databases on-prem to Mongo Atlas. Experience in creating clusters, databases and creating the users. SQL Server AdministrationInstall, configure, upgrade, and manage SQL Server databases hosted on AWS EC2, RDS. AWS Cloud IntegrationDesign, deploy, and manage SQL Server instances using AWS services like RDS, EC2, S3, CloudFormation, and IAM. Performance TuningOptimize database performance through query tuning, indexing strategies, and resource allocation within AWS environments. High Availability and Disaster RecoveryImplement and manage HA/DR solutions such as Always On Availability Groups, Multi-AZ deployments, or read replicas on AWS. Backup and RestoreConfigure and automate backup strategies using AWS services like S3 and Lifecycle Policies while ensuring database integrity and recovery objectives. Security and ComplianceManage database security, encryption, and compliance standards (e.g., GDPR, HIPAA) using AWS services like KMS and GuardDuty. Monitoring and AutomationMonitor database performance using AWS CloudWatch, SQL Profiler, and third-party tools. Automate routine tasks using PowerShell, AWS Lambda, or AWS Systems Manager. CollaborationWork closely with development, DevOps, and architecture teams to integrate SQL Server solutions into cloud-based applications. DocumentationMaintain thorough documentation of database configurations, operational processes, and security procedures. Required Skills and Experience: 6+ years of experience in SQL Server database administration and 3+ years of experience in MongoDB administration. Extensive hands-on experience with AWS cloud services (e.g., RDS, EC2, S3, VPC, IAM). Proficiency in T-SQL programming and query optimization. Strong understanding of SQL Server HA/DR configurations in AWS (Multi-AZ, Read Replicas). Experience with monitoring and logging tools such as AWS CloudWatch, CloudTrail, or third-party solutions. Knowledge of cloud cost management and database scaling strategies. Familiarity with infrastructure-as-code tools (e.g., CloudFormation, Terraform). Strong scripting skills with PowerShell, Python, or similar languages. Preferred Skills and Certifications: Knowledge of database migration tools like AWS DMS or native backup/restore processes for cloud migrations. Understanding of AWS security best practices and tools such as KMS, GuardDuty, and AWS Config. Certifications such as AWS Certified Solutions Architect, AWS Certified Database Specialty, or Microsoft CertifiedAzure Database Administrator Associate. Educational Qualification: Bachelor’s degree in computer science, Information Technology, or a related field.

Job Title:Senior Database Engineer Experience7-10 Years Location:Chennai We are seeking a highly skilled Senior Database Engineer (SQL Server) to design, implement, optimize, and manage our SQL Server database infrastructure. The ideal candidate will have deep expertise in database architecture, performance tuning, automation, and high availability solutions. This role requires collaboration with development, QA, and IT teams to ensure the database environment is secure, scalable, and aligned with business goals. Key Responsibilities: Database Design & Architecture Design, develop, and maintain complex SQL Server databases. Define and implement database models, schemas, and indexing strategies. Design database structures and schemas based on business requirements. Performance Tuning & Optimization Analyse and optimize SQL queries, stored procedures, and indexing strategies. Monitor database performance using tools like SQL Profiler, Extended Events, and DMVs. Implement partitioning, caching, and execution plan optimization to improve efficiency. Database Deployment and Integration Build and deploy database systems for new applications. Ensuring seamless integration with front-end and back-end systems. Collaborate with developers to implement APIs for database access. Database Maintenance and Monitoring Monitoring database systems for performance, uptime, and availability. Addressing incidents and alerts related to database health. Performing routine maintenance tasks like backups and recovery testing. Collaboration & Support Work closely with application developers to optimize database interactions. Provide production support, troubleshoot database issues, and participate in on-call rotations. Document database processes, architecture, and troubleshooting guides. Database Administration & Maintenance Install, configure, and upgrade SQL Server instances in on-premises and cloud environments. Manage database security, user access controls, and compliance policies (RBAC, encryption, auditing). Develop and enforce database backup, recovery, and retention policies. Qualifications & Skills: Required: Bachelor's degree in computer science, Information Technology, or a related field. 7+ years of experience as a Database Engineer/Administrator (SQL Server). Expertise in SQL Server 2016/2019/2022, T-SQL, and query optimization. Strong knowledge of indexing, partitioning, and performance tuning techniques. Experience with PowerShell, T-SQL scripting, or automation tools. Familiarity with CI/CD pipelines for database deployments (e.g. Redgate). Strong analytical and problem-solving skills. Hands-on experience with high-availability (HA) and disaster recovery (DR) solutions. Excellent communication and documentation abilities. Preferred: Experience with cloud-based SQL Server solutions (AWS RDS). Familiarity with NoSQL databases (MongoDB, Redis) is a plus. Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without advance notice. Any changes may be for an indeterminate time frame. EEO Statement

Job Title Mongo DB Engineer Experience 5-10 Years Location Bangalore : Technical Skills -Strong knowledge of MongoDB architecture, aggregation framework, and schema design. -Hands-on experience with MongoDB Atlas or self-managed MongoDB clusters in cloud environments. -Diagnose, troubleshoot, and resolve issues related to database performance, availability, and connectivity. -Manage MongoDB database clusters, including replica sets, sharding, and backups. -Optimize database performance through indexing, query optimization, and schema design improvements. -Monitor and manage database storage, capacity planning, and scaling. -Support MongoDB deployments on cloud platforms such as AWS, Microsoft Azure. -Certification in MongoDB (e.g., MongoDB Certified DBA) good to have. Certifications Needed Bachelor’s or master’s degree in computer science, Information Systems, Engineering or equivalent. Skills PRIMARY COMPETENCY Data Engineering PRIMARY MongoDB Development PRIMARY PERCENTAGE 51 SECONDARY COMPETENCY Cloud Apps SECONDARY Microsoft Azure-Cloud platform SECONDARY PERCENTAGE 49

Job Title:Database Administrator Experience7-14 Years Location:Chennai : We are looking for a highly skilled Database Administrator (DBA) to manage, maintain, and optimize our databases across multiple platforms. The ideal candidate will have extensive experience with AWS RDS, Microsoft SQL Server, and MongoDB, along with a strong understanding of database security, performance tuning, and high-availability architectures. This role is crucial in ensuring data integrity, security, and efficiency for our SaaS applications while meeting HIPAA and other healthcare compliance requirements. Key Responsibilities Database Management & Administration Design, configure, and maintain AWS RDS (PostgreSQL, MySQL, SQL Server), Microsoft SQL Server, and MongoDB databases. Ensure high availability, performance, and scalability of all databases. Implement backup and disaster recovery strategies, including point-in-time recovery (PITR) and failover mechanisms. Monitor and optimize database performance using tools like AWS CloudWatch, SQL Profiler, and MongoDB Atlas Performance Advisor. Manage database provisioning, patching, and version upgrades in production and non-production environments. Security & Compliance Enforce data security best practices, including encryption, access controls (IAM, RBAC), and compliance with HIPAA and other healthcare regulations. Perform regular security audits and vulnerability assessments using tools like AWS Security Hub and Tenable. Implement and maintain database auditing, logging, and monitoring to detect and prevent unauthorized access. Optimization & Automation Analyze and optimize query performance, indexing strategies, and database schema design. Automate database maintenance tasks using Terraform, AWS Lambda, PowerShell, or Python scripts. Work with DevOps to integrate CI/CD pipelines for database changes (e.g., Flyway, Liquibase). Optimize storage and resource utilization in AWS to reduce costs while maintaining performance. Collaboration & Support Work closely with DevOps, Engineering, and Security teams to ensure database reliability and security. Provide guidance and best practices to developers on database design, indexing, and query performance tuning. Support application teams with troubleshooting, query optimization, and data modeling. Participate in on-call rotation for database-related incidents and outages. Required Qualifications & Experience 5+ years of experience as a Database Administrator in a SaaS or cloud environment. Strong expertise in AWS RDS (PostgreSQL, MySQL, or SQL Server). Proficient in Microsoft SQL Server, including T-SQL, SSMS, and high-availability configurations. Experience with NoSQL databases like MongoDB (Atlas preferred). Deep understanding of performance tuning, query optimization, indexing strategies, and partitioning. Familiarity with Terraform, AWS CloudFormation, or other Infrastructure-as-Code (IaC) tools. Experience with backup and disaster recovery strategies in AWS and on-prem environments. Knowledge of database replication, clustering, and high-availability architectures. Proficiency in scripting (Python, PowerShell, Bash) for automation. Strong knowledge of security best practices (IAM, RBAC, data encryption, audit logging). Familiarity with healthcare compliance requirements (HIPAA, HITRUST) is a plus. Preferred Skills & Certifications AWS Certified Database – Specialty Microsoft CertifiedAzure Database Administrator Associate MongoDB Certified DBA Associate Experience with AI/ML-driven database performance optimization tools Exposure to data warehousing and analytics (Redshift, Snowflake, or BigQuery) Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without advance notice. Any changes may be for an indeterminate time frame. EEO Statement

Job Title:BI Developer Experience4-8 Years Location:Chennai : As a BI Developer, you will collaborate with Initial Validation Audit (IVA), Risk Adjustment, and Quality Improvement (HEDIS) stakeholders to develop dashboards and reports that drive data-informed decision-making. These dashboards and reports will be used both internally and externally to support analytics initiatives. Additionally, you will build internal-facing reports for teams across the organization, including growth, marketing, business development, finance, and operations. Your role will involve managing analytics projects from discovery to implementation, ensuring that business users have access to accurate, timely, and actionable insights. You will work closely with data architects, developers, and analysts to develop analytics products, using Looker as the primary BI tool while also utilizing SQL and Excel for additional data manipulation and analysis. You will also help automate report distribution through scheduled reports, emails, and dashboards, streamlining data delivery to stakeholders. What You'll Do Dashboard Development & Data Visualization – Apply SDLC methodology to design, test, and deploy enterprise dashboards with a strong focus on user experience and effective data visualization. BI Reporting & Analysis – Generate ad-hoc and routine reports, transform raw data into meaningful insights, and provide actionable business intelligence to support data-driven decision-making. Stakeholder Communication & Training – Effectively communicate technical concepts to both clinical and technical audiences and collaborate with business users to understand and address reporting needs. Project & Priority Management – Manage multiple assignments, deadlines, and priorities independently, ensuring timely delivery while maintaining high standards of customer service and documentation. Develop metrics and dashboards with stakeholders to track key performance indicators (KPIs) related to risk score trending, quality improvement, suspecting, member and provider management, financial forecasting, and ROI. Collaborate with data engineering to support and validate data architecture. Provide user assistance and direction for ad-hoc data reporting. Build and refine new analytic processes to better support all lines of business. Maintain structured documentation for dashboards, reports, and data processes using Confluence, Jira, and other documentation tools. Track and manage analytics requests and tasks using Jira, ensuring timely completion and clear stakeholder communication. Write technical documentation to ensure knowledge sharing and reproducibility of BI processes Must Have 4+ years of experience in BI development with strong SQL skills (minimum 4 years) for query optimization on large data sets. Proficiency in data visualization tools (e.g., Looker). Experience in data parsing, manipulation, and validation. Strong statistical analysis skills for working with large data sets. Experience with ETL processing and knowledge of Data Warehouse solutions, strategies, and implementations. Ability to track and manage BI development tasks in Jira. Strong Excel skills (e.g., pivot tables, VLOOKUPs, visualization). Ability to build trust and communicate insights effectively across technical and business teams. Nice to Have Proficiency in Python for data analysis and automation. Experience with U.S. Government-sponsored health plans (Medicare, Medicaid, ACA) and Managed Care Organizations (MCOs), particularly in Quality, Compliance, and Risk Adjustment reporting and analytics. Expertise in data architecture, including designing and implementing new database tables and optimizing schema structures for improved performance. Hands-on experience managing analytics projects using Jira, including creating custom dashboards, workflows, and tracking project progress efficiently. Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without advance notice. Any changes may be for an indeterminate time frame. EEO Statement

We are a pioneering company dedicated to Revolutionizing autism with AI-driven solutions. Role: Develop, debug, and enhance SAP ABAP programs. Collaborate with functional teams to gather requirements. Design and implement technical solutions in SAP Required Candidate profile Optimize existing code for performance. Ensure code quality through testing and reviews.

We are a pioneering company dedicated to Revolutionizing autism with AI-driven solutions. Role: Design, implement, and support SAP solutions Collaborate with stakeholders to gather requirements Customize and configure SAP modules Required Candidate profile Optimize business processes using SAP best practices Provide end-user training and support Ensure system performance and security.

We are a pioneering company dedicated to Revolutionizing autism with AI-driven solutions. Role: Manage and optimize databases (MySQL, MS SQL) Ensure data integrity and security Monitor database performance Required Candidate profile Perform backups, recovery, and tuning Collaborate on database design Write and optimize complex queries Provide database support to developers.

Hiring for Senior Dot net developer - WFO - Job at Chennai Mode : WFO Experience : 5+ yrs A Senior Developer with strong experience in building and maintaining Web APIs and frontend applications . Key Requirements: Deep understanding of Web API design, development, and integration , including RESTful standards and best practices. Proficient in C# , with hands-on experience in both .NET Core and .NET Framework environments. Strong grasp of OOP , SOLID design principles , and modern MVC frameworks . Extensive experience with SQL queries , including query optimization , indexing , and performance tuning . Solid knowledge and experience with distributed caching solutions such as Redis , with a focus on enhancing application performance and scalability . Interview Process - 3 Levels - Virtual round only If interested please apply With Regards , Rathna ( rathna@trinityconsulting.asia )

Job purpose : Maintain, upgrade and manage the database systems in Microlise Data Center. Actively diagnose and resolve problems Job Responsibilities Database and query performance troubleshooting and tuning. Day to day support and administration of all areas of SQL and data warehousing environments. ¢ SQL server patching, Version upgrades, migrations, SSRS, SSIS troubleshooting etc. ¢ Strong root cause analyses skills for urgent live issues. ¢ Database move and handle corruption on system database and user database. ¢ Database refresh/upgrade and data correction work, Performance tuning, capacity planning. ¢ Archiving, backup and restore best practices including robust security policies. ¢ Automation of regular tasks and maintenance tasks. ¢ Assisting developers, implementation and support staff with putting together complex database queries and stored procedures. ¢ Establishing and maintaining company standards and guidelines for SQL. ¢ Contributing to product improvements, ease of use, reliability and reducing support levels. Key Evaluation Criteria ¢ The successful candidate will demonstrate how they can add value to the business by explaining and delivering what best practises and technical methods they have used and which they can implement to allow us to deliver leading edge web-based applications. ¢ In addition, we are also looking for someone who has the experience and knowledge to provide out the box thinking to deliver business requirements in a fast pace ever changing environment. Qualifications & Capabilities Essential ¢ The successful applicant must be able to work independently and within a team environment to help support internal business and external client systems. A mature, professional attitude with good interpersonal and customer facing skills and a flexible attitude to working hours are essential. ¢ Proven experience in a similar role and with a real passion and drive for database administration. 3 to 6 years of relevant experience. ¢ Excellent time management skills, with the ability to deliver accurate quality work to agreed timescales and manage and prioritise own. ¢ Great communication skills to effectively collaborate with geographically separated teams ¢ Relishes a fast pace ever changing environment. ¢ Should be a team player. ¢ Good knowledge on best practices but also out of the box thinking to provide business solutions. ¢ Good Knowledge of PowerShell, especially working on PowerShell for automations. ¢ A great understanding and experience in Microsoft SQL server 2016 to 2022 including installation, configuration, administration, Availability Groups and Clustering. ¢ Some level of experience with SSRS, SSAS and SSIS, also CDC etc. ¢ Experience of 3rd party monitoring tools (DPA, SolarWinds, Redgate SQL Monitor, Grafana). ¢ Always on and Replication hands-on experience is a must. ¢ Flexibility to work in 24*7 with rotational shift model (morning, afternoon or night shifts. Weekly offs as per roster, not necessary on Saturday and Sunday) Desirable ¢ Database architecture ¢ Experience on various versions of MS SQL SERVER. ¢ Tools like Service now, Confluence, AZDO Familiarity with Linux commands ¢ Couchbase hands-on knowledge is a plus. ¢ PostgreSQL hands-on knowledge is also a plus Microsoft SQL server certification DP-300

We are seeking an experienced SQL Developer with expertise in SQL Server Analysis Services (SSAS) and AWS to join our growing team. The successful candidate will be responsible for designing, developing, and maintaining SQL Server-based OLAP cubes and SSAS models for business intelligence purposes. You will work with multiple data sources, ensuring data integration, optimization, and performance of the reporting models. This role offers an exciting opportunity to work in a hybrid work environment, collaborate with cross-functional teams, and apply your skills in SSAS, SQL, and AWS to design scalable and high-performance data solutions. Key Responsibilities : - Design, develop, and maintain SQL Server Analysis Services (SSAS) models, including both Multidimensional and Tabular models, to support business intelligence and reporting solutions. - Create and manage OLAP cubes that are optimized for fast query performance and used for analytical reporting and decision-making. - Develop and implement multidimensional and tabular data models for various business needs, ensuring the models are flexible, scalable, and optimized for reporting. - Work on performance tuning and optimization of SSAS solutions, ensuring efficient query processing and high performance even with large data sets. - Integrate data from various sources, including SQL Server databases, flat files, and cloud-based storage, into SSAS models for seamless and accurate reporting. - Integrate and manage data from AWS services (e.g., S3, Redshift, etc.) into the SQL Server database and SSAS models for hybrid cloud and on-premise data solutions. - Leverage SQL Server PolyBase to access and integrate data from external data sources like AWS S3, Azure Blob Storage, or other systems for data processing. - Ensure data integrity, consistency, and accuracy within the data models and reporting systems. Work closely with data governance teams to maintain high-quality data standards. - Work in an agile team environment with BI developers, data engineers, and business analysts to align data models and solutions with business requirements. - Provide support for production systems, troubleshoot issues with SSAS models, queries, and reporting solutions, and implement fixes when necessary. - Maintain clear and detailed technical documentation for SSAS model designs, ETL processes, and best practices for data integration. Required Skills & Experience : - 5+ years of experience as a SQL Developer with strong hands-on expertise in SSAS. - In-depth experience in creating and managing SSAS models, including multidimensional (OLAP) and tabular models. - Proficiency in SQL Server (T-SQL, SSIS, SSRS) for data integration, data transformation, and reporting. - Strong understanding of SSAS performance tuning, query optimization, and processing. - Experience with AWS services, particularly AWS S3, AWS Redshift, and their integration with SQL Server-based solutions. - Knowledge of SQL Server PolyBase for data integration and access from external data sources. - Experience in business intelligence solutions and creating reports using tools like Power BI or SSRS. - Familiarity with cloud data integration, ensuring seamless integration between on-premise SQL Server databases and cloud-based storage (AWS). - Strong problem-solving skills and the ability to troubleshoot and resolve issues in data models and data warehouses. - Excellent communication skills, both verbal and written, with the ability to effectively collaborate with cross-functional teams. Apply Insights Follow-up Save this job for future reference Did you find something suspiciousReport Here! Hide This Job Click here to hide this job for you. You can also choose to hide all the jobs from the recruiter.

Must have skills - Must have strong working experience with PHP, MySQL. - Must have atleast 4+ years of experience in Laravel framework. - Must be expertise in developing REST API Services. - Good understanding of OOPS, MVC structure. - Good understanding of front-end technologies, including HTML5, CSS3, JavaScript, jQuery. - Knowledge on client-side rendering, AJAX. - Good understanding of MySql query optimization. - Must have good problem-solving skills. Good to have skills: - Analysing websites, portals and application requirements. - Review code of team members. - knowledge of Swagger/Postman tool. - Handling NodeJS services. - Writing backend code & building efficient PHP modules. - Knowledge about OWASP security implementations. - Knowledge about PSR (PHP Standard Recommendations) - Developing backend portals with an optimized database. - Troubleshooting application and code issues. - Finalizing backend features and testing web applications. - Updating & Altering application features to enhance performance. - Strong communication skills. Apply Insights Follow-up Save this job for future reference Did you find something suspiciousReport Here! Hide This Job Click here to hide this job for you. You can also choose to hide all the jobs from the recruiter.

Role Proficiency: Resolve enterprise trouble tickets within agreed SLA and raise problem tickets for permanent resolution and/or provide technical leadership (lateral or hierarchical) for the team to resolve customer issues Outcomes: 1) Update SOP with updated troubleshooting instructions and process changes2) Mentor new team members in understanding customer infrastructure and processes3) Perform analysis for driving incident reduction4) Escalate high priority incidents to customer and organization stakeholders for quicker resolution5) Contribute to planning and successful migration of platforms6) Perform root cause analysis to find out corrective and preventive actions after every major incidents and escalations7) Work on problem tickets for finding permanent solutions of repeated issues8) Create roll out and roll back plan for change implementation and ensure adherence for preventing unauthorized changes Measures of Outcomes: 1) SLA Adherence2) Time bound resolution of elevated tickets - OLA3) Manage ticket backlog timelines - OLA4) Adhere to defined process - Number of NCs in internal/external Audits5) Number of KB articles created6) Number of incidents and change ticket handled 7) Number of elevated tickets resolved8) Number of successful change tickets9) % Completion of all mandatory training requirements Outputs Expected: Resolution: Understand Priority and Severity based on ITIL practice resolve trouble ticket within agreed resolution SLA Troubleshooting: Troubleshooting based on available information from previous tickets or consulting with seniors. Participate in online knowledge forums reference. Covert the new steps to KB article Perform logical/analytical troubleshooting. Work on problem tickets to identify permanent solutions Escalation/Elevation: Escalate within organization/customer peer in case of resolution delay. Understand OLA between delivery layers (L1 L2 L3 etc) adhere to OLA. Elevate to next level work on elevated tickets from L1 Tickets Backlog/Resolution: Follow up on tickets based on agreed timelines manage ticket backlogs/last activity as per defined process. Resolve incidents and SRs within agreed timelines. Execute change tickets for infrastructure. Installation: Install and configure tools software and patches Runbook/KB: Update KB with new findings Document and record troubleshooting steps as knowledge base Collaboration: Collaborate with different towers of delivery for ticket resolution (within SLA); resolve L1 tickets with help from respective tower. Collaborate with other team members for timely resolution of tickets. Actively participate in team/organization-wide initiatives. Co-ordinate with UST ISMS teams for resolving connectivity related issues. Stakeholder Management: Lead the customer calls and vendor calls. Organize meeting with different stake holders. Take ownership for function's internal communications and related change management. Strategic: Define the strategy on data management policy management and data retention management. Support definition of the IT strategy for the function's relevant scope and be accountable for ensuring the strategy is tracked benchmarked and updated for the area owned. Process Adherence: Thorough understanding of organization and customer defined process. Suggest process improvements and CSI ideas. Adhere to organization' s policies and business conduct. Process/efficiency Improvement: Proactively identify opportunities to increase service levels and mitigate any issues in service delivery within the function or across functions. Take accountability for overall productivity efforts within the function including coordination of function specific tasks and close collaboration with Finance. Process Implementation: Coordinate and monitor IT process implementation within the function Compliance: Support information governance activities and audit preparations within the function. Act as a function SPOC for IT audits in local sites (incl. preparation interface to local organization mitigation of findings etc.) and work closely with ISRM (Information Security Risk Management). Coordinate overall objective setting preparation and facilitate process in order to achieve consistent objective setting in function Job Description. Coordination Support for CSI across all services in CIS and beyond. Training: On time completion of all mandatory training requirements of organization and customer. Provide On floor training and one to one mentorship for new joiners. Complete certification of respective career paths Performance Management: Update FAST Goals in NorthStar track report and seek continues feedback from peers and manager. Set goals for team members and mentees and provide feedback.Assist new team members in understanding the customer environment Skill Examples: 1) Good communication skills (Written verbal and email etiquette) to interact with different teams and customers. 2) Modify / Create runbooks based on suggested changes from juniors or newly identified steps3) Ability to work on an elevated server ticket and solve4) Networking:a. Trouble shooting skills in static and Dynamic routing protocolsb. Should be capable of running netflow analyzers in different product lines5) Server:a. Skills in installing and configuring active directory DNS DHCP DFS IIS patch managementb. Excellent troubleshooting skills in various technologies like AD replication DNS issues etc.c. Skills in managing high availability solutions like failover clustering Vmware clustering etc.6) Storage and Back up:a. Ability to give recommendations to customers. Perform Storage & backup enhancements. Perform change management.b. Skilled in in core fabric technology Storage design and implementation. Hands on experience on backup and storage Command Line Interfacesc. Perform Hardware upgrades firmware upgrades Vulnerability remediation storage & backup commissioning and de-commissioning replication setup and management.d. Skilled in server Network and virtualization technologies. Integration of virtualization storage and backup technologiese. Review the technical diagrams architecture diagrams and modify the SOP and documentations based on business requirements.f. Ability to perform the ITSM functions for storage & backup team and review the quality of ITSM process followed by the team.7) Cloud:a. Skilled in any one of the cloud technologies - AWS Azure GCP.8) Tools:a. Skilled in administration and configuration of monitoring tools like CA UIM SCOM Solarwinds Nagios ServiceNow etcb. Skilled in SQL scriptingc. Skilled in building Custom Reports on Availability and performance of IT infrastructure building based on the customer requirements9) Monitoring:a. Skills in monitoring of infrastructure and application components10) Database:a. Data modeling and database design Database schema creation and managementb. Identify the data integrity violations so that only accurate and appropriate data is entered and maintained.c. Backup and recoveryd. Web-specific tech expertise for e-Biz Cloud etc. Examples of this type of technology include XML CGI Java Ruby firewalls SSL and so on.e. Migrating database instances to new hardware and new versions of software from on premise to cloud based databases and vice versa.11) Quality Analysis: a. Ability to drive service excellence and continuous improvement within the framework defined by IT Operations Knowledge Examples: 1) Good understanding of customer infrastructure and related CIs. 2) ITIL Foundation certification3) Thorough hardware knowledge 4) Basic understanding of capacity planning5) Basic understanding of storage and backup6) Networking:a. Hands-on experience in Routers and switches and Firewallsb. Should have minimum knowledge and hands-on with BGPc. Good understanding in Load balancers and WAN optimizersd. Advance back and restore knowledge in backup tools7) Server:a. Basic to intermediate powershell / BASH/Python scripting knowledge and demonstrated experience in script based tasksb. Knowledge of AD group policy management group policy tools and troubleshooting GPO sc. Basic AD object creation DNS concepts DHCP DFSd. Knowledge with tools like SCCM SCOM administration8) Storage & Backup:a. Subject Matter Expert in any of the Storage and Backup technology9) Tools:a. Proficient in the understanding and troubleshooting of Windows and Linux family of operating systems10) Monitoring:a. Strong knowledge in ITIL process and functions11) Database:a. Knowledge in general database management b. Knowledge in OS System and networking skills Additional Comments: Key Responsibilities: Database Management: Administer and manage MS SQL Server databases (versions 2012 and above), ensuring database availability, security, and performance. Performance Tuning: Perform performance tuning and optimization of databases, including indexing, query optimization, and SQL Server Profiler usage. Backup & Recovery: Implement and manage backup and recovery strategies for high availability and disaster recovery plans. High Availability Solutions: Design and implement high availability solutions like Always-On Availability Groups, SQL Server Clustering, Log Shipping, and Database Mirroring. Database Security: Administer SQL Server security, including creating and managing users, roles, permissions, and encryption techniques. Database Migrations & Upgrades: Lead database migration projects and upgrade efforts across environments and versions. Automation: Automate routine database maintenance tasks, such as backups, cleanup jobs, and index maintenance using SQL Agent and PowerShell scripts. Troubleshooting: Identify and resolve database-related issues such as performance bottlenecks, corruption, connectivity, and query optimization. Monitoring & Reporting: Monitor the health and performance of SQL Server instances and provide proactive reports and dashboards to stakeholders. Documentation: Maintain up-to-date documentation for all databases, configurations, and procedures to ensure easy troubleshooting and knowledge transfer. Collaboration: Work closely with development teams to optimize application code and database interactions. Provide support in database design, and implement best practices. Capacity Planning: Ensure that databases are scalable by analyzing resource usage trends and planning for capacity needs. Required Skills and Experience: Experience: 8-9 years of experience as a Microsoft SQL Server DBA managing large-scale SQL Server environments. SQL Server Versions: Deep expertise with SQL Server 2012 and above (2016, 2019 preferred). High Availability & DR Solutions: Strong hands-on experience with Always-On Availability Groups, SQL Server Clustering, and other HA/DR solutions. Performance Tuning: Proven experience in query optimization, execution plan analysis, and performance tuning. Backup & Recovery: Hands-on experience with backup strategies, point-in-time recovery, and disaster recovery planning. Scripting & Automation: Proficiency in T-SQL and PowerShell scripting to automate administrative tasks. Security Management: Knowledge of database security best practices, encryption, auditing, and compliance. Tools & Monitoring: Experience with monitoring tools like SQL Server Management Studio (SSMS), SQL Profiler, Redgate, etc. Problem-Solving: Strong troubleshooting and problem-solving skills with a proactive mindset. Preferred Certifications: Certifications: Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: SQL Server Database Administration (MCSA) is a plus. Cloud Experience: Experience with Azure SQL Database or other cloud database platforms is a plus. Soft Skills: Strong communication and interpersonal skills with the ability to work effectively across teams. Ability to work under pressure, manage multiple tasks, and meet deadlines. Detail-oriented with excellent organizational skills. Required Skills Mysql,Mongo Db,SQL Server DBA

Education background: BE/B Tech/MCA/MSc Comp science. --Only Detailed job description - Skill Set: 8+ years of experience with data analytics and warehousing in Investment Finance Domain. Informatica, SQL Deep knowledge of SQL and query optimization ELT Good understanding of ELT methodologies and tools. Troubleshooting Experience with troubleshooting and root cause analysis to determine and remediate potential issues Communication Excellent communication, problem solving and organizational and analytical skills. Able to work independently and to provide leadership to small teams of developers 3 years of coding and scripting Python, Java, Scala and design experience. Mandatory Skills Informatica, SQL, Python

Key Responsibilities: Oracle DBA Responsibilities: Install, configure, and upgrade Oracle databases (including RAC and Data Guard). Monitor database performance and implement tuning measures. Manage Oracle ASM, RMAN backup/recovery strategies, and OEM for monitoring. Handle Oracle patching, cloning, and migration activities. Perform Oracle GoldenGate replication setup and troubleshooting. Ensure database security, role management, and audit compliance. Participate in disaster recovery (DR) planning and testing. Performance and tuning with good SQL skills PostgreSQL DBA Responsibilities: Install, configure, and manage PostgreSQL databases (community and enterprise editions). Handle backup and recovery using pg_dump , pg_basebackup , and WAL archiving. Implement streaming replication and high availability using tools like Patroni, repmgr, or pgpool-II. Tune PostgreSQL performance through query optimization, indexing, and configuration parameters. Manage upgrades and patching with minimal downtime. Support migration of databases from Oracle to PostgreSQL (using tools like Ora2Pg or AWS DMS). Performance and tuning with good SQL skills

SS&C Eze Software is seeking Senior Engagement Specialist to join the Product Specialists (Framework) team based out of Hyderabad, India office within the Engagement function of Client Services group . The Engagement Specialist team acts as a SME to our clients who are among the top Hedge Funds, Institutional Wealth Managers and financial professionals around the world. The team serves as an important arm of onboarding new clients and supporting the existing clients. Engagement Specialist will take requests and solve them according to the internal/external stakeholder s needs. The successful candidate will be a highly-motivated individual who will play a key role in the implementation of the system for our customers. Additionally, the candidate will assist in executing the standard day to day responsibilities of the team foundational or critical elements of the Eze Software product suite implementations, migrations and upgrades. This position requires extensive leadership capabilities, critical thinking, organization, attention to detail, and a strong understanding of electronic trading workflows. This role will allow this individual to develop strong relationships with our sell-side clients, including business, technical contacts, and other external parties. This position will also provide the opportunity to work closely with client technology teams. Excellent communications and organizational skills are essential, and the candidate should be comfortable managing projects from start to finish with minimal supervision. Job Functions: Understand customer requirements and deployments and map them to the solution, provide product implementation and support Knowledge or exposure in SQL server installations. Plans and tests DR (Disaster Recovery) exercises Responsible for interfacing with the customer and partners on implementation projects to ensure readiness before implementation Investigate failures, collaborates with the R&D team to come up with fixes, and test and release the fixes or patches to customers Designs, develops, troubleshoots and resolves data migration strategies and tools, database integrity issues; performance issues; deadlocks; performance tuning & query optimization Detect & resolve issues related to CPU; Memory; I/O disk space etc., installation and configuration of SQL Server and troubleshooting Monitor alerts, and proactively fix issues to ensure database systems to work seamlessly Communicates impact of issues to senior management

The successful candidate will be a highly-motivated individual who will play a key role in the implementation of the system for our customers. Additionally, the candidate will assist in executing the standard day to day responsibilities of the team foundational or critical elements of the Eze Software product suite implementations, migrations and upgrades. This position requires extensive leadership capabilities, critical thinking, organization, attention to detail, and a strong understanding of electronic trading workflows. This role will allow this individual to develop strong relationships with our sell-side clients, including business, technical contacts, and other external parties. This position will also provide the opportunity to work closely with client technology teams. Excellent communications and organizational skills are essential, and the candidate should be comfortable managing projects from start to finish with minimal supervision. Job Functions Understand customer requirements and deployments and map them to the solution, provide product implementation and support Knowledge or exposure in SQL server installations. Plans and tests DR (Disaster Recovery) exercises Responsible for interfacing with the customer and partners on implementation projects to ensure readiness before implementation Investigate failures, collaborates with the R&D team to come up with fixes, and test and release the fixes or patches to customers Designs, develops, troubleshoots and resolves data migration strategies and tools, database integrity issues; performance issues; deadlocks; performance tuning & query optimization Detect & resolve issues related to CPU; Memory; I/O disk space etc., installation and configuration of SQL Server and troubleshooting Monitor alerts, and proactively fix issues to ensure database systems to work seamlessly Communicates impact of issues to senior management

About the Role: We are seeking a highly skilled SQL Performance Engineer to analyze, troubleshoot, and optimize SQL queries across our database systems. The ideal candidate will have deep expertise in database internals, query execution plans, and performance tuning, providing actionable recommendations to enhance system efficiency and response times. Key Analyze slow-performing queries, stored procedures, and database workloads. Review and interpret SQL execution plans to identify bottlenecks. Recommend and implement query optimization strategies (e.g., indexing, rewriting queries, partitioning). Collaborate with developers, DBAs, and application teams to drive SQL performance improvements. Conduct root cause analysis of database performance issues and suggest solutions. Develop and maintain SQL performance monitoring tools and reports. Assist in capacity planning and optimization of database resources. Provide best practices and training on SQL performance to development and operations teams. Required Skills and Qualifications: 7+ years of experience in SQL performance tuning and optimization. Strong expertise in interpreting SQL execution plans and query profiling. Proficient in major RDBMS platforms (e.g., Microsoft SQL Server, PostgreSQL). Experience with database indexing strategies, statistics management, and query refactoring. Hands-on experience with performance monitoring tools (e.g., SQL Profiler, AWS RDS Performance Insights). Good understanding of database internals (locking, latching, blocking, deadlocks). Strong analytical and problem-solving skills. About the Role: We are seeking a highly skilled SQL Performance Engineer to analyze, troubleshoot, and optimize SQL queries across our database systems. The ideal candidate will have deep expertise in database internals, query execution plans, and performance tuning, providing actionable recommendations to enhance system efficiency and response times. Key Analyze slow-performing queries, stored procedures, and database workloads. Review and interpret SQL execution plans to identify bottlenecks. Recommend and implement query optimization strategies (e.g., indexing, rewriting queries, partitioning). Collaborate with developers, DBAs, and application teams to drive SQL performance improvements. Conduct root cause analysis of database performance issues and suggest solutions. Develop and maintain SQL performance monitoring tools and reports. Assist in capacity planning and optimization of database resources. Provide best practices and training on SQL performance to development and operations teams. Required Skills and Qualifications: 7+ years of experience in SQL performance tuning and optimization. Strong expertise in interpreting SQL execution plans and query profiling. Proficient in major RDBMS platforms (e.g., Microsoft SQL Server, PostgreSQL). Experience with database indexing strategies, statistics management, and query refactoring. Hands-on experience with performance monitoring tools (e.g., SQL Profiler, AWS RDS Performance Insights). Good understanding of database internals (locking, latching, blocking, deadlocks). Strong analytical and problem-solving skills.

Providing support on all versions of SQL Starting from 2014 to SQL 2022 Installation and configuration of Standalone as well as clustered instances of SQL Server with SSIS/SSRS Patching of Standalone as well as clustered instances of SQL Server Hardening SQL Server as per WNS Standard DB Hardening policy Providing support for upgrade to higher versions Setting up of DR sites using log shipping, always on etc. Providing support for Backup / Restores / migrations of databases, logins and Jobs Providing support for troubleshooting of all issues related to Databases Troubleshooting performance issues, performance tuning and Query optimization Hands on Experience in development of ETLs using SSIS Providing support for SQL Database like Azure, AWS and SQL and Manged instance or RDS Though not mandatory expected to have working knowledge of Postgres on Windows Knowledge of AWS RDS PostgreSQL Administration Qualifications Any Graduate or Diploma in IT

Design scalable and robust PostgreSQL database architectures for enterprise-grade applications. Develop logical and physical data models aligned with business requirements. Create and maintain best practices for database design, coding, performance tuning, and security. Perform capacity planning, data partitioning, and replication strategies. Implement and manage high availability, disaster recovery, and backup strategies. Work closely with software developers, DevOps, and system architects to integrate database solutions with applications. Develop database deployment pipelines and automation scripts using tools such as Ansible, Terraform, or CI/CD. Conduct performance monitoring, query optimization, and troubleshooting for slow-running SQLs. Establish and enforce database access controls, user roles, and data protection protocols. Migrate legacy databases (e.g., Oracle, MySQL) to PostgreSQL when required. Provide mentorship to developers and DBAs on PostgreSQL usage and tuning Preferred candidate profile Proven experience with high-availability architecture (Patroni, Streaming Replication, etc.). Strong expertise in performance tuning, indexing strategies, and complex query analysis. Familiarity with JSONB, GIS data types, full-text search, and PostgreSQL extensions. Experience in Linux-based environments (preferably Ubuntu/CentOS/RHEL). Experience in designing databases for microservices and event-driven architectures. Knowledge of PostgreSQL monitoring tools (pgAdmin, pg_stat_statements, Prometheus, etc.). Hands-on experience with database automation and DevOps pipelines. Experience in database security, encryption, auditing, and compliance. Experience in cloud-native PostgreSQL deployments (e.g., AWS RDS/Aurora, GCP Cloud SQL, Azure Database for PostgreSQL). Certification in PostgreSQL or relevant database technologies. Experience with NoSQL integrations or hybrid data architectures.