| Title: Production DBA
|
| Location: Highlands Ranch, CO
|
| Job Type: Contract
|
| Compensation: per Hour
|
| Reference Code: 1000304-WQG
|
Description: Our client is seeking a Production DBA to take a technical leadership role involved in the architecture, design and development, as well as the tuning of new and established SQL databases and related applications. The Database Administrator participates in the definition of the overall delivery strategy of large data initiatives such us data migration and consolidation, data warehousing, data quality, and master data management.
Responsibilities:
- Administer database and system installations for optimum availability and performance, including all configuration settings
- Create and perform database and system maintenance policies and procedures
- Determine and maintain database sizing requirements
- Aid in design and construction of application data models, including transactional and data warehouse stores, ensuring consistency and integration with best-practice policies. Heavily involved with data governance
- Responsible for data acquisition and access, analysis and design
- Ensure that configurations and scheduled jobs are maintained
- Diagnose database and system performance problems. Proactively evaluate database and system performance and make recommendations for improvements/upgrades. Assist with planning and implementation of improvements.
- Maintain a baseline and perform data layer load balancing -- which clients on what servers from a database perspective
- Assist customers and data analysts with reporting and querying of DB
- Develop scripts for system management needs
- Perform and document disaster recovery functions
- Moderate experience with Visual Basic, and other scripting languages
|
Requirements: Requirements:
- 5-8 years of hands on industry experience working with enterprise-class database systems/applications with some experience filling the role of database technical lead or consultant
- SQL DBA with at least 2 recent years in a MS
- SQL Server specific environment
- End-to-end full life-cycle DBA experience
- Expertise with building & rebuilding databases (fresh or from backups)
- Expertise with table/index design
- Expertise with performance tuning
- Experience with administrating backups and cleanup tasks (crucial for this position)
- Strong design skills
- Experience with advanced database clustering/mirroring technologies
- Maintaining data integrity and cleaning up bad/old data will also be a priority
- Detail oriented (for change management)
- Business intelligence
- Excellent communication skills, both oral and written
|
|
|
|
|
|
|