- Perform database administrative procedures using the latest tools and technologies.
- Manages components and progress of large complex projects. Oversees small and medium projects using: project management, budgeting and financial tracking controls. Provides project reporting to project sponsors.
- Designs, develops, and implements complex physical databases across multiple platforms, technologies and computing environments.
- Monitors the performance of databases and makes tuning changes.
- Oversees ongoing system capacity planning, forecasting and tuning.
- Performs research, presents technical studies/findings and make recommendations.
- Prepares business requirements reports, feasibility studies and cost justification statements. Articulates information architecture to clients.
- Consults with higher-level resources to ensure the consistency of recommendations with enterprise direction. Researches and evaluates alternative solutions and recommends the most cost-effective design solutions.
- Works closely with technical and client management to ensure implementation of database management and support tools for complex business application development requirements and processes in accordance with the latest enterprise direction (e.g., diverse development platforms, technological environments, software, hardware and tools).
- Works as a Team Lead in the design and implementation of large, complex database solutions. Consults with IT staff and clients to determine the impact of new or revised applications on information architecture. Consults with clients to determine the information management requirements.
- Provides training, knowledge transfer and professional development on new technologies and applications to staff.
- Provides 24 x 7 database support services. After hour and weekend support is required.
- Performs tasks, and provides guidance to senior database administrators for second level diagnoses and resolution of database problems with divisional or national impact.
- Works with vendor personnel, if necessary, to achieve timely solutions of database problems.
- Reports extended outages to clients and Sr. Management within KP-IT.
- Coordinates with internal/external resources for 2nd level severity problem resolutions.
Education & Experience:
- A Bachelor’s degree or equivalent experience in Computer Science, or a related discipline, and 10+ years of relational database background, of which 8+ years as a DBA is required.
- Extensive work experience in information technology and diverse technological environments. Both data and process analysis and modeling skills which include logical and physical database design, as well as physical database implementation.
- Strong knowledge of distributed database concepts and design.
- Has large database development experience in Oracle database environments.
- Strong performance tuning and trouble-shooting skills.
- Understand n-tier architecture, cluster, and database connectivity issues in a client/server environment.
- Good Knowledge and experience to Build, Configure, Optimize and Troubleshoot High Availability, Disaster Recovery, and Data Replication Systems.
- Experience with Oracle Database Engineered Systems (Exadata, ODA, ZDLRA).
Required Competencies:
- Must have analytical ability, sound judgment and problem analysis techniques, an in-depth knowledge of database administration, along with a broad knowledge of diverse data administration methodologies, database technologies, tools, and alternatives.
- Strong project management and effective oral/written communication skills.
- Ability to adapt to new technologies.
Preferred Skills:
Oracle/UNIX, Oracle Enterprise Manager, BMC Patrol, UNIX, Linux, Win2000, TSM, DD Boost, Shell script programming.
Hardware/Operating Systems/Software:
IBM Power Systems, SUN Solaris, EMC, TSM, Exadata
RDBMS:
Oracle 11g through 19c
Desired Skills:
SQL Server 2005, 2008, 2016, SQL Server Enterprise Manager, Grid computing or partitioning experience is desirable.