Senior Oracle Database Administrator

Senior Database Administrator (DBA III)

Job Title

Senior Database Administrator (DBA III)

Job Summary

We are seeking an experienced Senior Database Administrator (DBA III) to manage, optimize, and support enterprise database environments across Oracle and Microsoft SQL Server/Azure SQL platforms. The ideal candidate will have extensive experience in database administration, performance tuning, database security, disaster recovery, high availability, and cloud-based database solutions. This role involves working closely with application development teams in an Agile (Scrum) environment to design, maintain, and optimize databases supporting mission-critical enterprise applications.

The successful candidate will be responsible for database migrations, Oracle-to-Azure SQL conversions, logical and physical data modeling, database monitoring, backup and recovery, and implementing best practices to ensure database availability, integrity, confidentiality, and performance.

Key Responsibilities

• Administer, maintain, and support enterprise Oracle and Microsoft SQL Server/Azure SQL databases.
• Design, implement, and maintain logical and physical database models.
• Monitor database performance and perform query optimization, indexing, and performance tuning.
• Migrate databases and convert Oracle schemas, stored procedures, and functions to Azure SQL.
• Develop and maintain database security, user access controls, encryption, and auditing.
• Implement backup, recovery, disaster recovery, replication, clustering, and high-availability solutions.
• Install, configure, patch, upgrade, and troubleshoot database management systems.
• Design and implement database monitoring solutions to track health, availability, and performance metrics.
• Support ETL processes for loading and transforming data from multiple sources into Azure SQL databases.
• Create and maintain database standards, naming conventions, data dictionaries, and technical documentation.
• Work closely with application developers to support Full-Stack Java applications and optimize database interactions.
• Analyze database structures and recommend improvements for scalability, reliability, and efficiency.
• Participate in database capacity planning, storage management, and resource allocation.
• Support software development lifecycle activities using Agile (Scrum) methodologies.
• Collaborate with DevOps teams to support CI/CD pipelines and automated database deployments.
• Ensure compliance with database security policies, governance standards, and accessibility requirements.
• Support disaster recovery planning, testing, and business continuity initiatives.
• Provide technical guidance and mentoring to junior database administrators and development teams.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 10 years of professional database administration experience.
• 8 years of experience administering Oracle and Microsoft SQL Server (or equivalent relational databases).
• Strong experience with database architecture, administration, and performance tuning.
• Extensive knowledge of database indexing, query optimization, execution plans, and troubleshooting.
• Experience designing enterprise database solutions supporting large-scale applications.
• Strong understanding of relational database concepts, normalization, and data modeling.
• Experience creating technical design documents and database documentation.
• Experience working in Agile (Scrum) software development environments.
• Experience supporting enterprise multi-tier, SOA, or Microservices-based applications.
• Strong knowledge of backup and recovery strategies, replication, clustering, and disaster recovery.

Preferred Qualifications

• Experience with Microsoft Azure and Azure SQL Database.
• Experience migrating Oracle databases to Azure SQL environments.
• Experience developing and supporting ETL processes.
• Experience with Git, Azure DevOps, and CI/CD pipelines.
• Exposure to Java/J2EE enterprise applications.
• Azure Certification (preferred).
• Oracle DBA or Microsoft SQL Server DBA certifications (preferred).

Technical Skills

Database Technologies

• Oracle Database
• Microsoft SQL Server
• Azure SQL Database
• T-SQL
• PL/SQL
• Oracle Stored Procedures
• SQL Optimization
• Database Migration

Database Administration

• Database Installation & Configuration
• Performance Tuning
• Query Optimization
• Indexing Strategies
• Database Monitoring
• Capacity Planning
• Backup & Recovery
• Replication
• Clustering
• High Availability (HA)
• Disaster Recovery (DR)
• Security & Encryption
• User Management
• Database Auditing

Data Management

• Data Modeling (Logical & Physical)
• Data Migration
• ETL
• Data Transformation
• Data Validation
• Data Integrity
• Data Dictionary Management

Cloud & DevOps

• Microsoft Azure
• Azure SQL
• Git
• Azure DevOps
• CI/CD Pipelines

Development Environment

• Agile (Scrum)
• Java/J2EE
• SOA
• Microservices
• RESTful Services

Preferred Certifications

• Microsoft Azure Database Administrator Associate
• Oracle Database Administrator Certification
• Microsoft SQL Server Database Administration Certification
• Azure Fundamentals (AZ-900)

Soft Skills

• Strong analytical and problem-solving skills
• Excellent troubleshooting abilities
• Effective verbal and written communication
• Ability to work independently and collaboratively
• Strong organizational and documentation skills
• Attention to detail
• Ability to manage multiple priorities in a fast-paced environment
• Leadership and mentoring capabilities