Sr. Database Administrator

As a family company, we serve people and communities. When you work at Meijer, you’re provided with career and community opportunities centered around leadership, personal growth and development. Consider joining our family – take care of your career and your community!

 

Meijer Rewards

• Weekly pay

• Scheduling flexibility

• Paid parental leave 

• Paid education assistance

• Team member discount

• Development programs for advancement and career growth

 

Please review the job profile below and apply today!

This position defines, creates, and maintains the enterprise data models and databases within the assigned database environment(s). Analyzes, tests and implements physical database design supporting various business applications (including base definition, structure, documentation, long-range requirements and operational guidelines). Ensures data recovery, maintenance, data integrity and space requirements for physical database are met through formulations and monitoring of policies, procedures and standards relating to database management. Provides a high degree of coordination between user, technical, application and corporate entities to ensure effective data management as a corporate enterprise. Leads projects in assigned area, mentors other DBA’s, and ensures that database solutions are providing value. Ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence in the IT group’s knowledge of and concern for users’ business needs.

 

What You'll Be Doing:

• Takes the lead in resolving complex problems and issues related to the RDBMS.  Resolves problems and answers questions related to the RDBMS and platform environment (e.g., Windows, Linux, Cloud).  Contacts vendor support when necessary.  Facilitates application development and client problem resolution with optimum speed and efficiency.
• Understands the enterprise data model, how each RDBMS is used and why; and is able to articulate to others how the systems and components work together to support Meijer applications and key processes such as Product Flow.
• Designs and implements monitoring solutions.  Closely monitors RDBMS performance.  Identifies problems and implements solutions.  Ensures the database is running at optimum speed and efficiency.
• Responds quickly to refresh data.  Verifies implementation of correct backup strategy.  Develops recovery procedures.  Supports recovery from loss of data caused by user or system error.
• Keeps RDBMS at current release and maintenance levels.  Installs supporting products.  Provides current, stable production and development environments.
• Leads efforts to automate procedures at regular intervals.  Has intimate knowledge of automation that is in use.  Uses tools to reorganize or defragment database table spaces, tables and indexes.  Provides efficient database environment to maximize productivity and improve performance.
• Refreshes data from one environment to another at the request of the application development staff.  Executes necessary tasks to accomplish this including export, drop, create and import prescheduled time to minimize impact.  Provides application development staff optimal development environment with current data.
• Researches and recommends optimal design criteria.  Publishes standards and work with development staff.  Standardizes environment and improve efficiency.
• Monitors file system space, database allocation, etc.  Verifies efficient use of disk storage.  Reclaims dead space.  Optimizes space allocation and avoids out-of-space conditions.
• Creates, develops and reviews the logical data model ensuring the logical designs comply with standards, guidelines, and procedures.
• Creates, develops and reviews the physical model created from the logical model ensuring the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design and maintenance.  Ensures proper data modeling and design paradigms are applied.
• Provides the appropriate tools, procedures and facilities for creating and maintaining the entity data enterprise model.
• Produces entity relationship diagrams, logical model diagrams, physical model diagrams and logical to physical database mapping.
• Manages the implementation and use of the enterprise data dictionary.
• Works closely with peers to ensure review of database schemas and sub schemas and gathers estimated sizes of new databases.
• Develops and follow rules, procedures and standards for the access and maintenance of shared data resources.
• Reviews overall physical database structures for data integrity, performance quality, recoverability, maintenance and space requirement considerations.
• Communicates complex technical information in a concise and articulate manner.
• Leads in the evaluation and recommendation of DBA tools and new DBMS technologies.
• Serves as business liaison to database vendors.
• Responsible for the integrity of production test and QA database environments.
• Performs impact analyses, researches products, configures software and establishes standards and procedures that support the company’s database environment needs.
• Responsible for application-oriented database administration and technical support for the various development, training, testing and production requirements of relational database environments.  Focuses on application-specific database issues to ensure optimal application performance and integrity.
• Develops utilities for monitoring and evaluating data quality.
• Leads in the definition and development of database documentation and standards.
• Conducts application transaction volume and traffic analysis and interprets impact on database and network performance.
• Interacts with analysts and developers, understands system requirements from conceptual models, analyzes transactions and data volumes and designs the logical/physical database.
• This job profile is not meant to be all inclusive of the responsibilities of this position; may perform other duties as assigned or required.

What You'll Bring With You:

• Bachelor’s degree in Computer Science, Engineering or related discipline.
• Master’s degree is desirable or equivalent experience acceptable.
• 8+ years of in-depth experience in the design, administration, programming and support of RDBMSs/MDDBMSs (e.g., Oracle, Sybase, SQL Server) in one or more computing environments (e.g., Linux, Windows, Cloud).
• 6+ years of experience as a DBA in one or more environments is highly desirable (preferably with RDBMSs) or strong, demonstrated DBA skills earned in equivalent experience.
• Demonstrated experience working well with customers and leading peers and other technical resources of varying levels of technical expertise in high-pressure situations and complex environments.
• Extensive experience in designing, modeling, developing, and supporting large RDBMSs (or MDDBMSs).
• Extensive experience in the design of data extract, and migration facilities.
• Experience with cross-platform networking in a TCP/IP environment.
• For Linux environment, experience with shell scripting languages (e.g., Transact-SQL, Perl, Python) is necessary.
• For Windows environment, experience with Windows scripting/jobs/DTS, stored procedures languages is necessary.
• Required that individual has demonstrated all of the following:
• Successful experience as a member of a multidiscipline, high-performance work team or project group.
• Competency in project management and management of resources to meet goals and multiple projects.
• Successful experience in working with end users to develop effective solutions to diverse and complex business problems.
• Initiative, good judgment and the ability to achieve results through others.
• Success in developing and implementing new technology and work processes.
• Proven ability to quickly diagnose and restore service for high impact problems.
• Proven ability to handle database modeling or systems administration tasks to fulfill backup role if needed.
• Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques.  Ability to see the big picture and to conceptualize and document creative solutions.
• Extensive experience in logical and physical database design, hands-on data modeling techniques and development methodology; physical schema design of table spaces, rollback segments and data files.
• Proficiency in the concepts and practice of database normalization techniques.
• Strong working knowledge of state-of-the-art database concepts/design/deployment, recovery techniques, performance monitoring and tuning, Structured Query Language, relational database design techniques and JCL.
• Full certification of key areas/skills.
• Extensive ability to monitor and tune the database.
• Extensive knowledge of server-side development issues surrounding triggers, stored procedures, and packages.
• Strong customer focus and management of client expectations.  Ability to establish and maintain a high level of user trust and confidence in the IT group’s knowledge of and concern for users’ business needs.
• Ability to present and explain technical information to diverse types of audiences (management, users, vendors, technical staff) in a way that establishes rapport, persuades others, and gains understanding.
• Ability to write clear proposals and technical documents.
• Proven leadership and strong interpersonal skills with ability to motivate employees/ teams to apply skills and techniques to solve dynamic problems; excellent teamwork skills.
• Extensive project management skills, effectively managing multiple small to large projects in a cross-functional environment.
• Ability to weigh various suggested technical solutions against the original business needs and choose the most cost-effective solution.
• Proficiency in several RDBMS-specific middleware tools and utilities to support activities as monitoring, database migration, DDL (data description language) management and replication is a must.
• Full knowledge of SQL, including programming and ways to optimize SQL code.
• Solid programming knowledge of more than one 3GL/4GL/OO4GL language (e.g., C/C++, Perl, UNIX shell, Visual Basic).
• Knowledge of Web-enabled GLs is a plus (e.g., Oracle Developer).