DBA/Database Analyst

Procom Services; Milwaukee (WI); On-site; USD 82,656 - 110,208; Full time

Job summary

A leading IT staffing firm seeks an experienced Database Administrator for a 9-month contract in Milwaukee. The ideal candidate will have over 5 years of experience with Oracle and SQL Server, alongside expertise in performance tuning and strong troubleshooting skills. This role requires effective communication and coordination with various teams to ensure database performance and integrity in a dynamic manufacturing sector environment.

Qualifications

• 5+ years of DBA experience in Oracle and SQL Server.
• Proven success supporting large databases (multi-terabyte).
• Extensive experience with performance tuning and troubleshooting.

Responsibilities

• Troubleshoot database performance issues associated with OS.
• Manage and coordinate issue resolution with on/offshore resources.
• Execute physical database changes and participate in disaster recovery design.

Skills

Database Performance Tuning

Strong Communication Skills

Troubleshooting

Data Loading/ETL Tools

Change Management Processes

Tools

Oracle Enterprise Manager

SQL Server

Windows

UNIX

Shell Scripting

Job description

Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.

With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.

Procom’s areas of staffing expertise include:
• Application Development
• Project Management
• Quality Assurance
• Business/Systems Analysis
• Datawarehouse & Business Intelligence
• Infrastructure & Network Services
• Risk Management & Compliance
• Business Continuity & Disaster Recovery
• Security & Privacy

Specialties• Contract Staffing (Staff Augmentation)
• Permanent Placement (Staff Augmentation)
• ICAP (Contractor Payroll)
• Flextrack (Vendor Management System)

Job Description

Job #201272 | Data Base Administrator | DBA/Database Analyst

Database Administrator Duration: 9 months

Database Administrator Start Date: ASAP

$60+/ hr/ W2

W2 only – No Corp to Corp

On behalf of our client in the manufacturing sector, we are seeking a DBA for 9 months contracting opportunity in Milwaukee, WI.

- Good understanding of Windows & Unix Operating systems & ability to drill down & troubleshoot database performance issues associated with OS

- Knowledge of Oracle Enterprise Manager (OEM) a plus

- Familiarity with change management processes

- Verify/Review project plans and scope of production upgrades, application releases and implementations.

- Ability to manage and work with various on/offshore resources and coordinate issue resolution between them

- Familiarity with Microsoft Office tools

- Familiarity with shell scripting (PERL, Windows, Korn/Bourn shell)

- Ability to execute physical database changes required by applications

- Participate in project design phases as well as disaster recovery design

- Familiarity with both Oracle and SQL Server database security concepts

- Familiarity with both Windows and UNIX security concept

- Experience with TSQL, stored procedures, packages, triggers, PL/SQL and other database scripting languages a plus

- Experience with both Oracle and SQL Server replication, SQL Server mirroring/log shipping and high availability concepts

- Familiar with data loading/ETL tools (exp/imp, bcp, data pump, Data Stage, etc.)

- Strong interpersonal and communication skills

Qualifications

Database Administrator Mandatory Skills

- Proven success as a Senior DBA supporting large (multi-terabyte) databases

- 5+ years of DBA Experience in design, implementation & support primarily for Oracle (10g & 11g) and SQL Server (2005/2008/R2/2012) on Windows and UNIX platforms

- Install, configure and upgrade database software and related tools

- Extensive experience with backups, monitoring, performance tuning and troubleshooting tools & techniques. Ability to identify bad SQL statements & optimize them

- Basic Systems Administration skills on Windows and UNIX

- Ability to work with database vendor support to resolve complex issues