Job Description
With us you will be responsible for
• Proactively monitor server and database process health to ensure availability and performance.
• Security management and user provisioning.
• Support Oracle DB Admin Tasks.
• Create and maintain database standards.
• Support product development and test teams through the SDLC process.
• Provide support for reviewing and approving schema changes.
• Produce technical documentation.
We expect you to have
• 10 to 15 years of hands-on experience in managing Oracle database.
• Experience to Install, configure environments running on UNIX, Linux, and Windows.
• Strong experience in Database Administration.
• Experience in troubleshooting and resolving database integrity issues, performance issues, deadlocking issues, log issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to identify and troubleshoot Oracle Server related CPU, memory, I/O, disk space and other resource contention.
• Experience in planning and executing Oracle version upgrades.
• Deep understanding of SQL statement tuning.
• Strong knowledge of backups, restores, recovery models, database shrink operations for Oracle environments.
• SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
• SQL Development- experience in creating database architecture with associated schema as part of a software design process.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching.
• Routine assessment of database performance
• Finding and debugging malfunctioning programs affecting the database integrity and performance
• Highly experienced with database partitioning, database clustering, database archiving and database high availability
• Handling and optimizing queries, stored procedures, materialized views
• effective management and utilization of table spaces, schemas and database objects
• Develop performance metrics or standards as per system applications (e.g. banking applications)
• Altering storage structures as per evolving needs of the system applications (e.g. banking applications)
• Added advantage - having experience in enterprise banking applications
• Added advantage - having experience in Amazon RDS for oracle
.
As a person you are
Must be well-organized, responsible, work effectively in a project management framework, and with the ability to create a project plan and manage to execute on it.
• Knowledge and experience with DB2 is a plus.
• Strong Unix, Linux and Windows skills
• Good communication skills.
💡 Quick Summary
Seeking a career-building opportunity? The Lead Database Administrator position is now open for candidates interested in the Database Administrator sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
