Wednesday, May 8, 2013

REQ :: SENIOR SQL DBA :: GC or Citizen Only

Hi Partners,

Hope You are doing great!

Please help me with the below requirements and send me suitable resumes of your consultants ASAP !

 

Position : SENIOR SQL DBA

Location : Dublin, OH

Start Date: 5/20/2013
End Date: 11/26/2013

GC or Citizen Only

 

Local candidates would be ideal, but not mandatory and their communication skills must be very strong… 9/10.

 

Keys to the role:

At this time, US Citizen are preferred but they will consider Green Card Holders and any candidate with previous government projects such as DMV, Child and Family Services , etc would be a very  big plus!

The candidate must be able to review code and suggest best practices and must be able to debug complex code and trouble shoot complex problems.  

 

Skills Required:

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.

 

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. 

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.

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.

 

Thanks & Regards J

 

Adam Brad
Clear Thought Solutions LLC 
|
Phone: 919-342-0824    cid:image004.jpg@01CB484A.1ABFD370 347-296-3797
| E-mail :
adam@clearthoughtsolutions.com

| URL :www.clearthoughtsolutions.com

cid:image001.png@01CC0414.3E7517E0 : adam.bradads cid:image001.jpg@01CCC931.DF84BAE0 : Adam.cts1

LinkedIN : http://www.linkedin.com/pub/adam-brad/31/636/713

USA |*Lakewood *New Jersey  *Cary *NC |

Partners in your thought… Gateway to Success

 

We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a remove in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you or click on this link to be removed.
Remove link:
mailto:Adam@clearthoughtsolutions.com?subject=Remove_me We are sorry for the inconvenience.

 

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment

AddThis Smart Layers

Attention

The job offers on this web site are not related with jobs724.blogspot.com and the owner of the website. These job offers indexed by RSS feed from Google Groups about Online Job offers, Software Jobs, IT Jobs, Recruiters&Consultants, USA Jobs etc. This site does not reserve any rights to, nor claims copyright to, any software names listed on these pages. All references are copyright to their respective owners. If you want to apply for any job, you need to contact with the owner of job, not with any admins of jobs724.blogspot.com. If you have any doubts about legality of content or you have another suspicions, feel free to contact us.

Find the latest software jobs, Talent from US and Canada. ASP.NET, VB.NET, C#, ADO.NET, Consultamcy, ASP.NET, VB.NET, C#, ADO.NET, Consultamcy SAP, client-server, e-commerce and web development etc., SAP APO Green Card H1B, B1, JAVA J2EE, RMI, XML, weblogic, websphere JDBC

Stay Updated!

We have indexed IT job opportunities and counting! Don't miss any chance. Subscribe us and get the latest IT jobs listings to your inbox!

Jobs Archive