Oracle Database Analyst - California, United States - Kyra Solutions

Description

Oracle Database Analyst (On-site from Day One) Join Our Team Do you want to make an impact on the world around you? The work we do at Kyra Solutions directly impacts government entities and the citizens they serve.

In Transportation, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility.

Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees.

If you are interested in furthering your career with Kyra and help us improve the way governments serve their citizens, please send your resume, and make sure to include salary expectation, availability, and contact information.

You do not want to miss this opportunity Join Our Team Do you want to make an impact on the world around you? The work we do at Kyra Solutions directly impacts government entities and the citizens they serve.

In Transportation, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility.

Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees.

If you are interested in furthering your career with Kyra and help us improve the way governments serve their citizens, please send your resume, and make sure to include salary expectation, availability, and contact information.

You do not want to miss this opportunity Required Skills and Experience 10 years of IT business/industry work experience.5 years of Oracle Database Management Systems administration.

Experience with Sun Solaris operating systems and Oracle WebLogic.5 years supporting multiple services and multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data.

Ability to communicate effectively (verbally and in writing) with client staff.
Preferred Skills and Experience Oracle Database Administration 2019 Certified Professional.
Experience leading the planning, design, development, implementation, and maintenance of Oracle Relational Database Management Systems.
Experience leading the installation, configuration, and maintenance of Sun Solaris operating systems and Oracle WebLogic.
Experience working in a Unix environment.
Extensive experience diagnosing, isolating, and resolving complex problems pertaining to the database infrastructure.
Extensive experience writing PL/SQL, SQL, and Oracle Stored Procedures, Functions, Packages, and Database Triggers.
Extensive experience in designing logical databases and data models.
Knowledge of data privacy and protection initiatives.
Strong communication and collaborative skills.
Excellent verbal and written communication skills.

Primary Responsibilities Database administration in a large Oracle (12c and 19c) Solaris-based production environment including assisting client staff, as directed by the Contract Manager or Functional Manager.

All stages of database implementation and deployment.
Analysis, review, coordination, and implementation of new database requests.
Monitoring, troubleshooting, and resolving database performance issues or related problem resolution.
Provide administration and support of Oracle WebLogic, Oracle Forms, and Oracle Reports.
Provide maintenance and support of server hardware with Sun Solaris operating systems.
Provide direct support for Oracle databases as assigned by the Contract Manager.
Ensure that the logical data model design adheres to the clients standards-based upon best practices and guidelines.

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 client policies and procedures.

Write 12c and 19c 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.

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.

Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance.
Work with development teams to tune SQL queries and improve performance.

Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the client.

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 client-approved tools and scripts.

Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts.
Attend and participate in all assigned meetings.
Attend client-required training.
Complete a Project Report and a Project Timesheet on a weekly basis.

Education Bachelors degree in one of the computer sciences fields or in management information systems or 5 years of work experience in information technology, systems analysis, management analysis, program planning, program research, or program evaluation.

Why Kyra? Founded in 1997, Kyra Solutions is a national leader of transportation technology and regulatory solutions in government. We specialize in the art and science of digital transformation in government.

Our commitment to providing the highest level of service and tailored solutions has supported our consistent double-digit growth for over a decade.

We are headquartered in the greater Tampa Bay area with other offices across Florida and an innovation center in Silicon Valley, CA.Because of our dedication to our employees, we have won one of the Best Companies to Work for in Florida 2 years in a row by Florida Trend magazine.

Kyra has won other numerous awards including the coveted INC magazine s one of America s Fastest Growing Companies several years in a row.

Kyra s commitment to our employees, to best practices in project management and business analysis, and to solution development has led to our achievement in becoming the first Project Management Institute certified company in Florida.

Our proven successful track record has resulted in several prestigious awards including the State of Florida's Diversity Business of the Year Award.

We are proud to be a sponsor for the TaxWatch Productivity Awards and partner to Florida TaxWatch. for more information.

Background & References Verifiable professional references will be required along with the resume; however, references will be checked/contacted after the interview and before the project starts.

Level two background check will be done on the selected candidate for employment, criminal (State & Federal), education, and others as mandated by the client.

Please make sure your resume and all other information provided are accurate. Any misrepresentation will mean permanent disqualification by the client. Equal employment opportunity employer.
Think you might be a good fit for this job? Apply online using the form below. We look forward to hearing from youFirst Name *Last Name *Email *Phone *Attach Resume *Tell us why you might be a good fit for this position *#J-18808-Ljbffr