Sign in

Sr. Oracle DBA

Company:
Rita Technology Services
Location:
St. Petersburg, Florida, United States
Salary:
W2 DOE
Posted:
December 10, 2018

Description:

Full-time (Direct Hire) position in St. Petersburg, FL. Must be a US Citizen or Green Card holder.

As a Senior Database administrator, you will be part of a dynamic team that administers and manages complex database systems. You will create, manage and monitor performance and tuning of databases. You will be responsible for data warehousing design, data architecture strategy design and capacity planning. In this role, you are the primary on the most complex or escalated issues and may provide direction and guidance team members.

Duties & Responsibilities:

Ensures availability, security and integrity of assigned databases.

Implements data models and database designs and enables applications with efficient back-end access and processing.

Resolves database performance, capacity, replication, and other distributed data issues.

Installs and configures database management software (DBMS) and applicable service packs and/or patches.

Develops and implements database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.

Establishes regular backups of databases and transaction logs.

Manages logins and user accounts, including assigning database object permissions and ancillary privileges.

Schedules and manages jobs for data transfers and sundry procedures and monitors performance and impact on operations.

Participates in data modeling and database logical and physical design.

Participates in application development processes and code reviews of database objects.

Analyzes long-term database performance trends to optimize database and application performance.

Configures database server to work with middleware, web servers and OnLine Analytical Processing (OLAP) and Data Warehouse tools.

Configures, supports, and optimizes replication.

Participates in supporting on-call rotation

Performs acceptance testing on computer systems, applications and hardware.

Performs other duties and responsibilities as assigned.

Experience and Skills:

Bachelor’s degree in Computer Science, IS or related degree and five (5) years of relevant experience including relational database programming experience or combination of education, training and experience.

Experience in Financial Services or other regulated industry preferred.

Experience in Oracle 12c, ASM, ZFS Appliance, database monitoring

Extensive experience in RMAN backup and recovery, Exadata patching procedure, exposure to ODA and PCA systems

Experience with Real Application Clusters (RAC), Replication solutions such as Data Guard and/or Golden Gate, Exadata and other engineered systems, Multitenant, and Oracle Enterprise Manager (OEM)

Experience with PL/SQL code development and tuning

Extensive experience in performance tuning and analysis using AWR, ASH

Scripting and automation using shell scripting, Perl, Python, etc.

Capacity planning for all aspects of a database system (storage, compute, memory, etc.)

Understanding of networking and connectivity and how it relates to a database environment.

Ability to occasionally work a non-standard shift including nights and/or weekends and/or have on-call responsibilities.