Database Admin

IBA InfoTech Inc.

Raleigh, NC, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

4 years minimum

Working hours

Regular working hours

Job source

ibainfotech.com

Tech stack

Databases Perl (Programming Language) Microsoft SQL Server NetApp Applications Oracle (Applications) Windows PowerShell Shell Script Scripting Oracle Enterprise Manager

Job description

Assist in design, development, and implementation of database architecture and database solutions for new “Speed-to-Market” SOA-based Agile projects underway.
Support end-to-end execution from roadmap to implementation of the database. consolidations, migrations, conversions, and upgrades.
Support design and build of large, complex Oracle databases running on Oracle 11g/12c environments with features for data compression, partitioning, RAC, RMAN, Active DataGuard.
Support analysis of business and application requirements to translate into a new or modified database or data capabilities.
Educate and influence stakeholders to promote an understanding of the environments, increase simplification, risk management, and promote reuse and innovation.
Maintain and develop database design within the business and IT teams to ensure system availability, performance, and data quality.
Reduce complexity and cost in database environments through analysis and implementation of database consolidation and rationalization.
Collaborate and participate in application release planning and implementation.
Partner with business and architecture teams to properly engineer effective database solutions that ensure reliability, quality, and scalability.
Establish and maintain partnerships and relationships with infrastructure teams and application managers and teams.
Learning a managing NoSql and or Open Source database solution for various projects., * Support new and enhance existing database designs for improved longevity, reduced maintenance, and improved performance.
Assist in the creation and enhancement of cross-functional database systems
Participate in database design forums in areas of expertise.
Resolve complex incidents (e.g. security, performance tuning).
Assist with the evaluation and implementation of new product features to tailor solutions for database requirements.
Assist the enforcement of database processes, procedures, best practices, standards, and SLAs
Maintain awareness of industry best practices.
A willingness to keep up to date with developments in new technology.
Documentation skills for processes and procedures ie creating Knowledge Base articles, runbooks, topology, etc.
Learn, understand, champion ITIL frameworks
Proactively integrate process improvements into the way we do our work
Support the changing of work processes to align with all phases of the development and implementation processes

Requirements

Solid knowledge of Oracle 11g and 12c and technical database concepts, such as logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication, and backup/recovery techniques.
At least 8 plus years of experience with implementations, upgrades, conversions and consolidation projects with Oracle databases.
Requires strong ability to handle multiple priorities.
Requires at least 5 years of working knowledge of Oracle Real Application Clusters (Oracle RAC), Oracle Enterprise Manager (Oracle OEM/Cloud Control), Oracle Recovery Manager (RMAN), Oracle Data Guard and Oracle Database Security.
Bachelor’s degree in Computer Science or a related discipline and at least four or more years of solid, diverse work experience in IT, database management, system administration or an equivalent combination of education and work experience.
Solid understanding of the Mortgage Insurance industry and the challenges with building databases to meet the changing business environment preferred.
Knowledge in a scripting language like Unix/Linux Shell scripts, Powershell, Perl.
Knowledge of Oracle flashback technologies i.e. Flashback database, flashback table. Flashback query.
Knowledge of NetApp SnapManger Technologies (SnapManger for Oracle (SMO, SnapManager for SqlServer (SMSQL), SnapCenter).