Database Administrator

• Administer and support existing databases, including routine monitoring, access management, troubleshooting, and maintenance
• Examine and document the existing Oracle database structure, including schemas, tables, columns, data types, keys, constraints, indexes, views, sequences, triggers, stored procedures, and functions
• Recreate the corresponding database structure in Azure SQL Managed Instance
• Map Oracle data types and database objects to suitable SQL Server/Azure SQL equivalents and identify compatibility gaps
• 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
• Validate target schema objects, relationships, constraints, and key definitions against the source Oracle structure
• Prepare and maintain database scripts and support repeatable deployment 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
• Troubleshoot database connectivity and query issues with backend developers and technical team members
• Manage database permissions and access controls
• Support backup, recovery, monitoring, storage, blocking, and deadlock analysis
• Maintain documentation of source structures, target structures, conversion decisions, scripts, and validation results

• 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
• 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

• Remote work
• Support for backup and recovery practices
• Database performance monitoring and tuning responsibilities