Oracle Database Administrator

Indore, Madhya Pradesh Mastech Digital

Posted 3 days ago

Job Viewed

Tap Again To Close

Job Description

Position: Oracle Database Administrator

Location: Remote

Duration: Full Time and Full Time Contractors

Notice Period: Only Immediate Joiners/ Currently Serving Notice/ Notice is less than 30 days

Budget : 10-16 LPA for Full Time and 15-25 LPA for Contract (For Contract- No PF, No Gratuity, No leaves, No benefits)

Year of experience: 6- 12 years




Key Responsibilities

• Performance Optimization & Tuning

o Analyze and resolve database bottlenecks affecting application/API performance.

o Tune SQL queries, PL/SQL packages, stored procedures, and indexes for optimal response times.

o Implement best practices for connection pooling, partitioning, and caching strategies.

• Application & Middleware Integration Support

o Work with API Gateway and custom orchestration teams to optimize database interaction patterns.

o Support GET/POST transaction flows from APIs into Oracle.

o Ensure efficient database design for web applications with high concurrency and SLA targets.

• On-Premise & Cloud Integration

o Manage data synchronization between on-prem Oracle and Fusion Cloud Oracle DB via OIC (Oracle Integration Cloud).

o Implement and support Pub/Sub mechanisms for customer data exchange.

o Monitor and troubleshoot replication/data transfer issues.

• Operational Excellence

o Proactively monitor system health, query execution plans, and workload statistics (AWR, ASH, ADDM).

o Provide root cause analysis and resolution for performance incidents.

o Partner with infrastructure DBAs for patching, backups, disaster recovery, and capacity planning.

o Develop and maintain documentation, standards, and runbooks for application database operations.

___

Qualifications & Skills

• 6–8 years of hands-on experience as an Oracle DBA, with emphasis on Application DBA responsibilities.

• Strong expertise in:

o Oracle 12c/19c performance tuning, indexing, partitioning, optimizer hints.

o SQL and PL/SQL development and debugging.

o AWR, ASH, ADDM, TKPROF, and other Oracle diagnostic/tuning tools.

• Experience supporting web applications, API-driven architectures, or middleware platforms.

• Familiarity with Oracle Integration Cloud (OIC) and Fusion Cloud database integration (Pub/Sub methodology preferred).

• Knowledge of high availability, scalability, and SLA management for mission-critical applications.

• Solid understanding of database security, auditing, and user access controls.

• Strong analytical skills and ability to work in cross-functional agile teams.

• Excellent communication skills to interact with application developers, architects, and operations teams.

___

Preferred/Bonus Skills

• Exposure to Oracle GoldenGate or other replication tools.

• Experience with API Gateway products (Apigee, Kong, Oracle API Gateway, etc.).

• Knowledge of containerization (Docker, Kubernetes) and DevOps pipelines for DB changes.

• Familiarity with monitoring tools (Oracle Enterprise Manager, Grafana, Prometheus).

This advertiser has chosen not to accept applicants from your region.

Sr SQL Server Database Administrator – Azure

Indore, Madhya Pradesh Maitsys

Posted 5 days ago

Job Viewed

Tap Again To Close

Job Description

Job Title: Senior SQL Server Database Administrator – Azure

Location: Remote

Experience Level: Senior (Minimum 10 years of professional experience)

Employment Type: Full-Time


Job Summary:

We are looking for an experienced Senior SQL Server Database Administrator (DBA) with strong expertise in Azure SQL Server and Azure SQL Subscription management. The ideal candidate will have a proven track record in managing, securing, optimizing, and migrating SQL Server environments, both on-premises and in the Azure cloud. This is a fully remote opportunity for professionals located in India.


Key Responsibilities:

  • Manage and administer SQL Server databases (on-premises and Azure SQL).
  • Plan, implement, and oversee Azure SQL Subscription services, ensuring high availability and cost-efficiency.
  • Perform database performance tuning , query optimization, indexing, and monitoring.
  • Configure and maintain disaster recovery , backups , and high availability solutions (Always On, Geo-Replication, etc.).
  • Implement and monitor security policies , access controls, and compliance standards.
  • Plan and execute database migrations from on-premises SQL Server to Azure SQL .
  • Work with development and DevOps teams to support CI/CD and database lifecycle management.
  • Monitor and troubleshoot production issues and proactively address database health and capacity concerns.
  • Develop and maintain documentation , runbooks, and best practices.

Required Qualifications:

  • Minimum 10 years of experience as a SQL Server DBA.
  • Minimum 3 years of hands-on experience with Azure SQL Server and Azure SQL Subscription management.
  • Strong experience in performance tuning and troubleshooting database issues.
  • Deep knowledge of T-SQL , backup/recovery , replication , indexing , and security configurations .
  • Proven experience with migration projects from on-premises SQL Server to Azure.
  • Familiarity with Azure services like Azure Monitor , Azure Security Center , and Azure Automation .
  • Understanding of licensing and cost management for Azure SQL resources.
  • Excellent problem-solving and communication skills.

Preferred Qualifications:

  • Microsoft Certified: Azure Database Administrator Associate or equivalent certification.
  • Experience with PowerShell scripting for automation.
  • Knowledge of infrastructure-as-code tools and CI/CD pipelines related to database deployments.
  • Experience working in Agile and DevOps environments.

Work Environment:

  • Fully remote role; candidates must be located in India .
  • Flexible work hours with occasional availability needed for collaboration across international teams.
This advertiser has chosen not to accept applicants from your region.

Tech Lead - Snowflake,MS SQL Server,SSIS Job

Indore, Madhya Pradesh YASH Technologies

Posted today

Job Viewed

Tap Again To Close

Job Description

Job Summary

: We are looking for a highly skilled Senior Data Engineer with 8–10 years of experience in data engineering, specializing in Snowflake, Microsoft SQL Server, and SSIS package review/analysis. The ideal candidate will not only design and optimize scalable data solutions but also provide technical guidance, mentorship, and direction to other developers in the team. This role requires strong hands-on expertise, architectural thinking, and leadership in building reliable data ecosystems that enable analytics and reporting across the enterprise.

Must-Have Skills & Experience:

· 8–10 years of professional experience in data engineering.

· Deep expertise in Microsoft SQL Server (T-SQL, indexing, query tuning, stored procedures).

· Strong hands-on knowledge of Snowflake (database design, ingestion, data sharing, security, and resource management).

· Proven experience designing and implementing end-to-end data warehousing and ETL/ELT solutions.

· Prior exposure to SSIS package review, analysis, and troubleshooting.

· Strong understanding of data architecture, performance tuning, and optimization strategies.

· Experience in leading or mentoring developers and providing architectural guidance.

· Excellent communication and stakeholder management skills with the ability to translate technical requirements into business-aligned solutions.

Key Responsibilities:

· Lead the design and development of data pipelines and integration flows across SQL Server and Snowflake.

· Review and guide developers on SSIS package optimization and troubleshooting.

· Set coding and design best practices for SQL and Snowflake development, ensuring performance, scalability, and robustness.

· Mentor junior and mid-level data engineers by providing technical guidance, peer reviews, and knowledge sharing.

· Collaborate with solution architects and business stakeholders to design data models, schemas, and warehouse solutions for enterprise analytics.

· Drive initiatives to ensure data quality, governance, and compliance across platforms.

· Partner with cross-functional teams to prioritize and deliver strategic data engineering solutions.

· Troubleshoot complex issues, conduct root cause analysis, and propose long-term improvements.

· Contribute to the continuous improvement of data engineering processes, tools, and Frameworks.

Required Technical/ Functional Competencies

Domain/ Industry Knowledge:

  • Working knowledge of customer's business processes and relevant technology platform or product.
  • Able to analyze current-state and define to-be processes in collaboration with SME and present recommendations with tangible benefits.
  • Requirement Gathering and Analysis:

  • Specialized knowledge of requirement management processes and requirement analysis processes, tools & methodologies.
  • Extract requirements for complex scenarios and prototype independently.
  • Identify modules impacted, features/functionalities impacted and arrive at high level estimates.
  • Develop traceability matrix and identify transition requirements.
  • Product/ Technology Knowledge:

  • Implement code or configure/customize products, drive adoption of industry standards and practices, and contribute to development of reusable assets and innovative solutions.
  • Conduct technical sessions and knowledge sharing sessions, and work on complex modules independently.
  • Analyze various frameworks/tools and present recommendations, contribute to development of training and certification material, and demonstrate thought leadership through whitepapers and webinars.
  • Architecture tools and frameworks:

  • Specialized knowledge of architecture Industry tools & frameworks.
  • Implement tools & framework in a complex scenario.
  • Conduct tools & framework customization & tailoring workshop.
  • Architecture concepts and principles:

  • Specialized knowledge of architectural elements, SDLC, methodologies & customer business/domain.
  • Establish Architectural principles/ patterns and use advanced tools to capture and analyze system/ technical issues.
  • Analytics Solution Design:

  • In Depth knowledge of statistical & machine learning techniques.
  • Able to design analytical modelling approach for moderate-scale projects or for components of large-scale.
  • Understand business requirements & constraints including potential trade-offs between speed & accuracy, maintains trends.
  • Tools & Platform Knowledge:

  • Familiarity with the wide range of data science/analytics commercial and open source software tools, their constraints, advantages, disadvantages, areas of application and mainstream packages relevant to technical stages of data science/analytics projects.
  • Intermediate to advanced skills in programming languages used for data science/analytics and ability to apply these for data acquisition, pre-processing, modelling and model deployment. Ability to interpret and modify existing scripts and conduct quality checks.
  • Required Behavioral Competencies

    Accountability:

  • Takes responsibility for and ensures accuracy of results and deadlines of the function and/or team and in completing own work.
  • Collaboration:

  • Reaches out to others in team to ensure connections are made and team members are working together.
  • Looks for ways to integrate work with other teams, identifying similarities and opportunities, making necessary changes in work to ensure successful integration.
  • Agility:

  • Demonstrates openness to the possibilities that change presents and begins to plan for how role may change.
  • Works with others to prepare for change.
  • Customer Focus:

  • Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.
  • Communication:

  • Communicates well-organized ideas, information, and data to broad and diverse audiences across the Organization (through formal and informal presentations).
  • Helps others identify their appropriate audience.
  • Drives Results:

  • Sets realistic stretch goals for self & others and perseveres to follow through with resilience and remains calm in a crisis or stressful situation to exceed organization/client expectation.
  • Resolves Conflict:

  • Identifies and understands the source of conflict, addresses, and overcomes.
  • Certifications

    Mandatory At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale. Our Hyperlearning workplace is grounded upon four principles
  • Flexible work arrangements, Free spirit, and emotional positivity
  • Agile self-determination, trust, transparency, and open collaboration
  • All Support needed for the realization of business goals,
  • Stable employment with a great atmosphere and ethical corporate culture
  • This advertiser has chosen not to accept applicants from your region.

    Software Engineer - SnowFlake,MS SQL Server,SSIS Job

    Indore, Madhya Pradesh YASH Technologies

    Posted today

    Job Viewed

    Tap Again To Close

    Job Description

    Job Summary

    : We are seeking an experienced Data Engineer with 4–6 years of expertise in SQL Server, Snowflake, and data engineering practices. The ideal candidate will be responsible for building scalable data solutions, analyzing existing ETL processes, and ensuring seamless data integration across platforms. This role requires strong analytical skills, hands-on development experience, and the ability to collaborate with cross-functional teams to support data-driven decision-making.

    Must-Have Skills & Experience:

    · 4–6 years of professional experience in data engineering.

    · Strong proficiency in Microsoft SQL Server (T-SQL, stored procedures, indexing, performance optimization).

    · Proven hands-on experience with Snowflake (database creation, query optimization, data sharing, and schema management).

    · Solid understanding of ETL/ELT concepts and data warehousing principles.

    · Experience reviewing, analyzing, and troubleshooting SSIS packages (no development required).

    · Strong knowledge of data modeling, query performance tuning, and optimization techniques.

    · Excellent problem-solving skills and ability to work both independently and in a team environment.

    · Strong communication skills for collaborating with business and technical stakeholders.

    Key Responsibilities:

    · Design, build, and optimize data pipelines and integration flows between SQL Server and Snowflake.

    · Review and analyze existing SSIS packages to identify improvements, troubleshoot issues, and recommend optimizations.

    · Develop, maintain, and tune complex SQL queries, stored procedures, and triggers.

    · Implement and manage data warehousing solutions in Snowflake to support reporting and analytics.

    · Collaborate with business analysts, data scientists, and application teams to gather requirements and deliver robust data solutions.

    · Conduct data validation, quality checks, and error handling to ensure accuracy and reliability of business reporting.

    · Ensure adherence to data governance, best practices, and documentation standards.

    · Participate in troubleshooting, root cause analysis, and performance enhancement activities.

    Required Technical/ Functional Competencies

    Domain/ Industry Knowledge: 

  • Basic knowledge of customer's business processes and relevant technology platform or product
  • Able to prepare process maps, workflows, business cases and simple business models in line with customer requirements with assistance from SME and apply industry standards/ practices in implementation with guidance from experienced team members.
  • Requirement Gathering and Analysis: 

  • Basic knowledge of requirement management processes and requirement analysis process, tools and methodologies.
  • Able to prototype/ design a prototype of an example system to be demonstrated to stakeholders and extract functional/ non-functional requirements from business requirements and document a system/ software requirements specification for low to medium complexity scenarios.
  • Product/ Technology Knowledge:

  • Working knowledge of technology product/platform standards and specifications.
  • Able to implement code or configure/customize products and provide inputs in design and architecture adhering to industry standards/ practices in implementation.
  • Analyze various frameworks/tools, review the code and provide feedback on improvement opportunities.
  • Architecture tools and frameworks:  

  • Basic knowledge of architecture Industry tools & frameworks
  • Able to analyse available tools and frameworks for review by the SME and plan (under guidance) for tool configurations and development.
  • Architecture concepts and principles: 

  • Basic knowledge of architectural elements, SDLC, methodologies.
  • Able to apply various architectural constructs in the projects and identify various architectural patterns and implement.
  • Analytics Solution Design: 

  • High-level awareness of wide range of core data science/analytics techniques, its advantages, disadvantages, and areas of application.
  • Tools & Platform Knowledge:  

  • Familiar with wide range of mainstream commercial and open-source data science/analytics software tools, their constraints, advantages, disadvantages, and areas of application.
  • Required Behavioral Competencies

    Accountability:

  • Takes ownership for and ensures accuracy of own work, meets deadlines, and asks questions about possible gaps to ensure clarity of ownership.
  • Agility:

  • Demonstrates a willingness to accept and embrace differing ideas or perceptions which are beneficial to the organization.
  • Collaboration:

  • Participates in team activities and reaches out to others in team to achieve common goals.
  • Customer Focus:

  • Displays awareness of customers stated needs and gives priority to meeting and exceeding customer expectations at or above expected quality within stipulated time.
  • Communication:

  • Effectively communicates in written and oral form, well-organized thoughts to others. Speaks openly and honestly with all employees.
  •  Drives Results:

  • Demonstrates a "can do" attitude and is willing to stretch self to achieve and exceed defined goals/targets.
  • Certifications

    Good To Have At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale. Our Hyperlearning workplace is grounded upon four principles
  • Flexible work arrangements, Free spirit, and emotional positivity
  • Agile self-determination, trust, transparency, and open collaboration
  • All Support needed for the realization of business goals,
  • Stable employment with a great atmosphere and ethical corporate culture
  • This advertiser has chosen not to accept applicants from your region.
    Be The First To Know

    About the latest Database administration Jobs in Indore !

     

    Nearby Locations

    Other Jobs Near Me

    Industry

    1. request_quote Accounting
    2. work Administrative
    3. eco Agriculture Forestry
    4. smart_toy AI & Emerging Technologies
    5. school Apprenticeships & Trainee
    6. apartment Architecture
    7. palette Arts & Entertainment
    8. directions_car Automotive
    9. flight_takeoff Aviation
    10. account_balance Banking & Finance
    11. local_florist Beauty & Wellness
    12. restaurant Catering
    13. volunteer_activism Charity & Voluntary
    14. science Chemical Engineering
    15. child_friendly Childcare
    16. foundation Civil Engineering
    17. clean_hands Cleaning & Sanitation
    18. diversity_3 Community & Social Care
    19. construction Construction
    20. brush Creative & Digital
    21. currency_bitcoin Crypto & Blockchain
    22. support_agent Customer Service & Helpdesk
    23. medical_services Dental
    24. medical_services Driving & Transport
    25. medical_services E Commerce & Social Media
    26. school Education & Teaching
    27. electrical_services Electrical Engineering
    28. bolt Energy
    29. local_mall Fmcg
    30. gavel Government & Non Profit
    31. emoji_events Graduate
    32. health_and_safety Healthcare
    33. beach_access Hospitality & Tourism
    34. groups Human Resources
    35. precision_manufacturing Industrial Engineering
    36. security Information Security
    37. handyman Installation & Maintenance
    38. policy Insurance
    39. code IT & Software
    40. gavel Legal
    41. sports_soccer Leisure & Sports
    42. inventory_2 Logistics & Warehousing
    43. supervisor_account Management
    44. supervisor_account Management Consultancy
    45. supervisor_account Manufacturing & Production
    46. campaign Marketing
    47. build Mechanical Engineering
    48. perm_media Media & PR
    49. local_hospital Medical
    50. local_hospital Military & Public Safety
    51. local_hospital Mining
    52. medical_services Nursing
    53. local_gas_station Oil & Gas
    54. biotech Pharmaceutical
    55. checklist_rtl Project Management
    56. shopping_bag Purchasing
    57. home_work Real Estate
    58. person_search Recruitment Consultancy
    59. store Retail
    60. point_of_sale Sales
    61. science Scientific Research & Development
    62. wifi Telecoms
    63. psychology Therapy
    64. pets Veterinary
    View All Database Administration Jobs View All Jobs in Indore