Database Administrator at Three Point Solutions Inc
Baltimore, MD
About the Job
Job Title: Database Administrator
Client: Health Care Insurance Company
Duration: 6 Months
Location: Baltimore, MD 21224 (Mandatory - 100% remote; however, the resource must reside in District of Columbia, Maryland, Virginia (DMV Candidates Only))
General Information
Job Description:
Purpose:
Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
Maintains database dictionaries and integrates systems through database design
Maintains and documents shell scripts and batch processes
Ensures that documentation is complete and up-to-date
Develops and applies procedures for periodic database backup.
ESSENTIAL FUNCTIONS:
20% Implements designs and structures provided by Systems and Data Architects
Performs installation of software and hardware environments in a timely manner in keeping with current release levels
Creates and maintains schedules for software maintenance and upgrades.
15% Prepares appropriate dimensional data structures and provides logical interfaces for the extract/transform/load process.
15% Maintains database and ensures its availability to users
Maintains database backup and recovery.
15% Monitors database performance and assists with database security.
15% Develops and implements techniques to prevent system problems, troubleshoots incidents to recover services, and supports root cause analysis.
10% Validates, loads, tests, and verifies data; Performs complete functional testing of database structures and verifies information provided in all environments including development, test, and production.
10% Provides project management support regarding most technical aspects of implementing project release upgrades for assigned systems which includes: properly following a project life cycle, the development of project plans, completing all appropriate documentation and notifications in order to obtain resolution within the established timeframes.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily
The requirements listed below are representative of the knowledge, skill, and/or ability required
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education Level: Bachelor's Degree
Education Details: Computer Science or IT related field
Experience:
3 years Experience using relational databases
Experience retrieving data to perform management and reporting duties.
In Lieu of Education:
In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
Preferred Qualifications
Knowledge, Skills and Abilities (KSAs):
Knowledge of Oracle and similar databases
Proficient
Ability to communicate effectively with analysts, developers, testers, and project managers in both oral and written form
Proficient
Ability to work with minimal supervision
Proficient
High level of analytical and troubleshooting skills
Proficient
Proficient in Microsoft Office applications
Proficient
Knowledge of structured query language (SQL)
Proficient
The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes them ineligible to perform work directly or indirectly on Federal health care programs
Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time
Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence
Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.
Additional Skills:
SQL Knowledge
Oracle database knowledge including advanced functions and features (no GUI point-and-click only)
#ZR
Client: Health Care Insurance Company
Duration: 6 Months
Location: Baltimore, MD 21224 (Mandatory - 100% remote; however, the resource must reside in District of Columbia, Maryland, Virginia (DMV Candidates Only))
General Information
Job Description:
Purpose:
Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
Maintains database dictionaries and integrates systems through database design
Maintains and documents shell scripts and batch processes
Ensures that documentation is complete and up-to-date
Develops and applies procedures for periodic database backup.
ESSENTIAL FUNCTIONS:
20% Implements designs and structures provided by Systems and Data Architects
Performs installation of software and hardware environments in a timely manner in keeping with current release levels
Creates and maintains schedules for software maintenance and upgrades.
15% Prepares appropriate dimensional data structures and provides logical interfaces for the extract/transform/load process.
15% Maintains database and ensures its availability to users
Maintains database backup and recovery.
15% Monitors database performance and assists with database security.
15% Develops and implements techniques to prevent system problems, troubleshoots incidents to recover services, and supports root cause analysis.
10% Validates, loads, tests, and verifies data; Performs complete functional testing of database structures and verifies information provided in all environments including development, test, and production.
10% Provides project management support regarding most technical aspects of implementing project release upgrades for assigned systems which includes: properly following a project life cycle, the development of project plans, completing all appropriate documentation and notifications in order to obtain resolution within the established timeframes.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily
The requirements listed below are representative of the knowledge, skill, and/or ability required
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education Level: Bachelor's Degree
Education Details: Computer Science or IT related field
Experience:
3 years Experience using relational databases
Experience retrieving data to perform management and reporting duties.
In Lieu of Education:
In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
Preferred Qualifications
Knowledge, Skills and Abilities (KSAs):
Knowledge of Oracle and similar databases
Proficient
Ability to communicate effectively with analysts, developers, testers, and project managers in both oral and written form
Proficient
Ability to work with minimal supervision
Proficient
High level of analytical and troubleshooting skills
Proficient
Proficient in Microsoft Office applications
Proficient
Knowledge of structured query language (SQL)
Proficient
The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes them ineligible to perform work directly or indirectly on Federal health care programs
Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time
Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence
Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.
Additional Skills:
SQL Knowledge
Oracle database knowledge including advanced functions and features (no GUI point-and-click only)
#ZR