zettamine labs pvt. ltd.
Website:
zettamine.com
Job details:
Hello,
Greetings from ZettaMine!!
Hiring for Oracle DBA
Experience:8-10 years
Location : Chennai
Shift Timings: 10:30 AM to 8:30 PM
Looking for immediate joiners
JD: Application DBA / App DBA - DBA Oracle
General Expectation :
1) Must have Good Communication
2) Must be ready to work in 10:30 AM to 8:30 PM Shift
3) Flexible to work in Client Location DLF Downtown, Tharamani, Chennai
4) Must be ready to work from office in a Hybrid work environment.
Description:
We are looking for a skilled Application DBA / App DBA to manage and support application databases with a strong focus on schema management, database performance, SQL tuning, and data migration. The ideal candidate should have hands-on experience in database design, troubleshooting, optimization, and operational support, along with strong problem-solving, collaboration, and communication skills.
Key Responsibilities:
- Create, maintain, and manage database schemas, tables, indexes, constraints, and other database objects.
- Support database design and schema changes for application enhancements and releases.
- Perform performance troubleshooting across database and application layers.
- Review, analyze, and tune SQL/PLSQL queries to improve performance and efficiency. Monitor database performance using tools such as AWR, ADDM, and OEM.
- Execute and support data migration activities across environments. Perform data hydration, environment refreshes, and data movement using Data Pump..
- Investigate production issues, perform root cause analysis, and implement preventive fixes. Work closely with application, development, QA, and infrastructure teams to ensure stable database operations. Ensure database reliability, integrity, and availability in line with business and application requirements.
- Required Skills Strong experience as an Application DBA / App DBA. Hands-on expertise in: DB schema creation and maintenance Table creation and database object management Performance troubleshooting SQL review and tuning Data migration Data hydration Data Pump AWR, ADDM, OEM Strong analytical and problem-solving skills.
- Good collaboration, stakeholder management, and communication skills.
- Ability to work with cross-functional teams in a fast-paced environment.
- Good to Have Skills Experience with Replication / Oracle GoldenGate. Exposure to PostgreSQL, SQL Server, and CockroachDB. Knowledge of CDC (Change Data Capture).
- Experience working with AWS database environments and services.
- Preferred Candidate Profile Strong understanding of database performance tuning and optimization best practices.
- Ability to manage database changes in application-driven environments. Comfortable handling both operational support and project-based database activities.
- Proactive mindset with a focus on continuous improvement and reliability.
Interested candidates can share updated profile on md.afreen@zettamine.com or call on 6302404807
Thanks & Regards
Afreen saranya
Click on Apply to know more.