Recruiting the Talent. Staffing the Culture. Call Us: 847-945-7600

Job Seekers.

  • Share this Job

Sr. SQL Database Administrator

Location : Kenosha, WI
Job Type : Temp/Contract to Direct
Hours : Full Time
Required Years of Experience : 5-7+
Required Education : College Degree Required
Travel : No
Relocation : No

Job Description :
ESSENTIAL FUNCTIONS:  

  • Designs and executes overall database architecture strategy, standards and practices.

  • Works closely with project teams to develop data models that support business processes.

  • Works with application development to ensure database changes adhere to best practices and are properly prioritized and scheduled.

  • Supports all areas of the enterprise - ensures that all databases run at optimal performance

  • Proactively identifies and troubleshoots databases performance issues

  • Ensures that industry wide security standards are properly implemented

  • Develops and optimizes complex t-sql and PL/SQL code at advanced level

  • Understands written business requirements and translates them into technical design

  • Designs and develops SQL code; ETL processes and SSRS reports based on provided requirements

  • Responds to business requests in a professional manner with high sense of urgency

  • Works well under high levels of stress

  • Participates in on-call rotation and occasional off-hours activities (DR tests; upgrades, etc.)

  • Performs other duties as required or assigned which are reasonably within the scope of the activities enumerated above.


Required Qualifications :
REQUIRED SKILLS/EXPERIENCE:

  • RDBMS: SQL Server 2012 - 2016 (advanced); Oracle 11g,12c (RAC) (basic), DB2 LUW 11.1(purescale) (basic)

  • OS: Windows 2012 - 2016; RHEL 6.5-7.5; AIX (at a level required to support RDBMS)

  • ETL: SSIS (development, troubleshooting and optimization)(advanced)

  • Reporting: SSRS  (development, troubleshooting and optimization)(advanced)

  • SQL Server replication (transactional, snapshot) (advanced)

  • T-SQL; PL/SQL  (development, troubleshooting and optimization)(advanced)

  • OLTP performance troubleshooting (all RDBMS' listed above)(advanced)

  • RDBMS installation and configuration (all RDBMS' listed above)(advanced)

  • WSFC - Windows Server Failover Clustering (advanced)

  • RDBMS upgrade/patching (all RDBMS' listed above)

  • ORACLE RAC (basic)

  • SQL Server Replication (to SQL Server and Oracle) (advanced)


ADDITIONAL SKILLS/EXPERIENCE (PLUSES):

  • DBMS: DB2 on iSeries (as400), MySQL, Cassandra, Elastic Search

  • Data Modeling (physical/logical) - ErWin (basic)

  • Attunity Replicate

  • Vision Double Take Share

  • Stibo STEP API

  • DataStage

  • Cognos



Powered by AkkenCloud
Back to Top
Enter your Infotext or Widgets here...