45 Tsql Jobs - Page 2

Qualification : Bachelor's or Master's in Computer Science & Engineering, or equivalent. Professional Degree in Data Science, Engineering is desirable. Experience level : At least 3 - 5 years hands-on experience in Data Engineering, ETL. Desired Knowledge & Experience : Spark: Spark 3.x, RDD/DataFrames/SQL, Batch/Structured Streaming Knowing Spark internals: Catalyst/Tungsten/Photon Databricks: Workflows, SQL Warehouses/Endpoints, DLT, Pipelines, Unity, Autoloader IDE: IntelliJ/Pycharm, Git, Azure Devops, Github Copilot Test: pytest, Great Expectations CI/CD Yaml Azure Pipelines, Continuous Delivery, Acceptance Testing Big Data Design: Lakehouse/Medallion Architecture, Parquet/Delta, Partitioning, Distribution, Data Skew, Compaction Languages: Python/Functional Programming (FP) SQL : TSQL/Spark SQL/HiveQL Storage : Data Lake and Big Data Storage Design additionally it is helpful to know basics of: Data Pipelines : ADF/Synapse Pipelines/Oozie/Airflow Languages: Scala, Java NoSQL : Cosmos, Mongo, Cassandra Cubes : SSAS (ROLAP, HOLAP, MOLAP), AAS, Tabular Model SQL Server : TSQL, Stored Procedures Hadoop : HDInsight/MapReduce/HDFS/YARN/Oozie/Hive/HBase/Ambari/Ranger/Atlas/Kafka Data Catalog : Azure Purview, Apache Atlas, Informatica Required Soft skills & Other Capabilities : Great attention to detail and good analytical abilities. Good planning and organizational skills Collaborative approach to sharing ideas and finding solutions Ability to work independently and also in a global team environment.

About the Role: The Team: We are a small, highly motivated team in a newly set up division to scale innovation. We use agile methodologies to drive performance and we share and transfer knowledge as well as embracing methods such as pairing or lightning talks to do so. We are always trying to stay ahead of things and try to be state-of-the-art and cutting-edge. We are looking for a Lead Software Developer (Full Stack) with .Java, Spring boot, React or Angular, JavaScript skills who will contribute and lead the application development of the product. Candidate should understand product vision and should be able to analyze requirements, design and implement enterprise level applications and follow agile methodology in a Scrum environment. The Impact: You have the possibility to shape one of the oldest existing industries in one of the largest enterprises in the market. Through active participation in shaping and improving our ways to achieve technical excellence you will drive and improve our business. Responsibilities: Analyze stories that have been written by Product Owner and perform an estimation of the complexity Setup?a strategy to implement the stories. Build or Enhance features in respect to the stories with defensible coding strategies. Delivery with best quality. Provide support and maintenance. Collaborate effectively with technical and non-technical stakeholders Follow agile best practices. Raise Concerns About Incomplete or Poor Requirements Attend all Scrum ceremonies Mentoring the junior developers Analyze and recommend solution design (Design Guidance) Ensure that team has an optimal breakdown of Tasks based off functionality or Make sure that code review tasks on all user stories are added and timely completed Ensures that scrum practices are followed and raise concern where you see an anomaly Ensures that team is following the Unit Testing. What Were Looking For: Basic Qualification A minimum of 10+ years of strong experience in application development. Proficient with software development lifecycle (SDLC) methodologies like Agile, Test- driven development. Strong command in JavaScript-frameworks (React /Angular/ Durandal/ similar), Java, Spring boot, python, Restful Services, HTML 5, CSS, XML/XSLT, JQuery, TSQL (SQL Server) and query optimization techniques Knowledge of object-oriented design, Cross-browser Compatibility, Responsive UI Good understanding of Design Principles & excellent communication skills Bachelors or masters degree (or higher) in a relevant discipline, or equivalent work experience Knowledge of system architecture, designpatterns & ability to work in layered architecture: Presentation, Service, Business & Data. Experience working with AWS cloud or equivalent. Experience working with Serverless, Kubernetes, Elastic Search, Redis, NoSQL, Containers and Docker is a plus.

Azure Data Engineer (Technical lead) JD Designation- Technical Leader Experience - 10-12 years Location - Chennai, Kochi and Bangalore Responsibilities: l Design, develop, and maintain robust data pipelines and ETL processes. l Implement and optimize data storage solutions in data warehouses and data lakes. l Collaborate with cross-functional teams to understand data requirements and deliver high-quality data solutions. l Utilize Microsoft Azure tools for data integration, transformation, and analysis. l Develop and maintain reports and dashboards using Power BI and other analytics tools. l Ensure data integrity, consistency, and security across all data systems. l Optimize database and query performance to support data-driven decision-making. Qualifications: l 10-12 years of professional experience in data engineering or a related field. l Profound expertise in SQL, T-SQL, database design, and data warehousing principles. l Strong experience with Microsoft Azure tools, including SQL Azure, Azure Data Factory, Azure Databricks, and Azure Data Lake. l Proficiency in Python, PySpark, and PySQL for data processing and analytics tasks. l Experience with Power BI and other reporting and analytics tools. l Demonstrated knowledge of OLAP, data warehouse design concepts, and performance optimizations in database and query processing. l Excellent problem-solving, analytical, and communication skills.

Power BI Lead - J48719 We are looking for Power BI developers to join our team You should be familiar with SSRS and TSQL, Power Query, MDX, PowerBI, and DAX are just a few of the tools and systems on the MS SQL Server BI Stack. Developing Power BI desktop to create dashboards, KPI scorecards, and visual reports Required Candidate profile Candidate Experience Should Be : 8 To 15 Candidate Degree Should Be : BE-Comp/IT,BE-Other,BSc-Comp/IT,BSc-Other,BTech-Comp/IT,BTech-Other,MCA,MCM,ME-Comp/IT,ME-Other

evaluate and plan migrations to Postgres, Develop/Enhance database PLSQL scripts/TSQL,GCP Services, heterogenous database migrations.5-7 years, min 4+ years of experience in database development/migration using Oracle/SQL Server/MySQL Required Candidate profile Notice Period: immediately.Education BE, B.Tech, ME, M.Tech, MCA Location Pune, Noida, Hyderabad & Chennai, Bangalore

Greetings!! Immediate hiring for MSBI Developers Role : MSBI Developer Exp - 6+ Years Notice - Immediate to 20 Days Share CV to safoora.imthiyas@aspiresys.com - immediate joiners Candidate Validation Checklist: SSIS 4 + Years SQL 4+ yaers SSRS - 1 + Years Job Description SSIS Highly proficient in SSIS with Strong knowledge of working in ETL development, Performance tuning, data profiling. Proficient in Data Migration from different sources using SSIS. Ability to walk through independently and logically understand existing SSIS Packages, Scheduling Jobs, and Debugging. SQL Well-versed in T-SQL Programming Highly proficient in SQL DB Complex Queries, indexing, stored procedures, functions, and joins. Performance tuning & optimizations Basic DB Administration knowledge to handle common database procedures such as upgrade, backup, recovery, migration, etc. Knowledge of best practices when dealing with relational databases. SSRS Basic knowledge in SSRS report development & deployment. Able to work with the code from scratch. Prepare documentation and specifications for the work that is done. Good in Communication Following the project life cycle. Must have skills: SQL SSIS SSRS basics Nice to have. Hands-on Power BI Tool Knowledge in Azure cloud technologies Safoora Nausheen Talent Acquisition Mobile: 9384788107 Website: www.aspiresys.com | Blog: http://blog.aspiresys.com

Must have overall IT experience 4+ years, 3+ years of Data Migration and experience with D365 CE/CRM Strong communication and collaboration skills Very good Knowledge of Dynamics CRM product Develop data migration code based on the requirements Mentors and Coaches the team members Day-to-Day management of the team, working closely with the customer to provide information around scheduling, risks, issues etc. Strong TSQL and SSIS skills Good to have either Scribe / Kingsway soft or other tool in the Data Migration projects Must have worked at least in 1 Data Migration projects (end to end) using CRM. Must have work experience in performing Document migration activities CRM Customization Azure BI tools Data Insights, Analytics inclusive and not limited to Data Engineering development and their GTM forays Focus on Data lake on cloud , BigData Data Science including AI , ML , NLP and also covering Automation development and their GTM forays Block Chain and Computer Vision offerings to Global Clientele Required Skills- D365 CE CRM, Dynamics CRM, TSQL, SSIS, AI , ML , NLP

Design and implement Azure BI infrastructure, ensure overall quality of delivered solution. Develop analytical & reporting tools, promote and drive adoption of developed BI solutions. Demonstrated experience using development tools such as Azure SQL database, Azure Data Factory, Azure Data Lake, Azure Synapse, and Azure DevOps. Proficient in TSQL and python for data analysis. Experience with development methodologies including Agile, DevOps, and CICD patterns

Job Title: Power BI Developer Job Summary: We are looking for a talented and detail-oriented Business Intelligence (BI) Developer to join our growing data team. In this role, you will be responsible for designing, developing, and maintaining BI solutions, such as reports, dashboards, and data models. You will work closely with business stakeholders to ensure that data insights are effectively presented and utilised for strategic decision-making. Key Responsibilities: • BI Solution Development: Design, develop, and implement BI reports, dashboards, and data visualisations that align with business requirements and provide actionable insights. • Data Integration: Work on extracting, transforming, and loading (ETL) data from various sources to ensure accurate and timely availability of information. • Collaboration with Stakeholders: Partner with business users to understand reporting needs and translate them into technical solutions. • System Optimisation: Monitor and optimise BI systems for performance and scalability, ensuring that reporting tools are both responsive and reliable. • Documentation: Document BI solutions, processes, and workflows to ensure consistency and ease of maintenance. • Support & Troubleshooting: Provide ongoing support to end-users by troubleshooting issues with reports and dashboards. Required Skills and Qualifications: • Proven experience as a BI Developer or in a similar data analytics role. • Strong proficiency in BI tools (e.g., Power BI, Tableau, Qlik, SSRS etc.) for creating reports and dashboards. • Experience with cloud-based BI platforms (e.g., Azure, AWS, Google Cloud). • Solid experience with SQL for data extraction, analysis, and query optimisation. • Proficient in TSQL, DAX, Power Query • Experience with ETL processes and data integration techniques (e.g. SSIS) • Strong understanding of data modelling concepts and database design principles. • Ability to analyse large datasets and present complex findings in an understandable format. • Excellent problem-solving and troubleshooting skills. • Strong communication skills, with the ability to present findings to both technical and non-technical stakeholders. Preferred candidate profile Candidate should have minimum 5 years of experience with Power BI along with below skills: • Familiarity with cloud-based BI solutions (e.g., Azure, AWS, Google Cloud). • Experience with programming languages such as Python or R for data manipulation. • Knowledge of Big Data technologies such as Hadoop or Spark. • Familiarity with data governance, security practices, and compliance standards. • BI tool certifications (e.g., Power BI, Tableau) are a plus. Perks and benefits 5 Days working Mediclaim Paid Leaves

Minimum Requirements: 9+ years of experience overall in IT Current - 4+ years of experience on Azure Cloud as Data Engineer Current - 4+ years of hands-on experience on Databricks/Azure Databricks Proficient in Python/PySpark Proficient in SQL/TSQL Proficient in Data Warehousing Concepts (ETL/ELT, Data Vault Modelling, Dimensional Modelling, SCD, CDC) Logistics domain experience Primary Skills: Azure Cloud, Databricks, Azure Data Factory, Azure Synapse Analytics, SQL/TSQL, PySpark, Python Technical Expertise: ETL/ELT Pipelines: Design, implementation, and optimization. Azure ADF and Synapse: Proficiency in creating pipelines, developing notebooks, and performing data transformations. Databricks: Hands-on experience with creating notebooks and performing data transformations. Familiarity with Dataflows, Data Wrangling, and integration with REST APIs. Experience with Parquet and Delta file processing, along with optimization techniques Familiarity with Azure DevOps and CI/CD Concepts and Methodologies: Data Warehousing: Comprehensive understanding of concepts and implementation Data Modelling Techniques: Familiarity with Data Vault (if not, then Dimensional Modelling Technique) SCD and CDC: Strong grasp of Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) methodologies Agile Methodology Programming Skills: Python/PySpark/SparkSQL Strong proficiency in any of these SQL/T-SQL A must-have: Demonstrates strong association with team dynamics and the ability to maintain harmony in a collaborative environment. Proven ability to be a team player who contributes to shared goals while supporting peers. Good to have: Basic knowledge on Delta Tables, Delta Live Tables (DLT), Partitioning and Optimization. Knowledge of Unity Catalog and Job Clusters is an added advantage. Familiarity with tools like Azure Monitor, Log Analytics, and Spark UI is an added advantage. Good to have knowledge with real-time data ingestion and streaming pipelines. Experience with framework driven projects (Metadata framework, Audit control framework) Relational and No-SQL Databases Certifications: AZ 900 Azure fundamentals DP 203 – Azure Data Engineer Databricks Associate Data Engineer

Minimum of 8+ years of experience as a SQL Developer. Knowledge of SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). hemalatha.a@srijanspectrum.com

We are in search of a dynamic and motivated Associate Architect to join our team. As an Associate Architect your responsibilities encompass the entire software development life cycle, from design and coding to maintenance and deployment. The successful candidate will be a self-starter, highly motivated and possess the ability to prioritize and manage multiple projects. As the successful individual grows, there will be opportunity to add further responsibility and ownership, focused on driving innovation and products to meet the demands and needs of the industry. This role will be focused initially on remotely deploying our web applications to customer networks and maintaining them. Training will be provided. Position Requirements Design and develop secure desktop and web applications for real time systems. Create applications using coding best practices and internal ePS coding guidelines. Strong project time management and prioritization skills. Communicate questions, concerns, status and provide recommendations to managers. Ability to estimate projects accurately, build project schedules based on level of effort, communicate deliverables, document updates and stay on schedule. Liaise with key business and technology teams (understanding our business and marketing goals) to ensure stylized, integrated and aligned solutions are created. Unit testing and documentation. Help maintain code quality by being part of regular code reviews. Regular visits to customer sites for software testing, deployment and upgrades. Ensure you and the team are always working in a safe manner, adhering to the customers and ePS H&S rules and Risk Assessments. Skills : 8+ years experience of web applications development. Experience of Java, Spring, RabbitMQ, Nginx. Experience of ELK stack is must. Experience in building distributed systems. Solid understanding of developing applications using latest web standards including security. Experience of configuring and deploying applications on Webservers including Tomcat. Experience of writing applications in Angular or similar JavaScript framework. Experience of backend database development and creating reports using TSQL. Experience of deploying web applications using Docker would be an advantage. Proficient understanding of code versioning tools?such as git. Familiarity with CI/CD pipeline, automated testing platforms and unit tests. Familiarity of working within a scrum/agile team. Excellent interpersonal and communication skills for interacting with customers. Ability to work effectively under pressure and meet project deadlines. Requirements : Willingness to travel. This role involves traveling to sites, sometimes on weekends. These trips can vary between one day site visits up to two weeks installations. Extra pay and expenses are provided. A clean driving license. A valid passport.

Experience: 8 - 10 years of prior experience which includes 3+ years of Team Lead experience required. What you will be doing: Working on Microsoft SQL Server 2012 and above server-side development. Designing the schema that can be usable across multiple customers. Design and developing T-SQL (Transact SQL) Stored Procedures, Functions and Triggers and SSIS packages. Develop underlying data models and databases. Develop, manage and maintain data dictionary and or metadata. Doing performance tuning & query optimization. Ensuring compliance of standards and conventions in developing programs. Analyse and resolve complex issues without oversight from other people. Perform quality checks on reports and exports to ensure exceptional quality. Works in Scrum environment. Preferred Skills: Knowledge of tools like Qlik /Qlik sense and/or any other data visual tools. Understanding of .NET code/jQuery experience is a plus. Knowledge in Microsoft Reporting tool (SSRS). Experience in Database Administration activities. Benefits: Flexible working hours Learning & Development Medical & Insurance benefits

The Team : We are looking for a Senior Software developer (Full Stack) with React, .NET, C#, JavaScript and JQuery skills who will contribute and lead the application development of the product. Candidate should understand product vision and should be able to analyze requirements, design and implement enterprise level applications And follow agile methodology in a scrum environment. Responsibilities : Analyze stories that have been written by Product Owner and perform an estimation of the complexity Setup?a strategy to implement the stories. Build or Enhance features in respect to the stories with defensible coding strategies. Delivery with best quality. Provide support and maintenance. Collaborate effectively with technical and non-technical stakeholders Follow agile best practices. Raise Concerns About Incomplete or Poor Requirements Attend all Scrum ceremonies Analyze and recommend solution design (Design Guidance) Make sure that code review tasks on all user stories are added and timely completed Ensures that team is following the Unit Testing. What Were Looking For : Basic Qualifications :- A minimum of 6+ years of strong experience in application development. Proficient with software development lifecycle (SDLC) methodologies like Agile, Test- driven development. Strong command in ReactJS, C#, ASP.NET Core, LINQ, Entity Framework, Restful Services, HTML 5, CSS, XML/XSLT, JQuery, TSQL (SQL Server) and query optimization techniques. Knowledge of object-oriented design, Cross-browser Compatibility, Responsive UI Good understanding of Design Principles & excellent communication skills Bachelors or masters degree (or higher) in a relevant discipline, or equivalent work experience Knowledge of system architecture, design patterns & ability to work in layered architecture: Presentation, Service, Business & Data. Experience working with AWS cloud. Experience working with Serverless, Elastic Search, Redis, NoSQL, Containers and Docker plus Nice to have GenAI, Java, Spring boot, Knockout JS, requireJS, Node.js, Lodash, Typescript, VSTest/ MSTest/ nUnit AWS Certification is a Plus

Required Skills & Experience: A minimum of 6 + years of strong experience in application development. Proficient with software development lifecycle (SDLC) methodologies like Agile, Test- driven development. Strong command in React.JS, HTML 5, requireJS, Node.js, Lodash, Typescript, CSS, TSQL (SQL Server), C#, .NET, LINQ, Entity Framework, Restful Services and query optimization techniques Knowledge of object-oriented design, Cross-browser Compatibility, Responsive UI Good understanding of Design Principles & excellent communication skills Bachelors or masters degree (or higher) in a relevant discipline, or equivalent work experience Knowledge of system architecture, designpatterns & ability to work in layered architecture: Presentation, Service, Business & Data. Nice to have AWS Cloud Basic Qualifications: Bachelor's degree in computer science or related fields. Previous experience in software development, computer engineering, or other related fields. Ability to work well in team environment following Agile software development principles. Strong interpersonal and written communications skills. Demonstrated ability to successfully multi-task. High energy and a self-starter

Were currently seeking a Senior Developer for data warehousing to work closely with our Data Analytics team in driving the adoption, optimization, and iteration, leveraging multiple integrations and technologies. The ideal candidate will have at least 6-8 years of experience with technical implementation of customer projects. Using their expertise, problem-solving ability, and creative flair, the consultant will design, build, deliver, and maintain. The consultant will also help develop business requirements, specifications, process flows, application design, and configuration, along with testing and deployment. Locations- Mumbai, Bangalore Required Qualifications & Experience- • Minimum experience of working in projects as a Senior Azure Data Engineer. • B.Tech/B.E degree in Computer Science or Information Technology. • Experience with SQL, TSQL (SQL Server, Azure SQL, Azure Synapse or similar) or NO SQL (Mongo DB or similar) • Experience in implementation of Data warehouse platform and creation of physical datamodel from logical / conceptual datamodel. • Experience in maintenance of data pipelines, data mart, stored procedures, Table Functions, Triggers and Index • Extensive knowledge on database optimization techniques • Experience in creation of schemas, users and user roles. • Experience in working with high volume structured, semi structured and unstructured data • Experience in database technology in both On-prem and cloud • Expertise in Azure ADLS, BLOB Storage, Cosmos DB or Similar • Understand Business Requirements, Interacting with business users and or reverse engineering existing data products • Good Understanding and working knowledge of distributed databases and Pipelines • Ability to analyze and identify the root cause for technical issues. • Proven ability to use relevant data analytics approaches and tools to problem solve and trouble shoot. • Excellent documentation and communication skills.Role & responsibilities Preferred candidate profile Perks and benefits

Greetings from IndusInd Bank!!!! We are hiring Application Manager who can join us in short notice. Experience : 5 - 8 years Location : Navi Mumbai Notice : 0 to 45 days Technical Skills: Languages / Technologies: - SQL Server, T-SQL and Oracle, Python Database Tools: - MS-SQL Server and MySQL Operating System: - Microsoft Windows, Microsoft Windows Server, Mac OS, Linux. ITIL Roles and Responsibilities: Performance Monitoring: monitoring day to day server and application logs, server Issues and resolution in timely manner to make 99% uptime Customer Issue Management: attended & resolved the customer's issue in defined time. Incident Management: Responds to incidents, incident raising, tracking and resolution in timely manner Escalation Management: Ensure minimal escalation of issues and proper reporting of issues to stakeholders and higher management. Patch Management:Deployment and porting of patches provided by vendor and development team in UAT and moving to Production setup. Application Management: End to End management of Applications, ensuring timely support and issue resolution. System upgradation: Time to time upgrading the systems, verifying system OS patch is up to date and if required we will take step to new version OS upgradation with the confirmation or certify by vendor to run smooth operation. Involvement in technical discussion, production Evaluation of new upcoming projects, getting an understanding of the projects architecture and understanding its function. Assisting the project team in testing the applications prior to project go-live and sharing requested logs to respective business stakeholders Monitoring newly implemented projects for load and reporting application issues. Closely analyzed and track the finding and closed based on solution and same apply in UAT and production. Preparing ISO documents as per ISMS standards for Incident management, Vendor management, Project managements, Escalation Management, Issues management. Ensuring that backup systems are ready in case of failover. Interested candidate Please drop your resume to kavitha.k@indusind.com

Must have minimum 5+ years of experience in design & development using .Net core, web API, Angular tools/technology, MS SQL Server technology ( prefer 2016 or above version). Must have proven experience in design & development of enterprise wide large application. Must be proficient in setting-up n-tier architecture for web applications. Must have 2+ yrs of working experience in Angular 12.0 & above. Should have work experience working with Data warehouse project/s. Very strong knowledge of functions, stored procedures, TSQL, triggers. Query optimization/Performance tuning techniques. Must have worked in Agile development environment and familiar with all Agile/Scrum process. Must be familiar with ETL concepts and good on implementing them. Must have problem analytics mindset and should have experience in resolving issues on time. Experience of implementing programming best practice, especially around scalability, automation, virtualization, optimization, availability, and performance. Knowledge on JIRA(for task list, user story)/Bit bucket( code repository tool) is an added advantage. Knowledge of NoSQL databases/Hadoop-Hive, Spark will be added advantage. Good/strong communication skill and team player Qualification Must have minimum 4+ years of experience in design & development using .Net core, web API, Angular tools/technology, MS SQL Server technology ( prefer 2016 or above version). Must have proven experience in design & development of enterprise wide large application. Must be proficient in setting-up n-tier architecture for web applications. Must have 2+ yrs of working experience in Angular 6.0 & above. Very strong knowledge of functions, stored procedures, SQL, triggers. Query optimization/Performance tuning techniques. Must have worked in Agile development environment and familiar with all Agile/Scrum process. Must have problem analytics mindset and should have experience in resolving issues on time. Experience of implementing programming best practice, especially around scalability, automation, virtualization, optimization, availability, and performance. Good/strong communication skill and team player

Development experience of 4 8 years in C# .NET, WCF, Database (SQL Server), WSO2, design patterns, agile development Experience in Web APIs, CI/CD, Advanced SQL (TSQL) Experience in UI technologies like JavaScript, Angular, AJAX, etc. Experience in MS SQL DB, SQL queries and reporting tools Good analytical and debugging skills Should be a quick learner and like to explore and work on new technologies University education Knowledge of Banking Capital Markets, Lending and Cash Management domains Based in Pune but willingness to travel Excellent skills communication, collaboration, interpersonal, presentation, perseverance, team player.

Join a Montreal headquartered company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative Feedback Analytics solutions because we believe that each experience matters. We are looking to add a Database administrator with a solid background in Postgres to join our growing CloudOps team. As an Explorance DBA, you will be joining the Global CloudOps Team out of our Chennai office. You will be responsible for the implementation, configuration, maintenance, and performance of critical RDBMS systems, specifically Postgres and MS-SQL Server, to ensure the availability and consistent performance of our SaaS applications. This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills. Key Responsibilities include: Database Design & Implementation Design, install, configure, and maintain PostgreSQL and MS SQL Server databases, ensuring high levels of performance, availability, and security Linux knowledge and bash experience Implement database architecture and data models that align with business requirements. Setup/monitoring/fixing/analyzing/troubleshooting high availability, including AlwaysOn, PG streaming replication and Active/Passive clusters Performance Tuning & Optimization Monitor database performance, monitoring development and perform tuning and optimization tasks. Analyze query performance and make recommendations for improvements. Backup & Recovery Develop, document and implement backup and recovery strategies. Ensure data integrity and availability through regular backups and disaster recovery plans. Security Management Manage user access and permissions to ensure data security. Implement and monitor security measures to protect sensitive data. Database security (e.g. TDE) and auditing abilities (i.e. CDC) Troubleshooting & Support Diagnose and resolve database-related issues promptly in support of SLAs. Provide support for application development teams and assist in database design and queries. Documentation & Reporting Maintain documentation for database architecture, configurations, and processes. Prepare regular reports on database performance and security. Collaboration Work closely with IT teams, application developers, and stakeholders to support data-related initiatives. Participate in system upgrades, migrations, and other database projects. Deployment code review and suggest performance enhancements Follow and participate in Explorance development standards and guidelines Qualifications: Bachelor’s degree in Computer Science, Information Technology, or a related field. 5+ years of experience as a Database Administrator, with a strong focus on PostgreSQL and MS SQL Server. Proficient in PSQL, T-SQL, and other database programming languages. Experience with database performance tuning and optimization techniques. Familiarity with database backup, recovery, and disaster recovery processes. Strong understanding of database security principles and practices. Excellent problem-solving skills and attention to detail. Ability to work independently and as part of a team. Preferred Skills: Experience with on-premise and cloud-based databases (AzureSQL). Knowledge of Redis is a plus. Experience with database monitoring tools and performance analysis. Understanding of fundamental design principles behind a scalable application Experience in SSIS / SSRS / SSAS Experience in ETL Flexible, team player with a “get-it-done” personality PowerShell knowledge for process automation Basic knowledge of Linux Other Requirements Only apply if you are a Chennai (or surroundings) resident that is interested in being part of a vibrant and highly engaged at-the-office culture. At Explorance, we take inclusion to heart and live it each day. We put the ‘human’ first in everything we do and take pride in our authenticity and culture of inclusion. We therefore encourage persons of any race, religion, ethnicity, gender identity, sexual orientation, age, immigration status, disability or other applicable legally protected characteristics to apply. We make employment-related decisions without regard to any of these characteristics. And to ensure a safe workspace for all our employees, all employment is contingent upon receipt of a satisfactory background and reference check.