Search by job, company or skills

3-6 Years
Quick Apply
  • Posted a day ago
  • Over 500 applicants have applied

Job Description

  • Key Responsibilities:
  • Database Development & Management:
  • Design, develop, and optimize SQL queries and stored procedures for data extraction, manipulation, and analysis.
  • Develop, test, and deploy database solutions to meet business requirements.
  • Create and manage database objects such as tables, indexes, views, and triggers.
  • Performance Tuning & Optimization:
  • Analyze and optimize database queries for performance improvements and efficiency.
  • Monitor and troubleshoot database performance issues, including slow queries, locking, and deadlocks.
  • Implement and ensure the best practices for indexing, query optimization, and data retrieval.
  • Data Integrity & Quality:
  • Ensure data integrity, consistency, and accuracy within the databases by designing robust database schemas and validation processes.
  • Implement ETL processes and data migrations as required by business or project needs.
  • Create and maintain automated data validation and reconciliation routines.
  • Collaboration & Requirements Gathering:
  • Collaborate with business analysts and other stakeholders to gather database requirements for new features and systems.
  • Translate business requirements into efficient and scalable database solutions.
  • Work with cross-functional teams to support data integration with various systems, including data warehousing solutions.
  • Database Security & Backup:
  • Implement and maintain database security measures, ensuring appropriate access control and encryption.
  • Monitor, maintain, and verify regular database backups and restore procedures.
  • Ensure compliance with data privacy laws and regulations as applicable.
  • Reporting & Data Analytics:
  • Write complex SQL queries to generate reports and provide actionable business insights.
  • Work with business intelligence tools (e.g., Power BI, Tableau) to create interactive dashboards and reports.
  • Assist in designing, building, and maintaining data warehouses or data lakes for consolidated business data reporting.
  • Database Documentation & Best Practices:
  • Document database design, development processes, and procedures.
  • Establish and enforce best practices for SQL development, database performance, and code versioning.
  • Create user manuals and documentation for technical teams and end-users as required.
  • Continuous Improvement & Troubleshooting:
  • Stay updated on new database technologies, best practices, and industry trends.
  • Provide troubleshooting and technical support for any database-related issues.
  • Continuously look for ways to improve database performance, efficiency, and scalability.

About Company

Laminaar Aviation Infotech is a global applications software solutions and consulting services provider to the aviation industry. Its proprietary software suite, ARMS®, is a comprehensive solution that is tailor-made to suit the operations for airlines, business aviation, airports, ANSP and defense.

Job ID: 121674333

Similar Jobs

Bengaluru, India

Skills:

Sql Database AdministrationPerformance TuningExecution plansSQL query optimizationIndexing strategiesDatabase design principles

Bengaluru, India

Skills:

PostgreSQLSQL ServerMySQLOracleVector Database Architecture and ManagementData Warehousing Dimensional Data ModellingData Governance Data Quality ManagementQdrantData Lake Architecture Development and MaintenanceAI ML Data Modelling and Feature EngineeringPineconeQuery Performance Tuning Database OptimizationAdvanced SQL DevelopmentChromaPython for Data Engineering Data Processing and AutomationMilvusWeaviate

Bengaluru, India

Skills:

Oracle Pl SqlFunctional TestingPythonSIT UATSQL Query writing

Bengaluru, India

Skills:

UnixPerformance TuningLinuxOracle Pl SqlTriggersFunctionsPackagesProcedures

Bengaluru, India

Skills:

data strategies BI strategiesPLX SQLModern analytical and transactional data storesDistributed data processing frameworksCreating dashboards using PLXGCP Big QueryData visualization productsSQL Dataflow

Beware of Scammers

We don’t charge money for job offers