687 Query Optimization Jobs

Write, optimize, and execute complex SQL queries to retrieve, transform, and deliver custom datasets to partner banks. Work with internal teams to interpret business requirements and translate them into technical SQL solutions. Ensure data accuracy, integrity, and completeness before delivery. Handle ad-hoc and scheduled data requests from multiple stakeholders. Monitor and troubleshoot query performance issues; recommend optimizations. Collaborate with Data Engineering to enhance query execution and data pipeline efficiency. Maintain a clear documentation repository of queries and data delivery processes. Ensure all data handling complies with security, privacy, and regulatory requirements (e.g., PCI DSS, RBI guidelines). The Perfect Fit 3+ years of hands-on SQL experience (PostgreSQL, MySQL, or similar). Strong background in data extraction, transformation, and delivery for large datasets. Experience working with financial data or in the banking/fintech domain is highly preferred. Proficiency in query optimization and troubleshooting performance issues. Understanding of data privacy & compliance frameworks in financial services. Ability to interpret business requirements and translate them into efficient technical solutions. Strong problem-solving skills with excellent attention to detail. Your Edge Over The Rest Experience with data visualization tools (e.g., Power BI, Tableau, Looker). Familiarity with ETL processes and scripting languages (Python, Shell). Exposure to APIs for data retrieval.

Lead the design and development of scalable, robust full stack applications using Node.js, React.js, and MongoDB. -Ensure technical design aligns with business and architectural goals. -Develop clean, reusable, and testable code with an emphasis on performance and maintainability. -Create responsive and dynamic UI using React.js, Redux, and other modern frameworks. -Build and maintain RESTful APIs and Microservices, ensuring security and scalability. -Guide and mentor junior developers, ensuring code quality through reviews and best practices. -Drive architecture and design discussions; identify and resolve performance bottlenecks. -Utilize build tools like Grunt, Webpack, and contribute to automation where possible. -Ensure consistent unit testing and CI/CD pipeline adherence.

We are looking for a highly skilled .NET Developer (C#) with 3-4 years of hands-on coding experience to join our team. The ideal candidate should have deep expertise in .NET technologies, strong knowledge of data types, .NET components, class attributes, class structure, and reusable functions. The role involves managing and enhancing an existing product and library, debugging issues, and developing new features. The candidate should be passionate about coding and problem-solving, possess an analytical mindset, and have the ability to optimize MySQL/MS SQL queries for better performance. Key Responsibilities Maintain and enhance the existing .NET WinForms application and WCF Services, Experience of using DevExpress UI elements will be preferable. Work extensively on WCF services for application communication and backend processes. Hands-on experience with third party integration lifecycle will be preferable. Debug and troubleshoot existing code, identify issues, and implement efficient solutions. Develop add-on functionalities for the existing product based on business needs. Write optimized and performance-tuned SQL queries (MySQL/MS SQL) for data processing. Ensure code reusability, maintainability, and adherence to best practices. Independently analyse existing code, functions, and class structures to implement improvements. Collaborate with the team to propose, design, and implement enhancements in the existing system. Required Skills Qualifications 5+ years of experience in .NET development (C#) with strong coding experience (3-4 years hands-on). Proficiency in WinForms development, preferred with experience using DevExpress UI components. Strong expertise in WCF Services, including developing and consuming services. Deep understanding of .NET fundamentals, including: Data types memory management Class structures attributes .NET components reusable functions Advanced skills in MySQL/MS SQL, including: Writing complex queries Query optimization for performance enhancement Indexing, stored procedures, and query tuning Strong debugging and problem-solving skills. Ability to understand and improve existing codebase independently. Passionate about coding, with a logical and structured approach to problem-solving. Excellent soft skills receptive, cool-tempered, and a strong team player. Good IQ level to quickly grasp the existing system architecture and bring meaningful improvements. Nice to Have Experience with multi-threading and performance optimization. Exposure to RESTful APIs and microservices. Hand on experience in ERP domain. Why Join Us Work on real-world, large-scale applications with an established codebase. Opportunity to take ownership of existing product maintenance and enhancements. Collaborative and growth-oriented environment with learning opportunities. Competitive salary and benefits. .NET Development (C#) with WinForms & WCF DevExpress UI & Third-party Integrations MySQL/MS SQL Query Optimization

About The Role Project Role : Database Administrator Project Role Description : Design, implement and maintain databases. Install database management systems (DMBS). Develop procedures for day-to-day maintenance and problem resolution. Must have skills : Oracle Database Administration (DBA) Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary As a Database Administrator, you will administer, develop, test, or demonstrate databases. Perform many related database functions across multi-customers, including designing, implementing and maintaining new databases, backup/recovery and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance. Roles & ResponsibilitiesDatabase Administration and Support:Handle all P1, P2, P3, and P4 incidents, changes, and service requests related to Oracle Database administration, ensuring prompt and efficient resolution within SLAs.Manage day-to-day database operations, including backup/restore, health checks, performance tuning, and resource optimization.Proactively monitor database systems using tools like Zabbix, CheckMK, or Extended Events, ensuring optimal performance and uptime.Implement and manage high availability (HA) and disaster recovery (DR) solutions such as Always On Availability Groups, clustering, replication, and log shipping.Perform Oracle Database upgrades, patching, migrations, and configuration changes with minimal disruption to business operations.Technical Expertise and Problem Solving:Troubleshoot and resolve complex database issues, collaborating with other senior team members or SMEs when necessary.Perform root cause analysis for recurring incidents and propose preventive measures to avoid future occurrences.Optimize database performance by identifying and addressing bottlenecks, inefficient queries, or hardware limitations.Utilize automation tools, SQL, and Shell scripts to reduce manual interventions and streamline repetitive tasks.Customer Interaction and Coordination:Act as the first point of contact for all Oracle Database-related issues allocated to your team, ensuring professional and timely communication with customers.Collaborate with the SME/Team Manager for escalations, providing detailed analysis and proposed resolutions.Provide guidance to customers on best practices, database strategies, and technical solutions when needed.Mentorship and Collaboration:Assist junior DBAs in resolving complex tickets, enhancing their troubleshooting skills, and providing technical guidance.Share knowledge with peers and juniors through training sessions, documentation, or informal mentoring.Coordinate effectively with other DBAs, SMEs, and Team Managers to ensure seamless operations across shifts and teams.Process Adherence and Reporting:Follow established processes, including ITIL-based incident, change, and problem management workflows, to maintain service quality.Maintain and update documentation for assigned tasks, incidents, and solutions for future reference and audits.Regularly review and contribute to process improvements and knowledge-sharing initiatives.Continuous Learning and Development:Stay updated on emerging Oracle Database technologies, tools, and best practices to enhance technical expertise.Participate in training, certifications, and workshops to remain proficient in Oracle Database administration. Professional & Technical Skills Must to have skills:Proficiency in High Availability (HA) and Disaster Recovery (DR) solutions for Oracle Database. Solid experience in performance tuning and query optimization, including troubleshooting and resolving database performance issues. Communication Skills: Strong verbal and written communication skills, with the ability to collaborate effectively within teams and with stakeholders. Work Tenure:A consistent career track record, with an average of at least 2 years spent in each previous organization. Work FlexibilityWillingness to work in a 24x7 environment as needed, adapting to rotational shifts. Escalation Handling and Customer Interaction:Experience in managing escalations and interacting directly with customers to resolve issues and ensure client satisfaction. Strong understanding of multi-geographic support environments, effectively addressing diverse customer needs while ensuring consistent, high-quality database support. Expertise in Oracle Database, with proficiency in high availability (HA) and disaster recovery (DR) solutions such as datagaurad and RAC. Proficient in Oracle Database performance optimization and tuning to ensure optimal database performance and responsiveness for critical systems. Skilled in planning and executing Oracle Database upgrades and migrations, minimizing downtime and ensuring seamless transitions. Proficient in Oracle database patching-standalone and RAC. Proficient in SQL or Shell scripting for automation and task optimization. Familiarity with cloud technologies for database-related components, with a preference for hands-on experience. Proficient in SQL or Shell scripting for automation and task optimization. Experience managing and supporting Oracle Database, ensuring reliable analytics and reporting functionalities. Strong troubleshooting skills on Unix/Windows platforms. In-depth knowledge of backup and recovery processes, ensuring data integrity and availability in critical situations. Good understanding of ITIL processes, ensuring structured incident management, change control, and service delivery. Demonstrate strong customer handling skills, with the ability to interact directly with clients, understand their requirements, and contribute to delivering tailored database solutions and strategic recommendations. Additional InformationHigh level of acceptance and flexibility to accept change and requirement according to industry demand. Should be enthusiastic to learn new technologies and enhance troubleshooting skills.The candidate should have a minimum of 6+ years of experience in Oracle Database Administration (DBA)This position is based at our Gurugram officeA 15 years full time education is required Qualification 15 years full time education

Must have : Bigdata ,GCP (Bigquery, Dataproc) We are looking for energetic, high-performing and highly skilled data engineers to help shape our technology and product roadmap. You will be part of the fast-paced, entrepreneurial Global Campaign Tracking (GCT) team under Enterprise PersonalizationPortfolio focused on delivering the next generation of global marketing capabilities. The team is responsible for marketing campaign tracking of new accounts acquisition and bounty payments and leverages large scale data engineering technologies, such as such as Adobe Analytics, Google Analytics, SQL, PySpark, GCP, Big Query, Data Proc, Hive, Kafka & Java. Focus: Designs, develops, solves problems, debugs, evaluates, modifies, deploys, and documents software and systems that meet the needs of customer-facing applications, business applications, and/or internal end user applications. Minimum Qualifications: This high energy Engineer must have: A Bachelor’s degree in computer science, computer engineering, other technical discipline, or equivalent Hands-on expertise with application design, software development, and automated testing. Strong programming knowledge in SQL, PySpark, Data Proc, Big QueryHands-on experience in Big Data technologies (Spark, Hive) Understanding and experience with UNIX / Shell / Perl / Python scriptingDatabase query optimization and indexingWeb services design and implementation using REST / SOAP and Java is a plus. Experience collaborating with the business to drive requirements/Agile story analysis. Experience with design and coding across one or more platforms and languages as appropriate Bonus skills:Machine learning/data miningObject-oriented design and codingAdobe Marketing Campaign products Roles and Responsibilities Develop and maintain large scale data processing pipeline using PySpark Data Proc, Big Query and SQL. Use Big Query and Data proc to migrate existing Hadoop/Spark/Hive workloads to Google Cloud. Proficient in Big Query to carry out batch and interactive data analysis. Function as member of an agile team by contributing to software builds through consistent development practices (tools, common components, and documentation) Develops and tests software, including ongoing refactoring of code, and drives continuous improvement in code structure and quality Enable the deployment, support, and monitoring of software across test, integration, and production environments

Department Workplace Investing Support GPS Level Application Support - 3 Were proud to have been helping our clients build better financial futures for over 50 years. How have we achieved this? By working together - and supporting each other - all over the world. So, join our Workplace Investing Support/ GPS team and feel like youre part of something bigger. About your team The team is part of the wider FIL Technology team and is primarily responsible for supporting the UK Business covering Personal Investing, Funds Network, Retail and Workplace Investing channels.The department is responsible for defining, delivering and supporting all IT hardware and software needs of the businesses that are supported. The technology teams are primarily located in Gurgaon and Kingswood. A key focus for the department is the delivery of the technology elements of the UK Business Transformation programme. About your role The Workplace Investing business comprises of Fidelitys institutional business units in the UK and other parts of Europe and is a strategic area targeted for growth over the coming years. Technology has been acting as the key enablers for the business in achieving their goals. This role is for a highly motivated technical resource to work within the Workplace Investing team. He/She will need to work on multiple technologies and will be responsible for the technical analysis and support of applications on cloud and on prem as per the requirements About you Key Responsibilities Maintaining and improving performance and availability of all Fidelitys web applications and platform. Leading high impact incident investigation and recovery in collaboration with various technology teams. Providing technical assistance in guiding the team for incident resolution. Leading continuous improvement of applications in collaboration with technology teams Leading the production readiness of new programs by engaging with Business and Technology teams. Ensuring non-functional requirements are covered as part of project lifecycle Regular review of changes impacting WI business and aligning required support Leading Problem management for Incident resolution Undertake support and maintenance activities to proactively identify and prevent potential issues within the specified portfolio of applications developing into high severity incidents. Liaison with other technology and operations team (e.g. Delivery, Unix, DBA, Network etc) Engagement in Disaster Recovery and BCP plans processes. Proactively manage the applications through understanding current risks (functional, operational and capacity) and ensuring they are flagged appropriately Experience and Qualifications Required Willing to work in Support (Along with UK Shifts & 24X7 On-call ) 4-6 years overall experience in IT Good knowledge in Oracle database concepts(19c), SQL statements (DML/DDL), query optimization, stored procedures, Triggers, & Functions Working experience in UNIX and Shell Scripting Working knowledge in ETL tools like Snaplogic, Informatica Knowledge of scheduling tools like Control- M Experience of best practices development methodologies, especially Agile Good analytical, problem-solving and documentation skills

Project Overview Prestigious Client / Project: Work with trusted global partner delivering end-to-end digital, engineering, and manufacturing solutions to top-tier clients across automotive, healthcare, and industrial sectors Revolutionizing Technologies: Passionate about revolutionizing technologies through smart data solutions. This role involves MS SQL development and database administration, ideal for professionals who can balance building optimized queries with maintaining robust database performance and security.. Agile Development. Strong delivery processes and tools. Long term project. Role and Responsibilities Database Design: Design, develop, and implement MSSQL databases based on the organization's requirements, ensuring data models are efficient and scalable. SQL Query Optimization: Write, optimize, and maintain complex SQL queries to retrieve and manipulate data efficiently. Maintain comprehensive documentation of the database schema, configurations, and procedures. Plan and execute database version upgrades and patch installations as needed. Data Security: Implement and manage database security measures, including access control, encryption, and auditing, to protect sensitive data. Performance Tuning: Monitor and analyze database performance, identifying and resolving bottlenecks and optimizing database queries and configurations for improved performance. Data Migration: Plan and execute data migration projects when necessary, ensuring data consistency and minimal downtime. Troubleshooting: Investigate and resolve database-related issues and errors, collaborating with other teams to diagnose and fix problems. Collaboration: Collaborate with software developers and other stakeholders to understand their database requirements and provide support in database-related tasks. Requirements Candidate must have MIN 6 years experience with MS SQL Developer profile. DB design /Stored Procedures/ Triggers / Tables /Query plan. Good understanding on SQL Queries / Joins / Indexes / Jobs etc. Analyze slow or poorly performing queries and optimize them for improved database efficiency. Stay Updated with the latest MSSQL developments, trends, and best practices.

We are looking for mid-level DB developers to work with our client on product enhancements and provide post-go-live production support for users in the US, Bangkok, Philippines, Shanghai, and Penang. Desired Candidate Profile Strong expertise in PL/SQL Must be able to write complex SQL queries by using advanced SQL functions Strong expertise in query performance tuning, query optimization, and query debugging Good in writing triggers, creating Indexes, views Expert understanding of complex concepts of data organization: Expert familiarity with RDBMS Experience in the Manufacturing domain is a big plus Experience in any Data Virtualization platform is a big plus Experience in Tibco Data Virtualization is a huge plus Would be responsible for the development of enhancements in the product and support Oracle, MySQL experience is plus

Role Overview Looking for an experienced SQL Developer to design, develop, and optimize MS-SQL queries, procedures, and reports to improve business productivity. Key Responsibilities Develop & optimize stored procedures, functions, and queries (T-SQL) Analyze and improve query performance Create and customize reports (SSRS, SSAS) Troubleshoot business data requirements & exceptions Support data research, reporting, and reconciliation Requirements 5 - 10 years SQL development experience Strong expertise in T-SQL & MS SQL Server 1–3 years’ experience with SSRS/SSAS Knowledge of NoSQL/NewSQL is a plus Strong analytical & problem-solving skills Keywords: SQL Developer, T-SQL, Microsoft SQL Server, SSRS, SSAS, Stored Procedures, Query Optimization, Data Reporting, Database Developer, NoSQL, Performance Tuning

Contact Details : 9354073534 • Write efficient and optimized database queries using SQL Server variants such as MySQL, MSSQL, or PostgreSQL. • Maintain, back up, and ensure the security of databases on a regular basis.

About the role: Your responsibility as a Lead Cassandra database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. Requirement : 6+ Years of experience in Configure, install, and manage Cassandra clusters. Manage node addition and deletion in Cassandra clusters. Monitor Cassandra clusters and implement performance monitoring. Configure multi-DC Cassandra clusters . Optimize Cassandra performance , including query optimization and other related optimization tools and techniques. Implement and maintain Cassandra security and integrity controls , including backup and disaster recovery strategies . Upgrade Cassandra clusters . Utilize cqlsh, Grafana, and Prometheus for monitoring and administration. Design and create database objects such as data table structures (Cassandra column families/tables). Perform data migration, backup, restore & recovery for Cassandra. Resolve performance issues, including blocking and deadlocks (as applicable in Cassandra's distributed context). Implement and maintain security and integrity controls including backup and disaster recovery strategies for document management systems and MySQL databases (if these are part of the Cassandra Administrator's broader scope, otherwise this point might be less relevant for a pure Cassandra role). Translate business requirements into technical design specifications and prepare high-level documentation for database design and database objects. Extensive work experience on query optimization, script optimization , and other related optimization tools and techniques . Strong understanding of Cassandra database architecture . Experience with backup and recovery procedures specific to Cassandra. Knowledge of database security best practices . Experience with data migration and transformation . Ability to work under pressure and meet deadlines.

Database Architecture: Design & implement scalable, optimized database structure, ensuring normalization & best practice Performance Monitoring: Continuously monitor & optimize database performance addressing bottleneck, query optimization & indexing

Experience - 5 to 8 Years Pune - F2F interview on 23rd Aug 2025 at Hinjewadi, Pune. Develop and maintain PLSQL procedures functions packages and triggers Design and optimize complex SQL queries for data extraction and reporting Perform data modelling schema design and database tuning Collaborate with application developers to integrate backend logic with frontend applications Conduct unit testing and support system integration and user acceptance testing Monitor and troubleshoot database performance issues Maintain documentation for database structures and processes Participate in code reviews and ensure adherence to best practices Required Skills Tools Strong expertise in Oracle SQL and PLSQL and Shell scripting Experience with tools like SQL Developer TOAD and PLSQL Developer Familiarity with database performance tuning and optimization techniques Knowledge of version control systems e.g. Git Bitbucket Exposure to Unix Linux environments and shell scripting Experience with data migration ETL processes and data quality checks

Job Summary: Supports, develops and maintains a data and analytics platform. Effectively and efficiently process, store and make data available to analysts and other consumers. Works with the Business and IT teams to understand the requirements to best leverage the technologies to enable agile data delivery at scale. Key Responsibilities: Implements and automates deployment of our distributed system for ingesting and transforming data from various types of sources (relational, event-based, unstructured). Implements methods to continuously monitor and troubleshoot data quality and data integrity issues. Implements data governance processes and methods for managing metadata, access, retention to data for internal and external users. Develops reliable, efficient, scalable and quality data pipelines with monitoring and alert mechanisms that combine a variety of sources using ETL/ELT tools or scripting languages. Develops physical data models and implements data storage architectures as per design guidelines. Analyzes complex data elements and systems, data flow, dependencies, and relationships in order to contribute to conceptual physical and logical data models. Participates in testing and troubleshooting of data pipelines. Develops and operates large scale data storage and processing solutions using different distributed and cloud based platforms for storing data (e.g. Data Lakes, Hadoop, Hbase, Cassandra, MongoDB, Accumulo, DynamoDB, others). Uses agile development technologies, such as DevOps, Scrum, Kanban and continuous improvement cycle, for data driven application. External Qualifications and Competencies Competencies: System Requirements Engineering - Uses appropriate methods and tools to translate stakeholder needs into verifiable requirements to which designs are developed; establishes acceptance criteria for the system of interest through analysis, allocation and negotiation; tracks the status of requirements throughout the system lifecycle; assesses the impact of changes to system requirements on project scope, schedule, and resources; creates and maintains information linkages to related artifacts.Collaborates - Building partnerships and working collaboratively with others to meet shared objectives. Communicates effectively - Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences. Customer focus - Building strong customer relationships and delivering customer-centric solutions.Decision quality - Making good and timely decisions that keep the organization moving forward. Data Extraction - Performs data extract-transform-load (ETL) activitiesfrom variety of sources and transforms them for consumption by various downstream applications and users using appropriate tools and technologies.Programming - Creates, writes and tests computer code, test scripts, and build scripts using algorithmic analysis and design, industry standards and tools, version control, and build and test automation to meet business, technical, security, governance and compliance requirements. Quality Assurance Metrics - Applies the science of measurement to assess whether a solution meets its intended outcomes using the IT Operating Model (ITOM), including the SDLC standards, tools, metrics and key performance indicators, to deliver a quality product. Solution Documentation - Documents information and solution based on knowledge gained as part of product development activities; communicates to stakeholders with the goal of enabling improved productivity and effective knowledge transfer to others who were not originally part of the initial learning. Solution Validation Testing - Validates a configuration item change or solution using the Function's defined best practices, including the Systems Development Life Cycle (SDLC) standards, tools and metrics, to ensure that it works as designed and meets customer requirements. Data Quality - Identifies, understands and corrects flaws in data that supports effective information governance across operational business processes and decision making. Problem Solving - Solves problems and may mentor others on effective problem solving by using a systematic analysis process by leveraging industry standard methodologies to create problem traceability and protect the customer; determines the assignable cause; implements robust, data-based solutions; identifies the systemic root causes and ensures actions to prevent problem reoccurrence are implemented.Values differences - Recognizing the value that different perspectives and cultures bring to an organization. Education, Licenses, Certifications: College, university, or equivalent degree in relevant technical discipline, or relevant equivalent experience required. This position may require licensing for compliance with export controls or sanctions regulations. Experience: Relevant experience preferred such as working in a temporary student employment, intern, co-op, or other extracurricular team activities.Knowledge of the latest technologies in data engineering is highly preferred and includes:- Exposure to Big Data open source- SPARK, Scala/Java, Map-Reduce, Hive, Hbase, and Kafka or equivalent college coursework- SQL query language - Clustered compute cloud-based implementation experience- Familiarity developing applications requiring large file movement for a Cloud-based environment- Exposure to Agile software development- Exposure to building analytical solutions- Exposure to IoT technology Additional Responsibilities Unique to this Position it's a Hybrid role with 2 days Work from Office in Pune. Must-Have: 3 to 5 years of experience in data engineering with expertise in Azure Databricks and Scala/Python . Proven track record in developing efficient pipelines. Hands-on experience with Spark (Scala/PySpark) and SQL . Strong understanding of Spark Streaming , Spark Internals , and Query Optimization . Skilled in optimizing and troubleshooting batch/streaming data pipeline issues. Proficient in Azure Cloud Services (Azure Databricks, ADLS, EventHub, EventGrid, etc.). Experienced in unit testing of ETL/ELT pipelines. Expertise with CI/CD tools for automating deployments. Knowledgeable in big data storage strategies (optimization and performance). Strong problem-solving skills. Good understanding of data models (SQL/NoSQL), including Delta Lake or Lakehouse. Exposure to Agile software development methodologies. Quick learner with adaptability to new technologies. Work Schedule:Most of the work will be with stakeholders in the US, with an overlap of 2-3 hours during EST hours on a need basis.

+91 80195 92902 Job Description: We are looking for a skilled PLSQL Developer to join our team. The ideal candidate should have hands-on experience in developing scalable applications. Key Responsibilities: Developing and maintaining Oracle database applications using PL/SQL Designing and developing database schemas, stored procedures, functions, and triggers. Optimizing database performance by tuning SQL queries. Developing and executing test plans to ensure the quality and accuracy. Analysis and manipulation of data to support building new reports and modify existing reports. Analyze client requirements and prepare technical specifications. Ensure application security, data integrity, and compliance with IT standards. Optimize database performance through indexing , query tuning , and data modeling. Perform code reviews and unit testing of code on SQL and PL/SQL codes. Analyse PL/SQL codes and perform bug-fixing. Skills & Experience: 1 - 3 years of working experience on PL/SQL. Data analysis and troubleshooting skills. Good analytical skills and ability to transform business requirements into programming specifications. Good communication skills. Contact Details :- Chennai: Name: Ms. Aiswariya Contact No: 9677719593 (Contact between 10:00 AM to 6:00 PM) Email: hr.chennai@betamonks.com Vizag & Nagpur: Name: Ms. Rupa Contact No: 8019592902 (Contact between 10:00 AM to 6:00 PM) Email: hr.vizag@betamonks.com

Position Overview BOLD seeks a DBA professional to provide support for various MS SQL databases. This person will perform database structure and software maintenance and implementations, support database tuning and consultation, and assist with database configuration implementation. The person will also participate in incident, change, and problem-management activities Company Overview BOLD is an established and fast-growing product company that transforms work lives. Since 2005, we've helped more than 10,000,000 folks from all over America (and beyond!) reach higher and do better. A career at BOLD promises great challenges, opportunities, culture and the environment. With our headquarters in Puerto Rico and offices in San Francisco and India, were a global organization on a path to change the career industry. Key Responsibilities Enhancing the scalability and performance of existing database architecture. Protecting data by developing data security and restoration policies, procedures, and controls. Conducting diagnostic tests and evaluating performance metrics. Developing procedures to ensure data integrity and quality. Performing database maintenance, migration, and upgrading hardware and software. Documenting processes and complying with best practices in database management. Required Skills Knowledge of Physical design of a database cluster, RAID/SAN and likewise. Strong understanding of SQL Server (IaaS and PaaS based on Azure) and on-premise SQL Server setup. Hands-on experience in Unix/Linux command line options. Experience on DB migrations, maintenance and optimization strategies Experience in implementing operational automation using PowerShell/Python automation. Knowledge of indexes, index management, and statistics. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. Ability to detect and troubleshoot SQL Server-related CPU, memory, I/O, disk space and other resource contention. Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking Experience with backups, restores and recovery models. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Azuer PAAS,MSSQL Server Capacity Planning (Backup Share, Disk, CPU, Memory etc.) Able to manage demanding stakeholders on technical solutions and align architect Additional Skills Experience in OLTP environment Basic understanding of MySQL or MongoDB to handle L1 issues

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Google BigQuery Good to have skills : NAMinimum 12 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. Your typical day will involve collaborating with teams to develop innovative solutions and contribute to key decisions. Roles & Responsibilities:- Expected to be an SME.- Collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Expected to provide solutions to problems that apply across multiple teams.- Lead the development and implementation of new features.- Conduct code reviews and ensure coding standards are met.- Troubleshoot and resolve complex technical issues. Professional & Technical Skills: - Must To Have Skills: Proficiency in Google BigQuery.- Strong understanding of data modeling and database design.- Experience with cloud platforms like Google Cloud Platform.- Knowledge of SQL and query optimization techniques.- Hands-on experience in developing scalable applications.- Good To Have Skills: Experience with data warehousing solutions. Additional Information:- The candidate should have a minimum of 12 years of experience in Google BigQuery.- This position is based at our Bengaluru office.- A 15 years full-time education is required. Qualification 15 years full time education

Responsibilities: Database Administration: Manage and support Production, QA, and Development environments for PostgreSQL and Progress 4GL databases. Monitor and manage database backups and ensure proper data growth management . Refresh Dev, Test, and Preprod environments by syncing them with the Live environment. Tune database performance by analyzing and optimizing query execution , index usage, and general database configurations. Database Operations: Perform Database Dump and Load operations, including experience with Progress database management . Ensure data integrity and consistency across different environments (Dev, Test, Preprod, and Production). Troubleshoot database-related issues, especially around code deployments , compilation , and their interaction with the database. Collaborate closely with the Development Team , providing support for database-related queries, optimizations, and issues. Monitoring & Performance Tuning: Use PROMON and other tools to regularly perform database health checks . Proactively monitor database performance and make adjustments to ensure optimum functionality. Experience in tuning performance issues and implementing changes when necessary. Knowledge of Appserver and Webspeed to optimize the performance of Progress-based applications. SQL Server Support (Optional but helpful): Manage SQL Server instances using SQL Server Management Studio (SSMS). Perform regular backup and restore operations for SQL Server databases. Release & Deployment Support: Prepare runbooks for production releases, outlining all steps and procedures for application deployment and database changes. Assist in Release Management by coordinating deployment schedules and ensuring that deployment goes smoothly. Handle deployment issues , ensuring the release process is seamless across all environments. Key Skills Required: Experience managing both PostgreSQL and Progress 4GL databases. Expertise in database backups, restores, and data refreshes across environments. In-depth experience with database performance tuning (e.g., query optimization, indexing). Familiarity with Progress 4GL queries , Appserver , and Webspeed . SQL Server management skills (backup, restore, etc.) are a plus. Experience with release management and writing/maintaining runbooks .

Role Description As a Senior Database Administrator at Incedo, you will be responsible for managing and optimizing database management systems (DBMS) such as Oracle or SQL Server. You will work with database architects and developers to ensure that databases are designed and configured correctly. You will be responsible for ensuring the performance, scalability, and security of the DBMS and troubleshooting any issues that arise. You will also work with the security team to ensure that the DBMS is secure and complies with relevant regulations. Roles & Responsibilities: Lead or support the design, development, and deployment of Oracle HFM solutions. Work closely with Finance and IT stakeholders to gather and analyze business requirements. Configure metadata, rules, data forms, and security in HFM Build and maintain integrations between HFM and source systems (e.g., ERPs, data warehouses) Design and generate complex financial reports using Hyperion Financial Reporting Studio and Smart View. Troubleshoot and resolve HFM application issues, including performance and consolidation problems. Support monthly, quarterly, and annual close cycles and reporting processes. Technical Skills Skills Requirements: Experience in Legacy Oracle Hyperion Financial Management (HFM) Proficiency in SQL programming for relational databases such as Oracle Understanding of relational database concepts such as ACID properties, transactions, and normalization. Familiarity with database design and optimization techniques such as indexing, partitioning, and query optimization. Experience with database administration tasks such as backup and recovery, performance tuning, and security management. Must have excellent communication skills and be able to communicate complex technical information to non-technical stakeholders in a clear and concise manner. Must understand the company's long-term vision and align with it. Provide leadership, guidance, and support to team members, ensuring the successful completion of tasks, and promoting a positive work environment that fosters collaboration and productivity, taking responsibility of the whole team. Nice-to-have skills Qualifications 4-6 years of work experience in relevant field B.Tech/B.E/M.Tech or MCA degree from a reputed university. Computer science background is preferred

As a Technical Lead - Database Administration at Incedo, you will be responsible for managing and optimizing database management systems (DBMS) such as Oracle or SQL Server. You will work with database architects and developers to ensure that databases are designed and configured correctly. You will be responsible for ensuring the performance, scalability, and security of the DBMS and troubleshooting any issues that arise. You will also work with the security team to ensure that the DBMS is secure and complies with relevant regulations. Roles & Responsibilities: Installing, configuring and maintaining databases such as MySQL Managing and optimizing database performance Implementing and maintaining database security and access controls Troubleshooting and resolving database issues Developing and implementing database backup and recovery strategies Collaborating with other teams to ensure the consistency and integrity of data Technical Skills Skills Requirements: Proficiency in SQL programming for relational databases such as Oracle, SQL Server, or MySQL. Understanding of relational database concepts such as ACID properties, transactions, and normalization. Familiarity with database design and optimization techniques such as indexing, partitioning, and query optimization. Experience with database administration tasks such as backup and recovery, performance tuning, and security management. Must have excellent communication skills and be able to communicate complex technical information to non-technical stakeholders in a clear and concise manner. Must understand the company's long-term vision and align with it. Should be open to new ideas and be willing to learn and develop new skills. Should also be able to work well under pressure and manage multiple tasks and priorities. Qualifications 7-9 years of work experience in relevant field B.Tech/B.E/M.Tech or MCA degree from a reputed university. Computer science background is preferred

Should be primarily experienced in front-end frameworks, able to create, design, and implement business solutions from scratch, while also being well-versed in backend enough to maintain, create additional code, fix bugs, and suggest new solutions in the backend code. Core Skills (Primary - 70%): Hard Skills: React/Next.js (Experienced), TypeScript/JavaScript, MSAL Auth flows, Ag-Grid React, GraphQL client-side libraries, HTML/CSS Nice to have: Tailwind CSS, Figma Core Skills (Secondary 30%):o C#/.NET (Proficiency), Azure Functions, REST/GraphQL API development, SQL (T-SQL, query optimization), Dependency Injection, Git. Competencies: o Design-to-Code Execution: Exceptional ability to translate high-fidelity Figma designs into pixel-perfect, responsive, and accessible UI. o Frontend Performance: A strong understanding of React performance best practices (hooks, state management, memoization) to build a fast, fluid user experience. o UI/UX Acumen: Possesses a keen eye for detail and a user-centric mindset, ensuring the UI is not just functional but also intuitive and easy to use. o Collaborative Mindset: A team player who proactively communicates with backend developers to define API contracts and data needs.

The Team: You will be part of a world class Product Services & Engineering team architecting various solutions for business requirements within different product offerings of S&P Commodity Insights, used by tens of thousands of users globally. The team is responsible for ensuring cloud database systems that deliver Greater Reliability & Resilience, High Performance, High Availability and Scalability. The Impact: You will utilize your technical knowledge and analytical skills in architecting and optimizing PostgreSQL, standardizing Aurora Postgres technology stack for relational database and applying best security policies for PostgreSQL/Aurora Postgres databases and suggesting best suitable replication practices as per business requirement. Whats in it for you: You will be part of a talented team of DBA team that demonstrate superb technical competency, delivering mission critical databases with the highest levels of availability, performance and security. The DBA team will be responsible for supporting a large-scale deployment of Aurora Postgres/PostgreSQL database systems related workloads and IT project deployment. Responsibilities: Sound knowledge on PostgreSQL, Aurora Postgres and working experience on other RDBMS like Oracle, MySQL, MS-SQL Server Good knowledge on AWS RDS Provision of PostgreSQL RDS and monitoring and optimization of the same in AWS Major, Minor version upgrade of PostgreSQL Migration of PostgreSQL in on-prem to AWS RDS Experience large PostgreSQL databases and performance tuning Good knowledge on interal parameters and how to fine tune them Logical/physical replication of PostgreSQL and suggesting best approach depending in business needs. Expert communicator with both technical peers and executives in the US and India. Perform Incident and Problem management duties. Good knowledge on maintaining databases in AWS RDS, aurora postgres Preparing DR strategies and implementing DR practice tests for mission critical databases to build DR availability confidence. Performing database refreshes between various DB environments. Capacity management which includes planning and recommend the application owners to archive the historical data, data file movement to improve the storage capacity. Performance and Tuning, Query optimization. Good knowledge in shell scripting, able to write shell scripts related to PostgreSQL Suggest best practices to application team for securing PostgreSQL ,Aurora postgres databases. Knowledge on Aurora postgres regional, global clusters. Knowledge on implementing changes and change management process. Basic Qualifications: Bachelor's degree in Computer Science, Information Systems or Engineering is required, or in lieu, a demonstrated equivalence in work experience Postgres & AWS Certifications preferred Very good experience in AWS Cloud Experience in other RDBMS like Oracle,MySQL, MS-SQL server has added advantage Experience in developing shell scripts, suggesting best security practices for database Excellent communication skills are essential, with strong verbal and writing proficiencies Preferred Qualifications: Candidates should have a minimum of 9+ years industry experience in PostgreSQL admin. Administer PostgreSQL in Linux, knowledge on AWS RDS and Aurora Postgres Deploy OS patches & perform upgrades of PostgreSQL Major, Minor version upgrades of PostgreSQL Applying best security practices to PostgreSQL databases running on Linux Develop Unix scripts related PostgreSQL database Develop scripts for automation of database infrastructure provisioning in AWS. Monitor PostgreSQL databases and Evaluate new AWS services and solutions related to RDS. Experience working with customers to diagnose a problem, and work toward resolution Excellent verbal and written communication skills Understanding of various PostgreSQL logical/physical replication and suggesting best solution according to business needs.

Should be primarily experienced in backend development and should be able to design, create, and implement a solution that is domain-driven, abstracted, business-oriented, and scalable from scratch, while also able to debug & fix issues. Should also be proficient in front-end development enough to maintain, create additional code, fix bugs, and suggest new solutions in the backend code. Core Skills (Primary - 70%): Hard Skills: C#/.NET (Advanced), Azure Functions, REST/GraphQL API development, SQL (T-SQL, query optimization), Dependency Injection, Git. Nice to Have: JWT, Azure APIM, Azure Data Factory, Azure Service Bus, Redis Caching, CI/CD YAML, Advanced Git Core Skills (Secondary 30%): Hard Skills: React/Next.js (Proficient), TypeScript/JavaScript, MSAL Auth flows, Ag-Grid React, GraphQL client-side libraries, HTML/CSS Nice to have: Tailwind CSS, Figma Competencies: o Backend for Frontend (BFF) Mindset: The ability to design and optimize backend services specifically for the needs of the Next.js frontend, including building efficient GraphQL resolvers. o Business Logic Expert: A deep understanding of object-oriented programming (OOP) principles and Domain-Driven Design (DDD) to build clean, maintainable, and testable business logic. o Integration Specialist: The ability to design and implement robust, resilient integrations with external systems. o Data-Driven: A solid understanding of database design, schema management, and writing performant inline SQL queries.

Proficiency in Java Experience designing and building distributed systems at scale Hands-on experience with AWS, messaging systems (Kafka), and CI/CD pipelines Strong understanding of storage systems, query performance, and caching strategies

We are seeking an experienced MySQL database administrator to ensure high performance, availability, and security of MySQL instances, as well as proficiency in other NoSQL databases like MongoDB and Elasticsearch. You will be responsible for various maintenance tasks such as upgrades, fixes, backups, and database instance provisioning, with complete ownership of all utilized databases. Responsibilities: - Installation, configuration, monitoring, upgrading, and maintenance of databases in both production and non-production environments. - Hands-on experience with MySQL, MongoDB, and Elasticsearch. - 24/7 support for failover in a High Availability Disaster Recovery environment using MySQL native Replication. - Management of database maintenance activities, including profiling server resource usage, optimization, and troubleshooting at all levels. - Addressing database issues such as data corruption, restoration, backup, offline database recovery, and statement-level analysis. - Ensuring performance, security, and availability of databases. - Documentation preparation to enforce organizational guidelines for developers. - Execution of common database procedures like upgrades, backups, recoveries, migrations, etc. - Collaboration with team members and stakeholders to drive critical updates related to database failover. - Identification and resolution of database issues, including slow queries and database structure changes. Requirements: - Minimum 5 years of DBA experience in MySQL, MongoDB, Elasticsearch, or similar technologies. - Profound knowledge in MySQL database management, relational schema definitions, integrity constraints, replication clusters, and log management for rapid issue identification. - Strong understanding of MySQL database fundamentals and query optimization, including query plan analysis, full table scan optimizations, query worker analysis, query caching, complex SQL queries with multiple joins, views, and stored procedures. - Solid grasp of NoSQL databases for concurrency and lock performance monitoring, WiredTiger for MongoDB, GlobalLocks, and Locks. - Experience in performance tuning, such as clustered and non-clustered indexing, sharding, partitioning concepts, versioned data rows, and periodic data archival from transactional tables. - Excellent communication and interpersonal skills.,