Database Administrator

This is a fully remote position, open to applicants in India.

📋 Description

• Oversee and provide support for existing databases, encompassing routine monitoring, access management, troubleshooting, and maintenance.

• Analyze and document the current Oracle database structure, which includes schemas, tables, columns, data types, keys, constraints, indexes, views, sequences, triggers, stored procedures, and functions.

• Reconstruct the equivalent database structure in Azure SQL Managed Instance.

• Map Oracle data types and database objects to appropriate SQL Server/Azure SQL counterparts and identify any compatibility issues.

• Review Oracle-specific SQL, PL/SQL, functions, sequences, identity behavior, triggers, and other features unique to the database.

• Assist in converting to T-SQL or Azure SQL-compatible implementations as necessary.

• Design and maintain schemas, tables, constraints, indexes, views, stored procedures, and functions within the target database.

• Validate target schema objects, relationships, constraints, and key definitions against the original Oracle structure.

• Develop and maintain database scripts, ensuring repeatable deployment across development, testing, staging, and production environments.

• Facilitate data loading and validation by checking record counts, key relationships, data types, nullability, and reconciliation outcomes.

• Evaluate SQL queries and execution plans, identify bottlenecks, and optimize indexes and database objects.

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

• Manage database permissions and access controls effectively.

• Provide support for backup, recovery, monitoring, storage, blocking, and deadlock analysis.

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

⛳️ Requirements

• Generally, 5–8+ years of experience in database administration and/or database development.

• Strong hands-on experience with Oracle database schemas, tables, data types, constraints, indexes, views, sequences, triggers, stored procedures, and functions.

• Practical experience with Microsoft SQL Server and/or Azure SQL Managed Instance, including schema creation and database administration.

• Capability to analyze an Oracle schema and recreate equivalent structures in SQL Server/Azure SQL while understanding platform differences.

• Proficient SQL skills and a working knowledge of PL/SQL and T-SQL.

• Experience in relational data modeling, including primary and foreign keys, referential integrity, indexes, and constraints.

• Knowledge of 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 skills, and effective communication across teams.

• Experience with Oracle-to-SQL Server or Oracle-to-Azure SQL modernization initiatives.

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

• Experience in database schema comparison, deployment automation, and validation utilities.

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

• Experience working collaboratively with application developers and data migration teams during database modernization projects.

🏝️ Benefits

• Opportunity for remote work.

• Support for backup and recovery practices.

• Responsibilities for database performance monitoring and tuning.