SQL DBA OPPORTUNITY

Last Post 20 Oct 2011 04:22 AM by Heather. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Informative
Heather
New Member
New Member

--
20 Oct 2011 04:22 AM

Are you currently in the market or simply looking for a change of pace? CDI’s direct client near Cleveland/Akron has a need for an SQL DBA. This will be a contract to hire assignment, only US Citizens, GC, EAD, TN visa holders will be considered. Please take a careful look at the detailed job description below and if it’s a good fit, please reply with the following. Must have recent SQL DBA job experience to qualify.

 

Candidate Full Name:

Visa Status:

Candidate contact info (phone/e-mail):

Availability for Interview:

Availability to Start:

Current hourly rate or salary:

Job search status (working, why looking, interviews, offers, where and when expected):

Current Location:

Last 4 of SSN:

·          Send word.doc resume

 

Project Details:

Direct Client

Location: Cleveland/West Side Suburb

3mo Contract to Hire

Visa: only US Citizens, GC, EAD, TN


The client already has a DBA that is more operationally oriented.  The DBA we are looking for needs to be development oriented and be ready to work with our developers while they are designing new systems and enhancements, etc.  This person should also be familiar with SSIS and DataWarehousing using SQL.  This person would design the database tables and ensure proper overall design.  They use Erwin so that would be very desirable.

 

 

General Description Of Duties:

Under general supervision, the Database Administrator’s (DBA) role is to design, install, monitor, maintain, and performance tune production databases and data warehouses while ensuring high levels of data availability and security. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

 

Required Skills:

Experience in SQL Server database and/or SQL Server database development

Working experience in SQL Server 2005 & 2008

Hands-On experience with SQL Server 2008 and/or SSRS and SSIS

Working experience in creating DTS packages and creating reports in SQL Server

Competency in Backup & Recovery procedure

Good knowledge in performance Tuning and troubleshooting

Ability to Support databases 24/7

Understand and write moderately complex queries

Create and Manage databases in SQL Server

Experience with SSIS/DTS and SSRS/Reporting Service

 

Optional Skills :

Working knowledge with Erwin is very desirable

 

 

Examples Of Essential  Functions:

The list of essential functions, as outlined herein, is intended to be representative of the tasks performed within this classification. It is not necessarily descriptive of any one position in the class. The omission of an essential function does not preclude management from assigning duties not listed herein if such functions are a logical assignment to the position.

 

·          Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.

·          Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.

·          Design, implement and support data warehousing and related business intelligence solutions to fully leverage agency information with the goals of increased taxpayer compliance, increased revenues for member cities and improved operating metrics for management purposes.

·          Implement business rules via stored procedures, middleware, or other technologies.

·          Work with analysts/developers to assist in the definition of user interfaces/reporting tools associated tools associated with presenting data warehouse information.

·          Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse.

·          Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

·          Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

·          Create and maintain logical/physical models for new database development and/or changes to existing ones.

·          Install and configure relevant network components to ensure database access as well as database consistency and integrity.

·          Respond to and resolve database access and performance issues.

·          Monitor system details within the database, including stored procedures and execution time, and implement efficiency improvements.

·          Monitor, optimize and allocate physical data storage for database systems.

·          Plan and coordinate data migrations between systems as well as write and support the code for the migrations.

·          Develop, implement, and maintain change control and testing processes for modifications to databases.

·          Create, or support creation of, required reports in response to business user needs.

·          Perform database transaction and security audits.

·          Establish appropriate end-user database access control levels.

·          Develop routines for end users to facilitate best practices database use.

·          Manage and/or provide guidance to junior members of the team.

·          Writes complex stored procedures and triggers.

·          Maintains referential integrity of data.

 

 

PERFORMANCE APTITUDES

 

Data Utilization : Requires the ability to evaluate, audit, deduce, and/or assess data and/or information using established criteria. Includes exercise of discretion in determining actual or probable consequences, and in referencing such evaluation to identify and select alternatives.

 

Human Interaction : Required to be team-oriented and skilled in working within a collaborative environment with the ability to interact in a professional manner with all levels of personnel regardless of their position within the Agency or the situation at hand is required. 

 

Equipment, Machinery, Tools, and Materials Utilization : Requires the ability to operate and control the actions of equipment and machinery, requiring the monitoring, adjustment, regulation, and/or setting of multiple conditions. 

 

Verbal Aptitude : Requires the ability to utilize a wide variety of reference, descriptive, advisory and/or design data and information.

 

Mathematical Aptitude : Requires the ability to perform addition, subtraction, multiplication and division; ability to calculate decimals and percentages; may include ability to perform mathematical operations involving basic algebraic principles and formulas, and basic geometric principles and calculations.

 

Functional Reasoning : Requires the ability to apply principles of influence systems, such as motivation, incentive, and leadership. Ability to exercise independent judgment to apply facts and principles for developing approaches and techniques to problem resolution.

 

Situational Reasoning : Requires the ability to exercise the judgment, decisiveness and creativity required in situations involving evaluation of information against measurable or verifiable criteria.

 

Physical Ability : Tasks involve the ability to exert light physical effort in sedentary to light work, but which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight. Tasks may involve extended periods of time at a keyboard or work station.

 

Sensory Requirements : Keen attention to detail. Some tasks require visual perception and discrimination. Some tasks require oral communications ability.

 

Environmental Factors : Tasks are regularly performed without exposure to adverse environmental conditions.

 

 

Heather Sandrick

Associate Recruiter

1960 Research Dr|Suite 200

Troy, MI  48083
Phone:      248-786-5997

http://www.cdicorp.com/" target="_blank" rel="nofollow">http://www.cdicorp.com/" href="http://www.cdicorp.com/" target="_blank" rel="nofollow">http://www.cdicorp.com/">www.cdicorp.com

http://www.cdicorp.com/" target="_blank" rel="nofollow">http://www.cdicorp.com/investor_relations/files/Forbes.com%20Most%20Trustworthy%20Companies.pdf" target="_blank">  



Acceptable Use Policy
---