Sr Specialist Database Administration

Job Title: Sr Specialist Database Administration

Experience: 8–15+ Years

Location: Hyderabad / Bangalore

Job Summary

We are seeking an experienced Senior Database Administrator (DBA) to manage and support mission-critical Oracle database environments across Production, Disaster Recovery, and Non-Production platforms. The ideal candidate will possess deep expertise in Oracle Database Administration, Performance Tuning, High Availability, Backup & Recovery, Security Compliance, and Database Modernization initiatives. Having experience in PostgreSQL and Snowflake will be added advantage.

The role requires hands-on experience with Oracle RAC, Data Guard, GoldenGate, RMAN, Oracle Enterprise Manager, and cloud-based database deployments. The candidate will work closely with application, infrastructure, security, and development teams to ensure database reliability, scalability, performance, and compliance.

Key Responsibilities

Database Administration

• Install, configure, upgrade, patch, and maintain Oracle databases (11g/12c/19c/23ai).
• Manage Oracle RAC, ASM, CDB/PDB, and Enterprise Database environments.
• Perform database provisioning, cloning, refreshes, migrations, and capacity planning.
• Ensure 24x7 database availability and production support.

Performance & Optimization

• Monitor and optimize database performance using:
  • AWR
  • ASH
  • ADDM
  • SQL Tuning Advisor
  • SQL Profiles
• Analyze execution plans and troubleshoot performance bottlenecks.
• Optimize SQL, PL/SQL, indexes, partitioning, and storage structures.

High Availability & Disaster Recovery

• Administer Oracle Data Guard environments.
• Manage Oracle GoldenGate replication and troubleshoot replication issues.
• Execute disaster recovery exercises and validate recovery procedures.
• Maintain defined RTO and RPO objectives.

Backup & Recovery

• Design and manage RMAN backup and recovery strategies.
• Perform database recovery testing and restore validations.
• Ensure backup compliance and retention standards.

Security & Compliance

• Implement Oracle database security best practices.
• Support vulnerability remediation and database patching activities.
• Manage database access controls, encryption, password policies, and auditing.
• Support SOX, PCI, RIM, CCDR, and other compliance requirements.

Automation & DevOps

• Develop automation scripts using Shell, Python, SQL, and PL/SQL.
• Support CI/CD database deployments and release activities.
• Automate monitoring, reporting, health checks, and maintenance tasks.
• Partner with DevOps teams for infrastructure and deployment automation.

Production Support

• Participate in on-call support rotation.
• Troubleshoot critical production incidents and perform root cause analysis.
• Support major releases, migrations, and infrastructure modernization initiatives.

Required Skills:

PostgreSQL

• PostgreSQL 12+
• Streaming Replication
• Logical Replication
• pgAdmin
• pgBackRest
• Performance Tuning
• Partitioning
• High Availability Solutions

Snowflake

• Snowflake Architecture
• Virtual Warehouses
• Snowpipe
• Time Travel
• Zero Copy Cloning
• Secure Data Sharing
• RBAC & Security
• SnowSQL
• Cost & Performance Optimization

Oracle Technologies

• Oracle Database Administration (11g/12c/19c/23ai)
• Oracle RAC
• ASM
• Data Guard
• RMAN
• GoldenGate
• Multitenant Architecture (CDB/PDB)
• Oracle Enterprise Manager (OEM)

Performance Tuning

• SQL Tuning
• PL/SQL Optimization
• AWR/ASH/ADDM Analysis
• SQL Profiles and Execution Plans
• Database Capacity Planning

Operating Systems

• Linux (RHEL / Oracle Linux)
• Unix Shell Scripting

Scripting & Automation

• Shell Scripting
• Python
• SQL / PL/SQL

Cloud Platforms (Preferred)

• Oracle Cloud Infrastructure (OCI)
• Microsoft Azure
• AWS

Tools

• GitHub/Git
• Control-M
• ServiceNow
• Jira
• Monitoring and Automation Platforms

Preferred Qualifications

• Oracle Certified Professional (OCP)
• Oracle RAC and Data Guard Certifications
• Cloud Certifications (OCI/Azure/AWS)
• ITIL Foundation Certification

Soft Skills

• Strong analytical and troubleshooting skills
• Excellent communication and stakeholder management
• Ability to handle multiple priorities in a fast-paced environment
• Experience leading critical incidents and mentoring junior DBAs

Nice to Have

• Exadata Administration
• Database Migration Projects
• Kubernetes / Containers Exposure
• PostgreSQL or SQL Server Administration
• AI-assisted Database Operations and Automation

Executive Hiring Summary

Seeking a senior Oracle DBA with strong expertise in Oracle RAC, Data Guard, GoldenGate, RMAN, Performance Tuning, Security Compliance, Automation, and Cloud Database Platforms to support enterprise-scale mission-critical database environments and drive database modernization initiatives. Having experience in PostgreSQL and Snowflake will be added advantage.

Weekly Hours:

Time Type:

Location:

It is the policy of AT&T to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, AT&T will provide reasonable accommodations for qualified individuals with disabilities. AT&T is a fair chance employer and does not initiate a background check until an offer is made.