Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SQL Tuning Triggers Stored Procedures Sql Statements Administrator
(Jobs in CHI
 
Requirement id 18207
Job title Administrator
Job location in Chicago, IL
Skills required MS SQL, PL/SQL, Database Design, SQL Tuning Triggers Stored Procedures Sq
Open Date 10-Apr-2014
Close Date
Job type Contract
Duration 3 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Administrator: MS SQL, PL/SQL, Database Design, SQL Tuning Triggers Stored Procedures Sq

Sr Database Administrator:
- Perform an end to end review and assessment of the Production Oracle 11G R2 which resides on a Sun Solaris 10 Operating System environment and associated application SQL with recommendations on optimization, performance tuning, quality standards and best practices.


Skills Required:
- Expertise in advanced sql tuning and pl/sql tuning including but not limited
Interpreting execution plan
Optimize table access, table join and subquery, bind variable, hints.
- Experience with SQL, PL/SQL coding, Stored procedures, Triggers, Functions, Packages, Database Design.
- Performance Tuning expertise: Expertise in Performance tuning SGA(Memory) tuning, Disk I/O, SQL tuning, SQL Tracing, etc
- Partitioning: Partitioning on large tables, expertise in using composite partitioning, Interval and Reference partitioning with local indexes and global indexes.
- Collecting and reviewing database diagnostic information and performance information.
- Analyzing SQL statements and documenting recommendations for optimizing performance.
- Analyzing database tables, index definitions, growth and associated entities. Determining the impact on the overall performance of the database, associated environment and application.
- Ability to document assessment results and deliver recommendations.


Skills Additionally Preferred: Oracle Geospatial
* Deliverable: Perform an end to end review and assessment of the Production Oracle 11G R2 which resides on a Sun Solaris 10 Operating System environment and associated application SQL with recommendations on optimization, performance tuning, quality standards and best practices.

Document assessment results and deliver recommendations that will optimize application performance

Document Database assessment and Web Services results and deliver recommendations
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 18207 while calling.
 
Other jobs in IL: Chicago (77), Deerfield (7), Des Plaines (2), Downers Grove (7), Downtown Chicago (5), DT Chicago (2), Elk Grove (3), Elk Grove Village (24), Elkgrove Village (1), Evanston (1), Lake Forest (1), Lincolnshire (4), Northbrook (3), Oak Brook (5), Oakbrook (1), Oakbrook Terrace (5), Round Lake (3), Schaumburg (4), South Barrington (1), Springfield (2), Vernon Hills (6), Warrenville (7),
MS SQL job openings in Chicago, IL
Jobs List

Sr. SQL Server DBA - 62575
Create date: 23-Apr-2020
Candidate must be our W2 Employee.

Job Description :

***MUST HAVE LOTS OF MIGRATION EXPERIENCE - VERY SENIOR CANDIDATES ONLY***

Company Overview:

We are the worlds premier securities dealer. We transform financial markets around the world through modern predictive analytics and high-performance computing.... (This job is for - OLTP DBA Jobs in IL Chicago DBA - (in Chicago, IL))

Application Support Specialist
Create date: 24-Mar-2011
Local preferred. In person required. Must be able to go perm after 12 months if client wants to bring resource on.

Most important: Linux & J2ee

Managing build and outage issues

Rotating night shift, every six weeks

Rollouts and health checks at night.

Maintenance and support during the day. Oracle Jobs in IL Chicago Specialist - (in Chicago, IL))
 
 MS SQL job openings in other states
Jobs List

SharePoint Administrator - SME - 130055
Create date: 06-May-2024
No of Submissions : 1

Start date : 5/20/2024

End date : 9/30/2024

Submission deadline : 5/8/2024 3:00:00 PM

Client info : MDEK12

Note :

* Onsite

Description :

The SharePoint Administrator will be responsible for .... (This job is for - job Jobs in MS Jackson Administrator - (in Jackson, MS))

WEB/INTERNET ENGINEER-CONSULTANT - 11198-1
Create date: 24-Apr-2024
Candidate Submission Limit Per Supplier : 2

Start date :5/17/2024

Submission deadline : 5/1/2024

Client info : Health & Environmental Control Department (DHEC)

Note :

* INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

- An interview panel will.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC))

Security Architect - 11168-1
Create date: 25-Mar-2024
Start date : 5/2/2024

Submission deadline : 4/1/2024

Client Info : Department of Motor Vehicles

Note :

Q) Interview Process (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) • Eric Crane, Security Team Manager
• In-person preferred but will be willing to accommoda.... (This job is for - job Jobs in SC Blythewood Architect - (in Blythewood, SC))

SYSTEMS ANALYST-11159-1
Create date: 12-Mar-2024
start date :APRIL 9, 2024

submission deadline :3/19/2024

client info :Department of Health and Human Services

Note:

Q) INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)?

A) HIRING MANAGER WILL CONDUCT MICROSOFT TEAMS INTERVIEWS

Q) SCHEDULE INTE.... (This job is for - job Jobs in SC COLUMBIA Analyst - (in Columbia, SC))

DATABASE DEVELOPER (SQL) - ADVANCED - 11149-1
Create date: 05-Mar-2024
Start date : 3/4/24

Submission deadline : 3/12/2024

Client info : Department of Transportation

Description :

RE-DEVELOPMENT AND INTEGRATION OF MULTIPLE DATABASE SYSTEMS SERVING INTERFACING BETWEEN THE AGENCY PERSONNEL INFORMATION SYSTEM, CLOUD HOSTED ENTERPR.... (This job is for - job Jobs in SC COLUMBIA Developer - (in Columbia, SC))
 
 MS SQL job openings in IL
Jobs List

Senior SQL DBA
Create date: 03-Aug-2017
Client Info : Insurance Auto Auctions


Interview: Phone and Onsite Interview (mandatory) LOCAL ONLY


Description :

The SQL DBA must be able to develop SQL queries/codes from scratch. Strong with T-SQL and Powershell

Perform SQL database administration tasks:

Moni.... (This job is for - Administration Jobs in IL Westchester Designer - (in Westchester, IL))

BI Developer Analyst
Create date: 21-Jun-2016
start date:07/01/2016
submission deadline:06/27/2016
description:

a. Northbrook, IL

b. 9 month contract

c. Client: Confidential

d. $55/hr c2c

e. QlikView, SiSense, SAP Business Objects, SAP Crystal Reports, Cognos, Tableau, MicroStrategy, SSAS Cubes
T SQL Jobs in IL Northbrook Analyst - (in Northbrook, IL))
(Administrator: MS SQL, PL/SQL, Database Design, SQL Tuning Triggers Stored Procedures Sq in Chicago, IL)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us