Sr. Database Administrator Job in Hilliard 43026, Ohio US

Position Summary:

The Senior Database Engineer is responsible for the health, configuration, and monitoring of the software and hardware that comprise the database, warehousing, and business intelligences services in support of Redemtech products, business partners, and infrastructure components.  This position is part of a team that ensures that the database, warehousing, and business intelligence to support business operations meets service level agreements, requirements, security, and commitments.  The Senior Database Engineer is required mentor and train entry-level and mid-level database administrators and engineers.

 

 

Position Responsibilities:

·         Must have the ability to complete work based on a schedule of activities.  Must be able to correctly interpret requests and produce expected results. 

·         Must have the ability to provide effort estimation for needed database, warehousing, and business intelligence, work at the highest level of accuracy.

·         Work with IT Operations Manager and Project Managers to set detailed schedules and project expectations.  May be able to assign and lead database resources for specific tasks as needed.

·         Demonstrated ability to fill the role of lead database engineer on projects providing guidance to other systems administrators and engineers on the team.

·         Actively participate and lead in installation, upgrade, maintenance, and security of database, warehousing, and business intelligence hardware and software.

·         Actively participate and lead in the backup/recovery planning, configuration, and execution of database, warehousing, and business intelligence hardware and software.

·         Actively participate and lead in maintaining the inventory of database, warehousing, and business intelligence systems, and software licensing as well as documentation of vendor activities.

·         Actively participate and lead in the development, review, publishing, and execution of database, data modeling, warehousing, and business intelligence standards.

·         Perform multiple levels and types of troubleshooting and testing based on project complexity with little to no direct supervision.

·         Actively participate and lead in the definition and tracking of database, warehousing, business intelligence metrics.

·         Actively participate and lead in diagraming database, data model, warehousing, and business intelligence infrastructure.

·         Actively participate and lead in planning and coordination of hardware and software releases to pre-production and production environments.

·         Verify system documentation is coherent, accurate, and consistent with defined standards and functionality. 

·         Demonstrate advanced proficiency with security, database, warehousing, and business intelligence concepts and environments

·         Actively participate in the requirements gathering process.

·         Actively participate in pre-release feedback loops and user acceptance testing with business partners.

·         Ability to review, analyze, and comprehend requirements and specification documentation to extract necessary information for accurate planning at the highest level.

·         Comfortable with current security, database, warehousing, and business intelligence strategies and technologies.  Able to comprehend new ideas and concepts and apply them.

·         Convey advanced level knowledge of and adhere to Redemtech’s change control, security, and incident management policies. 

·         Recognize and provide timely feedback to management, project managers, and lead database engineers with regard to project roadblocks as needed. 

·         Actively participate in the Software Development Life Cycle by providing support to development and quality engineers from a database perspective.

·         Investigate problems assigned by management and more senior database engineers.  Demonstrate high level efficiency in duplicating, analyzing, isolating, and negotiating problems. 

·         Protect Redemtech’s technical brand by securing information, practicing need-to-know, maintaining company privacy, and adhering to best practices.

·         Able to communicate in an effective manner that promotes healthy relationships with both internal and external team members.

·         Provide personal weekly updates that communicate the status of all assigned efforts. 

·         Provide tier 2 production support during business hours and after hours on-call as needed.

·         Provide support for production deployments as needed.

·         Other duties as assigned.

 

Experience and Education:

·         BS in computer science or related field. 

·         Six plus years of experience in database, warehousing, and business intelligence administration.

·         Four to seven years in any of the following: MS technologies, design, data modeling, performance tuning, SQL optimization, ERD

·         Equivalent combination of education and experience that demonstrates the ability to perform the essential functions of this position will be considered. 

·         Advanced level knowledge of standard database administration tools (i.e., monitoring, configuration, troubleshooting tools).

·         Advanced level knowledge of standard warehousing tools (i.e., monitoring, configuration, troubleshooting tools).

·         Advanced level knowledge of standard business intelligence tools (i.e., monitoring, configuration, troubleshooting tools).

·         Microsoft Office products and Microsoft Windows

·         Advanced level knowledge of installation, configuration, maintenance, and troubleshooting of database hardware and software

·         Advanced level knowledge of installation, configuration, maintenance, and troubleshooting of warehousing hardware and software

·         Advanced level knowledge of installation, configuration, maintenance, and troubleshooting of business intelligence hardware and software

·         Advanced level programming/shell scripting knowledge

·         Advanced level knowledge of SQL querying and programming

·         Advanced level knowledge of database concepts, structure, and design

·         Advanced level knowledge of data model concepts, structure, and design

·         Advanced level knowledge of warehousing concepts, structure, and design

·         Advanced level knowledge of business intelligence concepts, structure and design

·         Advanced level knowledge of inventory management best practices

·         Good written and verbal communication skills

·         Motivated, shows initiative, and has leadership aptitude

·         Preferred certifications:  MCITP: DBA, MCITP: DBD, MCTS: BI

5% to 10% travel may be required