This position is responsible for planning, designing, implementing, supporting and managing the most business critical DBMS (Database Management Systems) environments on distributed platforms and mainframe. Our core services are currently hosted on an IBM mainframe but there are several distributed platforms (DB2 LUW, SQL Server and Postgres) that need to be administered in a consistent manner with the core systems. The ideal candidate for this position will have both the experience and willingness to support multiple DBMS environments.
MINIMUM QUALIFICATIONS AND REQUIREMENTS:
- Education: B.S in related field or comparable business experience
- Skills: 5-8 years’ experience.
- Expert level experience with relational database environments and associated tools and utilities
- Advanced database design skills and broad experience in logical/physical modeling
- Leadership ability in tailoring database features and performance options to application design requirements (e.g. web-based OLTP systems vs. ODS and data warehouse implementations)
- Deep expertise in supporting development teams with database access, assisting them design decisions and tuning of database queries
- Hands-on database backup/recovery experience in production or DR environments
- Clear communications (oral and written) and willing team leader
DESIRABLE EXPERIENCE AND APTITUDES:
- Ability to learn and support distributed / Open Source DBMS (DB2 LUW, SQL Server, Postgres, MongoDB) within short timelines
- Experience with or willingness to learn DB2 z/OS and mainframe operational environments
- Strong data modeling skills with industry-standard tools
- Design level skill in support of relational database environments heavily invested in XML
- Advanced knowledge of database performance tuning and monitoring with the ability to map that knowledge to site-specific tool implementations
- Analytics and/or heavy reporting environment support and performance tailoring skills; experience with balancing workload performance to the specific environmental resources and business requirements
- Deep hands-on experience supporting industry-standard data integration tools such as ETL and data replication
- DBMS advanced certifications
GENERAL DUTIES AND RESPONSIBILITIES:
- The ultimate goal of this position is to provide database support and DBA team leadership that results in high data availability, productive development teams and the highest possible customer satisfaction with the database interaction experience.
- Provides and enhances all database administrative functions for the development, test and production environments.
- Researches, evaluates, tests and influences the implementations of database technologies and features.
- Reviews, approves and negotiates changes to logical data models; participates in physical data modeling and creates associated database structures; enhances long-term approaches to model management working closely with development and architecture teams.
- Identifies, implements and improves database monitoring, capacity planning, and performance monitoring processes and tuning.
- Tests new releases of DBMS. Supports the promotion of new installations into production.
- Becomes established as the “go to” resource for database troubleshooting - Production on call support; development and QA environment support
- Supports, enhances and designs future improvements to DBMS object change management/promotion from development to QA and production.
- Leads in providing information and training to the users in order to maintain the smooth operation of the database environment.
- Designs, conducts and reviews database performance tests to verify performance objectives and quality standards.
- Leads Developers, other Database and Systems Administrators and Data Security Personnel in coordinating implementations of new releases and providing access to objects of the shared databases.
- Constantly finds innovative ways to improve quality and productivity.
- Complies with and influences changes to all applicable corporate and departmental software policies, standards, and practices including all standards relating to Security and Disaster Recovery.
Ex. 25%: Administration
- 30% - database administration support of DB2 z/OS development and QA environments10% - database administration support of DB2 z/OS production environments
- 15% - database physical modeling and design
- 30% - database administration support of distributed DBMS systems (e.g. DB2 LUW, SQL Server, Postgres) environments
- 15% - development and maintenance of database administration policies, standards and operational documentation