Douglas County School - Database Administrator

"over 560 servers of which 90%​ are virtualized."Good chance this is a sprawling jumble of feifdoms.  Seriously, a real HR department doesn't brag about the political inefficiencies that require hundreds and hundreds of machines.

"Architect efficient ETL processes including hands-on ETL development and review of ETL load jobs for consistency and quality"
Develop the code and watch it run every day in production.  You get to do it all, and call yourself an "architect".  You probably will need your own machines for this - let's get over 600 machines!

"assisting in disaster recovery if necessary"
You are on-call for anything and everything, all of the time.

"frequent emergency information service requests requiring overtime commitments.​"
Management can't manage their customer's expectations, so you get to work frequent overtime.

"LICENSES OR CERTIFICATION – Valid Driver’s License"
If you choose not to have a driver's license, or if your physical ability (blind?) won't allow it, you can't work here because obviously everybody knows you must have a driver's license to handle hundreds and hundreds of machines while working frequent overtime.
_______________________________________________

The Senior SQL Database Administrator (DBA) is responsible for providing operational

leadership in support of Douglas County School District’s (DCSD) key transactional

database environment.​ Beyond core operational responsibilities, knowledge of designing and

implementing large scale data architecture to enable business intelligence is highly desirable.​


This is an exciting ground floor opportunity to create a resilient SQL server infrastructure

running the latest Microsoft and VMWare tools in support of current and future needs of the

district.​


DCSD has over 5,000 fulltime employees serving 65,000 students in 85 schools.​ With an annual

operational budget of $550 M, the district requires enterprise strength technology to maintain

daily operations.​ The IT infrastructure at DCSD spans 2 data centers containing over 560

servers of which 90%​ are virtualized.​


ESSENTIAL DUTIES& RESPONSIBILITIES

·        Perform system architecture, design and installation of SQL Server 2008 R2 or higher on
optimized virtual and/​or physical infrastructure
 ·        Create high capacity resilient SQL infrastructure using appropriate clustering techniques
 ·        Architect efficient ETL processes including hands-on ETL development and review of ETL load jobs for consistency and quality
·        Develop and own strategy for database backup and recovery
·        Promote best practices for SQL code promotion from development to production databases
·        Perform data modeling both logical and physical
·        Perform proactive database maintenance and tuning including monitoring, troubleshooting and optimizing performance
·        Perform capacity planning including allocation of system storage and planning future storage requirements
·        Install and manage tools for the ongoing assessment of database performance and the identification of problem areas
·        Develop and manage a security scheme for the database environment, as well as assisting in disaster recovery if necessary

REQUIRED EXPERIENCE

·        BS in one of the following subject areas: Computer Science, Business Administration, Information     Technology or related field of study, or equivalent experience and training.​
·        6-8 years in IT operations
·        3-5 years of progressive Microsoft SQL Server experience
·        Knowledge of reporting and query tools and practices
·        Ability to align with the organizations goals and objectives
·        Good interpersonal, written, and oral communication skills
·        Technical documentation skills
·        Able to prioritize and execute tasks in a high-pressure environment
·        Experience working in a team-oriented, collaborative environment
·        Good written and oral communication skills

REQUIRED TECHNICAL SKILLS

·        Strong knowledge of MS SQL Server 2005, 2008 & 2012
·        Microsoft SSIS, SSRS experience
·        Working knowledge of SAN storage (EMC)
·        Working knowledge of VMWare virtualization software
·        Operational knowledge of MySQL and Oracle is highly desired

GENERAL EXPECTATIONS

Has a customer-service orientation.​

Able to work under high stress conditions, including frequent emergency information service requests requiring overtime commitments.​

Able to keep current with evolving technologies applicable to business & a K-12 school environment.​

Able to work cooperatively with administrators and co-workers.​

Able to understand and follow complex oral and written instructions

Able to effectively communicate with the school district community.​

Maintain a generally positive attitude.​

Observe all District policies and procedures.​

LICENSES OR CERTIFICATION – Valid Driver’s License

ESSENTIAL ENVIROMENTAL REQUIREMENTS – Mostly clean and comfortable

ESSENTIAL PHYSICAL REQUIREMENTS

Occasional travel throughout 900 sq mi school district, requiring personal vehicle.  ​Occasional lifting of 10-20 pounds.​

Frequent bending, stooping, walking, crawling, standing, kneeling, squatting, reaching, and sitting.​

SUPERVISORY DUTIES– None