Sr Oracle DBA

Role: Sr Oracle DBA

Location: Salisbury, NC ( Hybrid)

Key Duties and Responsibilities
• Leads the design, development, delivery, and optimization of databases, database instances, database clusters, database software, and related components.
• Conducts Oracle application system reviews to optimize application performance and efficiency.
• Coaches and mentors’ teams on the efficient use of Oracle and database services.
• Serves as the senior subject matter expert and technical lead for Oracle database technologies.
• Leads the review of IT solutions to assure compliance with database standards and industry best practices.
• Leads the analysis of complex problems, business requirements, and technical requirements to develop effective database solutions.
• Provides database consulting and design services to application developers and other consumers of database services.
• Maintains and develops relationships with business partners, solution delivery, data management, operations, external service provider, engineering, and other IT teams.
• Proactively identify database issues and resolutions.
• Assume ownership of database related problems; work closely with internal technical teams to pursue problem resolution and root cause analysis.
• Configure and deliver end-to-end support for database servers and data services running on VMware platform.

Required Technical Skills and Experience
• 10+ years of Data Engineer/ DBA experience.
• Experience supporting 24/7 databases. Retail industry background is a plus.
• Extensive experience in RMAN, HADR, Data Guard, and Data-Domain.
• Experience as an Oracle database analyst, engineer, or architect.
• Experience with development and design in the database space.
• Experience designing, building, deploying, maintaining, and optimizing Oracle database instances, objects, software, and related components.
• Extensive knowledge in creating and maintaining well performing physical database structures.
• Work with Application DBA, Developers and Operations/Systems DBA to optimize database structures and performance.
• Provide SQL and technical analysis on non-prod and prod database environments and recommend improvements.
• Coordinate and support database, application, OS and hardware upgrades.
• Familiar with database installation and configuration/parameter tuning.
• Familiar with day-to-day database administration, database utilities and performance monitoring tools.
• Assist with database upgrades, configuration, and patches.
• Assist with monitoring and fine-tuning databases. Experience with Datadog a plus.
• Familiar with database security and access.
• Experience designing, building, deploying, maintaining, and optimizing Oracle database instances, clusters, objects, software, and related components.
• Proven experience delivering database solutions within a project management framework.
• Advanced knowledge of database stored procedures, database triggers, database commands, and database utilities.
• Proven experience designing, developing, delivering, and optimizing database backup, recovery, high availability, and DR solutions.
• Hands on experience in Design, configuration, and supporting HA on Oracle.
• Understand the ins and outs of database physical and logical replications, clustering, mirroring, and high availability.
• Advanced knowledge of SQL, DML and DDL.
• Extensive experience mentoring and providing database consulting services.
• Learn and stay current on the features and functionality of Oracle databases, focusing on technology.
• Experience with Microsoft Windows, Office, and other productivity tools.

Required Soft Skills and Experience
• Proven skills working with Managed Service Providers and leadership skills.
• Excellent written and verbal communication skills.
• Strong analytical and problem-solving skills.
• Strong organizational skills.
• Proven decision making and critical thinking.
• Proven project management skills

Desired Skills and Experience
• Bachelor’s degree in computer science, Information Systems, or equivalent work experience.
• Experience with database tools.
• Experience with Tivoli Storage Manager (TSM), DB2 Connect, MicroStrategy, or Cognos.
• Experience with programing languages, or Unix shell scripts.
• Experience supporting vendor delivered software products.
• Experience working with offshore teams, outsourcers, or managed service providers.
• Experience with Postgres, MYSQL, AZURE, ITIL and related certifications.
• Datadog & general systems monitoring tools for databases and data services.