Database Administration

Posted 17 Days Ago
Be an Early Applicant
Hiring Remotely in Chennai, IND
In-Office or Remote
Senior level
Information Technology
The Role
Administer existing relational databases and migrate Oracle schemas and database objects to Azure SQL Managed Instance. Responsibilities include schema analysis, Oracle-to-SQL mapping, DDL and deployment scripting, data validation, query tuning, access management, monitoring, backup and recovery, troubleshooting, and documentation across development, testing, staging, and production environments.
Summary Generated by Built In

This is a remote position.

Role Summary

The Database Administrator will administer existing relational database environments and analyze the structure of an existing Oracle database to recreate the equivalent schema and database objects in Azure SQL Managed Instance. The role focuses on understanding the source database, mapping Oracle structures to SQL Server/Azure SQL equivalents, creating and validating target database objects, supporting data validation, and maintaining database performance, security, availability, and operational stability.

Key Responsibilities

·        Administer and support existing databases, including routine monitoring, access management, troubleshooting, and maintenance.

·        Examine the existing Oracle database structure and document schemas, tables, columns, data types, primary and foreign keys, constraints, indexes, views, sequences, triggers, stored procedures, and functions.

·        Recreate the corresponding database structure in Azure SQL Managed Instance, preserving the source data model and relationships wherever appropriate.

·        Map Oracle data types and database objects to suitable SQL Server/Azure SQL equivalents, identifying compatibility gaps and required changes.

·        Review Oracle-specific SQL, PL/SQL, functions, sequences, identity behavior, triggers, and other database-specific features; support conversion to T-SQL or Azure SQL-compatible implementations where required.

·        Create and maintain schemas, tables, constraints, indexes, views, stored procedures, and functions in the target database as required.

·        Validate that target schema objects, relationships, constraints, and key definitions are complete and consistent with the source Oracle structure.

·        Prepare and maintain database scripts and support repeatable deployment of schema changes across development, test, staging, and production environments.

·        Support data loading and validation by checking record counts, key relationships, data types, nullability, and reconciliation results.

·        Analyze SQL queries and execution plans, identify bottlenecks, and tune indexes and database objects to improve performance.

·        Troubleshoot database connectivity and query issues in collaboration with backend developers and other technical team members.

·        Manage database permissions and access controls, and support backup, recovery, monitoring, storage, blocking, and deadlock analysis.

·        Maintain clear documentation of source structures, target structures, conversion decisions, scripts, and validation results.

Required Skills and Experience

·        Typically 5–8+ years of database administration and/or database development experience.

·        Strong practical experience with Oracle database schemas, tables, data types, constraints, indexes, views, sequences, triggers, stored procedures, and functions.

·        Hands-on experience with Microsoft SQL Server and/or Azure SQL Managed Instance, including schema creation and database administration.

·        Ability to analyze an Oracle schema and recreate equivalent structures in SQL Server/Azure SQL, with an understanding of platform differences.

·        Strong SQL skills and working knowledge of PL/SQL and T-SQL.

·        Experience with relational data modeling, primary and foreign keys, referential integrity, indexes, and constraints.

·        Experience with database performance analysis, query tuning, permissions, monitoring, and backup/recovery practices.

·        Ability to write, review, test, and maintain database DDL and deployment scripts.

·        Strong troubleshooting, documentation, analytical, and cross-team communication skills.

Preferred Qualifications

·        Experience with Oracle-to-SQL Server or Oracle-to-Azure SQL modernization projects.

·        Familiarity with SQL Server Migration Assistant (SSMA) for Oracle or other schema conversion and comparison tools.

·        Experience with database schema comparison, deployment automation, and validation utilities.

·        Familiarity with Azure Portal and Azure SQL monitoring and diagnostic capabilities.

·        Experience collaborating with application developers and data migration teams during database modernization.



Skills Required

  • 5-8+ years of database administration and/or database development experience
  • Practical experience with Oracle database schemas, tables, data types, constraints, indexes, views, sequences, triggers, stored procedures, and functions
  • Hands-on experience with Microsoft SQL Server and/or Azure SQL Managed Instance
  • Experience analyzing Oracle schemas and recreating equivalent structures in SQL Server or Azure SQL
  • Strong SQL skills and working knowledge of PL/SQL and T-SQL
  • Experience with relational data modeling, keys, referential integrity, indexes, and constraints
  • Experience with database performance analysis, query tuning, permissions, monitoring, and backup/recovery
  • Ability to write, review, test, and maintain database DDL and deployment scripts
  • Strong troubleshooting, documentation, analytical, and cross-team communication skills
  • Experience with Oracle-to-SQL Server or Oracle-to-Azure SQL modernization projects
  • Familiarity with SQL Server Migration Assistant for Oracle or similar schema conversion and comparison tools
  • Experience with database schema comparison, deployment automation, and validation utilities
  • Familiarity with Azure Portal and Azure SQL monitoring and diagnostic capabilities
  • Experience collaborating with application developers and data migration teams during database modernization
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chennai
1,396 Employees
Year Founded: 1998

What We Do

SRM Technologies is a global IT services company specialising in automotive technologies, digital transformation and product engineering services. We provide technology consulting, platform development, data analytics, artificial intelligence, cloud enablement, digital infrastructure, quality assurance, embedded software and design to manufacturing product solutions to various industries and enterprises across the North America, Japan, Europe and India. At the heart of our organization are passionate employees who embody our core belief - 'ideas@work.' We firmly believe that ideas and innovation truly matter only when they create a meaningful impact on our customers' businesses and the lives of their end customers. Therefore, we prioritize the practical application of these ideas and their transformative impact through our talented and ever-growing workforce. 𝘚𝘙𝘔 𝘛𝘦𝘤𝘩 𝘪𝘴 𝘢 𝘱𝘳𝘰𝘶𝘥 𝘮𝘦𝘮𝘣𝘦𝘳 𝘰𝘧 𝘵𝘩𝘦 𝘚𝘙𝘔 𝘎𝘳𝘰𝘶𝘱, 𝘢 𝘮𝘶𝘭𝘵𝘪𝘯𝘢𝘵𝘪𝘰𝘯𝘢𝘭 𝘤𝘰𝘯𝘨𝘭𝘰𝘮𝘦𝘳𝘢𝘵𝘦 𝘸𝘪𝘵𝘩 𝘢 𝘳𝘪𝘤𝘩 𝘩𝘪𝘴𝘵𝘰𝘳𝘺 𝘴𝘱𝘢𝘯𝘯𝘪𝘯𝘨 𝘰𝘷𝘦𝘳 𝘧𝘰𝘶𝘳 𝘥𝘦𝘤𝘢𝘥𝘦𝘴. 𝘛𝘩𝘦 𝘚𝘙𝘔 𝘎𝘳𝘰𝘶𝘱 𝘰𝘱𝘦𝘳𝘢𝘵𝘦𝘴 𝘪𝘯 𝘥𝘪𝘷𝘦𝘳𝘴𝘦 𝘴𝘦𝘤𝘵𝘰𝘳𝘴, 𝘪𝘯𝘤𝘭𝘶𝘥𝘪𝘯𝘨 𝘌𝘥𝘶𝘤𝘢𝘵𝘪𝘰𝘯, 𝘛𝘦𝘤𝘩𝘯𝘰𝘭𝘰𝘨𝘺, 𝘏𝘦𝘢𝘭𝘵𝘩𝘤𝘢𝘳𝘦, 𝘢𝘯𝘥 𝘔𝘦𝘥𝘪𝘢

Similar Jobs

Atlassian Logo Atlassian

Android Engineer

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
In-Office or Remote
560071, Domlur, Karnataka, IND
11000 Employees

Micron Technology Logo Micron Technology

Engineer, STPG PE

Artificial Intelligence • Hardware • Information Technology • Machine Learning
Remote
Gujarat, IND
45000 Employees

Micron Technology Logo Micron Technology

Facilities - Sr Manager

Artificial Intelligence • Hardware • Information Technology • Machine Learning
Remote
Gujarat, IND
45000 Employees

Hilton Logo Hilton

Commis I

Events • Food • Travel • Hospitality • Hotels & Resorts
Remote
India
500000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account