Date Posted:01/09/2024Hiring Organization:Rose InternationalPosition Number:456382Job Title:Senior Oracle DBAJob Location:Indianapolis, IN, USA, 46204Employment Type:TemporaryEstimated Duration (In months):6Min Hourly Rate($):29.44Max Hourly Rate($):58.92Must Have Skills/Attributes:Data Modeling, Linux, Oracle 11g, RMAN, VMWare

　　*Only those lawfully authorized to work in the designated country associated with the position will be considered.Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a clients business needs and requirements.*

　　Selected resource MUST come onsite the first week for onboarding. This is not reimbursable by the client. Please confirm the resource understands this requirement.

　　As the Database Analyst Senior, you will support Oracle databases to ensure data integrity, security, and stability.In this position, you will be responsible to provide adequate computer resources and up-to-date software environment to our various customers.This position will be responsible for monitoring and tuning database performance.It ensures that data is appropriately protected via database backup and related strategies.The position loads, or assists in loading of, database software, upgrade and patching.This position will assist with the evaluation and selection of infrastructure components and provide operational support for the database, ensuring data integrity, database availability, and performance.The Senior Database Analyst is needed to provide the degree of support that our agency customers currently expect and to meet their future needs.

　　The essential elements of the job duties:Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.Evaluate technology and products to determine the feasibility of adding to agency standards.Develop work plans for assigned projects and manage the execution.Design and implement logical and physical databases of a moderately to large complex nature.Determine aggregation, partitioning and indexing strategies for physical data.Monitor and tune database performance, including SQL scripts, hints, execution plans, and materialized views.Administer end-user access and security at the database level.Ensure that data is appropriately protected via database backup and related strategies.

　　The job profile is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

　　SkillsStrong experience working with Oracle versions 11gR1/2, 12c and 19c in a Windows and / or Linux environment Required 8 YearsExtensive work experience with Oracle Database version 19c Required 3 YearsGood observational and analytical skills to help identify and resolve issues with the systems and deployments before and after they occur Required 8 YearsOracle DBA Experience with strong understanding of database architecture and performance tuning Required 8 YearsExperience with Backup and Recovery using Oracle Recovery Manager (RMAN) Required 8 YearsExperience with Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Active Data Guard Required 8 YearsExperience with Oracle Enterprise Manager (OEM) and Golden Gate replication Required 5 YearsExperience with virtualization platforms such as VMware, Citrix, App-V and Terminal Services Required 3 YearsSelf-starter, have excellent communication skills and work seamlessly in a team environment as well as independently Required 5 YearsExpert experience administering various multi-Terabyte, 24x7 uptime Oracle databases as a Systems/Infrastructure Database Administrator Required 8 YearsExperience with Oracle Data Modeling and database design Required 2 YearsExperience with performing and deployment of database code objects to Test and Production databases and troubleshooting issues Required 8 YearsAbility to manage database security, users, groups, roles, and permissions Required 8 YearsExtensive knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load and Unload Required 8 YearsExtensive knowledge of relational database and data warehouse design techniques and dimensional modeling processes Required 6 YearsExtensive knowledge of capacity planning and disaster recovery Required 5 YearsBachelor''s degree from an accredited college/university with a major in computer sciences or management information systems or equivalent work exp. Required 5 YearsTeamwork is a key element of the position. Ability to collaborate with the DBA team, but also with the developers and system owners Required 5 YearsAbility to manage multiple hardware and software projects and priorities Required 8 YearsProven ability to work creatively and analytically in a problem-solving environment Required 4 Years

　　Benefits:For information and details on employment benefits offered with this position, please visithere{target="blank"}. Should you have any questions/concerns, please contact our HR Department via our securewebsite{target="blank"}.

　　California Pay Equity:For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' websitehere{target="_blank"}.

　　Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

　　If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise,please contact our HR Department{target="_blank"}.

　　Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).