Data Management Administration Specialist Levels 1-4

Description Job Title: Data Management Administration Specialist Levels 1-4 - Database Administration

• Assists in configuration, installation, testing, and maintenance of database technologies and resources to ensure that all application and systems availability targets are met.
• Troubleshoots database errors and other problems to resolve immediate customer needs.
• Assist with the development of system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
• Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements.
• Participate in the evaluation of new database products and technologies, under the direction and guidance of senior colleagues, to meet current and future software application requirements.
• Experience with Oracle Real Application Cluster (RAC), Backup & Recovery using Oracle's Recovery Manager (RMAN).
• Experience with Oracle Dataguard, Oracle Enterprise Manager (OEM).
• Experience of UNIX / Linux Shell Scripting.
• Comfortable in work with SQLPLUS command line, SQL Developer and TOAD.
• Experience of working with Oracle Release 11.2, 12.2 and Oracle 19c.
• Experience of performing database upgrades and apply patches.
• Knowledge of Oracle Multitenant database environment will be a plus.
• Must not have any problem working on a 24/7 On-Call Shifts.

• Provides ongoing support and troubleshooting for database issues including those escalated from more junior colleagues to resolve immediate customer needs.
• Monitors associated software such as version upgrades, patches, and tools and performance tune databases and related servers to ensure consistent database performance.
• Performs database backup on a regularly scheduled basis, and database recovery when required to provide users with minimal interruptions in service.
• Assists in project roll-outs by executing data migration activities to ensure solutions meet business needs.
• Investigates, evaluates, and tests new products and technologies to meet current and future software application requirements.
• Familiarity with Oracle Database SQL Performance Tuning diagnostic utilities, i.e. SQL Trace, TKPROF, Explain Plans, SQL Profiles, AWR Reports, and ADDM reports.
• Experience with Oracle Flashback feature.

• Design, install, configure, and maintain database technologies and resources to ensure that all application and systems availability targets are met.
• Implements change management/change control processes to improve database performance.
• Provides counseling and guidance to developers during application development to suggest best approach for the design of files and systems.
• Produces and maintains database documentation to ensure up to date information is available.
• Performs capacity analysis and planning for databases on file to ensure sufficient resources are available to hold needed data.
• Develop system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
• Research new technologies/products, prepares a preliminary evaluation of technologies/products and associated costs, and develops and presents recommendations to support anticipated future business needs.
• Guide junior database staff in the performance of their tasks to develop technical talent.
• Experience with Oracle Database Security utilities such as Data Masking, Transparent Data Encryption, TNS Network Encryption, and Data Redaction.

• Expert knowledge of Oracle's Database Administration functions i.e., Backup and Recovery, Performance Tuning and Database Security.
• Provides expertise in enterprise reporting and data management tools to maximize and share learning.
• Develops, documents, and maintains logical and physical data models for multi-phase development projects to support complex and critical organizational initiatives.
• Establishes and documents data policies and standards for the enterprise to ensure information is available and up to date.
• Formulates procedures to ensure that communications of data updates are distributed to all associates and that they are adhered to.
• Consults to the IT community to understand customer data needs and requirements.
• Provides guidance and technical coaching to less experienced staff to support effective workflow and develop technical talent
• Expert Knowledge of Oracle Real Application Cluster (RAC), Backup & Recovery using Oracle's Recovery Manager (RMAN)
• Expert knowledge of Oracle Database Security utilities such as Data Masking, Transparent Data Encryption, TNS Network Encryption, and Data Redaction.
• Experience of working with Oracle ASM and Exadata
• Experience of working with Oracle Multitenant database environment will be a plus.

• Requires basic knowledge and familiarity with installing, maintaining, and troubleshooting database technology.
• Proven ability to troubleshoot and support technical issues using standardized procedures.

• Requires proven knowledge and familiarity with installing, maintaining, and troubleshooting database technology, including ability to explain changes/ modifications/ improvements to applications.

• Requires strong knowledge and familiarity with installing, maintaining, and troubleshooting database technology, including ability to design and engineer solutions and standards.

• Requires seasoned expertise with data technologies, including ability to integrate solutions across technologies and systems.

• Bachelor's Degree in Computer Science or related fields or equivalent experience
• 1+ years of relevant experience.

• Bachelor's Degree in Computer Science or related fields or equivalent experience.
• 3+ years of relevant experience.

• Bachelor's Degree in Computer Science or related fields or equivalent experience.
• 5+ years of relevant experience.

• Bachelor's Degree in Computer Science or related fields or equivalent experience.
• 10+ years of relevant experience.