DBA/Database Analyst

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. Database Administrator Job Details - 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.) - Database auditing concepts - Strong interpersonal and communication skills 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 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)