Logo for SRM Technologies

Database Administration

Role overview

Summary

The Database Administrator role focuses on administering relational database environments and migrating Oracle databases to Azure SQL Managed Instance. You will analyze existing structures, recreate schemas, and ensure operational stability while collaborating with technical teams to support data validation and performance tuning.

Qualifications

  • 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.
  • Strong SQL skills and working knowledge of PL/SQL and T-SQL.
  • Experience with database performance analysis, query tuning, permissions, monitoring, and backup/recovery practices.

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.

Key facts

Hard skills

Key skills for this role

Other skills

  • Troubleshooting (Problem Solving)
  • Analytical Skills
  • Communication

About the company

SRM Technologies logo

SRM Technologies

  • IT Services & Consulting
  • Large
  • 501–1,000
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 USA, Japan 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. 𝘚𝘙𝘔 𝘛𝘦𝘤𝘩 𝘪𝘴 𝘢 𝘱𝘳𝘰𝘶𝘥 𝘮𝘦𝘮𝘣𝘦𝘳 𝘰𝘧 𝘵𝘩𝘦 𝘚𝘙𝘔 𝘎𝘳𝘰𝘶𝘱, 𝘢 𝘮𝘶𝘭𝘵𝘪𝘯𝘢𝘵𝘪𝘰𝘯𝘢𝘭 𝘤𝘰𝘯𝘨𝘭𝘰𝘮𝘦𝘳𝘢𝘵𝘦 𝘸𝘪𝘵𝘩 𝘢 𝘳𝘪𝘤𝘩 𝘩𝘪𝘴𝘵𝘰𝘳𝘺 𝘴𝘱𝘢𝘯𝘯𝘪𝘯𝘨 𝘰𝘷𝘦𝘳 𝘧𝘰𝘶𝘳 𝘥𝘦𝘤𝘢𝘥𝘦𝘴. 𝘛𝘩𝘦 𝘚𝘙𝘔 𝘎𝘳𝘰𝘶𝘱 𝘰𝘱𝘦𝘳𝘢𝘵𝘦𝘴 𝘪𝘯 𝘥𝘪𝘷𝘦𝘳𝘴𝘦 𝘴𝘦𝘤𝘵𝘰𝘳𝘴, 𝘪𝘯𝘤𝘭𝘶𝘥𝘪𝘯𝘨 𝘌𝘥𝘶𝘤𝘢𝘵𝘪𝘰𝘯, 𝘛𝘦𝘤𝘩𝘯𝘰𝘭𝘰𝘨𝘺, 𝘏𝘦𝘢𝘭𝘵𝘩𝘤𝘢𝘳𝘦, 𝘢𝘯𝘥 𝘔𝘦𝘥𝘪𝘢.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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.



Related jobs

See all Database Administrator jobs

Other jobs at SRM Technologies