6 Sql Performance Jobs

What will you be doing Operate, maintain, and administer solutions contributing to customer infrastructures operational efficiency, availability, and visibility. Planning maintenance activity, design documentation, and standard procedures Provide Root Cause Analysis reports for outages/incidents (ITIL - Problem Management) Observe and provide feedback on the current state of the client s infrastructure, and identify opportunities to improve resiliency, reduce incident occurrence, and automate repetitive administrative and operational tasks. Contribute to, improve, and maintain team documentation about client systems and infrastructure, procedures, policies, and schedules. Gather and document information about client environments through audit activities, and analyze the information to identify opportunities for improvement and application of best practices. Work collaboratively with teammates to contribute to the continuous improvement of our working culture. Act as a technology leader for clients, as well as drive client discussions on technology road maps. Participate in an on-call rotation in an escalation capacity. What do we need from you Experience working with Google and AWS Clouds (including infrastructure as code deployment with Cloud Formation, Terraform, Opsworks, etc) Scripting and automation of administrative tasks using Python and Scala is a must Solid understanding of microservices architecture and container technologies (Kubernetes is a must, Docker, lxc, etc) Clear understanding of software development lifecycles and best practices from an infrastructure point of view (PRs, merge, rebase, etc) Understanding the end-to-end operations of a Business System vs components. Comprehensive systems hardware and network troubleshooting experience Common Linux distribution platform installation, configuration, performance tuning, and cloud migration. TCP/IP networking, NIC bonding, and network services configuration (DNS, NTP, DHCP, SMTP, etc) Operation and administration of virtual infrastructure, including experience with at least one hypervisor (VMware, Hyper-V, KVM, etc.) Ability to describe IaaS, PaaS, SaaS, pros and cons of each, use cases for virtualization and cloud Administration of web servers and supporting technologies, including network load balancers Experience with the design, development, and deployment of Puppet System and application error investigation, troubleshooting of access/availability issues including deep multi-system root cause analysis Experience managing networking devices, such as switches and firewalls from a variety of vendors Solid understanding of DevOps tools, processes, and culture Ability to pick up new technologies quickly Ability to provide accurate work scheduling and task estimations for work delivery

What will you be doing Operate, maintain, and administer solutions contributing to customer infrastructures operational efficiency, availability, and visibility. Planning maintenance activity, design documentation, and standard procedures Provide Root Cause Analysis reports for outages/incidents (ITIL - Problem Management) Observe and provide feedback on the current state of the client s infrastructure, and identify opportunities to improve resiliency, reduce incident occurrence, and automate repetitive administrative and operational tasks. Contribute to, improve, and maintain team documentation about client systems and infrastructure, procedures, policies, and schedules. Gather and document information about client environments through audit activities, and analyze the information to identify opportunities for improvement and application of best practices. Work collaboratively with teammates to contribute to the continuous improvement of our working culture. Act as a technology leader for clients, as well as drive client discussions on technology road maps. Participate in an on-call rotation in an escalation capacity. What do we need from you Experience working with Google and AWS Clouds (including infrastructure as code deployment with Cloud Formation, Terraform, Opsworks, etc) Scripting and automation of administrative tasks using Python and Scala is a must Solid understanding of microservices architecture and container technologies (Kubernetes is a must, Docker, lxc, etc) Clear understanding of software development lifecycles and best practices from an infrastructure point of view (PRs, merge, rebase, etc) Understanding the end-to-end operations of a Business System vs components. Comprehensive systems hardware and network troubleshooting experience Common Linux distribution platform installation, configuration, performance tuning, and cloud migration. TCP/IP networking, NIC bonding, and network services configuration (DNS, NTP, DHCP, SMTP, etc) Operation and administration of virtual infrastructure, including experience with at least one hypervisor (VMware, Hyper-V, KVM, etc.) Ability to describe IaaS, PaaS, SaaS, pros and cons of each, use cases for virtualization and cloud Administration of web servers and supporting technologies, including network load balancers Experience with the design, development, and deployment of Puppet System and application error investigation, troubleshooting of access/availability issues including deep multi-system root cause analysis Experience managing networking devices, such as switches and firewalls from a variety of vendors Solid understanding of DevOps tools, processes, and culture Ability to pick up new technologies quickly Ability to provide accurate work scheduling and task estimations for work delivery

Coordinating, analyzing, designing, implementing and administering solutions. Recommending best practices for improvements to current operational processes. Configuring and maintaining SQL Server database servers. Troubleshooting operational problems. Administering proactive daily checks. Responding to monitoring alerts. Communicating status and planning activities to customers and other team members. Participating in the teams rotational shift pattern and on-call coverage rotation plan. What do we need from you 3 years or more of experience as a SQL Server DBA Installing, configuring and upgrading SQL Server databases. SQL Server Administration including: Managing Server and Database storage. Performance tuning of database server. Designing and implementing various backup/recovery strategies. SSRS & Power BI, SSIS, and BI experience. Coding scripts, procedures, functions, etc.

What you will be doing: You'll work closely with the customer teams to understand their needs, in both a project based and long term support capacity. You'll create and document database standards, create optimized queries, indexes, and data structure. Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support. Use database vendor provided tools and Pythian developed accelerators to performance tune various database systems, specific queries and applications scenarios. Diagnose and address database performance issues using performance monitors and various tuning techniques. Identify areas of opportunity and recommend appropriate improvement suggestions. Work with our site reliability engineering organization to help configure and deploy high-availability and disaster recovery solutions for critical applications to meet customers needs. Cross-functional training in Mongo, Ansible and Python are encouraged. When you're not fixing things, you'll be authoring new blog posts on interesting topics for our open-source community to digest, creating new articles in our customer facing knowledge base for more frequently seen issues, and hosting webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community. What we need from you: 5-8 years of overall experience required as a Database Consultant (DBC) for this role The position requires specialized knowledge and experience in installing, configuring and upgrading MySQL databases MySQL Administration. Debugging skills, MongoDB and Scripting/automation tooling experience is a huge plus. Strong ability to work in both a team oriented environment and also under minimal supervision. Strong ability to adapt and to learn quickly. Good customer service focus with the ability to handle customer expectations and priorities. Disciplined in their learning process. Self-motivated. Keen attention to detail. Good analytical, evaluative, and problem-solving abilities. Effective organizational skills. Demonstrate sound work ethics. Very good documentation skills. Nice to have - Understanding of current IT service standards such as ITIL. Scripting (bash/python) and Ansible experience is a huge plus. Excellent written and verbal communication skills. Contributor to Open Source projects relevant to MySQL, MongoDB or other database or infrastructure software.

Responsibilities: Develop and maintain SQL queries to extract, manipulate, and analyze data from relational databases. Collaborate with software developers and business analysts to understand application requirements and design appropriate database solutions. Optimize database queries for performance and scalability, ensuring efficient data retrieval and processing. Implement data validation and integrity checks to maintain data quality and consistency. Troubleshoot and resolve database-related issues in a timely manner. Develop and maintain database documentation, including data dictionaries, schemas, and query optimization techniques. Stay updated with emerging database technologies and industry best practices to continuously improve database performance and efficiency. Participate in code reviews and provide constructive feedback to peers. Work closely with cross-functional teams to support database-related initiatives and projects. Experience Must be in utilities or billing domain, No plsql developers only MSSql database developers

Oracle DBA TL/SME Location Details: Mumbai (Lower Parel)/ Hyderabad(Gachibowli) Primary Skills/Keywords Mandatory Skills -RAC(Installation, Upgradation and Management) Database backup and recovery, DB Migration and performance tuning Domain exp Prior working exp on Telecom or BFSI companies Job Responsibilities Candidate should have experience in Grid Installation and Grid Upgradation Mandatorily. Experience in Oracle RAC, Performance Tuning, Dataguard and knowledge of Golden gate. Expert level understanding of Oracle database architecture. Should have experience & ability to work with various teams to resolve performance issues (development, storage administrators, network administrators, system administrators and business users) Specialized in Oracle RAC, good understanding of complexity of RAC Architecture across Servers, OS, network, storage layer. Exposure to work on Oracle Engineered systems viz Exadata , SSC box & ExaCM . Should have SQL tuning skill and experience at refactoring sql queries to improve performance. Ability to diagnose the performance issues from SQL to Application to Database to System to Storage Excellent problem-solving skills, should be able to transverse across infrastructure layer to diagnosis issues. Expert at HA features of Oracle database. Complete understanding of Oracle databases backup recovery options. Skill to work under pressure in production environment on databases on all flavours of OS. Candidate should be okay Mumbai/Hyderabad Location(work from office) Domain Experience: Prior experience in Telecom or BFSI sector preferred Key Responsibilities: Database Architecture & Management: Expert-level understanding of Oracle database architecture. Specialized knowledge of RAC (Real Application Clusters), including architecture complexity across servers, OS, networks, and storage layers. Experience managing Oracle Engineered Systems (Exadata, SSC Box, ExaCM). Performance Tuning & Optimization: Diagnose and resolve SQL performance issues from the database to application level. Collaborate with development, storage, network, and system teams to address performance bottlenecks. Hands-on expertise in SQL tuning and query refactoring. High Availability & Disaster Recovery: Ensure high availability using Oracle RAC, Data Guard, and GoldenGate. Strong grasp of backup & recovery strategies for business-critical systems. Ensure database resilience and minimal downtime in production environments. Cross-Functional Collaboration & Problem Solving: Work with various stakeholders (business users, infra teams, DBAs) to troubleshoot performance issues. Ability to diagnose database issues across infrastructure layers (DB, application, OS, network, and storage). Strong analytical and problem-solving skills under high-pressure environments.