Oracle Application Database Administrator

Company: Brooksource
Location: Detroit
Posted on: November 22, 2021

Job Description:

This Financial Services IT Sustain team is looking for an outstanding Technical Lead. This individual is responsible for steady state application production support activities including: executing deployment, access management, audits, incident management, change management, etc. She/he works across all functional areas of the company to reproduce and resolve customer issues, achieving high levels of customer satisfaction. The right candidate will be an empowered self-starter, familiar with working in a fast-paced environment. The position will have the responsibility to work with customer support, development teams, and infrastructure teams to reproduce and resolve issues.Job ResponsibilitiesImprove and maintain database partition and index structuresAutomate performance enhancing jobs such as index rebuilding and data archivingGenerate AWR Reports and analyze for system or query slownessDevelop PL/SQL scripts for performance improvement and data fixesAnalyze problematic queries to re-write or create SQL Profiles as neededSetup and design database monitoring reports and alertsParticipate in technical discussions with the development and/or System DBA Teams for deployments and code reviewsImplement monthly database refresh using Oracle RMANReview Change Requests for database activity including patching and system upgradesVerify and maintain instantaneous database replication syncing through Oracle Active Data GuardFacilitate troubleshooting sessions with System DBA and Unix Operations TeamsLead the implementation of sustain Change RequestsMonitor daily RMAN backups, statistics, and space availabilityEvaluate and enhance best database disaster recovery drill strategiesProvide database and PL/SQL guidance and support to Application DevelopersEstablish and implement sustain activities to support database migrationTroubleshoot incident tickets and provide quick communications and solutions to usersRegular comparison of database environments and difference remediationOther Key responsibilities (enhanced services):Lead maintenance of sustain database master documents ie Runbook, Playbook and help maintain accurate application documentationCollect, prepare, and present data for internal and external audit reviewsProvide guidance in resolving performance related issuesProactively and regularly make recommendations for improvementsQualificationsEssential SkillsStrong PL/SQL skillsOracle 12c, 19c and Exadata system knowledgeUnix shell scriptingOracle Active Data Guard and database replicationAWR Report analysisOracle OEM monitoringCompetenciesOwnership of complex issues and following through to resolutionEffective time management and ability to prioritize multiple responsibilitiesConfident, Self-starter - demonstrates initiative and influenceProcesses work accurately and in a timely mannerUtilizes business and technology skills effectivelyPersonal IntegrityOpen communication / listeningTeam orientationAnalytical thinking/decision makingMinimum RequirementsExcellent verbal and written communication skills5+ years of experience working with Oracle DBMS and database tools:RAC and Exadata knowledgeOracle Enterprise ManagerExperience generating and analyzing AWR reportsUtilizing Oracle RMAN for backups and duplicationPerformance troubleshooting experiencePL/SQL and query buildingData partitioning (Range, Interval, List) and indexingManaging database schema objectsBachelor's DegreeABOUT EIGHT ELEVEN:At Eight Eleven, our business is people. Relationships are at the center of what we do. A successful partnership is only as strong as the relationship built. We're your trusted partner for IT hiring, recruiting and staffing needs.For over 16 years, Eight Eleven has established and maintained relationships that are designed to meet your IT staffing needs. Whether it's contract, contract-to-hire, or permanent placement work, we customize our search based upon your company's unique initiatives, culture and technologies. With our national team of recruiters placed at 21 major hubs around the nation, Eight Eleven finds the people best suited for your business. When you work with us, we work with you. That's the Eight Eleven promise.Eight Eleven Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.by Jobble

Keywords: Brooksource, Detroit , Oracle Application Database Administrator, IT / Software / Systems , Detroit, Michigan