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

Security Analyst II - 137418
Create date: 19-Nov-2024
No of Submissions : 1

Start date : 12/02/2024

End Date : 06/30/2025

Submission deadline : 11/21/2024 4:00:00 PM

Client Info : DOC

Note:

* Interview Process: Teams Call with Video

* Duration: 6/30/25 with 2 years with renewals

* Remote/Onsite? Candidate MUST b.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))

Travel RN - 63634
Create date: 13-Nov-2024
No of Submissions : 3

Start date : 12/04/2024

End Date : 03/08/2025

Submission deadline : 11/18/2024

Client Info : TN TDOC

Note:

* Position Location : On Site

* Lowest Current Proposal : USD 85.00

* Bill Rate : USD 90.00 Per Hour

Description : <.... (This job is for - job Jobs in TN Nashville Consultant - (in Nashville, TN))

NC Fast Child Welfare Readiness Liaison (750940)
Create date: 08-Nov-2024
No of Submissions : 1

Start date : 12/02/2024

End Date : 12/01/2025

Submission deadline : 11/14/2024

Client Info : NCDHHS-NCFAST

Note:

* Agency Interview Type : Either Webcam Interview or In Person

* Hybrid

Description :


IMPORTANT NOTE: Extensi.... (This job is for - Stakeholders Jobs in NC Durham Consultant - (in Durham, NC))

Travel RN - 63563
Create date: 25-Oct-2024
No of Submissions : 2

Start date : 11/20/2024

End Date : 02/08/2025

Submission deadline : 11/01/2024

Client Info : TN TDOC

Note:

* Position Location : On Site

Description :



Day Shift

HEALTH CENTER

Work Activities

.... (This job is for - Jobs in TN Nashville Consultant - (in Nashville, TN))

DHB Specialist- Junior (749435)
Create date: 23-Oct-2024
Hybrid

No of Submissions : 1

start date : 11/01/2024

End date : 10/31/2025

submission deadline : 10/29/2024

client info : NCDHHS-HB

Note:

* Agency Interview Type: Webcam Interview Only

* Typical Experience: 12-36 months

* NC DHHS Division of Health.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, 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