Sr. Database Administrator

Sr. Database Administrator

Requirements

• Bachelor’s degree in Computer Science, Engineering or related discipline.
• 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.
• Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques.
• 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 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).

Responsibilities

• Takes the lead in resolving complex problems and issues related to the RDBMS.
• 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.

Preferred Qualifications

• Master’s degree is desirable or equivalent experience acceptable.
• 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.