Role: Sr Oracle DBA
Location: Salisbury NC(Hybrid Onsite 3 days/ week))
Contract Length: 12 months
Key Duties andResponsibilities:
Leads the designdevelopment delivery and optimization of databases databaseinstances database clusters database software and relatedcomponents.
Conducts Oracle application systemreviews to optimize application performance andefficiency.
Coaches and mentors teams on theefficient use of Oracle and database services.
Serves as the senior subject matter expert and technical lead forOracle database technologies.
Leads the reviewof IT solutions to assure compliance with database standards andindustry best practices.
Leads the analysis ofcomplex problems business requirements and technical requirementsto develop effective database solutions.
Provides database consulting and design services to applicationdevelopers and other consumers of database services.
Maintains and develops relationships with businesspartners solution delivery data management operations externalservice provider engineering and other IT teams.
Proactively identify database issues andresolutions.
Assume ownership of databaserelated problems; work closely with internal technical teams topursue problem resolution and root cause analysis.
Configure and deliver endtoend support for databaseservers and data services running on VMware platform.
Required Technical Skillsand Experience:
10 years of DataEngineer/ DBA experience.
Experience supporting24/7 databases. Retail industry background is a plus.
Extensive experience in RMAN HADR Data Guard andDataDomain.
Experience as an Oracle databaseanalyst engineer or architect.
Experience withdevelopment and design in the database space.
Experience designing building deploying maintaining and optimizingOracle database instances objects software and relatedcomponents.
Extensive knowledge in creating andmaintaining well performing physical database structures.
Work with Application DBA Developers andOperations/Systems DBA to optimize database structures andperformance.
Provide SQL and technical analysison nonprod and prod database environments and recommendimprovements.
Coordinate and support databaseapplication OS and hardware upgrades.
Familiarwith database installation and configuration/parametertuning.
Familiar with daytoday databaseadministration database utilities and performance monitoringtools.
Assist with database upgradesconfiguration and patches.
Assist withmonitoring and finetuning databases. Experience with Datadog aplus.
Familiar with database security andaccess.
Experience designing building deployingmaintaining and optimizing Oracle database instances clustersobjects software and related components.
Provenexperience delivering database solutions within a projectmanagement framework.
Advanced knowledge ofdatabase stored procedures database triggers database commands anddatabase utilities.
Proven experience designingdeveloping delivering and optimizing database backup recovery highavailability and DR solutions.
Hands onexperience in Design configuration and supporting HA onOracle.
Understand the ins and outs of databasephysical and logical replications clustering mirroring and highavailability.
Advanced knowledge of SQL DML andDDL.
Extensive experience mentoring andproviding database consulting services.
Learnand stay current on the features and functionality of Oracledatabases focusing on technology.
Experiencewith Microsoft Windows Office and other productivitytools.
RequiredSoft Skills and Experience:
Provenskills working with Managed Service Providers and leadershipskills.
Excellent written and verbalcommunication skills.
Strong analytical andproblemsolving skills.
Strong organizationalskills.
Proven decision making and criticalthinking.
Proven project managementskills
DesiredSkills and Experience:
Bachelorsdegree in computer science Information Systems or equivalent workexperience.
Experience with databasetools.
Experience with Tivoli Storage Manager(TSM) DB2 Connect MicroStrategy or Cognos.
Experience with programing languages or Unix shellscripts.
Experience supporting vendor deliveredsoftware products.
Experience working withoffshore teams outsourcers or managed service providers.
Experience with Postgres MYSQL AZURE ITIL and relatedcertifications.
Datadog & general systemsmonitoring tools for databases and data services.