21 Oct
|
Atet
|
Hyderabad
Job Title: Sr Specialist Database Administration
Experience: 8-15+ Years
Location :Hyderabad / Bangalore
Job Summary
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 Qualified (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 workplace
- 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 : 40
Time Type : Regular
Location : IND:AP:Hyderabad / Argus Bldg 4f & 5f, Sattva, Knowledge City
- Adm: Argus Building, Sattva, Knowledge City
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.
📌 Sr Specialist Database Administration (Hyderabad)
🏢 Atet
📍 Hyderabad