Senior SQL Server DBA
Posted on Sep 27, 2019 by Request Technology - Craig Johnson
Must be MSSQL Admin or Dev certified
Prestigious Enterprise Company is currently seeking a Sr. SQL Server Database Administrator. Candidate provides planning, architecture, implementation and operational support for all enterprise databases. Candidate will focus on the data architecture and operations of the (SQL Server, Oracle, and/or Epic Cache) database environment(s).
- Develops database architectures that incorporate new features of (SQL Server, Oracle and/or Epic Cache) and OS software. Identifies strategic directions, creates high level plans, and develop project plans to implement the new strategies.
- Architect, design, install, create architecture documentation, and performs operational support for all database environments (currently over 500 databases).
- Architect zero data loss and high availability database environments for mission critical applications.
- Assists application development teams in working with databases, planning and implementing production changes and assisting with query optimization. Responsible for analysing and translating business information (data) and technical requirements into solutions to achieve business objectives.
- Creates enterprise data architecture, works with application and infrastructure teams to produce an optimal, high level, conceptual design for projects.
- Creates project plans for complex projects and monitors and reports project status. Maintains a log of issues and coordinates activities to resolve them.
- Will often coach, train or mentor less senior professionals.
- Implements and performs capacity planning, performance monitoring and reporting processes.
- Develops maintenance and backup procedures, change control processes and operational documentation.
- Lead database development projects and advise management and users on new or optimal technologies or methods to improve the functionality and/or efficiency of the organization's databases.
- Implements and performs proactive system monitoring to ensure high-availability and performance.
- Performs ongoing performance tuning and optimization activities.
- Is able to work independently to organize work that includes system implementations, projects and production support.
- Have the ability to escalate and communicate system outages to the appropriate levels of management.
- Understanding schema and dimension options beyond relational to include such techniques as star, cubes and other options to support best hosting options.
- Viewed as a technical expert and is critical resource across multiple disciplines and mentors other team members and application developers on technical solutions.
- Expert knowledge in database (SQL Server, Oracle or Epic Cache) with certification being desired.
- Must have 8+ years plus of database administration experience with at least two technical platforms including (MS SQL Server, Oracle and/or Cache).
- At least 5 years' experience working with large databases.
- At least 7 years' experience with backup and recovery strategies and procedures
- Experience in performance tuning and troubleshooting.
- Experience designing and implementing High Availability configuration
- Epic system certification for Epic database support
- Epic Healthcare Systems and the desire to learn new database technologies.