Sr. Database Administrator

Immediate need for a talented Sr. Database Administrator. This is a 12+ Months Contract opportunity with long-term potential and is located in Minneapolis, MN. Please review the job description below and contact me ASAP if you are interested.

Job ID: 26-11897

Pay Range: $46-$56/hour.  Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
 
Key Responsibilities:

• Provides database support for business applications and schedules back up jobs for user databases.
• Provides access control (password resets /account creation/deletion) and checks IP compliance (violation report review, compliance updates and compliance set Client).
• Performs data purging and data replication activities.
• Researches on connectivity issues and recurring errors in Application database.
• Responds to database alerts and takes appropriate actions.
• Provides escalation Level 1 and 2 Technical 24x7 support.
• Performs database creations.
• Performs performance tuning and troubleshooting for database.
• Performs application database maintenance and provides technical assistance to users.
• Manages database account access and database object changes.
• Ensures that monitoring and alerts are properly in place to meet monitoring requirements.
• Performs application database and OS scripting.
• Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set Client).
• Performs data purging and data replication activities
• Performs database recovery from logs, hot & cold backups, Export/Imports and Disaster Recovery.
• Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations. Also involved in database, schema, and object refresh activities.
• Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, and Cach, logs performance, and recommends effective resource utilization/emergency recovery procedures
• Provides Escalation Level 2 Technical 24x7 support.
• Performs Business Continuity/Disaster Recovery activities during Business Continuity Plan events.
• Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes.
• Implements database security and auditing features and periodic reviews. Conducts root cause analysis for repeated incidents.
• Performs heterogeneous database interface deployment and support for various data interfaces with applications, Middleware interface and functionality deployment with database architecture.
• Plans and develops processes for database updates and migrations to a higher/lower version or cross platform migrations. Also, involved in database, schema and object refresh activities.
• Develops capacity planning processes that include monitoring of existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective utilization of resources and emergency recovery procedures.
• Conducts team training and responsible for resource management.
• Provides escalation Level 2 and 3 Technical 24x7 support.
• Provides Business Continuity Planning/Disaster Recovery support.
• Researches new technologies to address operations reliability and compliance.
• implement's and performs configuration management of database cluster and replications.

Key Requirements and Technology Experience:

• Minimum 8 years of experience creating and managing Oracle databases and technologies
• Experience with versions 12.2 and newer, both standalone and multi-instance Real Application Clusters
• Demonstrated strong expertise in diagnosing and resolving database performance or reliability issues
• Strong background and hands-on experience administering Oracle Enterprise Manager ecosystem including agents, repositories and management servers in a highly-available, load-balanced configuration
• Familiarity with RedHat Linux OS versions 6 and newer
• Proven track record of implementing and administering Oracle DataGuard for replication
• Able to work independently and balance multiple concurrent projects with mid to long-term deliverables
• Hands on development and maintenance of UNIX Korn or Bash shell scripting
• Ability to provide technical direction to others, including application developers
• Comfortable in high-pressure situations, able to communicate well with both technical peers and leadership
•  4-year degree (BA or BS) or equivalent work experience in a related field of study
• Work with Client Oracle Engineers and our service providers to deliver a highly available, resilient and performant database environment;
• Build new, or upgrade / patch existing databases and associated software in accordance with vendor best practices;
• Deliver required database functionality that meets project requirements on or before defined due date;
• Ensure the detailed physical design of data structures and database complies with enterprise build and configuration standards and processes;
• Install, configure, and maintain Oracle database and Enterprise Manager software on database and application servers as required;
• Provide consultation to application development teams on Oracle database technical issues and techniques;
• Conduct database performance testing and tuning, user configuration, security and support processes including gather stats, database backup/recovery, partition administration, etc;
• Ensure Client Oracle database environment is secure, provide recommendations for improving database security and implementing approved security remediations;
• Coordinate downtime with application teams and system engineers to implement approved changes;
• Interface with vendors and managed service partners to resolve operational issues or questions;
• Follow established IT / DBA policies and procedure

Our client is a leading Airlines organization and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
 
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

"If you are a person with disability needing assistance with the application or at any point in the hiring process, please contact us at

" #DOLJ2W:CB3