Database Administrator

Owings Mills, MD

Educational Services

About the position

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.

Responsibilities

• Operational reliability, integrity and performance of all production databases.
• Back-up and recovery of existing databases.
• Performance monitoring and tuning.
• Database installations and upgrades.
• Ensure the security of confidential data.
• Periodic maintenance, fixes, patches of databases, SQL servers and Windows servers.
• Troubleshoot 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.

Requirements

• Bachelor's Degree in technical field of study.
• Five years' experience with MS Windows server in a complex, multi-site organization.
• Three years' experience as DBA for MS SQL.
• Development experience using BI processes and tools including data modeling, design, data management, ETL and tuning.
• Current Microsoft certification in MS SQL server or equivalent combination of education and experience.

Nice-to-haves

• Experience with Ellucian Colleague or in higher education.
• 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 database servers, log shipping or DB synchronization for MS SQL server.
• Understanding of MicroStrategy business intelligence platform.
• Complex report-writing skills, query-authoring, and dashboard design.
• Ability to read, write, debug and tune SQL.
• 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.
• Detailed-oriented with 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.