Campus Pride Jobs

Job Description

Work with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity.

Career Level - IC2

Responsibilities

Roles & Responsibilities:

• Responsible for all operational aspects of Oracle 19c/18c database systems including performance, integrity, and security.

• Monitor performance of the database and the database servers; Determine optimal performance parameters for the database server, operating system, etc., and tune as needed.

• Carry out periodic maintenance of the database platform in terms of rebuilding indexes, statistics, software updates, security updates, and service packs.

• Ensure that redundant database systems are properly maintained and available for activation as and when required.

• Carry out database design tasks in conjunction with the software development team and implement enhancements and modifications to the database.

• Respond to incidents, troubleshoot issues, and provide advice on improving database performance.

• Monitor database logs and take corrective action on issues if required.

• Participate in 24x7 on-call support on a weekly rotating schedule, including weekends

• Develop and maintain Standard Operating Procedures/Documentation

• Provide escalation support for database-related issues

• Share knowledge and mentor junior team members as needed

• Develop administration automation and monitoring scripts as needed

Skills & Experience

• Bachelor's degree in Computer Science or equivalent (B.E/B.Tech Only)

• 3 to 7 years of extensive database management experience with a strong sense of ownership, urgency, and drive

• Thorough knowledge of relational database theory, information modeling, SQL, and data organization.

• Proven experience in the administration of Oracle databases.

• Experience managing large-scale databases.

• Experience with database backup and recovery

• Experience administering DBMS systems running on Unix/Linux.

• Experience with database patching and upgrades

• Experience with developing and using automated database setup and maintenance scripts.

• Experience with analyzing query execution plans and tuning the database accordingly.

Experience in analyzing AWRs and troubleshooting query slowness using SQL Patch / SQL Profile and SQL Baseline.

• Strong troubleshooting skills to investigate errors and performance bottlenecks

• Willing to work in a 24x7 production mission-critical environment, including weekends

• Excellent written, and verbal communication, and documentation skills

Desirable

• Experience in automating the management and configuration of multiple databases

• Commercial Certification in Database Administration (Oracle)

• Experience in any Unix shell script, Perl script, and Python

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.

When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.

We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +1 888 404 2494, option one.

Disclaimer:

Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

* Which includes being a United States Affirmative Action Employer