Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Troubleshooting SQL DMV Nexus DDL DML Analyst
(Jobs in DUBLIN, OH)
 
Requirement id 13855
Job title Analyst
Job location in Dublin, OH
Skills required Problem Solving Skills, Troubleshooting, SQL Server, DMV Nexus DDL DML
Open Date 21-May-2013
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
   Email Recruiter: coolsoft
Job Description Analyst: Problem Solving Skills, Troubleshooting, SQL Server, DMV Nexus DDL DML

Consultant Role/Responsibilities or Tasks on Project:
Planning and configuring databases for high availability and disaster recovery including clustering, replication and backup/restore processes.
Monitor and tune database and application procedures to provide/support a high availability service.
Work with the Development, Test, Conversion and Performance Test teams to identify database related areas that needs improvements
Provide assistance with incident diagnosis, defect resolution, deployments, backup and restore.
Analyze the database and data model and identify potential risks with respect to security and performance.

Job Description:
The Senior DBA is responsible for the creation, configuration, maintenance and monitoring of multiple large SQL Server databases on MI BAM project. The DBA must be able to understand the application that he/she is supporting. Must be able to troubleshoot issue using a consistent methodology and he/she must be able to solve problems independently.

The DBA candidate must have a big picture of the application and relate various parts within the implementation. Must be able to understand and solve complex problems considering various variables.


Skills Required (provide specific details around tools, client environment, certifications needed, etc):

The candidate must have a strong problem solving skill. Must be able to troubleshoot complex problems. Must be aware of Performance analysis tools such as,
- SQL Server Profiler
- Major Perfmon counters
- SQL Server DMVs
- SQL Nexus (Optional)

The candidate must be able to approach a performance problem , use tools to analyze the problem and be able to get to the root cause. Must be able to help with corrective action to fix the problem.
The candidate must be able to review performance artifacts and provide valuable advice. The candidate must be able to deal with complex situations, must be able to research and find root cause or fix when the issue is not straight forward. Must be able to have the ability to match multiple variables to visualize the problem.
The candidate must be aware of configuration management concepts like source control, versioning and standard configuration management processes.
The candidate must be able to setup folder structure as per design and maintain them. Advanced concepts like Labels, Branching and Merging will be an advantage.
The candidate must have be able to write SQL Code such as
- Stored procedures, functions, triggers, views etc.
- Must be well versed with Data Definition Language (DDL), Data Manipulation Language (DML) and Transaction Control Language (TCL)
- Must have be able to look at already written code and trouble shoot if necessary
- Must be able to come up with the most optimal Database Code solution for a given requirement

The Candidate must be able to review code and suggest best practices. Must be able to debug complex code and trouble shoot complex problems.
The Candidate must be hands on with
Standard Database Administration tasks such as
- Backups, Restores
- Database creation/Maintenance/security
- User creation/ Maintenance/ Security, Roles etc.
- Troubleshooting administration problems
- SQL Server agent jobs and its components
- Must be able to work with Replication/ Log shipping etc., at a high level

The Candidate must be able to trouble shoot and support complex situations with Database Admin tasks. Provide the best solution for a given project situation. Must have the ability to work with remote databases and make sure all the environments have standard configuration. The Candidate must be able to guide and train team members.

Bachelors degree in Computer Science or Computer Engineering
previous experience with government projects su
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 13855 while calling.
 
Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2),
 
 Problem Solving Skills job openings in other states
Jobs List

Business Analyst - Advanced-11184-1
Create date: 11-Apr-2024
start date :05-07-24

submission deadline : 4/19/2024

client info : Department of Social Services

Note:

Q) INTERVIEW PROCESS

A) PANEL INTERVIEW

Q) SCHEDULE INTERVIEW:

A) ONCE QUALIFIED RESUMES/CANDIDATES HAVE BEEN RECEIVED.


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

DHHS Analyst- Mid Level (733556)
Create date: 10-Apr-2024
Hybrid

start date :05/01/2024

End date :05/01/2025

submission deadline : 04/16/2024

client info : NCDHHS-PH

Description :

Responsibilities include, but are not limited to:

· Provide subject matter expertise on QPHEs pro.... (This job is for - Stakeholders Jobs in NC Raleigh Analyst - (in Raleigh, NC))

Epidemiologist 1 - 62499
Create date: 04-Apr-2024
Start date : 05/20/2024

End date : 05/19/2025

Submission deadline : 04/19/2024

Client info : TN DOH

Note :

* Position Location : Hybrid

Description :

The Epidemiologist 1 position will support quantitative and qualitative .... (This job is for - SAS Analytical Skills Jobs in TN Nashville Consultant - (in Nashville, TN))

Business Analyst IV -62357
Create date: 15-Mar-2024
start date : 04/08/2024

End date :09/09/2024

submission deadline : 03/25/2024

client info :OPDS

Note:

* Position Location: Hybrid

Description :

Individuals in this position have demonstrated experience in the standard concep.... (This job is for - Business Analyst Jobs in OR Salem Analyst - (in Salem, OR))

NC - FTCC - Service Support Analyst- Junior (730161)
Create date: 29-Feb-2024
Onsite

start date :03/04/2024

End date :09/30/2024

submission deadline :03/01/2024

client info : Fayetteville Technical Community College

Description :

***All FTCC staff are working 100% onsite. The candidate will be expected to work fi.... (This job is for - job Jobs in NC Fayetteville Analyst - (in Fayetteville, NC))
 
 Problem Solving Skills job openings in OH
Jobs List

Scrum Master/Technical Project Manager III - 20230111090259
Create date: 11-Jan-2023
start date:1/23/2023
End date:3+Months from start date

submission deadline:1/18/2023

Note:

* Job Site: On-Site

Description:

JOB DESCRIPTION:

Responsible for a teams collaboration, transparency and delivering product releases meeting all quality standards and milestones. Ide.... (This job is for - job Jobs in OH Columbus Manager - (in Columbus, OH))

Sr Service Desk Plus Specialist - 58728
Create date: 06-Oct-2021
Description:

Responsibilities

Our client in Columbus Ohio is seeking a Sr. Service Desk Plus Specialist.

CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR ABLE TO RELOCATE BY DAY ONE FOR CONSIDERATION.

A Sr. Service Desk Plus Specialist maintains and upgrades core infrastructure technologies and systems to ensu.... (This job is for - job Jobs in OH Columbus Specialist - (in Columbus, OH))

Service Desk Technician - 58693
Create date: 04-Oct-2021
Description:

Responsibilities

Our client in Columbus Ohio is seeking a candidate for a Service Desk Technician position.

CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR ABLE TO RELOCATE BY DAY ONE FOR CONSIDERATION.

Job Duties:

Receive telephone calls and e-mails from users having problems usin.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH))

Native Android Developer Level 3 - 72612
Create date: 04-Mar-2021
Candidate must be our W2 Employee.

Job Description:

• 5+ years developing Android Apps (using Android and 3rd party libraries/frameworks)

• 5+ years Java experience

• Prior Android Developer Lead experience a plus

• Prior experience with project planning with large size or highly complex projec.... (This job is for - job Jobs in OH Cincinnati Developer - (in Cincinnati, OH))

Salesforce Developer - 71706
Create date: 08-Feb-2021
Note: 100% remote

Candidate must be our W2 Employee.

Job Description

The Salesforce Developer position will work closely with functional leaders, organizational units, and subject matter experts in developing solutions.

Responsibilities

Ownership of all technical aspects of Salesforce.com, .... (This job is for - HTML Jobs in OH Findlay Developer - (in Findlay, OH))
(Analyst: Problem Solving Skills, Troubleshooting, SQL Server, DMV Nexus DDL DML in Dublin, OH)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us