SQL DBA (need 2)

Texas  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Must have excellent communication skills.

The successful candidates will understand and be current on SQL Server database technologies - 2005 and 2008 - from both a DBA perspective as well as a developer perspective. Must be familiar with SQL Database Architecture, Database Modeling, Database security, Database setup, Stored procedure development, T-SQL, and SSIS development.
"Under the supervision of the Manager of Systems Integration and Development, the database administrator/developer will be responsible for the overall management and maintenance of database systems used to operate the infrastructure and technology platforms. The DBA/Developer will partner with business and technical groups to ensure that database performance is not hindered and performance standards adhere to service level agreements set with the enterprise.
Successful candidate will provide technical expertise on database development projects design; system integration; modify and develop Transact SQL and SSIS packages; manage database server security and set up. Will also perform various tasks such as performance tuning, database maintenance, log monitoring, data modelling, data extracts and troubleshooting."

Key Deliverables: Typical work activities usually include
Design, configure, implement, and administer all databases
Identify and resolve all issues related to database systems to ensure that systems are online and without service interruption
Design and manage the database disaster recovery and backup plan
Partner with development team and system analysts to design data management and governance protocols, manage the information life cycle, design infrastructure and data integration controls
Develop new and enhance existing standards, processes, procedures, and guidelines for database environments using industry experiences, best practices research, and business needs
Manage/modify database design to improve database performance.
Create/modify table relations to optimize query time.
Create/modify file groups to enhance database performance.
Logical data modelling physical data modelling.
Develop automated routines to load data from 3rd party systems/files
Develop automated routines to transfer data between systems
Documentation of databases
Develop of internal applications and reports
Develop data extracts and imports routines
Report development
Assist in the deployment of new systems
Assist Tier-1 and Tier-2 support staff as needed
Ensure all systems comply with corporate policies and procedures

Required:
Bachelor's degree in Computer Science; or equivalent education/experience in the information technology field
Demonstrated ability solve highly complex database programming problems
4+ years administrating multiple SQL Server database instances
4+ years of experience developing with SQL Server
2+ years of experience developing solution with SQL Server Integration Services and Reporting Services
Knowledge of at least 1 programming language (C#, C++, VB .Net)
Experience using SQL Profiler
Experience in database performance tuning techniques
Experience in designing and implementing database structures
Experience with data modelling and schema design
Nice to have
o SQL Server Analysis Services Administration
o SharePoint
o Idera SQLsafe and Diagnostic Manager tools
o Exposure to running SQL Server in a virtualized environment
Support Focus - understands and meets needs of end users
Innovation/Improvement - sets up continuous improvements/change processes and benchmarks; finds more effective ways of doing things
Decision Making - brainstorms alternatives before making timely, well-informed decisions
Direction Setting - establishes personal goals and priorities
Communications - speaks and writes clearly; confirms understanding by asking questions, anticipates needs of stakeholders
Teamwork - can work together with IT, Operations and Accounting staff
Work Environment - Experience working in a distributed team environment

Start date
ASAP
Duration
6 months maybe more
From
Generic Network
Published at
14.09.2011
Project ID:
238098
Contract type
Freelance
To apply to this project you must log in.
Register