Job Description
Summary
Description Summary of This Role
Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system.
What Part Will You Play?
• Performs testing of database software, utilities and patches, such as Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM), Data Guard, within a test environment prior to production roll out. Identifies and resolves issues while in the test environment. Performs the migration of tested/approved software, utilities, and patches to the production environment. Develops basic to moderately complex database configurations, such as multi-node RAC / Logical Standbys, by creating database objects per specified business requirements and the necessary test environments. Work in close liaison with application developers to ensure best practices are applied to mitigate potential impacts to the various user groups and/or other database configurations. Coach/mentor less experienced Database Administrators (DBAs) as they begin to perform routine/basic database administration tasks.
• Completes authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions. Performs and/or sets up scheduled database audit procedures to track the who/when changes are made or new items are created. Takes appropriate corrective actions based on audit results.
• Schedules database back-up tasks and ensure proper completion of scheduled tasks. Executes database recovery task during a disaster recovery and/or disaster recovery exercises. Demonstrates a working knowledge of Oracle Recovery Manager, Data Guard and Golden Gate.
• Monitors current usage levels of database storage to identify and report growth trends and assist in the forecasting of future storage requirements. Assists with the development of long-term capacity plans. Performs routine maintenance such as data compression, defragmentation, dropping temp tables, clearing transaction logs, archiving inactive databases, load balancing and evaluate server hardware to provide recommendations for performance improvements.
• Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides recommendations for corrective actions. Performs database statistic reporting on a regularly scheduled basis. Ensures the high availability of the supported database(s). Demonstrates a proficiency with Automatic workload Repository (AWR) reports, Auto service Request (ASR) and OEM.
• Works closely with the Applications Team while performing troubleshooting to determine the source of application failures. Assists in the development of solutions to minimize the potential of future application failures. Supports the implementation of solutions. Actively leads troubleshooting tasks when engaged by business units.
• Produces and maintains operational database documentation, such as Oracle Standard Operating Procedures documents, Disaster Recovery Plans, Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.
• Assists in the training and familiarization of less experienced DBAs regarding company policies and procedures, techniques and current server/database configurations.
What Are We Looking For in This Role?
Minimum Qualifications
• Bachelor's Degree
• Relevant Experience or Degree in: No degree specified
• Typically Minimum 4 Years Relevant Exp
• With the Installation, Customization, Testing and Maintenance of database systems within a production environment.
Preferred Qualifications
• Bachelor's Degree
• IT related field
What Are Our Desired Skills and Capabilities?
• Skills / Knowledge - A seasoned, experienced professional with a full understanding of area of specialization; resolves a wide range of issues in creative ways. This job is the fully qualified, career-oriented, journey-level position.
• Job Complexity - Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors. Demonstrates good judgment in selecting methods and techniques for obtaining solutions. Networks with senior internal and external personnel in own area of expertise.
• Supervision - Normally receives little instruction on day-to-day work, general instructions on new assignments.
• DBMS Knowledge - Extensive Knowledge of multiple database disciplines and technologies
• DBMS Utilities - Extensive Knowledge of multiple utilities utilized to manage, monitor and maintain database systems
• DBMS Recovery - Extensive Knowledge of recovery technologies for local and geographically disperse systems
Description Summary of This Role
Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system.
What Part Will You Play?
• Performs testing of database software, utilities and patches, such as Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM), Data Guard, within a test environment prior to production roll out. Identifies and resolves issues while in the test environment. Performs the migration of tested/approved software, utilities, and patches to the production environment. Develops basic to moderately complex database configurations, such as multi-node RAC / Logical Standbys, by creating database objects per specified business requirements and the necessary test environments. Work in close liaison with application developers to ensure best practices are applied to mitigate potential impacts to the various user groups and/or other database configurations. Coach/mentor less experienced Database Administrators (DBAs) as they begin to perform routine/basic database administration tasks.
• Completes authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions. Performs and/or sets up scheduled database audit procedures to track the who/when changes are made or new items are created. Takes appropriate corrective actions based on audit results.
• Schedules database back-up tasks and ensure proper completion of scheduled tasks. Executes database recovery task during a disaster recovery and/or disaster recovery exercises. Demonstrates a working knowledge of Oracle Recovery Manager, Data Guard and Golden Gate.
• Monitors current usage levels of database storage to identify and report growth trends and assist in the forecasting of future storage requirements. Assists with the development of long-term capacity plans. Performs routine maintenance such as data compression, defragmentation, dropping temp tables, clearing transaction logs, archiving inactive databases, load balancing and evaluate server hardware to provide recommendations for performance improvements.
• Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides recommendations for corrective actions. Performs database statistic reporting on a regularly scheduled basis. Ensures the high availability of the supported database(s). Demonstrates a proficiency with Automatic workload Repository (AWR) reports, Auto service Request (ASR) and OEM.
• Works closely with the Applications Team while performing troubleshooting to determine the source of application failures. Assists in the development of solutions to minimize the potential of future application failures. Supports the implementation of solutions. Actively leads troubleshooting tasks when engaged by business units.
• Produces and maintains operational database documentation, such as Oracle Standard Operating Procedures documents, Disaster Recovery Plans, Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.
• Assists in the training and familiarization of less experienced DBAs regarding company policies and procedures, techniques and current server/database configurations.
What Are We Looking For in This Role?
Minimum Qualifications
• Bachelor's Degree
• Relevant Experience or Degree in: No degree specified
• Typically Minimum 4 Years Relevant Exp
• With the Installation, Customization, Testing and Maintenance of database systems within a production environment.
Preferred Qualifications
• Bachelor's Degree
• IT related field
What Are Our Desired Skills and Capabilities?
• Skills / Knowledge - A seasoned, experienced professional with a full understanding of area of specialization; resolves a wide range of issues in creative ways. This job is the fully qualified, career-oriented, journey-level position.
• Job Complexity - Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors. Demonstrates good judgment in selecting methods and techniques for obtaining solutions. Networks with senior internal and external personnel in own area of expertise.
• Supervision - Normally receives little instruction on day-to-day work, general instructions on new assignments.
• DBMS Knowledge - Extensive Knowledge of multiple database disciplines and technologies
• DBMS Utilities - Extensive Knowledge of multiple utilities utilized to manage, monitor and maintain database systems
• DBMS Recovery - Extensive Knowledge of recovery technologies for local and geographically disperse systems
💡 Quick Summary
Seeking a career-building opportunity? The Senior Oracle 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.
