What are the responsibilities and job description for the Database Administrator position at Stevenson University?
Database Administrator
Summary:
This position serves as a Database Administrator responsible for all technical support aspects for the many Microsoft SQL server databases and the BI platform. Reviews and assesses business requests for data and data usage, analyzes requirements, researches data sources and develops design documentation; coordinates development of and develops BI presentation layers, consistent and integrated with BI applications and warehouse structure and aligned with organizational goals; designs, develops, tests and deploys dashboards, scorecards, reports and alerts/notifications for the presentation of business metrics according to business user requirements. The successful candidate will be able to demonstrate a proven track record of managing multiple projects and tasks concurrently. Must be a self-starter who uses good judgment and initiative to undertake activities with minimal supervision.
Department: Information Technology
Education/Experience:
Bachelors Degree in technical field of study plus five years experience with MS Windows server in a complex, multi-site organization with three years experience as DBA for MS SQL, and development experience using BI processes and tools including data modeling, design, data management, ETL and tuning in a complex, multi-site organization and current Microsoft certification in MS SQL server or equivalent combination of education and experience.
Knowledge/Skills/Ability:
- Able to work well under aggressive deadlines.
- Must work well as a member of a team as well as independently.
- In-depth understanding of database architecture and operation.
- In-depth understanding of database design in a large-scale multi-user application.
- Experience in setting up high availability data base servers, log shipping or DB synchronization for MS SQL server.
- Understanding of Windows server maintenance.
- Understanding of MicroStrategy business intelligence platform.
- Complex report-writing skills, query-authoring, and dashboard design. Ability to read, write, debug and tune SQL.
- Experience with Ellucian Colleague or in higher education is a plus.
- Highly skilled in writing complex Transact SQL statements.
- Ability to interact well with members of the Universitys administrative community
- Ability to identify and recommend new processes or business practices for the purpose of streamlining business processes
- Ability to design solutions, write efficient code, test and verify code results, and implement the solution
- Candidates for this position must be detailed-oriented and possess excellent technical skills, effective interpersonal skills, and advanced problem-solving ability
- Excellent communication skills (written and verbal)
- Exceptional logic & math skills demonstrated by high grades in those areas.
Physical Requirements:
Light work: exerting up to 50 pounds of force occasionally and/or a negligible amount of force constantly to move objects. Typing, standing and/or sitting, walking, talking and hearing. Close visual acuity to perform an activity such as viewing a computer terminal. Subject to both environmental conditions; activities occur inside and outside.
Essential Functions:
- Operational reliability, integrity and performance of all production databases.
- Back-up and recovery of existing databases.
- Performance monitoring and tuning.
- Database installations and upgrades.
- Insure the security of confidential data.
- Periodic maintenances, fixes, patches of data bases, SQL servers and Windows servers.
- Trouble shoot operational issues and implement solutions.
- Work with vendors in execution of duties where appropriate.
- Write reports on the analysis of information.
- Assist users in writing complex queries and reports.
- Investigate and resolve reported MicroStrategy issues, working with end-users, management, and other developers.
- Manage the requirements gathering, development and rollout of major projects on the solution platform.
- Design, develop and implement user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards, etc.) via software applications.
- Perform analysis of business needs, write reporting requirements and turn requirements into delivered solutions.
- Manage MicroStrategy email subscriptions; halt and re-activate subscriptions as needed.
- Monitor MicroStrategy performance and identify optimization opportunities.
- Participate in developing technical/business approaches and new or enhanced technical tools. Collaborate with DBA and Business Systems Analyst team members to address BI project needs. Build and test Metadata.
- Provide day to day production support of data warehouse BI environment.
- The ability to read, write and speak fluently in English is required.
Reports To: Director, Enterprise Applications
Work Location: Owings Mills
Position Category: Staff
Position Type: Full-Time
Months/Year: 12
Hrs/Week: 40
FLSA: Exempt
Close Date:
Open Until Filled: No
To be considered for this position please visit our web site and apply on line at the following link: stevenson.peopleadmin.com
EOE/AA Employer of Minorities/Females/Veterans/Disability
jeid-4a13c09c0eb8764c9a6452f2881a1b9f
