Skip to Main Content
← Back to Jobs

Sr. DBA BI/Analytics

Cook Systems Memphis ,TN
  • Expired: over a month ago. Applications are no longer accepted.
Job Description
The Sr. DBA (B/Analytics) role is to install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software and to provide best practice recommendations regarding database deployments/migrations/upgrades. The majority of the work for this position requires Microsoft SQL Server experience and will require some Oracle database experience.

Work Conditions

On-call availability for approximately 7 days per month and during outages.
Sitting for extended periods of time.
Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components.
Lifting and transporting of moderately heavy objects, such as computers and peripherals.
Responsibilities

Strategy & Planning
Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Acquisition & Deployment
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management
Respond to and resolve database access and performance issues.
Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
Plan and coordinate data migrations between systems.
Plan and coordinate database engine upgrades.
Develop, implement, and maintain change control and testing processes for modifications to databases.
Perform database health status and security audits.
Establish appropriate end-user database access control levels.
Develop routines for end users to facilitate best practices database use and assist with determining best practices for change management and code review processes.
Manage and/or provide guidance to all members of the team.

Position Requirements

Formal Education & Certification

College diploma or university degree in the field of computer science and/or 8 to 10 years equivalent work experience.

Knowledge & Experience
Strong understanding of database structures, theories, principles, and best practices.
Extensive technical experience with designing, building, installing, configuring, and supporting Database servers, including SQL Server 2012, 2016, 2017.
Extensive knowledge supporting Oracle Database environments.
Extensive experience with developing and deploying SSIS packages.
Extensive experience deploying and troubleshooting SQL Server Service Broker.
Extensive experience setting up and troubleshooting SQL Server Availability Groups.
Experience administering SQL Server Databases in an OLAP Environment and familiarity with Data Warehousing Concepts.
Experience managing assigned query plans for repeat processes.
Preferred exposure and familiarity with Database Administration in a cloud environment.
Hands-on database tuning and troubleshooting experience.
Agile Scrum Project management methodology experience.
Ability to quickly understand the organization's goals and objectives.
Knowledge of applicable data privacy practices and laws including Payment Card Industry compliance.

Personal Attributes

Good written and oral communication skills.
Strong technical documentation skills.
Good interpersonal skills.
Ability to conduct research into database issues, standards, and products as required.
Ability to present ideas in user-friendly language.
Highly self-motivated and directed.
Keen attention to detail.
Proven analytical and problem-solving abilities.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Strong customer service orientation.
Experience working in a team-oriented, collaborative environment with the understanding that some low level tasks may be required at times.

Cook Systems

Address

Memphis, TN
38105 USA