MadisonRecruiter Since 2001
the smart solution for Madison jobs

Senior Oracle Database Administrator

Company: AE Business Solutions
Location: Madison
Posted on: January 15, 2022

Job Description:

This role is Contract-to-Hire with a hybrid/remote schedule requiring up to 3 days onsite per week. Currently we are still fully remote but that will likely change in the next few months. We are seeking Someone confident in their Oracle skill sets so that they can help us with best practices, etc. We use the Oracle stack on RedHat Linux, we use RAC, and we use Dell Data Domain for backups. We'd like someone that can help with monitoring and automation to drive towards stability and limiting off hours planned/unplanned work.

Under general direction, provide advanced analytical and technical support in designing, implementing, and supporting database systems.
Size and make-up of the team: 1 other primary Oracle DBA, 2 SQL, 1 app DBA.
Lots of cross training/support.
Will interact primarily with Infra, Apps, and reporting teams as well as some project team members.
Plans, reviews, and performs the implementation of database changes.
Designs, develops, documents, and implements database jobs including backup and recovery strategies and procedures. Reviews periodically for effectiveness. Identifies, recommends, and implements changes.
Provides in-depth database support by identifying complex database problems related to user data access issues, recommends solutions, and implements as needed.
Assists in developing and delivering database training.
Assists in designing, developing, and implementing database capacity reporting procedures and tasks. Documents, monitors, and identifies hardware capacity requirements and implements changes. Forecasts database capacity needs.
Monitors, investigates, and reports performance issues. Evaluates, recommends, and remediates performance issues identified in performance reports.
Assists in developing documents and procedures for maintaining information related to database systems including data retention, archival schedule, etc.
Assists in developing, defining, and documenting naming standards, usage standards, etc., and establishes rules for defined data security.
Recommends, reviews, and implements database design and definition changes, meeting application requirements while ensuring database access performs within acceptable levels.
Enhances application development processes and system performance by performing application code reviews.
Evaluates, installs, tests, and maintains database software including applying maintenance, hotfixes, and APARs.

Education and Experience
Associate degree or Five to eight years of relevant DBA experience.

Knowledge and Skills
Advanced knowledge of Oracle 12c/ 19c preferred .
Oracle container databases, RAC, Active Data Guard, Oracle Enterprise Manager experience.
Advanced knowledge of Oracle Fusion preferred.
Knowledge of Oracle Data Integrator preferred.
Able to recognize and analyze complex problems, develop remediation recommendations, and implement appropriate solutions.
Excellent organizational and planning skills.
Excellent written and oral communications skills.
Good human relations skills necessary for clear communication with supervisor and peers and cooperative relationship with interdepartmental personnel.
Advanced knowledge of systems design and analysis techniques, routine testing and debugging procedures, and documentation methods.
Advanced knowledge of database design, naming standards, and database data access methods.
Advanced knowledge of database structures and their implementation.
Data Warehousing, large database concepts and practices preferred.
Familiarity with Microsoft SQL , replication, Always-On Availability Groups, monitoring, performance tuning a plus but not required.
General coding knowledge, database projects, source control, SQL Server Integration Services knowledge a plus.
Goldengate experience/knowledge.
PowerShell experience/knowledge.
Experience working in a large environment highly preferred

Keywords: AE Business Solutions, Madison , Senior Oracle Database Administrator, IT / Software / Systems , Madison, Wisconsin

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Wisconsin jobs by following @recnetWI on Twitter!

Madison RSS job feeds