À propos
Are you the right candidate for this opportunity Make sure to read the full description below.
• Experience with Oracle Enterprise Manager (OEM) • Knowledge of data privacy and protection initiatives • Strong communication and collaborative skills • Excellent verbal and written communication skills • Knowledge of data masking using Test Data Management Tool to o Develop and maintain enterprise-wide data masking standards for Oracle databases o Define masking rules, algorithms, and transformation logic aligned with business and compliance requirements o Ensure masked data remains referentially intact across schemas and applications o Configure and execute masking workflows using the organization's Test Data Management tool o Build reusable masking templates, rule sets, and automation pipelines Preferred KSA's: • Excellent working skills with Oracle Exadata and • 5+ years' experience with SQL performance tuning and database architecture. • Experience in converting traditional databases to Container Model - Oracle Multitenant architecture • Experience working with Test Data Management tool Tasks and Activities The resource (Intermediate, Database Analyst) will function as an integrated member of the Enterprise Data Management Team and will provide database support while working on assigned project and tasks and provide database support in the Motorist Modernization Project. The resource will be responsible for operational duties and assisting with the administration of the Department's Enterprise Oracle Databases and shall perform, at a minimum, the tasks and/or activities described below: a. Work with the Department's Contract Manager to serve as the primary point of contact to ensure that start-up activities are completed within fourteen (14) days prior to the performance of services. Start-up activities include Department's fingerprint background check and online information security training security requirements. b. Database administration in a large Oracle UNIX-based production environment including assisting Department staff, as directed by the Contract Manager, with the following: 1) All stages of database implementation and deployment. 2) Analysis, review, coordination, and implementation of new database requests. 3) Monitoring, troubleshooting, and resolving database performance issues or related problem resolution. c. Provide direct support for Oracle databases as assigned by the Contract Manager; d. Setting up database user accounts. e. Verifying backup and recovery plans to protect the database against data loss and reconstruct the data if loss occurs. f. Participating in design and planning of database and related database objects g. Ensure that the logical data model design adheres to the Department's standards based upon best practices and guidelines; h. Coordinate and deploy application changes, including Procedural Language/ Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Department policies and procedures; i. Write Structured Query Language (SQL), PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers, as required, to augment security and performance requirements of application development; j. Write and use custom scripts and processes to handle data loads, data cleansing, and data migration to include migrations to and from multiple data sources and types such as Access, SQL server, Excel, flat files, and different Oracle database versions including Oracle version 19c; k. Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance; l. Work with development teams to tune SQL queries; m. Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department; n. Design, implement, and maintain database maintenance scripts, including replication and monitoring; Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department approved tools and scripts; p. Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts; q. Attend and participate in all assigned meetings; r. Attend and complete Department-required training; and s. xywuqvp On a weekly basis, complete a Status Report that includes specific tasks handled by both the Project Manager and Project Team(s), and complete a Project Timesheet.
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.